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.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"rerailer" <(E-Mail Removed)> wrote in message
news:10594538-46C6-46E5-AFAA-(E-Mail Removed)...
>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?

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"rerailer" <(E-Mail Removed)> wrote in message
news:10594538-46C6-46E5-AFAA-(E-Mail Removed)...
>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?

"rerailer" <(E-Mail Removed)> wrote in message
news:10594538-46C6-46E5-AFAA-(E-Mail Removed)...
>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 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