Search results

Thank you once again for all your help...especially you Pat. Strangely enough I eventually solved the problem, not by changing the sytax, but by changing the MS DAO Object Library version from 3.8 to 3.51. (I'm not sure if this is the best fix but I'm using v2000 to build the DB and it will...

Thanks for your help, Can you tell me why the single apostrophe changes things?? Is it similar to enclosing the full lot on brackets?

Doesn't matterm I have figured it. I uses the WHERE clause and specified it as a the filter when I open my form. Thanks anyway

I have an SQL statement with a WHEWRE clause within my VBA code. The idea is the user can search for data from a search form. If the search only returns 1 record how can I open a form based on that returned record. ie if the search returns an employee ID on '10', is it possible to open the...

sorry the I have made an error. the Sub should look like Private Sub cmdPrint_Click() Docmd.OpenReport "rptOrders", , ,"[OrderID] = Forms![frmOrders]![OrderID]" End Sub

Are you familiar with VBA? If so I would do it like this DoCmd.OpenReport "Report Name", , , "[Unique ID Number on form] = forms![Form Name]![Form field that matches required unique ID nmuber on form]" A real example of this would look something like this: Private Sub cmdPrint_Click()...

I have a search form which searches a table for employee records. To keep it simply I am trying to get it to work only on the surname textbox at the moment. To do this I have a global string that has the 'WHERE' part of the SQL statement stored in it. It goes something like this: Set rcd =...