Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: leanne123
  • Content: Threads
  • Order by date
  1. leanne123

    filter by cell value when importing external data via ms query

    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?
  2. leanne123

    Need to loop thru records to identify specific situation

    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...
  3. leanne123

    case stmt on option group frame not working

    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...
  4. leanne123

    loop thru recs to update field based on value in table

    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...
  5. leanne123

    apply filter in form based on multiple comboboxes

    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...
  6. leanne123

    'Previous Operation was cancelled' error when filtering form

    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 = '"...
  7. leanne123

    Filter form based on combobox

    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...
  8. leanne123

    count unique values from a field in a query into another column

    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]...

Part and Inventory Search

Back
Top