5 replies
by mholton
I had this problem moving from an access store to a SQL store. We needed to replace seeks, and find firsts. We realized that all we needed the seeks for was to vefify we had data that matched a key combination to work with. For that we made a collection that stored those values. The rest we made into select queries, insert and update queries.
I do not have enough room to paste sample code here.
by kimm
To do this in VBA code or VB code you have to first dimension a record set then you use a SQL statement to pull the records in from the database into the recordset. It's a fairly lenghty process but it is the same with for whatever type of databasethat you are linking to.
You can use the same SQL statement in VBA that is used in your query. You just have to base then source of your recordset on the SQL statement. If you would like I can provide you with code but it is much to lengthy to post here.
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending