Software

Ask something
Question Locked

I need a popup please.

0 helpful
2 replies

by jmedley0231

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am devolping a program for the input of security related data in a local hospital, nothing too fancy. When I finally got everything up and running the only major complaint I got from the people that are actually using it is that they don't know if they have actually saved when they press the button. What I would like to do is set it up as when they hit the button to save a message comes up saying "New record has been saved" and, if possible it would force a new page on the form so more data could be input after. Anybody have an idea on how to do this? (I'm using MS Access 2003)

2 replies

by scott_heath

I don't do access programming, but my offhand guess would be to call use VBA when the button is called and check for the sucess of the save anf pop a message box. Something like:

sub save_item
on error resume next
err.clear
DoCmd.DoMenuItem acSaveRecord (blah, blah, maybe some other stuff)
if err.number <> then
msgbox "record not saved"
else
msgbox "record saved"
end if
end sub

It's kind a mess and rough, but do some Googling and you'll find better examples

Regards,
Scott

http://scottisageek.spaces.live.com

This discussion is closed to new replies.