Calling Database

[stevan]

This is my first time using access and got it to work for a blank database.

The problem I ran into is how do I call for the form in the database from my desktop

I tried a shortcut but it does bring it up but i still have to click on the form to open it

Is there a way to make a shortcut on my desktop to open the form

THXS Steve

 

[monkeytunes]

If you go to "Tools" and choose "Startup", you can designate a form (either a custom form you design or one of Access' Switchboards) to open whenever you kick open the database.

 

[stevan]

Thxs that worked

I have another question I you do not mind

I have the customers email adress Is there a way to put a buton to call for a email form ??

THXS Steve

 

[monkeytunes]

You can use the Toolbox to place a "Command Button" on your form, and if you have Wizards enabled, Access will walk you through the various pre-set functions for a command button, one of which is "Open Form". As you get better with Access, you'll be able to change the events that command buttons perform, and chain the events, so a press of a button can close one form, open another form, pre-populate fields, etc. Experiment!

 

[ghudson]

I have the customers email adress Is there a way to put a buton to call for a email form ??

THXS Steve

This will open a new email draft and prefill the email address based on the value in your email text box and also prefill the subject and body.

Application.FollowHyperlink "mailto:" & YourEmailTextBox & "?subject=Test Email&body=Hello", , True

Searching the forum is a great way to answer the questions that have already been asked and answered before.