ms-access 2003: form does not open! help!

1
votes

i have an access db with forms, one of the forms is not opening. i double clicked on it, i tried to open in design mode. nothing happens. there's no error message, but nothing happens.

has anyone had this issue before?

i am sorry i actually am getting an error now:

The error said that there wasn't enough memory to open it or something to that effect.

2
ms-access
Can you open the table or query that the form gets its data from? - BenV
Do you have any code in the OnLoad event? - BenV
no i do not have any code on onload - Alex Gordon
Have you done a compact and repair? - BenV
no i have not. but what we do to mitigate this error is we make a copy of the file and when the new one stops working we use the old one. i tried to export the form that was not opening at all to a different database and it would not export at all, no error again - Alex Gordon

2 Answers

5
votes

Here's the bible for Access corruption issues.

http://www.granite.ab.ca/access/corruptmdbs.htm

First things first: try to decompile and recompile (check the help files on how to do that). Next, try creating a second database and importing your form from the corrupt one. Lastly, use SaveAsText and LoadFromText to export and reimport the form.

2
votes

The lack of an error message makes this extra challenging. OTOH, without an error message, how do you know the form hasn't opened? Could it be open but hidden?

Try these two commands in the Immediate Window:

DoCmd.OpenForm "YourForm", acNormal,,,,acWindowNormal

? Forms("YourForm").Name

Do you you get any error messages then? If so, tell us what error messages and at which step they occur.