Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Forms

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-05-2010, 09:34 PM
carstenhdk carstenhdk is offline Windows XP Access 2007 (version 12.0)
Advanced Beginner
 
Join Date: May 2010
Location: Denmark
Posts: 42
carstenhdk is on a distinguished road
Default Instant load of a form

Hi


Is it possible to make the database load a form when it is started? When I click on the database file on the desktop, I would like it to instantly open the form Frontpage. How is that possible?


Carsten
Reply With Quote
  #2  
Old 05-05-2010, 10:09 PM
pbaldy's Avatar
pbaldy pbaldy is online now Windows XP Access 2007 (version 12.0)
Who is John Galt?
 
Join Date: Feb 2010
Location: Nevada, USA
Posts: 1,473
pbaldy is on a distinguished road
Default

In 2007 click the Office Button, Access Options, then Current Database. Select a Display Form.
__________________
Paul
MS Access MVP
www.BaldyWeb.com
Reply With Quote
  #3  
Old 05-05-2010, 10:27 PM
maximus's Avatar
maximus maximus is offline Windows 7 Access 2010 (version 14.0)
Wizard
 
Join Date: Aug 2009
Location: India
Posts: 804
Blog Entries: 1
maximus is on a distinguished road
Default

I asume that you are using Windows 7:

Click the Microsoft Office Button (upper left corner)
Click the Access Options button in the bottom right corner of the menu that appears
Click the Current Database category on the left side of the Access Options dialog box
Under Application Options section look for the option called "Display Form." Select your form name from the combo box
Click Ok to close the Access Options
The next time you open the database your form will load on Startup

You can also create an AutoExec Macro:

Set Action Of the Macro to Open Forms

Form Name=Select the Form you Want to Open
View=Form
Window=Normal

Now Name the Marco AutoExec.
When you start open your database the AutoExec maro is run and you form will open.



if this solves your problem mark the thread solved.
__________________
How to Mark a thead solved:
http://www.accessforums.net/forum-su...lved-1828.html

Contact
for Solutions to your database problems and at affordable rates
silverback_bats@yahoo.co.in
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Load Record from report in form rdirosato Reports 13 03-08-2010 07:35 PM
Change the text box color on form load mikec Programming 2 03-01-2010 08:47 PM
On Load, form not visible Bruce Forms 15 02-24-2010 01:06 PM
Program to load data fsmikwen Access 2 12-10-2009 05:36 AM
Load a form If a Registry Key exist on Registry heman85 Access 2 06-17-2009 07:50 PM


All times are GMT -8. The time now is 01:50 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.