Search results

  1. A

    Can anyone help with this?

    Please bear with me, the length of the code is long. I'm trying to get this search form search again after the first search is completed. I can type in a barcode # and perform a search but when I try another search, I get a yellow highlight pointing to the following code: myrec.Open...
  2. A

    Can someone tell me what is wrong here?

    I am trying to build a select case on a combo box that is executed by a find button. I'm getting a syntax error with the following: mstrSQL = "SELECT * FROM Employees WHERE " _ & "EmployeeID In (SELECT DISTINCTROW " _ & "EmployeeID...
  3. A

    Code help please

    I am using a form and a subform, on the main form I have a cmdfind. I want the find button to search a table (Tape3) that is displayed as the subform. I am looking to search by multiple criteria but I can't even get the button and form to interact so I've deleted all code and I am looking to...
  4. A

    Multiple Databases in one

    This may be a little long winded so please excuse me. I'm looking for the easiest way to create I guess what you could call multiple profiles for a database. In other words, I have one database but I want to have a situation where, when the splash screen appears, here are the choices: D.C...
  5. A

    Report based on Query

    I don't know if this should be in queries or in reports but here goes. I have a report which is based on a query and the query is based on 3 tables. My problem is there are multiple records for individuals that I wan't to appear but there is certain data I want to appear only once. Example...
Back
Top Bottom