dbTalk Databases Forums  

Compile error: User-defined type not defined

comp.databases.ms-access comp.databases.ms-access


Discuss Compile error: User-defined type not defined in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ManningFan
 
Posts: n/a

Default Compile error: User-defined type not defined - 11-03-2010 , 09:27 AM






I have a database which compiles. I removed a number of forms,
queries, macros, modules and tables from it. When I try to compile
the "boiled-down" version, I get an error "User-defined type not
defined" at this line:

Dim FrmTest as Form_frmHelp

I checked the references, all references are identical in both
databases. I did a search for Form_frmHelp within the DB and didn't
see anywhere that it was referenced. Teh Googles couldn't help me.
Anyone got any suggestions?

Reply With Quote
  #2  
Old   
ManningFan
 
Posts: n/a

Default Re: Compile error: User-defined type not defined - 11-03-2010 , 09:37 AM






Nevermind. I discovered that somehow the form frmHelp had no code
behind it. Once I went to a backup and imported all the code that was
supposed to be there, it compiled fine.

Reply With Quote
  #3  
Old   
Tony Toews
 
Posts: n/a

Default Re: Compile error: User-defined type not defined - 11-03-2010 , 12:50 PM



On Wed, 3 Nov 2010 08:37:24 -0700 (PDT), ManningFan
<manningfan (AT) gmail (DOT) com> wrote:

Quote:
Nevermind. I discovered that somehow the form frmHelp had no code
behind it. Once I went to a backup and imported all the code that was
supposed to be there, it compiled fine.
Oh, that's interesting. Thanks for posting the solution.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.