Access 2000 - Open Startup Form First 1

[dsmith910]

Hi

I'm running Access 2000 on Windows 98. I have just created a start up form - but its the second thing you see when you open the dbase.

As the dbase opens it shows the forms list or whatever I was working on last (the screen is locked so you can't do anything!) then my start up screen comes on. how do I 'blank out' the 'first bit' until it loads my start out form. I'm rather users had a blank screen followed by the start up than seeing the 'junk' behind.

Doren

 

[Dreamboat]

Doren, open the DB, close the form, then hit Window-Hide to hide the DB. Reopen and you should only see the form. Anne Troy

http://www.TheOfficeExperts.com

 

[dsmith910]

Hi Ann

Doubtless its me! I closed the start up form. Then went to 'Windows' and pressed 'Hide'. The list of forms disappeared - great! However when I went to close the dbase (to reopen it again) virtually everything is grayed out. If I close Access and go back in I'm back to where I started, i.e. the forms screen shows (but doesn't activate) first. Help! what am I doing?

Doreen

 

[Dreamboat]

Oops...it's Doreen, not Doren.

Sorry, my fault.

Go to Window and unhide the DB if you need to. Double-click your form.

Now, on your Form, you need an "Exit Database" option. Do you have one? If not, make one.

NOW hide the DB window. Exit the database with the button on the form.

If you can't get it to work, you can send it. It's really early here and I've got some time.
Anne@Theofficeexperts.com Anne Troy

http://www.TheOfficeExperts.com

 

[dsmith910]

Hi Anne

Many thanks - will try again. As you may be able to tell I'm a novice with Access - but learning fast!

Doreen

PS I typed my name wrong - must be getting senile

 

[Dreamboat]

LOL Anne Troy

http://www.TheOfficeExperts.com

 

[dsmith910]

Hi Anne

Yes, its me again! So I have put a button on my start up form but can only seem to get it to either close the application or close the form! Currently I've got DoCmd.Close - what else should I have on it to close the dbase?

Doreen

 

[Dreamboat]

What is your startup form? A switchboard?
If not, just create a command button on your form. The wizard should kick in (if you did a complete install) and ask you what operations to perform and exiting the database should be one of them. Of course, in Access, exiting the database would be the same as exit the application... Anne Troy

http://www.TheOfficeExperts.com

 

[dsmith910]

Hi Anne

My start up form is just a page which names the database and 'looks pretty' - it may eventually turn into a splash screen when I figure out how to do that! However in the meantime it would be nice if it was the first thing people saw. I can get the button to quit the application but when I go back in it still shows the form list (or table list) that I was in last. I used the wizard first off now I'm 'doing it alone' - but badly.

Could I put something in the Autoexec macro thingie that says 'window=hide' then goes on to open my start up form?

Doreen

 

[Dreamboat]

Damn!
Sorry, Doreen.

Just go to Tools-Startup.
There's a checkbox there to "hide the database window".


sorry! Anne Troy

http://www.TheOfficeExperts.com

 

[dsmith910]

Hi Anne

No apology necessary - am now much more familiar with buttons, etc, etc. - and your latest idea works just great - goto the top of the class!

would have taken me hours on my own.

Thanks again

Doreen (alias Doren)

 

[Dreamboat]

Woohoo!
LOL Anne Troy

http://www.TheOfficeExperts.com