Create a shortcut directly to a form

[Ron]

How can i create a shortcut on my desktop to open the
form only of an access database?
Thanks in advance...

 

[Fredg]

On the main database folder, right-click on the form name.
Select Create Shortcut

A shortcut will appear on the Desktop.

 

[Ron]

Actually, I want the form only to open, not open within
the access program. I have seen this done before, but am
not sure how.

Thanks for the help, and I apologize for being so vague
in my first post.

 

[Brian]

-----Original Message-----
How can i create a shortcut on my desktop to open the
form only of an access database?
Thanks in advance...
.

Hi Ron,

In Access 2002 you can create a asp and point the short

cut at it. You could also make a specific instance of the
front end under tools/startup/form set the form. You can
also open a specific form using switch setting on the end
of the file name which can start the form. If user
specific you can read thier systemuser variable and a
case statement to go to that form. You can also use the
user name to stop them or allow them navigation
privledges.

The following is from Access Help file:
Create a shortcut to open an Access file or database
object

Create a shortcut to an Access file in the Favorites
folder

The Favorites folder stores shortcuts to folders and
files you use frequently, including those in remote
locations, so that you don't have to search for the files
each time. The original file or folder doesn't move when
you create a shortcut to it.

Click Open on the toolbar.
To create a shortcut to a folder, subfolder, Microsoft
Access database (Microsoft Access database: A collection
of data and objects (such as tables, queries, or forms)
that is related to a particular topic or purpose. The
Microsoft Jet database engine manages the data.), or
Microsoft Access project (Microsoft Access project: An
Access file that connects to a Microsoft SQL Server
database and is used to create client/server
applications. A project file doesn't contain any data or
data-definition-based objects such as tables and views.)
that appears in the list under the Look in box, select
the file or folder, click Tools, and then click Add to
Favorites.
Create a shortcut to open an Access file or database
object

You can create a shortcut to open a database object
(database objects: An Access database contains objects
such as tables, queries, forms, reports, pages, macros,
and modules. An Access project contains objects such as
forms, reports, pages, macros, and modules.) in a
Microsoft Access file (Microsoft Access file: An Access
database or Access project file. An Access database
stores database objects and data in an .mdb file. A
project file doesn't contain data and is used to connect
to a Microsoft SQL Server database.) that is stored
locally on your computer or remotely on a network file
server or in a shared directory.

Under Objects in the Database window (Database window:
The window that appears when you open an Access database
or an Access project. It displays shortcuts for creating
new database objects and opening existing objects.),
click the type of database object you want to create a
shortcut for.
Right-click the object, and then click Create Shortcut.
If you want the shortcut to go to a location other than
the desktop, type a new path in the Location box, or
click Browse to choose the location and have Access fill
in the path for you. For example, you might want to store
the shortcut in the Favorites folder, which stores
shortcuts to items you use frequently.
If you're creating a shortcut for an object in a database
that is on a network, Access selects This Database is on
the Network, and fills in the network path in the Full
Network Path box. If you move the database later, you can
type in a new network path in this format:

\\server\share\filename

With the network path specified, you can, for example,
send the shortcut through e-mail so that others with
access to the network can use the shortcut, too.

Click OK.
When you double-click the shortcut, Access opens the
database in which the object is stored and displays the
object. A shortcut to a macro (macro: An action or set of
actions that you can use to automate tasks.) or stored
procedure runs that macro or stored procedure. To open
the object in a specific view, right-click the shortcut,
and then click the view you want.

Notes

If you move the database after you create the shortcut,
delete the shortcut and create a new one.
To delete a shortcut, click it and then press the DELETE
key. Deleting the shortcut does not delete the object
that the shortcut opens.
Tip

You can also drag the object from the Database window to
the desktop or to a folder. Make sure the place you want
to drag the shortcut to is visible. (If you previously
maximized the Access window, minimize it enough to show
the desktop or the folder where you want to place the
shortcut.)


Brian