Link to home
Start Free TrialLog in
Avatar of fabi2004
fabi2004Flag 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?
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

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

upload a .mdb version of the db
Avatar of fabi2004


it's an accdb, hope that's alright, it's based off the Contacts template
create a blank .mdb
import the objects from the .accdb

upload the .mdb
but some of the features won't work in an .mdb
then wait for somebody who is using A2007 now.
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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 ...

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.
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.