refresh problem

P

PayeDoc

Hello All

I have a split FE/BE A2K mdb where the FE has a form with two subforms and
various textboxes and other controls. One of the buttons initiates an append
query and then has the line:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
This is the command code that was generated when I used the wizard to create
a refresh button, and I added it to the event procedure of my button so
that, after running the append query, the subforms and textboxes would be
all refreshed. My problem is that this line works fine on some PCs but on
others it hangs forever (only ctrl-alt-del gets me out) - even though all
the PCs have identical FEs. How can that be? Is there a better way of
refreshing the subforms and textboxes?

Hope someone can help.
Many thanks
Leslie Isaacs
 
D

Damon Heron

After Access 97, domenuitem was replaced by runcommand - look up runcommand
in help and see the various acCommands that are available - ? I never use
these commands myself, just a VBA requery method. See Help.


Damon
 
L

Leslie Isaacs

Hello Damon and Alan

Many thanks for your replies. I am sure I will be able to get the info I
need from the links you've given, but unfortunately I'm away from the office
for a week now so will be unable to do anything until after that. I will
post back here with the results!

Thanks again
Les
 
R

ruralguy via AccessMonster.com

Thanks for the update Les.

Leslie said:
Hello Damon and Alan

Many thanks for your replies. I am sure I will be able to get the info I
need from the links you've given, but unfortunately I'm away from the office
for a week now so will be unable to do anything until after that. I will
post back here with the results!

Thanks again
Les
Here's a link I use for these situations:
http://home.clara.net/tkwickenden/domenuitem.htm
[quoted text clipped - 18 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top