I had a form (Form12) with a code error in it. I knew it was there. I
even planned on fixing it (someday). I needed a comprehensive test
of all my code so I clicked Debug, Compile All Modules. My standard
modules were all good but the compilation test halted in a Class
Module on Form12 due to the error. OK, I thought, don't really
wanna screw around with this right now, so I'll take it out-a-the
equation. I chose it on the database window and typed CTRL-x.
Then, I restarted the Compile All Modules process. You can
guess what happened...
Compile error in hidden module: Form_~TMPCLP506 991
There was a HELP button in the error msgbox. Here's what
the HELP had to say...
Compile error in hidden module: <module name>
Specifics
A protected module can't be displayed. This error has the following
cause and solution: There is a compilation error in the code of the
specified module, but it can't be displayed because the project is
protected. Unprotect the project, and then run the code again to view
the error. For additional information, select the item in question and
press F1.
If this is a Feature, then its buggy because Access terminates if
you CUT something else to the clipboard whilest the error is being
reported (IE, the HELP text above) then click the error msgbox's
OK button. The form object on the clipboard has been replaced by
some text and Access becomes confused. Has this behavior been
rectified in the 3 advanced versions of MS Access since 97?
5  1626 
On Sun, 24 Jul 2005 08:40:09 -0400, MLH <CR**@NorthStat e.net> wrote: I had a form (Form12) with a code error in it. I knew it was there. I
even planned on fixing it (someday). I needed a comprehensive test
of all my code so I clicked Debug, Compile All Modules. My standard
modules were all good but the compilation test halted in a Class
Module on Form12 due to the error. OK, I thought, don't really
wanna screw around with this right now, so I'll take it out-a-the
equation. I chose it on the database window and typed CTRL-x.
Then, I restarted the Compile All Modules process. You can
guess what happened...
Compile error in hidden module: Form_~TMPCLP506 991
There was a HELP button in the error msgbox. Here's what
the HELP had to say...
Compile error in hidden module: <module name>
Specifics
A protected module can't be displayed. This error has the following
cause and solution: There is a compilation error in the code of the
specified module, but it can't be displayed because the project is
protected. Unprotect the project, and then run the code again to view
the error. For additional information, select the item in question and
press F1.
If this is a Feature, then its buggy because Access terminates if
you CUT something else to the clipboard whilest the error is being
reported (IE, the HELP text above) then click the error msgbox's
OK button. The form object on the clipboard has been replaced by
some text and Access becomes confused. Has this behavior been
rectified in the 3 advanced versions of MS Access since 97?
not sure of the details but Access ofter leaves temporary things around
after you've deleted them, easiest is to close Access and reopen it,
or if you are in code always worth refreshing the relevant collection.
It certainly does leave things lying around.
This one's actually on the clipboard though, as you might guess
from its object name: Form_~TMPCLP506 991
I've proven that, replacing the clipboard contents by cutting or
copying something else from another application to the clipboard
a during the reporting of the error. And, of course, CTRL-x cuts 'n
pastes to the Windows clipboard as a system default behavior.
not sure of the details but Access ofter leaves temporary things around
after you've deleted them, easiest is to close Access and reopen it,
or if you are in code always worth refreshing the relevant collection.
MLH <CR**@NorthStat e.net> wrote in
news:go******** *************** *********@4ax.c om: I had a form (Form12) with a code error in it. I knew it was
there. I even planned on fixing it (someday). I needed a
comprehensive test of all my code so I clicked Debug, Compile All
Modules. My standard modules were all good but the compilation
test halted in a Class Module on Form12 due to the error. OK, I
thought, don't really wanna screw around with this right now, so
I'll take it out-a-the equation. I chose it on the database window
and typed CTRL-x. Then, I restarted the Compile All Modules
process. You can guess what happened...
The compiled code is not gone until you compact the database.
[]
If this is a Feature, then its buggy because Access terminates if
you CUT something else to the clipboard whilest the error is being
reported (IE, the HELP text above) then click the error msgbox's
OK button. The form object on the clipboard has been replaced by
some text and Access becomes confused. Has this behavior been
rectified in the 3 advanced versions of MS Access since 97?
Comment out the offending line in the uncompilable form.
I have a particular comment that I use as a marker for "this needs
to be re-visited and fixed" so I can search an entire project and
find all the things I left needing fixing later.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
MLH <CR**@NorthStat e.net> wrote in
news:cd******** *************** *********@4ax.c om: It certainly does leave things lying around.
This one's actually on the clipboard though, as you might guess
from its object name: Form_~TMPCLP506 991
I've proven that, replacing the clipboard contents by cutting or
copying something else from another application to the clipboard
a during the reporting of the error. And, of course, CTRL-x cuts
'n pastes to the Windows clipboard as a system default behavior.
Why are you hitting COMPILE ALL when you just want to COMPILE?
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
David W. Fenton wrote: Comment out the offending line in the uncompilable form.
I have a particular comment that I use as a marker for "this needs
to be re-visited and fixed" so I can search an entire project and
find all the things I left needing fixing later.
I just use:
' TODO:
--
[OO=00=OO] This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Omey Samaroo |
last post by:
Dear Access Gurus,
I am tasked with converting an Access 97 Database to A2K. I created Macros,
switchboards and used the full feature of buttons on forms. The A97 is also
split (FE and BE). Are there any suggestions that I should keep in mind
while attempting to do this task ?
What can I expect ?
Thanks
|
by: Bradley |
last post by:
Has anyone else noticed this problem? I converted the back-end to A2000
and the performance problem was fixed. We supply a 97 and 2000 version
of our software so we kept the backend in A97 to make upgrading simple
for users. We've done it like that for years but a new client has been
having severe performance issues... solved by converting the backend to
2000.
--
regards,
Bradley
|
by: Pieter Linden |
last post by:
I have a database of rental units etc that I'm using the
CreateTableFromRecordset code from ADH 2000. Well, at the moment, I'm
doing a sanity check and testing it on my computer, with A2002, but
anyway....
I'm trying to create is building by building (a table for each pair of
buildings), so the format is something like this:
Building AptNo AptType Tenant Annual Income
Rent
|
by: MLH |
last post by:
A97 allows separate procedures in a form module to share common
label names. Access 2.0 would puke when that happened. For instance,
if I had 2 procedures in an Access 2.0 form module with labels both
named ERR_MyButton_Click, compiling loaded modules produced
an error. I'm glad to see this is not the case in Access 97. Access
2.0 went so far as to disallow me from using the same line numbers
in two different procedures of a form module....
|
by: MLH |
last post by:
Trouble is, it doesn't happen every time. Yesterday, for example, it
happened only once and not again afterward. Some days ago, a similar
situation. Today, well - I tried 7 times straight to open the report
and each time, A97 shuts down. The seemingly hit 'n miss nature of
the error is intriguing. All I've been able to determine is that if I
allow the report to be opened from within code using this line...
DoCmd.OpenReport...
| | |
by: MLH |
last post by:
Here's the button click code that blows up my procedure...
Private Sub CopyMySQLbttn_Click()
171 Dim dtxt As Object
172 Set dtxt = Me!TextHolder
173 Me!TextHolder = MySQL
174 DoCmd.GoToControl "TextHolder"
175 dtxt.SelStart = 0
176 dtxt.SelLength = 13
177 DoCmd.RunCommand acCmdCopy
|
by: MLH |
last post by:
A runtime error 13 (type mismatch) occurs running the following line:
Set rst = dbs.OpenRecordset("tblMyTable", dbOpenTable)
What would be the most likely place I would find the source of the
error? The DAO code lines providing dependencies to this one are...
Dim dbs As Database, rst as RecordSet
Set dbs = CurrentDb
|
by: MLH |
last post by:
A97 aborts creation of MDE reporting that there's a compile
error in one form. Sure enough, if I remove the form from the
source database and attempt to compile the MDE, it succeeds.
But when I open the source MDB file and the form's class
module, click Debug, Compile Loaded Modules - no compile
time error is reported. What is the MDE doing to find a compile
time error that Debug/Compile Loaded Modules is not?
If you've encountered...
|
by: MLH |
last post by:
Invalid qualifier error displays at compile time on this A97 example
from Permissions Property HELP. What's wrong with the strContainerName
assignment line? (6th line)
Sub SetDocPermissions(docUnknown As Document)
Dim strContainerName As String
' Set UserName property to valid existing group account.
docUnknown.UserName = "Marketers"
' Get value of Container property.
strContainerName = docUnknown.Container.Name
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
