import form/qry /tbl

[GaryPanic]

guys i have imported a form, table and Qry into my d/b (making a copy first of course ) and when i open up the form it has lost all of the coding behind the form itself and also throws a network error ..(lost network connectivity)
Have i been a muppet
d/b split at the moment FE/BE

access 2000
actions taken so far
ensure that correct libaries are added (check) MS activex 2.1
compact & repair (check)


throws a tantrium

have i missed a trick

my next route will be to manual type code nd create my own form ....

any pointers ??

 

[Grafixx01]

Well, as far as I know, when I copied forms from another DB into one of mine a similar situation happened. I had to go back and make sure that the modules and everything else was also imported. The controls and everything also had to have the same names / field types in the new form after importing. You'll also have to reconnect it to the new backend of the DB.

 

[pbaldy]

Watch out for this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;304548

 

[GaryPanic]

Paul - spot on
(thank god i made a copy )
heads up to Grafixx01

its a bitch - but hell at least theres a fix

I will try the following --
1. When you import to a new database, create a new database and import the objects into the new database. Or, when you copy objects in the current database, copy and paste the objects into the current database.
2. Before closing the database, open the Visual Basic Editor by pressing ALT+F11.
3. On the Debug menu, click Compile <database name>.
4. After you compile the database, close and save the database. Note that when you reopen the database and view the code, the error message that is mentioned in the "Symptoms" section of this article does not occur

 

[GaryPanic]

Paul - if you were a girlie , i'd kiss you - worked a charm

 

[pbaldy]

My wife has a strict "no-sharing" policy, so you're out of luck anyway.

Glad it helped you.

 

[GaryPanic]

yeah mine has the same -tried to compromise - but she isn't moving an inch..Women who understands them .lol