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

Opening Recordset in a table via VBA

P: n/a
Hi,

Just wondering if there is a function in VBA that is able to open up
the data in a RecordSet
to a normal table look in MS Access?

Thanks.

Oct 31 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ja********@gmail.com wrote:
Hi,

Just wondering if there is a function in VBA that is able to open up
the data in a RecordSet
to a normal table look in MS Access?

Thanks.
Not that I'm aware of.

It'd be nice if you could do a
Docmd.OpenQuery "Select * From Employees"
but that's not an option. Or do a
rst.DataSheet
but there's no such animal.

You could have a temp query. And set it's SQL to your SQL statement
(see QueryDef in help and it's code examples) and open it with the
OpenQuery command.
Oct 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.