Hi. You are correct. The "complex" way will allow you to control a lot, while the "easy" way will not be so sophisticated, but may be enough for your needs. Here's what you need to do for the "easy" way.I searched for that and found a bit of complexity in it, is there an easy way for that?
During my simple experience in the world of Excel and Access, I found that there are things that can be done in a difficult way and can be done in an easy way, it remains to find someone to help you with that.![]()
![]()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
Good luck with your project.Hi, I tried this way, The access is still visible in the background, but this fulfills the need because it has hidden the contents as I want, thank you very much
Awesome! Glad it helped.Hi, I tried this way, The access is still visible in the background, but this fulfills the need because it has hidden the contents as I want, thank you very much
Thanks a LotGood luck with your project.
I think you're asking how to use the regular Access application normally again, right? Just open it and then Maximize it. Or you could add some code to your startup to Maximize the app on certain login or condition that's only applicable to you.But @theDBguy, If I want to enter the access again how can I do that?
yes, I added a button in the main form with this code for editing later:I think you're asking how to use the regular Access application normally again, right? Just open it and then Maximize it. Or you could add some code to your startup to Maximize the app on certain login or condition that's only applicable to you.
DoCmd.ShowToolbar "Ribbon", acToolbarYes
Good job!yes, I added a button in the main form with this code for editing later:
Thanks AgainCode:DoCmd.ShowToolbar "Ribbon", acToolbarYes
@theDBguy this is old thread, but relevant.Hi. You are correct. The "complex" way will allow you to control a lot, while the "easy" way will not be so sophisticated, but may be enough for your needs. Here's what you need to do for the "easy" way.
- Go to Database Options and set your Document Window Options to Tabbed Documents, but uncheck Show Document Tabs
- In your startup code, add the following line:
DoCmd.ShowToolbar "Ribbon", acToolbarNo
- Open your application and Restore the Access database Window to match the size of your Form
- Close your app and open it again to verify the result
@isladogs Very nice effort. As said above, I was looking for hiding access app interface and came across.Have a look at my example database Control Application Interface - Mendip Data Systems
It uses the code in the link given by @Minty in post #4 plus some additional features.
I use this code in many of my applications and it works well. The application interface can be completely hidden so forms are left 'floating on the desktop'. Personally I don't think its a lot of effort to setup
View attachment 88966
Hi. Does it help if before you close the maximized windows you issue the restore command first?@theDBguy this is old thread, but relevant.
I was looking for hiding access app interface and came across. I liked this, the best of this is it is flexible. user can minimize, maximize according to their screen especially on the main form (dashboard).
Here I have question.
In my case I am using this code on two forms: 1) login page 2) Mainform / dashboard.
1. Login page is smaller size, adjust to open in middle of screen.
2. Dashboard goes to maximize and fits to window.
When user exits the app from dashboard, because it was of maximize size (while exiting), When user opens the app again, then my login form also goes maximized size. Access remembers the the last window size, when was closed.
I want, at least in the beginning it should open in smaller size to login page (login form).
In addition, login form has link to user registration form. which is again of different size, then access window stays at different size and registration form of different size.
what do you suggest?
Thank you very much. Restore command worked. Now app opens on it orginal 1st form size.Hi. Does it help if before you close the maximized windows you issue the restore command first?