Connecting Tech Pros Worldwide Help | Site Map

UpDate query at Runtime

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 13th, 2005, 03:04 AM
DD
Guest
 
Posts: n/a
Default UpDate query at Runtime

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, 03:05 AM
david epsom dot com dot au
Guest
 
Posts: n/a
Default 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]


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.