And when I have the main Access window minimized the numbers for the top, left of my form are even more bizzare (when placed in the top, left most corner the position is 19,013/18,113, what tha? With Access visible the position depends on where in the window Access is placed as well as the height of the ribbon and the width of the navigation pane). I have found a way to get the height of the Ribbon but not the width of the Navigation pane. If I drag the form further up or left its position goes negative. When trying to position a popup form it appears Access always uses the top, left corner of the Access window, below the Access Ribbon and to the right of the Navigation pane as the top, left most corner (position 0, 0). This will disable the right-click so the user can’t change the view as well as hide all your objects in the Navigation pane (and the Navigation pane itself) if the user happens to bring up the Access Window anyway.īut here’s a problem I’m running into with that, and I have googled my butt off looking for a solution. Double-click your icon and voila! Now you’ll ONLY see the main form appear, with Access minimized at the bottom of the screen.Īlso, a few other things to keep the user from going “behind the scenes”… save your project as an executable file (*.accde, Access 2010) and on the desktop shortcut add the switch “/runtime” at the very end of the “Target:” option, outside the quotes.Drop-down and choose ‘Minimized’ as shown below. Choose the ‘shortcut’ tab and notice a drop-down option called ‘Run’. Right click on the shortcut you just created and choose ”Properties.”.Then click ‘next’ and ‘finish’ if necessary, creating the icon on your desktop.In this example, I choose the OpenAccessFormOnly.accdb database. Go to your desktop, right click in any blank area and choose ‘New’ then ‘Shortcut’.Click “OK” to close the database options dialog box.In my example, I have selected the form frmMainMenu. In the “Display Form’’ option, drop-down the list and select the form you intend to use as the startup form. In the backstage view, open the Database Options window and choose the “Current Database” tab.Be sure to set the form property PopUp = True. In the attached example database OpenAccessFormOnly.accdb, I have the same main menu form entitled frmMainMenu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |