There are two commonly used options:

1)There is an option to select the desired start up form:

Access 2000/2002/2003 -On the Menu -  Tools Startup... > Display Form/Page

Access 2007 - Office Button (upper left corner) > Access options (lower right) >
                         Current database >  Display Form
Access 2010 - File > Options > > Current database >  Display Form

2) use a macro named AutoExec

Action - OpenForm

Sample VBA code for downloading a file or web page from a URL:

'--- place this code in a standard module ---'
Option Compare Database
Option Explicit

Private Declare Function URLDownloadToFile Lib "urlmon" _
Alias "URLDownloadToFileA" (ByVal pCaller As Long, _
ByVal szURL As String, ByVal szFileName As String, _
ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long

Public Sub bimDownloadURLtoFile(pURL As String, _
      pFullFilePath As String)

   Call URLDownloadToFile(0, pURL, pFullFilePath, 0, 0)

End Sub

''' end code '''

It is possible to pass the username and password

on the URL like this:

http://username:password@hostname/pathtofile

or

ftp://username:password@hostname/pathtofile

Sub reports are great for showing data from a related table. This works just like a sub form, by setting the master/child linking fields.

What else can you use a sub report to print?

Other data that is not related to a specfic reord in the parent report. The trick is to not set the master/child linking fields. This allows you to print information in the report header or footer that is not "link" to a record.

Sub reports are great for sunmmizing the data in a report.

By basing an sub report's recprd source on the same record source as the parent report, you can show all the totals for each grouping (hiding the detail). You can also create a  totaling query based on the parent report's record source (query)

What if you want to place the report's total in the report header?

Use a sub report that cauclates and displays just the total.   

How do you print several different statistics that are caclulated with different queries?

Use sub reports. It is possible to have a parent report that has no record source, only sub reports.

Working with Report Header and Footer sections.

• Report Header - prints once at the beginning. This section can be set to grow or shrink.
• Pager Header - Prints at the top of each page. This section can NOT be set to grow or shrink.
• Group Headers - prints at the begining of each group This section can be set to grow or shrink. It can also be set to Repeat on each new page.
• Group Footers - prints at the end of each group. This section can be set to grow or shrink.
• Page Footer - prints at the bottom of each page. This section can NOT be set to grow or shrink.
• Report Footer - prints once at the end. This section can be set to grow or shrink.

When a report is used as a Sub Report, the header and footer sections work a little different.

• Report Header - prints once at the beginning. This section can be set to grow or shrink.
• Pager Header - does NOT print. The parent report is responsible for the page header
• Group Headers - prints at the begining of each group This section can grow or shrink. It can also be set to Repeat on each new page.
• Group Footers - prints at the end of each group. This section can be set to grow or shrink.
• Page Footer - does NOT print. The Parent report is responsible for the page footer.
• Report Footer - pirnts once at the end. This section can be set to grow or shrink.

Header and Footer Tips

Repeating Group Headers:

In the Group Header's prperties, set the Repeat property to Yes to get the header to print on every page if the group spans multiple pages.

Print Report Header without a Page Header:

In the Report's properties, set the Page Header property to Not With Rpt Hdr or Not With Rpt Hdr/Ftr depending on your needs.

Print Report Footer without a Page Footer:

In the Report's properties, set the Page Footer property to Not With Rpt Ftr or Not With Rpt Hdr/Ftr depending on your needs.

Here you will find some Third-Party Developer Tools and Code libraries to help speed up your Access programming.

ACCVER

Allows you to work with multiple versions of MS Access. Detects the version of Access used to create your MDB, MDA or MDE files and either reports the version number or starts the appropriate version of MS Access.

Auto FE Updater

The Auto FE Updater is a drag and drop deployment on the server.   No installation required.  Just download, unzip the files and place on the server.  The utility does not require any extra admin privileges to test or for the users to run the utility.  The IT folks in your organization do not need to be involved in your decision to use the Auto FE Updater.