 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / October 2006Opening Recordset in a table via VBA
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. > Hi, > [quoted text clipped - 3 lines] > > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.