Expression errors after exporting data 2

[JustSara]

I'm trying to duplicate a database I've made. I've created a blank database (db2) and I choose File --> Import Data --> And choose db1.mdb since it has all the info.

Everything will import over into my new database and work just great until I close it and reopen it. Once I close it and reopen it I can't open any of the forms anymore. I keep getting Expression Errors. One form tells me "Undefined Function CLNG in expression". The other forms tell me that OnActivate and OnCurrent aren't working.

I don't know how to find where these expressions are or how to fix them. Any ideas?
Sara

 

[GDGarth]

I'm guessing you have a reference problem.

Open any code window, then choose "Tools", "References". Make sure any references that were checked in the original database are checked in the new one.

 

[JustSara]

I checked the references and they look ok. I have figured out that when I import into the new database none of the code is being imported. When I open a code window in the new database Access gives me a tiny warning dialogue box but it's empty... It has the yellow triangle with the exclamation point in it but it doesn't say anything and I can't open up anything to just put the code back in. Any idea on how to fix it?

 

[SgtJarrow]

A thought is that you Access is hosed...try reinstalling Access and see what happens.

****************************
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com