It doesn't matter which I try the results aren't working. When I do it using the form results, or using the QueryDef, it looks like as the Checkbox or Combo box I now am testing, the query seems to want not to give me what I want..???
Here is a script I wrote: Basic one
strSQL = "SELECT tbl_Personnel.* " & _
"FROM tbl_Personnel " & _
...
IGGI
Last Activity: Jul 25 '07, 12:07 PM
Joined: Jul 19 '07
Location:
-
Thanks for all your help Lysander, Still not getting the required results.
I'll try and give the QueryDef ago, to see if i can get the required results.
IGGI...Leave a comment:
-
Thanks Lysander
Got it going OK, but when I try to Execute the command to open a query based on the results, I get an error message saying
MS cannot find the object '"select * from [Personnel] Where " & strFilter & " ; " line of the code,
This is what I tried to run, probable the wrong statement, want to open a form or report based on the results..(Here I tried to open the Query)...Leave a comment:
-
How can I run an MS Access Query from within MS Excel?
How can I run an MS Access Query from within MS Excel to update a pivot table? -
Creating query dynamically in VBA code
Looks like this is the best place for the right Answers.
Got a database that stores users skills, "Leader", "Investigator", "Engineerin g" ect
in a "personnel" table, A form called "Search Query" with uncontrolled Check boxes namely "Cleader","CInv estigator","CEn gineering" and so on. When the users checks some of these boxes, I need to build a query...
No activity results to display
Leave a comment: