Search results for query: *

my parameters option is greyed out, any idea why? I tried to access it from the original queried data tab and a new empty tab?

How do I make a parameter query using the 'query wizard' filter data? What is the syntax for point to a cell in Excel?

I have an ODBC connection to an sql database. I have created a DSN file and want to filter the data I bring back by an invoice number. However instead of typing this invoice number into MS query filter feature, I want MS query to find it in a cell on one of the tabs in the file. Is this possible?

I have a table with the following fields: CONTAINER NUMBER - 1 container no. can have several CS no.s CS NUMBER - several CS no.s can belong to one container Size Type ETD ETA etc... I need to determine 3 things, first, I need to identify all containers where any of the size, type, etd. data...

Problem is I will always be getting new messages. I don't want to hard code these message identifiers anywhere, rather would like to store them in a table accessible by the user so they can update strings when new messages come thru. I have already built the table, it has 2 fields, the message...

I have solved it. Seems I needed the 'me.' in front of the field name in the first select statement: Private Sub Frame23_Click() Select Case Me.Frame23 Case 1 Me.cboIDOC_YEAR_IDD185.Visible = True Me.cboIDOC_MONTH_IDD185.Visible = True Me.cboIDOC_DATE_IDD185.Visible = True...

I have an option group named fram23. I have 2 options in the frame: IDD185 (1) AND IDD186 (2). When the option IDD185 is selected, I want all cboxxxxx185 to be visible and the cboxxxxxx186 to be invisible. And vice versa. I keep getting this error: "A problem ocurred while error handling...

I have a table called IDD185. This table has a field called MESSAGE. The MESSAGE field has a message that includes specific information. I have another field called GENERIC MESSAGE. I want to update GENERIC MESSAGE field with the MESSAGE value excluding the specific information. This GENERIC...

Thank You!! It is working now. Only thing is it doesn't re-filter if I remove a value from one of the fields. For example, if I choose a date, and then pending. If I delete the 'pending' value from status, it doesn't re-filter just on the date.

I just saw error in my code, re-posting, but still does not work, when I debug the me.cboActionOn field, the value is null, when I set the if statement to me.cboActionOn is null, it says invalid use of null, if I set it like me.cboActionOn = null or = "" it adds the field to the filter anyway...

BEGIN CODE Sub SetFilter() Dim FrmFilter As String Dim varMessageDate As String If Me.cboMessageDate = Null Then Me.cboMessageDate = "" Else varMessageDate = "date = '" & Me.cboMessageDate & "'," End If Dim varActionOn As String If Me.cboActionOn = Null Then Me.cboActionOn = "" Else...

I have a form with four comboboxes at the top used to filter the form, each one works independantly, now I want them to work in conjunction, for example: MessageDate, IDOCStatus, SystemStatus and ActionOn are the four fields. The code below allows me to filter using one combobox at a time...

MajP - thanks so much. My problem was that stored values on the form were numeric, for example the status 'pending' or 'cleared' are comboboxes themselves and are numeric due to the ID being the first invisible column. I was trying to set the filter to the actual text instead of the ID. PHV -...

I have a form and a combobox that filters the form. This works for the date field. Now I am adding exact same code to the change event of 2 more combo boxes and they do not work? thread702-1384539 addresses similar issue. BEGIN CODE Private Sub cboStatus_Change() Me.Filter = "IDOCStatus = '"...

Thanks! I went with the combobox wizard and works great.

This is a simple process yet I cannot get it to work. I have a table called IDD185 which contains a PK field called 'IDOC NO'. I created a form based on this table called frmIDOCmain. I created a combobox called [cboIDOC] based on the field [idoc no] on this form. Now when I select an idoc...

Apologize. The period has nothing to do with it. I will simply concatenate the count with this column once it is calculated. The Invoice number will change whenever the FCR changes. My code does include the column where this 'count' will be stored. Hope that clarifies.

I have a table with FCR numbers. I need to have a new column label the first set of fcr numbers as 1, then second as 2 as in example below: FCR Inv No. abc123 1 abc123 1 abc123 1 abc345 2 abc345 2 def678 3 my query is currently: begin code: SELECT qryTLP_cmf1.[FCR Number]...