Search results

  1. S

    Using a form to update paramter query

    I copied and pasted the results from the immediate window to a new query and it didnt work
  2. S

    Using a form to update paramter query

    Theres like 30,000 records in it, no practice code is text an example of a practice code is Z00004
  3. S

    Using a form to update paramter query

    I tried out the green bit of coding there but it didnt seem to work also :(
  4. S

    Using a form to update paramter query

    Yea will till you sent me that bit yesterday it just run up an error, now it runs but no results appear when i select and hit the command. If i select nothing an error message does appear saying i selected nothing so it works. The print debug command sends this statement into the immediate box...
  5. S

    Using a form to update paramter query

    The button now works but no query results will appeae, im a bit of a novice how would u do the print debug? Thanks Stephen
  6. S

    Using a form to update paramter query

    Can anyone help me with my problem :(
  7. S

    List box in a parameter query?

    Sorry brian I just checked the date and thought it no one would see this
  8. S

    Using a form to update paramter query

    In the list box there is alot of Practice codes which represents buildings in northern ireland each practice has a lot of assets assigned to them. So from the list box i want to select practice codes which are in the same area and populate them into a table and then i can create a macro which...
  9. S

    Using a form to update paramter query

    Hey when i select a practice code. I basically want to run the query from a list box which will produce results on this selection, I had it as a single parameter box which the owner doesn’t think it is sufficient enough as it is time consuming. Do you know what would be wrong? Now no results...
  10. S

    Using a form to update paramter query

    Im having serious problems getting my head around this:banghead:I want to pass a list box (which is called Pract_List) to a paramter query called testquery but for some reason it wont work. The line qdf.SQL = strSQL is comming up in the debugger could anyone help? Private Sub Command_4_Click()...
  11. S

    List box in a parameter query?

    I want to pass a list box (which is called Pract_List) to a paramter query called testquery but for some reason it wont work. The line qdf.SQL = strSQL is comming up in the debugger could anyone help? Private Sub Command_4_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As...
Back
Top Bottom