By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,461 Members | 1,108 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,461 IT Pros & Developers. It's quick & easy.

getting a 3011 error

100+
P: 462
This has been driving me nuts. I'm working on a friends new computer with Windows 7, she has a data base for a membership system written in Access. I have the same system on my machine. We are running Office professional 2007. I run the membership system on my machine and it works fine. When I run it on her system I get the error 3011 it happens on a DoCmd.openform command.

The Microsoft Office Access Database engine could not fine the object “1”. Make sure the object exists and that you spell its name and the path name correctly.
Expand|Select|Wrap|Line Numbers
  1. StDocName = “Edit Members”
  2. DoCmd.openform stDocName, acNormal, acedit
It looks like it doesn't like the Acedit, when I look at it there is a 1 there. I've check the references and everything is the same as my machine. I've checked the trust center to make sure everything there is correct and it is.

Any help would be appreciated as I've been trying different things all afternoon with no luck.

The only difference is she has a 64Bit machine and my is a 32. I don't think that should make a difference.

My machine is running Windows 8.

I just tried running the office 2007 updates from the MS website tried the Office suite service pack 2 and it failed also service pack 3 and it failed.
I'm at a loss.

Thanks for any help
Tom
May 10 '14 #1
Share this Question
Share on Google+
5 Replies


zmbd
Expert Mod 5K+
P: 5,397
Please show us the full code and indicate the line of the error.

Please use the [CODE/] button to format posted script and formated text by placing the text between the [code] [/code] code tags

also, Please post the EXACT title, number, and text of the error message. Please do not alter, omit, nor abbreviate the information provided in the error message

You also need to double check that the install versions of Office are correct, look in the "about" in the help... they should both be 32-Bit installs under Office 2007; however, strange things happen.
May 10 '14 #2

Expert 100+
P: 1,240
Are you saying it failed to install those service pack, or the problem continues after installing those service packs?

Can you make any edits to the database? I'm wondering if it's a problem during some code in the load or open events that's making the form fail to load.

Have you enabled macros?

Jim
May 10 '14 #3

100+
P: 462
Ok, zmbd sorry I didn't think the two lines of code needed to be with the code/. Here's the error message and code

Run time error “3011”

The Microsoft Office Access Database engine could not fine the object “1”. Make sure the object exists and that you spell its name and the path name correctly.
Expand|Select|Wrap|Line Numbers
  1. stDocName = "Edit Members"
  2. Docmd.OpenForm stDocName AcNormal, AcEdit
To answer Jim Yes I tried to install the service packs for Office 2007 and they both failed. Not sure about the macros, When I run the code it stops on the Docmd statement everything works fine up to that point. I don't understand where the '1' comes from in the error message (see message above), I see that when I put the mouse on the AcEdit it shows as a 1, If I take the AcEdit out of the statement the docmd will open the form.
What happens is a when she selects to edit a member a form comes up that she can lookup the members name she then selects the name and that's when she gets the error trying to open the edit members form.
I hope this explains a little better.
Thanks again for your help
May 10 '14 #4

100+
P: 462
Ok, you can stop looking I logged on to her computer this morning and tried the membership again and it worked. The only thing I can think of is there was 59 windows updates that I ran on her computer and then restarted it last night.
Sorry of having you guys look into this when the problem looks like it was a Windows.
May 10 '14 #5

zmbd
Expert Mod 5K+
P: 5,397
was 59 windows updates that I ran on her computer and then restarted it last night.
WOW

I was going to tell you to do a cold-boot on the PC; however, the kids started having a melt-down between the four of them and it seems you beat me to it before I could get back to press enter! (^_^)
May 10 '14 #6

Post your reply

Sign in to post your reply or Sign up for a free account.