Access Shortcuts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a shortcut to the desktop for a switchboard. I want only
the switchboard, and not the entire access program pane to open when I click
this shortcut. How do I do this?
 
I think you mean you want to "hide" the Access main screen (tables,
forms, queries...tabs)
Try Tools/StartUp and uncheck Display Database Window.
 
You can drag a form from the Database window onto your Windows desktop, to
act as a shortcut to start the database and fire off this form. However,
that approach will show the database window.

Using API code, it is possible (though messy) to hide the main Access
window. Details in:
Manipulate Access Window
at:
http://www.mvps.org/access/api/api0019.htm

Note that a form normally opens as a child window of the main Access window,
so if you hide OMAIN, your form will not show either. You could try settting
the form's Popup property to Yes, so it opens as a standalone form and not a
child of the Access window.
 
rerailer said:
I want to create a shortcut to the desktop for a switchboard. I want only
the switchboard, and not the entire access program pane to open when I
click
this shortcut. How do I do this?
Click to expand...

I tried posting this a couple of days ago with no success. Sorry if this
gets double posted.

Here is one trick I use. It opens up an Access form into which I enter
criteria for a query (Query-by-form), prints my report, and exits Access.

Create a Sub or Function like this in your Access database:
Sub OpenMyForm
DoCmd.OpenForm "frm_AnyForm", acNormal, , , , acDialog
End Sub

Create a VBScript file containing the following:
Set AccApp = CreateObject("Access.Application")
loc = "C:\Documents and settings\DB1.mdb" 'put path to your
database here
AccApp.OpenCurrentDatabase loc
AccApp.Run "OpenMyForm"
AccApp.CloseCurrentDatabase
AccApp.Quit
Set AccApp = nothing

Create a shortcut to this script on your desktop. It will open just the
form, which will stay open until you close it because it is a dialog box,
with Access running hidden. When you close the form, Access will close.

I don't know how well this will work with a switchboard.

Dave
66 Fox
 
Back
Top