Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database Quits at DoCmd.OpenForm?

Status
Not open for further replies.

samn265

Technical User
Feb 12, 2002
35
US
I have a database that I converted from Access97 to Access2000. This database is copied from a server to a local workstation and gets executed from that station using AccessXP. I am puzzled of why the database quits on only one specific workstation but not the others. After I inserted some toggle points, I was able to find out what line of codes it is stopping at. Here is the line:

DoCmd.OpenForm "RM FORM PARTIAL CK", A_FORM, , , A_EDIT, A_HIDDEN

Do you guys see anything wrong with this code. Keep in mind that I do not have any problems with any other machines that run the same database!

Also, if I replace the above code with this:
DoCmd.OpenForm "RM FORM PARTIAL CK" by removing the “A_FORM, , , A_EDIT, A_HIDDEN” section from the code, the database will run with no problem!

I checked the references in all machines and they appear to have the same ones.

Any ideas, hints?

Thanks,
Sam
East or West Home is Best.
 
I got this problem on and off when I started doing ex-97 db's in 2000. Never did suss out the reason. I would have to fiddle aboutn with it and even delete the offending form and start again. I know it doesn't solve your problem. Just letting you know I have seen it before was stumped. Have fun! :eek:)

Alex Middleton
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top