How to Open a Recordset

submit to reddit

Submit Your Tip

How to Open a Recordset – This is a place for the community to provide tips and advice on How to Open a Recordset. This topic was created by Morwen Madrigal and the tips are provided by the community. The tips you add here can be your own or referred from another site. The best tips are then ranked at the top when up-voted by members of the community.

Votes

Tips

1
- Vote
Tip 1
MS Access VBA ADODB Recordset.Open table OK but SQL fails More
Published: 9 years, 4 month(s) ago by Hein Heyster | permalink
Vote
I have an MS Access 2007 table: Columns are DB, Module, CommentID, and Comment I have an SQL query that returns the correct record in MS Access Query Design. I have confirmed in the Immediate

For further reading: http://stackoverflow.com/questions/10264764/ms-access-vba-adodb-recordset-open-table-ok-but-sql-fails ^[1]

1
- Vote
Tip 2
Open recordset in Access 2003/2007 More
Published: 9 years, 4 month(s) ago by Lisa Hester | permalink
Vote
It's been years since I've worked in Access code and it is making me certifiably insane. I just don't remember anything and all I want to do is open a recordset in code and nothing I've found onli...

For further reading: http://stackoverflow.com/questions/6034959/open-recordset-in-access-2003-2007 ^[2]

1
- Vote
Tip 3
ADO, Tutorials, Example Code, Reference, Resources, Help More
Published: 9 years, 4 month(s) ago by mstansfield | permalink
Vote
The DevGuru ADO Quick Reference is the definitive ADO reference and tutorial resource on the web, with hundreds of ready to use examples for you to include in your projects.
Tags: help, database, SQL, tutorial, howto, ADO basics, ADO, Help, ADO, Tutorials, ADO, Programming, ADO, Code, ADO, Free
For further reading: http://www.devguru.com/technologies/ado/8686 ^[3]

About Author

Morwen Madrigal

More by Morwen Madrigal

Foods That Lower Cortisol

About This Topic

Category: Fun | 9 years, 4 month(s) ago

7.8k+ Reads

3 Tips

3 Votes

0 Likes

0 Saved

Contributors

mstansfield, Lisa Hester, Hein Heyster

References & Citations

1. http://stackoverflow.com/questions/10264764/ms-access-vba-adodb-recordset-open-table-ok-but-sql-fails

2. http://stackoverflow.com/questions/6034959/open-recordset-in-access-2003-2007

3. http://www.devguru.com/technologies/ado/8686