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

Question

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.

Can you open the table or query that the form gets its data from? — BenV, Jul 15 '10 at 18:11
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, Jul 15 '10 at 18:24
Have you written the bad form to a text file, copied all the other objects to a new database and then imported the bad form from text? — Fionnuala, Jul 15 '10 at 20:01
Can you open it in DESIGN VIEW and then switch to FORM VIEW? — David-W-Fenton, Jul 15 '10 at 23:28
neither design view nor form view work. i try to open it but it doesnt do anything — Alex Gordon, Jul 16 '10 at 16:18

score 5 · Answer 1 · answered Jul 15 '10 at 21:57

5

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.

answered Jul 15 '10 at 21:57

AMW

86
1

I wrote a script to automate the process of decompiling a database: http://stackoverflow.com/a/20666309/1399438 – StockB Dec 18 '13 at 20:22

HansUp · Accepted Answer · 2013-04-04T21:49:26.220

2

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.

edited Apr 04 '13 at 21:49

answered Jul 15 '10 at 18:44

HansUp

95,961
11
77
135

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. – Alex Gordon Jul 15 '10 at 18:56
Nuts. I hoped you would get an error message I knew what to do with. I can only fall back to 2 generic suggestions without much hope they will help: check your project's references; try decompile. – HansUp Jul 15 '10 at 19:03
2

"Not enough memory" usually means corruption somewhere in the VBA project. A backup/decompile/recompile cycle is in order. – David-W-Fenton Jul 15 '10 at 23:29

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

2 Answers2

Linked