BamaColtsFan
Registered User.
- Local time
- Yesterday, 21:39
- Joined
- Nov 8, 2006
- Messages
- 91
Greetings Revered Access Guru's!
Okay, so we recently "upgraded" from Access 2003 to Access 2007 and now I'm having a problem with two queries called be VBA to send e-mails. The queries both have user prompts in them so specific values can be isolated. In Access 2003, they both got called by VBA and executed perfectly based on the input from the user. Now, since switching to Access 2007, I get the error "Run-time error '3061': Too few parameters. Expected; 1".
I am assuming the problem has to do with the user prompts in the query being called since the debug stops right on the queries. What I don't know is what to do about it. It is essential that the user be able to isolate the data with this prompt.
As always, any suggestions are deeply appreciated!
THNX!
Okay, so we recently "upgraded" from Access 2003 to Access 2007 and now I'm having a problem with two queries called be VBA to send e-mails. The queries both have user prompts in them so specific values can be isolated. In Access 2003, they both got called by VBA and executed perfectly based on the input from the user. Now, since switching to Access 2007, I get the error "Run-time error '3061': Too few parameters. Expected; 1".
I am assuming the problem has to do with the user prompts in the query being called since the debug stops right on the queries. What I don't know is what to do about it. It is essential that the user be able to isolate the data with this prompt.
As always, any suggestions are deeply appreciated!
THNX!