Problem creating MDE

[MiAs]

I am trying to create an MDE within A97 but I get "compile error message in a hidden module" Form.......
I experimented with a timer function for auto close down of a form but abandoned it.
I thought I had removed all the timer controls but it seems they are hidden preventing me making the MDE.
Any suggestions welcome.

 

[Rich]

Have you Compilled and saved all modules?

 

[MiAs]

Yes I tried that but got the message:
'Compile error:method or data member not found'
I have seen in the help files that my problem may be due to an error in a hidden module,but how do I unhide the module to check?

 

[dt01pqt]

To unhide db objects go to Tools -> Options -> View. In the show options chech hidden objects.

 

[MiAs]

Hidden objects already checked.

 

[dt01pqt]

Repair the database before compiling. It might be a system object that is corrupted.

 

[MiAs]

Done that,
still same problem.

 

[dt01pqt]

"Important Some restrictions may prevent you from saving your database as an MDE file:

· If your database is secured with user-level security, you must meet certain criteria.
· If your database is replicated, you must first remove replication system tables and properties.
· If your database references another database or add-in, you must save all databases or add-ins in the chain of references as MDE files."

 

[MiAs]

These restrictions don't apply.

 

[Rich]

Does it not show which method or data member isn't found, do you have any missing references, have you tried importing everything into a new blank db?

 

[MiAs]

Importing everything into a new blank db,
won't that import the problem also?

 

[Rich]

Have you tried it?

 

[MiAs]

Tried & failed.

When running the debug - compile,as I mentioned I get an error message:Method or data member not found.
When O.K.ing this message a section of code is highlighted in blue which is part of a txtbox-combobox setup on a form,the txtbox reading from the cbobox to autofill.
This setup works OK and doesn't appear to have a problem.

 

[dt01pqt]

I agree it might be a refrences issue. Note this applies under the add-ins restrictions. You might want to change the priority of some or the references. Also sometimes I find you need to write a refrenced properties in full i.e. VBA.DateTime.Date rather than just Date.

 

[WindSailor]

Or...
This may sound silly, but create another textbox-combobox setup on the form with the same functionalilty - everything identical - and see if you get an identical error...
I have had Access lose its internal reference to objects textboxes etc. on the form before and a simple restructure or rebuild will solve it.

 

[Rich]

Post the code that is highlited in blue

 

[MiAs]

I will try Windsailors suggestion and re-create the form which appears to be causing the problem.
Unfortunately I do not have access (pardon the pun) to the db now as it's at work so I will continue tomorrow UK.
The db contains sensitive information and has to be renamed with innocuous items before I can post any part of it.

 

[Rich]

You don't need to post the db just to post the code that's highlited in blue

 

[MiAs]

When trying to compile, as mentioned I get error message:Method or data member not found.
I have several txt-cbo boxes on form

Private Sub cboSurname1 AfterUpdate()
Me.txtNumber1=Me.cboSurname1.Column(1)
End Sub

The highlighted bit is .cboSurname1

 

[MarkK]

Try...
As previously posted...
Open a blank database, click File->GetExternalData...->Import and import everything from the problem database file. Reset your references.
Takes < 2 minutes and solves multitudes of spooky compiler issues.