Recent content by Stephen_p

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

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

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

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

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

Can anyone help me with my problem :(

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

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

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

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()...

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