Solved

Open Access Window remains and will not close

Posted on 2000-03-23
4
294 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

860 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