Connecting Tech Pros Worldwide Forums | Help | Site Map

UpDate query at Runtime

DD
Guest
 
Posts: n/a
#1: Nov 13 '05
When i load my Wise packaged software onto xp home I have an update
qry that will not fire until i close and reopen the computer.

As a test I have placed a button on a form and removed warnings. i get
the first message that i am about to append a record.and then thats
it.

If i then close the software and turn off the computer and restart
then the code works

any ideas??

the code is

DoCmd.Openquery "UpdatePayment"

david epsom dot com dot au
Guest
 
Posts: n/a
#2: Nov 13 '05

re: UpDate query at Runtime


You need to reboot to finish the install. Your version of
Windows thinks it knows better, and suppresses the reboot
action.

(david)

"DD" <david.deacon@bigpond.com.au> wrote in message
news:1412655e.0409200139.38ce736f@posting.google.c om...[color=blue]
> When i load my Wise packaged software onto xp home I have an update
> qry that will not fire until i close and reopen the computer.
>
> As a test I have placed a button on a form and removed warnings. i get
> the first message that i am about to append a record.and then thats
> it.
>
> If i then close the software and turn off the computer and restart
> then the code works
>
> any ideas??
>
> the code is
>
> DoCmd.Openquery "UpdatePayment"[/color]


Closed Thread