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: *

  1. leanne123

    filter by cell value when importing external data via ms 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?
  2. leanne123

    filter by cell value when importing external data via ms query

    How do I make a parameter query using the 'query wizard' filter data? What is the syntax for point to a cell in Excel?
  3. 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?
  4. 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...
  5. leanne123

    loop thru recs to update field based on value in table

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

    case stmt on option group frame not working

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

    apply filter in form based on multiple comboboxes

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

    apply filter in form based on multiple comboboxes

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

    apply filter in form based on multiple comboboxes

    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...
  12. 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...
  13. leanne123

    'Previous Operation was cancelled' error when filtering form

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

    Filter form based on combobox

    Thanks! I went with the combobox wizard and works great.
  16. 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...
  17. leanne123

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

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