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

Reference Error

P: n/a
I think this is a reference error. All of a sudden my database doesn't
know what a "control" is. I have written forms and I get a "Module Not
Found" error. The line that is highlighted is a sub definition. (Sub
tbFormat(ctl As control))

I've tried fudging it and changing the statement to: Sub tbFormat(ctl
As object) then I get an error in another module on a line saying the
following: dim db as database.

I think there has to be some default references that have gotten
deleted. Can someone help please!!!!

Jul 23 '07 #1
Share this Question
Share on Google+
9 Replies


P: n/a
Try "refreshing" your references.
http://www.accessmvp.com/djsteele/Ac...nceErrors.html

to******@gmail.com wrote:
>I think this is a reference error. All of a sudden my database doesn't
know what a "control" is. I have written forms and I get a "Module Not
Found" error. The line that is highlighted is a sub definition. (Sub
tbFormat(ctl As control))

I've tried fudging it and changing the statement to: Sub tbFormat(ctl
As object) then I get an error in another module on a line saying the
following: dim db as database.

I think there has to be some default references that have gotten
deleted. Can someone help please!!!!
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200707/1

Jul 23 '07 #2

P: n/a
If that does not work then try a /decompile.
http://www.granite.ab.ca/access/decompile.htm

to******@gmail.com wrote:
>I think this is a reference error. All of a sudden my database doesn't
know what a "control" is. I have written forms and I get a "Module Not
Found" error. The line that is highlighted is a sub definition. (Sub
tbFormat(ctl As control))

I've tried fudging it and changing the statement to: Sub tbFormat(ctl
As object) then I get an error in another module on a line saying the
following: dim db as database.

I think there has to be some default references that have gotten
deleted. Can someone help please!!!!
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

Jul 23 '07 #3

P: n/a
On Jul 23, 4:38 pm, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:
Try "refreshing" your references.http://www.accessmvp.com/djsteele/Ac...nceErrors.html

tonym...@gmail.com wrote:
I think this is a reference error. All of a sudden my database doesn't
know what a "control" is. I have written forms and I get a "Module Not
Found" error. The line that is highlighted is a sub definition. (Sub
tbFormat(ctl As control))
I've tried fudging it and changing the statement to: Sub tbFormat(ctl
As object) then I get an error in another module on a line saying the
following: dim db as database.
I think there has to be some default references that have gotten
deleted. Can someone help please!!!!

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
I am having another problem in addition to this one. I don't know if
they are related. I keep getting a error popping up saying:

The report name '~TMPCLP202761' you entered in either the property
sheet or macro is misspelled or refers to a report that doesn't exist.

I have nor ever have had a report by this name. But every time I try
to edit the code window, this error pops up. It even happens when I
try to use the immediate window to invoke test functions.

Jul 24 '07 #4

P: n/a
On Jul 23, 4:39 pm, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:
If that does not work then try a /decompile.http://www.granite.ab.ca/access/decompile.htm

tonym...@gmail.com wrote:
I think this is a reference error. All of a sudden my database doesn't
know what a "control" is. I have written forms and I get a "Module Not
Found" error. The line that is highlighted is a sub definition. (Sub
tbFormat(ctl As control))
I've tried fudging it and changing the statement to: Sub tbFormat(ctl
As object) then I get an error in another module on a line saying the
following: dim db as database.
I think there has to be some default references that have gotten
deleted. Can someone help please!!!!

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted viahttp://www.accessmonster.com
I tried to decompile the db, but I don't know if it is because my
database is in 2002-2003 format or what but it doesn't seem to do
anything. I keep getting the report error I mentioned earlier.

"The report name '~TMPCLP202761' you entered in either the property
sheet or macro is misspelled or refers to a report that doesn't exist.
"

Jul 24 '07 #5

P: n/a
Do you have Name AutoCorrect turned OFF? Tools>Options...>General Tab
While you are in there, turn ON Compact on Close for now. Now when you do a
/decompile and close the db. it should shrink a bit. Then you go back in and
compile again and close. Then open and try it. It sure sounds like you have
some sort of corruption. The only other trick I know is to create a new,
empty db with Name AutoCorrect turned off and import everything from the old
db and Compact and Repair and then see if the problem followed you.

