VBA Code Not Being Imported with Forms

[PaulA]

Hi, all--

I am importing forms from one A2K Db to another blank A2K database and the code behind the forms is not being imported as well.

Is this normal and, if so, how does one get the code over as well?

It's been a while since I've been doing this.

Thanks!

Addendum: I'm getting a message that says "Error Accessing File. Network Connection May Have Been Lost."

Paul

 

[vbaInet]

Paul, check the Has Module property on the Other tab of the form. Ensure its set to Yes.

 

[gemma-the-husky]

the code SHOULD import. definitely.

 

[vbaInet]

Yeap it should. I think the OP has solved this one from a different thread.

 

[boblarson]

Importing a form will bring the code over UNLESS the form is corrupted. In that case you would need to do the restore method where you copied out the code from the form(s) in question and then you set the HAS MODULE to NO which will delete the modules from them. Then import the forms into the new database and then add the code back by selecting HAS MODULE - YES and then go paste the entire module from your saved text (from notepad) into the VBA window. That should get them back in order.

 

[PaulA]

Thanks for all your responses.

I believe it has to do with having both Access 2007 and A2K on my computer.

I was able to accomplish what I needed to do.

 

[vbaInet]

Happy to know its all been sorted.