update query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lior Montia - 28 Feb 2007 11:40 GMT

Hi,

I have a button in a form that "on click" occurred
DoCmd.OpenQuery ("my_update_query")

How do I run this update query without any questions or messages ? just to
do the update and that's all.

Thanks.

Reply to this Message

Jason Lepack - 28 Feb 2007 12:06 GMT

currentdb.execute "my_update_query", dbfailonerror

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

Douglas J. Steele - 28 Feb 2007 12:20 GMT

Actually, assuming that my_update_query is the name of a stored query, I
believe you need to use:

Dim qdfUpdate As DAO.QueryDef

Set qdfUpdate = CurrentDb.QueryDefs("my_update_query")
qdfUpdate.Execute dbFailOnError

If you knew the SQL of that update query, then you could use the Execute
method on the Database object.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> currentdb.execute "my_update_query", dbfailonerror
>
[quoted text clipped - 8 lines]
>>
>> Thanks.

Reply to this Message