Re: Running queries with VBA functions in external database

• Previous message: david epsom dot com dot au: "Re: Running queries with VBA functions in external database"
• In reply to: david epsom dot com dot au: "Re: Running queries with VBA functions in external database"
• Messages sorted by: [ date ] [ thread ]

Date: Wed, 11 Aug 2004 00:48:53 -0700

Originally I was running without setting the warnings off
with the same result. But I thought as if you are trying
to execute DoCmd.OpenQuery actionQueryName in the same
database - it comes up with a confirmation, so I tried to
turn them off through Automation, just in case. They do
not seem to make any difference.

Any other ideas???

>-----Original Message-----
>Set warnings True and see what it is telling you!
>
>(david)
>
>"Sergey Poberezovskiy"
<anonymous@discussions.microsoft.com> wrote in
>message news:3daa01c47f34$8841ff30$a601280a@phx.gbl...
>> Hi,
>>
>> I have an (update) query that utilizes my Custom VBA
>> function (BitAnd). I need to run this query from within
>> another database. The code (attached below) runs without
>> errors, but records do not update.
>> On another hand, when I step thru the code line by line,
>> everything seems to work just fine.
>> Could anyone please help?!!
>>
>> The code:
>>
>> Dim oAccess As Access.Application
>> Set oAccess = New Access.Application
>> oAccess.OpenCurrentDatabase vsDatabase
>> With oAccess.DoCmd
>> .SetWarnings False
>> .OpenQuery "qryUpdateTempScores"
>> End With
>> oAccess.CloseCurrentDatabase
>>
>> Any help is greatly appreciated.
>
>
>.
>

• Previous message: david epsom dot com dot au: "Re: Running queries with VBA functions in external database"
• In reply to: david epsom dot com dot au: "Re: Running queries with VBA functions in external database"
• Messages sorted by: [ date ] [ thread ]