yes it can be done but you need to account for different users having different screen resolutions. Check out Peters Softwarehttp://www.peterssoftware.com/winmanip.htm he has a good windows manipulation example db that will maximize a popup to fit the desktop.
I'm looking to do the same thing, however I'm using Access 2007 and your link only covers up to Access 2003. Is it still applicable or should I look elsewhere?
thanks!
1. make a macro with the name MAX and give it the command 'MAXIMUM' ( don't know or the english term is right, I am using a local language version)
2. in the form you want to have full screen...
FORM OPEN - run macro MAX
FORM ACTIVE - run macro MAX
3. rename your original startup form as MAINMENU
4. create then a new form which you will start up with... for ex. START FORM
add the next procedure to this form...
docmd.openform "MAINMENU", acNormal, , , acFormEdit, acDialog
save it and close it
5. start now the START FORM and you will see it will show MAINMENU in full screen
I have a extra line in MAINMENU which will unload the START FORM
6. check seize of the forms or it will fit on each users screen... I have standard for anyone 1600... so I can put a lot of information it... if someone would have for ex. 1024... then I have to cut a big part away... that's why we upgraded everybody to the 1600 screens...
Thanks, - It works!
I've been avoiding macros to date as I've little experience in that area, but that's very straightforward.
There is an enhancement I'd like to make to this though - I'd like the window to move up so that the blue Access bar can't been seen and just the form displays. The reason being is that I've created a bespoke close button for the form and I don't want users to use the existing Access one on the top right corner of the top blue bar instead.
..... aha! I've just noticed in the form properties that the Access close button can be disabled. Problem saolved!
Well it all seemed too good to be true...! Adding the MAX macro to the form's properties seems to cut off the bottom of the form, ie. the Access bar that offers the user the option to scroll through records, create new record, selected filtered/ unfiltered and search ...
Can anyone suggest how I can get this bottom bar back?
Thanks in advance.
Well it all seemed too good to be true...! Adding the MAX macro to the form's properties seems to cut off the bottom of the form, ie. the Access bar that offers the user the option to scroll through records, create new record, selected filtered/ unfiltered and search ...
Can anyone suggest how I can get this bottom bar back?
Thanks in advance.
Just simply create some new buttons on the form with prev/next record, new, filter, search, etc.... all very standard buttons... will do the same job and you can place them anywhere... or using icons in a picture control and hang some code behind the CLICK event...
if you don't know which code to use behind a icon, create first a standard button with the function you want, copy the source code of that action to the icon... and hoppa easy job done... and beautiful buttons...