469,267 Members | 1,091 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

Access cannot find object "*"

101 100+
I have created a navigation form "frmNavigation" to use as a menu for a dbase. When I use it If I press one of the buttons I get the above error and then it opens the correct form. If I try to open the frmNavigation in design view I also get the same error and then it opens in design view?

I have tried taking out all events and macros and the form is now empty of any commands (only the design info remanis). Even so, if I press a button I get the same error.

It does not happen on all buttons, just 2?

Can anyone help here?
Oct 16 '11 #1

✓ answered by NeoPa

NeoPa:
If you have no VBA code then you certainly have at least one control connected to either SQL code or a QueryDef. Please post the SQL of that.
You will find a control somewhere on your form, a ListBox or ComboBox control, which is populated by some SQL. Look in the Control Source property. Your problem is almost certainly to be found within that SQL (or QueryDef name).

BTW I expect you can create a blank db in 2003 form, even in 2010, then import the form into that new DB for posting in here.

16 5382
Stewart Ross
2,545 Expert Mod 2GB
Please post the VBA code for the relevant button's On Click events. Can't answer you without it.

-Stewart
Oct 16 '11 #2
Cyd44
101 100+
None of the buttons have any code behind them. I have simply created the form with no events behind any of the buttons as yet.

However, if I try to open the form in design view I get the error and if I open in form view and press buttons, I get an error on some and nothing on others
Oct 16 '11 #3
NeoPa
32,171 Expert Mod 16PB
If you have no VBA code then you certainly have at least one control connected to either SQL code or a QueryDef. Please post the SQL of that.

As Stewart says, if you don't tell us anything about your problem it'll be somewhat complicated to help you.
Oct 16 '11 #4
Cyd44
101 100+
I fully appreciate your attempts to help me and apologise on the fact that I am very new to access. The Form I have created simply has the buttons without any events entered the VB code behind the form is as follows:-

Option Compare Database


This is the only code visible as I have deleted all of the original events in order to get back to the basic proble. I know it is illogical and I have pulled my hair out looking for any residual code for this form but cannot find any. Why then should I get the error when either trying to open in design view or when pressing 2 of the empty buttons on form view????
Sorry if I appear to be thick but the logic here is beyond me as I am only opening a form to be used as a menu?
Oct 16 '11 #5
ADezii
8,800 Expert 8TB
Why not Upload the DB with only the Form present?
Oct 16 '11 #6
Cyd44
101 100+
Will try that Adezil. I will let you know
Oct 16 '11 #7
Cyd44
101 100+
Have export just the form to an empty database and am still getting the error
Oct 16 '11 #8
ADezii
8,800 Expert 8TB
@Cyd44:
I meant to Upload the Database with the Empty Form to this Site as an Attachment.
Oct 16 '11 #9
Cyd44
101 100+
Would love to but I don not have winzip on my system (only have jZip). This site will not let me upload jZip file.

The error is illogical as I have only got a blank form now and it still gives me an error on trying to open the design view. It does go to the view and will let me change views without error after the first time.

There is absolutely no code that I can see which could upset the system but it is obviously trying to look for some object or other.

I am using Access 2010, do you know of any bug in this version
Oct 16 '11 #10
Cyd44
101 100+
Will go on line and purchase winZip so that I can send you the dabase
Oct 16 '11 #11
Cyd44
101 100+
Here is the dbase, many thanks for having a look
Attached Files
File Type: zip Room Dbase WIP.zip (852.1 KB, 115 views)
Oct 16 '11 #12
ADezii
8,800 Expert 8TB
Sorry Cyd44, but I need it in an earlier Version, say 2003.
Oct 16 '11 #13
Cyd44
101 100+
I only have 2010 I am afraid, this is a new comuter
Oct 16 '11 #14
NeoPa
32,171 Expert Mod 16PB
NeoPa:
If you have no VBA code then you certainly have at least one control connected to either SQL code or a QueryDef. Please post the SQL of that.
You will find a control somewhere on your form, a ListBox or ComboBox control, which is populated by some SQL. Look in the Control Source property. Your problem is almost certainly to be found within that SQL (or QueryDef name).

BTW I expect you can create a blank db in 2003 form, even in 2010, then import the form into that new DB for posting in here.
Oct 17 '11 #15
Cyd44
101 100+
Thanks for trying guys. The error is a mistery. However, I have built a new form and populated this and it works fine.

Still at a loss about the old form though.

Thanks to everyone who has tried to help
Oct 17 '11 #16
NeoPa
32,171 Expert Mod 16PB
Never mind. At least you have a working solution :-)
Oct 17 '11 #17

Post your reply

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

Similar topics

reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.