dbTalk Databases Forums  

MS-Access doesnt close

comp.databases.ms-access comp.databases.ms-access


Discuss MS-Access doesnt close in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
maffonso@gbl.com.br
 
Posts: n/a

Default MS-Access doesnt close - 01-03-2005 , 10:33 AM






Hi guys,
Whenever i launch my app, use it and close it,
the MS-access insist in not finish. The app
ended but Ms-access keeps a windows opened.
Anyone knows this bug?? How to fix it??
Its MS-Access 2000.

Thank you all

Maffonso

Reply With Quote
  #2  
Old   
MGFoster
 
Posts: n/a

Default Re: MS-Access doesnt close - 01-03-2005 , 01:22 PM






-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

That was a recognized but in the earlier version of Access 2000. There
is a service pack (SP) that corrects that problem - see the Microsoft
download site.

In the mean time, one of the fixes was programmatic:

Some people use this True/False syntax:

If chkIsAllowed Then
...

If you used that syntax in your VBA change it to this:

If chkIsAllowed = True Then

Apparently, the bug happens when you don't use an explicit comparison
expression on a Boolean value.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQdmbCoechKqOuFEgEQI80ACfTUaNIqfUbWm+RIoIujLkO2 KqMz8AoMBk
nnkNILFycJE2KZfP3VxCydnO
=Ev9+
-----END PGP SIGNATURE-----


maffonso (AT) gbl (DOT) com.br wrote:
Quote:
Hi guys,
Whenever i launch my app, use it and close it,
the MS-access insist in not finish. The app
ended but Ms-access keeps a windows opened.
Anyone knows this bug?? How to fix it??
Its MS-Access 2000.

Reply With Quote
  #3  
Old   
laurenq uantrell
 
Posts: n/a

Default Re: MS-Access doesnt close - 01-03-2005 , 04:26 PM



Also a known bug, if closing Access from code, always use DoCmd.Quit
instead of Application.Quit.
lq


Reply With Quote
  #4  
Old   
laurenq uantrell
 
Posts: n/a

Default Re: MS-Access doesnt close - 01-03-2005 , 04:26 PM



Also a known bug, if closing Access from code, always use DoCmd.Quit
instead of Application.Quit.
lq


Reply With Quote
  #5  
Old   
laurenq uantrell
 
Posts: n/a

Default Re: MS-Access doesnt close - 01-03-2005 , 04:26 PM



Also a known bug, if closing Access from code, always use DoCmd.Quit
instead of Application.Quit.
lq


Reply With Quote
  #6  
Old   
Trevor Best
 
Posts: n/a

Default Re: MS-Access doesnt close - 01-04-2005 , 05:21 AM



MGFoster wrote:
Quote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

That was a recognized but in the earlier version of Access 2000. There
is a service pack (SP) that corrects that problem - see the Microsoft
download site.

In the mean time, one of the fixes was programmatic:

Some people use this True/False syntax:

If chkIsAllowed Then
...

If you used that syntax in your VBA change it to this:

If chkIsAllowed = True Then

Apparently, the bug happens when you don't use an explicit comparison
expression on a Boolean value.

You may also use:

If chkIsAllowed.Value then


--
This sig left intentionally blank


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.