Pop Up Box

[Shazz]

Hi everyone,

I would like to put a Pop up Box in my database that pops up with a message on a certain date, can anyone help me with this?

Happy New Year to you all.

Shazz

 

[namliam]

If date() = #01/Jan/2010# then
    msgbox "Happy Newyear!"
end if

Something like that?

 

[Shazz]

Thanks for your reply, but where do I put this code, I am very new this Access, I know how to create a pop up box but that is my limit.

Shazz

 

[namliam]

Anywhere where you would want the popup box...

where would you stick your box if you want it? Exactly on that spot!

 

[Shazz]

I only want it to pop up on a particular date, so if I put the code in the form, will it just pop up on that date, or will it pop up everytime I open it.

Shaz

 

[Dennisk]

Create a macro called Autoexec and call a module function that contains the code.

any macro call 'Autoexec' will be executed every time the db is opened.