Connecting Tech Pros Worldwide Forums | Help | Site Map

DoCmd.OpenForm fails in 2003

dynfax@yahoo.com
Guest
 
Posts: n/a
#1: Nov 13 '05
In Access 97 it runs fine, but when converted to 2003 the code "skips"
the Docmd.openform line.

I tried putting the line a few times but to no avail.

Also, sendkeys does NOT work reliabely in 2003 as it did in 97.

Anybody else have this??

Ken Post
Guest
 
Posts: n/a
#2: Nov 13 '05

re: DoCmd.OpenForm fails in 2003



What do you mean by "skips?"

DoCmd.OpenForm "Form Name Here"
works fine for me in Access 2003

Can't say that I've tried in a db that was converted from 97 though.

Wanna post some sample code?

dynfax@yahoo.com
Guest
 
Posts: n/a
#3: Nov 13 '05

re: DoCmd.OpenForm fails in 2003


if i break the code and run it manually with the {F8} key, it works,
but if I let the whole procedure run, it doesn't open the form.

Ken Post
Guest
 
Posts: n/a
#4: Nov 13 '05

re: DoCmd.OpenForm fails in 2003


Any error coming up?

Have you tried the same code in a new Access 2003 database?

dynfax@yahoo.com
Guest
 
Posts: n/a
#5: Nov 13 '05

re: DoCmd.OpenForm fails in 2003


another thing, I don't know if it's related, in the database I keep an
invisible form on. When I change the default printer - the form becomes
visible. this did not happen in 97.

dynfax@yahoo.com
Guest
 
Posts: n/a
#6: Nov 13 '05

re: DoCmd.OpenForm fails in 2003


no error. it just doesn't open the form. i will try to create a new
database with just that form and see what happens.

dynfax@yahoo.com
Guest
 
Posts: n/a
#7: Nov 13 '05

re: DoCmd.OpenForm fails in 2003


same thing. i also noticed that if i leave access to be the active
window it does work, but if i put another application on top of access
THAT'S when it doesn't open the form.

Closed Thread


Similar Microsoft Access / VBA bytes