Error in Visual Basic closes the database

[nicole bissell]

Hello,

I am working in a new form and still making changes to the visual basic
code of the form. Not always, but very often when I try to save my
changes in the visual basic window and press the icon, this window
closes(without saving) and the whole database, too.

I already tried to switch everything in a new form and error occurs
again after starting to work in the visual basic code of this specific
form not in others and I did compile and repair the db, too.

I would appreciate any other ideas.

Thanks Nicole

[Allen Browne]

Did you try a decompile?

This sequence should work:
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access, and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, and reference ambiguities are
resolved.

One other possible approach would be to save the form as text, delete,
compact, and then load it from the text file again. The syntax is:
SaveAsText acForm, "Form1", "C:\Form1.txt"
and
LoadFromText acForm, "Form1", "C:\Form1.txt"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"nicole bissell" <la******@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

Hello,

I am working in a new form and still making changes to the visual basic
code of the form. Not always, but very often when I try to save my
changes in the visual basic window and press the icon, this window
closes(without saving) and the whole database, too.

I already tried to switch everything in a new form and error occurs
again after starting to work in the visual basic code of this specific
form not in others and I did compile and repair the db, too.

I would appreciate any other ideas.

Thanks Nicole