Kamis, 24 Juli 2014

RE: [MS_AccessPros] append query inconsistent

 

John taught that to me too, so you can actually trap errors from them!

 

Btw, The stretch of code I’ve changed with a bunch of action queries is much faster, and I’m using a local temp table and can check with unmatched queries to make sure the data went across.

 

Seems that we were having something like “packet loss” or something, so I can alert the operator and they can rerun the query or simply do an error trap, resume next, and rerun the query.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, July 24, 2014 8:43 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] append query inconsistent

 



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

 

 

 






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (22)

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