Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / February 2008

Tip: Looking for answers? Try searching our database.

Minimise, Restaure,  Close

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
StePie - 02 Feb 2008 20:02 GMT
I would like to make my users to use only my forms to navigate and to close
my application. How can I make disappear the three icons on the title line
of MS Access... Thank you for your help..
Beetle - 02 Feb 2008 20:34 GMT
If you're referring to the min, max and close buttons for the main Access
window, I don't believe it's possible. However, you could use a forms Unload
event to prevent Access from closing. Here is one example of how to do it.

Supposing you have your own close button called cmdClose on your form, add a
checkbox called chkCloseFlag somewhere on your form and set it's visible
property to no. In the forms On Open event set the check box to true;

Private Sub Form_Open()

  Me.chkCloseFlag = True

End Sub

Then in the Click event for the close button, set the checkbox to false
before closing the form;

Private Sub cmdClose_Click()

 Me.chkCloseFlag = False
 Docmd.Close

End Sub

Finally in the Unload event, verify the value of the checkbox;

Private Sub Frorm_Unload(Cancel As Integer)

 If me.chkCloseFlag = True Then
    Cancel = True
    MsgBox "Please use the Close button to exit the application"
 End If

End Sub

If the form can't close then Access can't close.

Signature

_________

Sean Bailey

> I would like to make my users to use only my forms to navigate and to close
> my application. How can I make disappear the three icons on the title line
> of MS Access... Thank you for your help..
Ron - 03 Feb 2008 02:46 GMT
You can set the property for the close button to no, you can set the property
for the max/ min to neither and set the property for the control box to no
Signature

Ron

> If you're referring to the min, max and close buttons for the main Access
> window, I don't believe it's possible. However, you could use a forms Unload
[quoted text clipped - 36 lines]
> > my application. How can I make disappear the three icons on the title line
> > of MS Access... Thank you for your help..
Beetle - 03 Feb 2008 06:15 GMT
For the form window yes, but I think the OP is talking about the main Access
window. Are you saying there is a way do disable those buttons?
Signature

_________

Sean Bailey

> You can set the property for the close button to no, you can set the property
> for the max/ min to neither and set the property for the control box to no
[quoted text clipped - 39 lines]
> > > my application. How can I make disappear the three icons on the title line
> > > of MS Access... Thank you for your help..
boblarson - 03 Feb 2008 03:42 GMT
You can also set the border to none.
Signature

Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

> I would like to make my users to use only my forms to navigate and to close
> my application. How can I make disappear the three icons on the title line
> of MS Access... Thank you for your help..
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.