sql vba
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » SQL in VBA

SQL in VBA

resolvedResolved · High Priority · Version 2003

replyReply Thu 4 Sep 2008, 15:57Delegate Gillian said...

Gillian has attended:
Access VBA course
Excel Advanced course

SQL in VBA

Should many SQL queries be called upon one after the other in VBA? I no longer want to do many Access queries manually. There are about 15 queries to do one after the other on a table I am analysing.

For upcoming training course dates see: Pricing & availability

replyReply Wed 10 Sep 2008, 19:57Trainer Laura said...

RE: SQL in VBA

Are all the 15 queries action queries?

I don't see a problem running one query after the other in SQL in VBA if they are action queries.

If the queries are all based on each other so it would be one very complex SQL statement combining all the queries that might be a different matter just due to the complexity of the SQL.

Laura

 

Please browse our web site to find out more about
ms+access+courses and other Microsoft training courses.

Access tip:

Change case

To change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard