Connecting Tech Pros Worldwide Help | Site Map

UpDate query at Runtime

  #1  
Old November 13th, 2005, 04:04 AM
DD
Guest
 
Posts: n/a
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"
  #2  
Old November 13th, 2005, 04:05 AM
david epsom dot com dot au
Guest
 
Posts: n/a

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
update query in ms-access doesn't working abhilashcashok@gmail.com answers 5 November 25th, 2007 09:15 AM
Crystal reports customization at runtime Suhail Salman answers 0 November 18th, 2005 05:44 AM
Crystal reports customization at runtime Suhail Salman answers 0 November 15th, 2005 10:32 PM
anyone using CommandBuilder to generate update logic at runtime? Jason Shohet answers 1 November 15th, 2005 06:52 PM