Avatar of fabi2004
fabi2004
Flag for United States of America asked on

The object doesn't contain the automation object 'Form'

When I open the database I get the error listed above.  I've tried some of the suggestions in posts similar to this one but nothing has worked so far.  Does anyone have any ideas?
Microsoft Access

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon
Rey Obrero (Capricorn1)

it would be difficult to tell without seeing the db..

upload a .mdb version of the db
fabi2004

ASKER
it's an accdb, hope that's alright, it's based off the Contacts template
Contacts.accdb
Rey Obrero (Capricorn1)

create a blank .mdb
import the objects from the .accdb

upload the .mdb
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
fabi2004

ASKER
but some of the features won't work in an .mdb
Rey Obrero (Capricorn1)

then wait for somebody who is using A2007 now.
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
fabi2004

ASKER
Thank you for your help.  I appreciate you looking at that.  Someone else suggested I just exclude that AutoExec macro and the db seems to run fine without it.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Well ... there you go.  I don't remember seeing an Auto Exec macro that complex in recent history.  Normally, there are just a couple of lines ...

mx
fabi2004

ASKER
I used the MS "Contacts" template provided for A2010 and modified it to better suit.  I'm sure I broke several things along the way and then I had to deal with version issues.  But it's all good now.  Finally.  :-)  In any case, that AutoExec Macro came with the template.  

Thanks again. I apprecciate you looking at it.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

With the new macro editor - which I am totally not used to ... it's a lot harder for me to figure out what the macro is doing - especially in this case.  Of course, I don't use macros in general, except for a one link Auto Exec macro that call a Function to do what ever startup I need ... and the AutoKeys macro.

At least I have a good example of a complex macro - should I want to see how the editor works lol.

thx.mx
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23