piedpiper8
Registered User.
- Local time
- Today, 13:39
- Joined
- Oct 11, 2008
- Messages
- 21
Hi There,
I'm a total noob. I'm building a very simple "Time Track" program in Access 2007 for my company. However, I'm looking to filter a report that I want to generate. What I want to accomplish is allow a pop-up window to prompt users and let them set "Variables"/"filters" to give them control of what the report would display. What I would also need is a prompt asking date as well, but I can't figure that one out. Anyways, I found on MS website a help and support document detailing exactly what I need (except the date option) the URL is:
http://support.microsoft.com/kb/q208529
I followed the instructions to the letter several time and I keep getting a type mismatch "13" error. When I debug I get the following highlighted in yellow
strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " _
& " = " & Chr(34) & Me("Filter" & intCounter) & Chr(34) & "" _
And ""
I don't know how to fix it and I'm surprised because this is code right on MS website??????
Anyways, I'm attaching the file I would really appreciate it if someone would look at it and let me know what is wrong.
When you open the file, goto "Forms" and open "frmFilter"... try to select variables and then click on the "set filter" button.
Also, if you can guide me to code that would permit me to add an option to query the report by date...that would be so awesome.
example: only display results from the database from “Oct 1” to “Oct 10”... with whatever other variables that was selected.
I would really like to thank you... hopefully I can get this done, so I can enjoy the rest of my long weekend!!!!
Thanks again
-Keith
I'm a total noob. I'm building a very simple "Time Track" program in Access 2007 for my company. However, I'm looking to filter a report that I want to generate. What I want to accomplish is allow a pop-up window to prompt users and let them set "Variables"/"filters" to give them control of what the report would display. What I would also need is a prompt asking date as well, but I can't figure that one out. Anyways, I found on MS website a help and support document detailing exactly what I need (except the date option) the URL is:
http://support.microsoft.com/kb/q208529
I followed the instructions to the letter several time and I keep getting a type mismatch "13" error. When I debug I get the following highlighted in yellow
strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " _
& " = " & Chr(34) & Me("Filter" & intCounter) & Chr(34) & "" _
And ""
I don't know how to fix it and I'm surprised because this is code right on MS website??????
Anyways, I'm attaching the file I would really appreciate it if someone would look at it and let me know what is wrong.
When you open the file, goto "Forms" and open "frmFilter"... try to select variables and then click on the "set filter" button.
Also, if you can guide me to code that would permit me to add an option to query the report by date...that would be so awesome.
example: only display results from the database from “Oct 1” to “Oct 10”... with whatever other variables that was selected.
I would really like to thank you... hopefully I can get this done, so I can enjoy the rest of my long weekend!!!!
Thanks again
-Keith