UserForm Auto Open On DB Open

[abyss]

is there any way 2 AutoOpen a userForm in MSAccess2000?
i mean that the form would appear when you openup myDb.mdb?
in excel theres smth like that:

Private Sub Workbook_Open()
Sesame.OpenUpYourselfDude
End Sub

any1?

thx

______________________________
i hate the light !!!

 

[mdmilner]

Try Tools-Startup (select appropriate form from drop down list)

Mike

 

[abyss]

there's only access report forms available....
i whant to launch vba UserForm

 

[Norie]

You have a VBA Userform in Access?

 

[abyss]

its an importable thing why not!!!

theorically: i create macro to launch UserForm1.Show, and to automate that macro. i'm trying to solve this broblem


o maybe you know how to put a "label" object in the toolbar menu, because
in my own toolbar there is only icons shown (OFF2000 no SP), i need labels like on xp... ...doh

any ideas. please feel 3 2 help

 

[Norie]

I didn't think you could have them?

Maybe it's a version thing.

Whenever I want to do anything a Userform type stuff I just used an unbound Access form.

They're basically the same. No?

 

[abyss]

no no.
access form is like a sheet, a report.... ...unless you are talkin about an object that is unknown to me...

UserForm is a window! its the winapi object where you can put components that you need...
i need a form with buttons labels and so on

or is there any way to get thees $%*$ labels in a toolbar object... ...doh

 

[Norie]

Goto the Forms tab of access and goto New>Design View.

You should now have a blank form which you can add buttons, labels, etc

Generally these are used for displaying the data in the database but can be used largely in the same way as a Userform.

Look at the Northwind database with it's switchboard thing.

 

[mdmilner]

Ok, In my copy of Access 2000 (U.S. distribution) I only have the option to startup with either Forms or Pages (Pages are Data Access Pages). I can not choose a Report.

UserForms is really an Excel Term. In Access, they're called "Forms" and have every bit of the functionality.

The syntax for opening a form is what you posted:

DoCmd.OpenForm

But you can really only use this behind an Event such as a button click.
I'm really wondering if Norie was correct - perhaps the copy of Access 2000 that you use has important differences from mine/ours.

Mike

 

[Norie]

Mike

An AutoOpen macro could be created.

I have one that runs other code to add controls to the command bar.