By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,776 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,776 IT Pros & Developers. It's quick & easy.

Trouble with a Query

P: 1
Hello all.

I have just started to use access and VBA and i have the folowing problem.
I have a query that contains an Inner join.
I make the query using only parameters from one table and it returns results, but if i narrow the results using parametes from the other table, the query does not run, and i get the following error:

Method 'Open' of object '_Recordset' failed.
Can anyone help me?
Dec 18 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 374
Can you please post the SQL Statement from Access so that we can see how it is setup?

If you go under View and the select SQL

then that will show you the SQL Statements being used.

Then we would be able to see what is going on?


Joe P.
Jan 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.