How DAO works with outer join query with Parameter 
Author Message
 How DAO works with outer join query with Parameter

I have a problem using rst.RecordCount in a form.

The rst is a outer join query and the left side query has a parameter
using a date from the opening form.

I had the following error message:

Run-time error '3061':
Too few parameters. Expected 1.

I can open the outer query with the "Date" form open.

Anyway get around?

Thank you in advance


Fri, 12 Nov 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. DAO Left Outer Join Update Problem

2. Full Outer Join w/ DAO + Access??

3. Crystal Outer join and link options not working?

4. LEFT JOIN does not work in query

5. outer join with ACCESS

6. Access 2000 -Full Outer Join

7. Outer Joins

8. No outer joins with Jet 4 drivers?

9. sql poser: OUTER JOINS?

10. SQL Builder - Outer Joins.

11. E_FAIL when outer-joining

12. Ambiguous Outer Joins....


Powered by phpBB® Forum Software