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?
LVL 1
fabi2004CIOAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Your Auto Exec macro is extremely complex. Macros are *very* difficult to trobleshoot.  There are several places where you have
IF [Form].[Dirty] = True then SaveRecord.

I suspect one of these is causing the issue ... because that form may not be open.  You need to Comment out these one at a time (a suggestion) and see which one causes the error.

That is my best guess ...

mx
0
 
Rey Obrero (Capricorn1)Commented:
it would be difficult to tell without seeing the db..

upload a .mdb version of the db
0
 
fabi2004CIOAuthor Commented:
it's an accdb, hope that's alright, it's based off the Contacts template
Contacts.accdb
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Rey Obrero (Capricorn1)Commented:
create a blank .mdb
import the objects from the .accdb

upload the .mdb
0
 
fabi2004CIOAuthor Commented:
but some of the features won't work in an .mdb
0
 
Rey Obrero (Capricorn1)Commented:
then wait for somebody who is using A2007 now.
0
 
fabi2004CIOAuthor Commented:
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.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
fabi2004CIOAuthor Commented:
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.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.