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.
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.
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.