Valentino-
Execute is ALWAYS the best way to run an "action" query from VBA.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 24, 2014, at 10:35 AM, valentino.avvisati@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi Bill, John,
I was reading this post and I have an additional question due to my inexperience.
Usually I used the DoCmd.OpenQuery "queryname" Command, when I replaced one macro with VBA.
Alternatively I used DoCmd.RunSQL "SQL String" inside vba code.
The problem that you wrote regarding OpenQuery that runs independently of VBA code, it is valid also for DoCmd.RunSQL "SQL String"?
Between DoCmd.RunSQL and execute, what is the best way to perform query action inside vba code?
Thank you
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (21) |
Yahoo Groups
Improved Group Homepage!
The About page of your Group now gives you a heads up display of recent activity, including the latest photos and files
Yahoo Groups
Control your view and sort preferences per Yahoo Group
You can now control your default Sort & View Preferences for Conversations, Photos and Files in the membership settings page.
.
__,_._,___
Tidak ada komentar:
Posting Komentar