Startup Home Page in Access 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed Hawley - 25 Feb 2007 16:12 GMT

I have an Access database built in Access 2003. I was able to set up a start
page form that opens when the database is selected. I did some modifications
to the database including some form name changes. Now when I open the
database, I get an error message that the form names is misspelled or
corrupted. How do I find the fault and change the previous form name to the
new name.

Any help will be appreciated.

Reply to this Message

tina - 25 Feb 2007 17:06 GMT

from the database window, click Tools | Startup on the menu bar, and change
the startup form name in the dialog box.

hth

> I have an Access database built in Access 2003. I was able to set up a start
> page form that opens when the database is selected. I did some modifications
[quoted text clipped - 4 lines]
>
> Any help will be appreciated.

Reply to this Message

Ed Hawley - 25 Feb 2007 17:50 GMT

Dear Tina,
Thanks for the quick reply but I am using Access 2007 and can find no
reference to Startup on the menu bar. Access 2007 has a totally different
menu setup from earlier versions, this one has a "Ribbon" type of menu. It
does offer a number of options but none of them relate to the "Startup" that
I remember from earlier versions. Are you familiar with this version and do
you know what it would be called in this version?

Again, thanks and if you have any further thoughts, I would appreciate
hearing from you.

Ed

> from the database window, click Tools | Startup on the menu bar, and
> change
[quoted text clipped - 13 lines]
>>
>> Any help will be appreciated.

Reply to this Message

Jeff Conrad - 25 Feb 2007 18:28 GMT

Hi Ed,

1. Click the Microsoft Office Button (upper left corner)
2. Click the Access Options button (near bottom right corner of Office menu)
3. Click the Currrent Database category on left side
4. The Startup form option is near the top
5. Select your startup form from the combo box
6. Click OK to save and close Access Options dialog box.

Viola!

Signature

Jeff Conrad - Access Junkie - MVP
Co-author - Microsoft Office Access 2007 Inside Out
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

> Dear Tina,
> Thanks for the quick reply but I am using Access 2007 and can find no reference to Startup on the
[quoted text clipped - 9 lines]
>> from the database window, click Tools | Startup on the menu bar, and change
>> the startup form name in the dialog box.

Reply to this Message

Ed Hawley - 26 Feb 2007 00:22 GMT

Jeff,

Thanks! Your suggestions were right on. I made the changes and the database
works as it should. Now I only need a way to put the database icon on the
desktop and go directly to the particular database and have it open to my
"Data Center" home page. I should be able to do that also.

Thanks Again!

Ed

> Hi Ed,
>
[quoted text clipped - 24 lines]
>>> change
>>> the startup form name in the dialog box.

Reply to this Message

Jeff Conrad - 26 Feb 2007 02:26 GMT

You're welcome, glad to help.
Good luck with your project.

Signature

Jeff Conrad - Access Junkie - MVP
Co-author - Microsoft Office Access 2007 Inside Out
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

> Jeff,
>
[quoted text clipped - 3 lines]
>
> Thanks Again!

Reply to this Message

tina - 25 Feb 2007 19:11 GMT

i keep forgetting how different menus can be in A2007, sorry! i shouldn't
answer these questions at all, because i don't have A2007.

> Dear Tina,
> Thanks for the quick reply but I am using Access 2007 and can find no
[quoted text clipped - 26 lines]
> >>
> >> Any help will be appreciated.

Reply to this Message

Ed Hawley - 26 Feb 2007 00:24 GMT

Hello Tina,

Don't stop trying to help those of us who get lost in our projects. I am
quite sure you are right much more than you are wrong. Also, sometimes even
when you may be wrong, you will give us ideas we can use for the problem at
hand or later on.

Thanks Again for taking the time to offer your help.

Have a Great Day!

Ed

>i keep forgetting how different menus can be in A2007, sorry! i shouldn't
> answer these questions at all, because i don't have A2007.
[quoted text clipped - 33 lines]
>> >>
>> >> Any help will be appreciated.

Reply to this Message

tina - 26 Feb 2007 01:15 GMT

you're very welcome, Ed, and thank you for your kind words. :)

> Hello Tina,
>
[quoted text clipped - 45 lines]
> >> >>
> >> >> Any help will be appreciated.

Reply to this Message