CODEWITHSUNDEEP
ms-access
Alex Gordon
Alex Gordon

Reputation: 60691

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

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.

Upvotes: 1

Views: 5619

Answers (2)

HansUp
HansUp

Reputation: 97101

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.

Upvotes: 2

AMW
AMW

Reputation: 86

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.

Upvotes: 5

Related Questions