compile error in hidden module (1 Viewer)

pungentSapling

NeedHotSauce?
Local time
Today, 02:46
Joined
Apr 4, 2002
Messages
116
I am getting athe following error message when I try to make an mde database

compile error in hidden module Form_frmReferance

does anyone know how to access the hidden module in order to look for the problem?
 

Fuga

Registered User.
Local time
Today, 08:46
Joined
Feb 28, 2002
Messages
566
Have you tried repairing the db?

Fuga.
 

pungentSapling

NeedHotSauce?
Local time
Today, 02:46
Joined
Apr 4, 2002
Messages
116
yes, to no avail
I have made mde copies of this db before... today I was editing the main form, went to save as mde and got the error.
I guess I am going to have to start over on the changes..
 

Opengrave

Registered User.
Local time
Today, 01:46
Joined
Sep 6, 2001
Messages
70
Have you shown all modules?
TOOLS->OPTIONS->VIEW then check HIDDEN OBJECTS
 

pungentSapling

NeedHotSauce?
Local time
Today, 02:46
Joined
Apr 4, 2002
Messages
116
i found out how to see the module.....It is just the code behind my form...I did not realize that it would be referred to as a hidden module.

Next question is why does it give me a compile error while making an mde. The database works fine as mdb. If there is a problem with the code why would i not get an error right away?

anyway here is the sub I changed does anyone see a prob?
[vbcode]

Private Sub cmdFin_Click()
On Error GoTo Err_cmdFin_Click
Me.Refresh
If Me.chkEHS = True Then
DoCmd.SendObject acSendReport, "rptService", acFormatRTF, "emailaddress@whatever.com, emailaddress@whatever.com", "emailAddress@whatever.com", , "Service Request", , False
Else
DoCmd.SendObject acSendReport, "rptService", acFormatRTF, "email address@whatever.com", "emailaddress@whatever.com", , "Service Request", , False
End If
DoCmd.Close
DoCmd.Quit

Exit_cmdFin_Click:
Exit Sub

Err_cmdFin_Click:
MsgBox Err.Description
Resume Exit_cmdFin_Click

End Sub
[/vbcode]
 

Opengrave

Registered User.
Local time
Today, 01:46
Joined
Sep 6, 2001
Messages
70
Go into the code window for the module and compile it there, it should highlight the line that has the error.

While viewing the code select the DEBUG menu then one of the compile options, I usually use COMPILE AND SAVE.
 

Users who are viewing this thread

Top Bottom