Unable to import a form from another database

[Matt Greatorex]

I've posted this in the 'General' forum, but without success, so I'm trying here.

I have two databases. One is 'live', one is for development. Once I get something working in the latter, I manually import it into the former (File - Get External data - Import). This has been working fine for just over two months.

Today, however, i'm trying to import a form and get one of the following messages:

"The search key was not found in any Record"

"No current record"

I'm unable to import the form. I also get the same error messages if i try to copy and paste the form within its own database.

The form in question has a lot of lengthy code behind various combo boxes, text boxes, etc. When I attempt to look at this code (via right-clicking on a field and going to Properties and the Event tab), none of it is present any more.

What's going on? This form took weeks to get working and now it can't be copied, renamed or imported, plus it appears to have been 'wiped' of everything but the visual features.

Any ideas what could be causing this? Can one form become 'corrupt'? If so, please say that there's some way to remedy it?

 

[RV]

Hello Matt,

perhaps one of these links will help you to get this sorted out.
I do hope it doesn't turn out that your form is corrupt as there's no way to remedy it.

PS how's life in Canada (I'm looking for opportunies )

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=88&Number=330002

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=88&Number=249362

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=82&Number=750847

RV

 

[Matt Greatorex]

Thanks for the response. Unfortunately, it does like corruption of some sort. I've spent all day on this $@&%ing problem and gotten nowhere.

I think I'm going to have to revert to a backup copy and manually redo whatever turns out to be missing.

As far as Canada goes, I'll send you a quick mail, so as to not clog up this forum with what could be seen as 'irrelevancies'.

 

[ghudson]

Have you tried to compile the database?

Also, have you tried to convert the form to a text file and then import that form into another database?

Export All Database Objects Into Text Files

 

[Matt Greatorex]

Thanks for the suggestion.

I hadn't tried that, no. Should it happen again (and I wouldn't bet against it), I shall do so.

In the end I found one of the suggestions described by Allen Browne did the job. In brief, I created a blank database and reimported everything. By that point, the one corrupt form wouldn't even allow itself to be opened in design mode, so I reverted to an earlier version and am altering back to how it was before the error.

Luckily for me, my bad memory means I kept copious notes of the changes made.