store SELECT results in VB?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I want to write a VB script that performs SELECT queries on a database and
then stores the results in a variable so I can manipulate them later. Is this
possible? I have not been able to find anything like this in the Help or
discussions. I don't know VB very well but I think if I got past this
stumbling block I'd be OK after that.

Thanks very much in advance,
bd
 
dim rs as dao.recordset

set rs = currentdb.OpenRecordset("TableName")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Functions not found 4
Filling query parameters from different forms without VB 4
What are the steps to fix damaged MDF files in SQL Server? 0
Refresh method in VB doesn't pull most recent records 1
vb variables 2
Storing calculated query results 2
Access pass-through query to Oracle 10g stored procedure - results 1
vba powerpoint pasting named shape in selected named slides 0

Back
Top