Search results

  1. E

    Dynamic Fliter in Query or Form

    I don't have much SQL knowledge so can someone explain the code a little for me. I am trying to learn as much as possible so I don't want to just copy the code and get it to work I want to know who it works also. So if someone has the time just let me know what each line of code is doing and...
  2. E

    Dynamic Fliter in Query or Form

    OK I have a switch board that lets the user pick from a group of manufactures. Now they might want to pick form more then one. How would I set up the code to filter out the other manufactures. I am using radio buttons as the item they would check. I was thinking about a public string that I...
  3. E

    VBA in query criteria

    I found it Thanks
  4. E

    VBA in query criteria

    Yes I am looking up public function now but if you can help me that would be great.
  5. E

    VBA in query criteria

    Ok I have the property name stored in "Public propertyname As String" how would I get that information into the query to use.
  6. E

    VBA in query criteria

    OK I have worked in Access for awhile now but never worked with SQL statements or anything like that. This is what I am trying to do I want a criteria in a query come from a public string that I have. When some one logs in to the database it stores what property they work for I only want records...
  7. E

    VBA code and query criteria

    OK I have worked in Access for awhile now but never worked with SQL statements or anything like that. This is what I am trying to do I want a criteria in a query come from a public string that I have. When some one logs in to the database it stores what property they work for I only want...
  8. E

    populate text box from another table

    I have a table that logs the person that is logged in and what time I would like to use this information so when they are inputing records it will pull their name from this table(LogInTime) and auto populate the Dispatcher that is making the call(this information is logged in another table...
  9. E

    Value of one text box to populate other text boxes

    OK I have changed it to a combo box but now i get this error The expre3ss on lost focus you entered as the event prperty setting producred the following error: Ambigous name detects: combo30_lostfocus.
  10. E

    Value of one text box to populate other text boxes

    sorry don't understand. what is a Combobox I.S.O. or are you telling me to use a list box instead.
  11. E

    Value of one text box to populate other text boxes

    Thanks I have been playing around and started to use a list box this seems to work other then I would like for them to be able to type in the number right not I have a list of number 1001 1002 1003 2001 when I type in a 1 then 0,0,2 it would jump to the 2001. How can I get it to pick 1002...
  12. E

    Value of one text box to populate other text boxes

    I would like to type a value in one text box and fill in four other text boxes with informaiton. I have one table that will be imported on a weekly bases to update the locatoin of machines. I would like to be able to creat a heat ticket for a tech from a call center. I would like for the...
Back
Top Bottom