Major Prooblem opening access database!!!!

[marcja]

I recently found a need to pass a message on to everyone that opened a certain access database. So in I thought the easiest way of doing this would be to use the startup page & macro on the Northwinds Sample Database that comes with access.

However, I kept getting an error because the ok button was pointing the main switchboard which doesnt exist on my database, so I tried deleting the following to see if it would sort the problem: -

' Closes Startup form.
' Used in OnClick property of OK command button on Startup form.
DoCmd.Close
DoCmd.OpenForm ("Main Switchboard")

Now I think I've made things a whole lot worse. When I opne the database I get that first startup form and of course the button doesnt work and everything else is disabled.

I could really do with some help on this one.

Thanks,

Marc.

P.s. Cracking forum guys, if it weren't for places like this people like me would be in a whole world of ****!!

 

[MStef]

Instead of "Main Svitchboard" put the name of your form you want to open
when close startup form.

 

[marcja]

Instead of "Main Svitchboard" put the name of your form you want to open
when close startup form.

But that's just it I cant close the startup form the Ok button isn't pointing anywhere since I deleted the code, therefore it won't close.

 

[MStef]

Look at "DemoMessageA2000.mdb". Open mdb.

 

[ghudson]

Check out the scrollingmessageboard.zip sample I posted @ Scrolling news using a record for a cool way to display information, news or updates to the users of your application.