Kamis, 24 Juli 2014

Re: [MS_AccessPros] append query inconsistent

 

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: valentino.avvisati@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (20)

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