A link for you to review: http://allenbrowne.com/ser-47.html

to******@gmail.com wrote:
>On Jul 23, 4:39 pm, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:
>If that does not work then try a /decompile.http://www.granite.ab.ca/access/decompile.htm
[quoted text clipped - 16 lines]
>>
Message posted viahttp://www.accessmonster.com

I tried to decompile the db, but I don't know if it is because my
database is in 2002-2003 format or what but it doesn't seem to do
anything. I keep getting the report error I mentioned earlier.

"The report name '~TMPCLP202761' you entered in either the property
sheet or macro is misspelled or refers to a report that doesn't exist.
"
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200707/1

Jul 24 '07 #6

P: n/a
On Jul 24, 10:07 am, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:
Do you have Name AutoCorrect turned OFF? Tools>Options...>General Tab
While you are in there, turn ON Compact on Close for now. Now when you do a
/decompile and close the db. it should shrink a bit. Then you go back in and
compile again and close. Then open and try it. It sure sounds like you have
some sort of corruption. The only other trick I know is to create a new,
empty db with Name AutoCorrect turned off and import everything from the old
db and Compact and Repair and then see if the problem followed you.

A link for you to review:http://allenbrowne.com/ser-47.html

tonym...@gmail.com wrote:
On Jul 23, 4:39 pm, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:
If that does not work then try a /decompile.http://www.granite.ab.ca/access/decompile.htm
[quoted text clipped - 16 lines]
Message posted viahttp://www.accessmonster.com
I tried to decompile the db, but I don't know if it is because my
database is in 2002-2003 format or what but it doesn't seem to do
anything. I keep getting the report error I mentioned earlier.
"The report name '~TMPCLP202761' you entered in either the property
sheet or macro is misspelled or refers to a report that doesn't exist.
"

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
Tried these two suggestions. Still not working. I tried to create a
new db. and import specific forms. And I got an error:

Name conflicts with existing module project or object library

Jul 24 '07 #7

P: n/a
Hmmm...
Does the old db compile without errors?

You could try importing things one at a time (which is a pain) and see which
object has the problem. It is probably in a module or a form.

to******@gmail.com wrote:
>On Jul 24, 10:07 am, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:
>Do you have Name AutoCorrect turned OFF? Tools>Options...>General Tab
While you are in there, turn ON Compact on Close for now. Now when you do a
[quoted text clipped - 28 lines]
>>
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...

Tried these two suggestions. Still not working. I tried to create a
new db. and import specific forms. And I got an error:

Name conflicts with existing module project or object library
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200707/1

Jul 24 '07 #8

P: n/a
to******@gmail.com wrote in
news:11**********************@d55g2000hsg.googlegr oups.com:
"The report name '~TMPCLP202761' you entered in either the
property sheet or macro is misspelled or refers to a report that
doesn't exist.
Do you see a module listed under this name in the project browser in
the VBE? If so, you've got a corrupted VBA project, and need to
start a new MDB and import everything into it. I encountered this in
someone else's project a couple of weeks ago, and there was no way
to recover the project without beginning anew.

It's an indicator that the programmer is not taking good care of his
code, in my opinion.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jul 24 '07 #9

P: n/a
On Jul 24, 4:11 pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
tonym...@gmail.com wrote innews:11**********************@d55g2000hsg.google groups.com:
"The report name '~TMPCLP202761' you entered in either the
property sheet or macro is misspelled or refers to a report that
doesn't exist.

Do you see a module listed under this name in the project browser in
the VBE? If so, you've got a corrupted VBA project, and need to
start a new MDB and import everything into it. I encountered this in
someone else's project a couple of weeks ago, and there was no way
to recover the project without beginning anew.

It's an indicator that the programmer is not taking good care of his
code, in my opinion.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Actually I found out that, while trying to compact and repair the
database access crashed. The aforementioned "missing file" was an
internal issue. After creating a report by the offending name and
recompiling, all was fixed. The report erases itself after compile.

Jul 25 '07 #10

This discussion thread is closed

Replies have been disabled for this discussion.