Solved

Open Access Window remains and will not close

Posted on 2000-03-23
4
292 Views
Last Modified: 2011-04-14
If I run the following code and then close the mdb file, there remains an open Access window which will minimise but will not close. How can I prevent this?


Public Sub AddIconProperty()
   
    Dim prpAppIcon
    Dim prop As Property
           
    Set dbs = CurrentDb
    Set prpAppIcon = dbs.CreateProperty("AppIcon")
    prpAppIcon.Name = "AppIcon"
    prpAppIcon.Type = dbText
    prpAppIcon.Value = "C:\My Documents\Other\WORK\Rimses Reports\Reports.ico"
    On Error GoTo Err_Appending_Property
    dbs.Properties.Append prpAppIcon

    RefreshTitleBar
       
Exit_AddIconProperty:
    Exit Sub
   
Err_Appending_Property:
    Exit Sub
       
End Sub


Nick
0
Comment
Question by:ncw
  • 2
4 Comments
 
LVL 2

Expert Comment

by:goyam
ID: 2649351
Hi,
try to set all object to nothing before exit:
set dbs=nothing
set prpAppIcon =nothing.
Regards
0
 
LVL 1

Accepted Solution

by:
pclement earned 25 total points
ID: 2649974
I think you've encountered a documented bug in Access. See the following:

ACC97: Unable to Quit Microsoft Access
http://support.microsoft.com/support/kb/articles/Q190/0/74.ASP

0
 
LVL 1

Author Comment

by:ncw
ID: 2667091
It seems to have solved its self, I must have modified the code and its ok now. Thanks
0
 
LVL 1

Expert Comment

by:pclement
ID: 2667260
Those are the best kind. ;-)

Thanks.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now