Error loading my database

  • Thread starter Thread starter skulmat
  • Start date Start date
S

skulmat

when i exit mt access database by either clicking on the
main "x" or my the button I created, the program exits,
but i it does not load again if i click the shortcut to my
database,and when i click ctrl-alt-del i see there is
something called msaccess still runing, when i force that
program to close then it does work.

I am running access 2000
 
skulmat said:
when i exit mt access database by either clicking on the
main "x" or my the button I created, the program exits,
but i it does not load again if i click the shortcut to my
database,and when i click ctrl-alt-del i see there is
something called msaccess still runing, when i force that
program to close then it does work.

I am running access 2000
Click to expand...

There is either a boolean control (usually a check box) which is not being
referred to explicity:

Instead of: If Me.chkBox Then

Use: If Me.chkBox = True Then
Or: If Me.chkBox.Value Then

Or there is a recordset left open and not closed in the exit procedure. Make
sure you explicity close objects you create:

Dim db As Database
Dim rst As Recordset

Set db = CurrentDb
Set rst = db.OpenRecordset("blah, blah")

rst.Close
Set rst = Nothing
Set db = Nothing

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top