figured out I can do a SELECT with DoCMD.RUNSQL, but need to use SELECT INTO
figured out I can do a SELECT with DoCMD.RUNSQL, but need to use SELECT INTO
Last edited by eastgoddes; 02-16-2014 at 12:59 AM.
Often, when I have coding issues relative to SQL and VBA, I create a query using the QBE and then copy the SQL statement into the VBA.
Additionally, somewhere, I found this neat little utility that converts SQL to VBA. Import this form into any Access DB and use it.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks