Need code for message that does not require a response

[Bill Stillwell]

I need to show a message in my Access app that will be displayed while a form is open. This message will instruct the user what process he/she will need to use upon closing the form. I need this message to go away after the form is closed. I was given an example in a manual I had to use the "Infomessag e" command. Could not get it to work ??
Thanks, Bill Stillwell

[MMcCarthy]

Is there some reason you can't put the message in a label on the form?

[Bill Stillwell]

In detail, I am changing the background color of the form while decision is made what to do with it. (using the On Dirty property) The form is actually used for multiple things, and I do not want to change the form itself with a label. When the user makes the change, (change records, cancel input to database, etc.) the background will change back to the default color, and the message will go away.

[MMcCarthy]

Infomessage is a method of adodb connection. It is used to trigger error messages for things like connection problems. I'm not sure how you would use it without establishing an adodb connection.

Something else you might like to look at is the notify tray icon messages. Have a look at this tutorial and see if it's something you could adapt.

http://msdn.microsoft.com/en-us/library/aa930660.aspx

This is a shell structure that can be accessed from the Shell32.dll library.

If you do decide to go in this direction let me know and I'll direct some of our shell guru's in your direction. I don't use it much myself.

Mary

[Bill Stillwell]

Code for message that does not require a response

Mary (msquared),
Thanks for the input. Being a "rookie" in VBA, I need more hand-holding that you are probably used to.
The link you sent me about the notify tray icon message might work ....... I am trying to see what I can learn about its use. As I mentioned in the explanation of the original post, I just need a message that will be displayed while the form I have displayed has a different background color that the default color. As soon as the user does an action (select another record, cancel the entry, etc.), the background color will change back to the default color and the message will go away. The solution is probably not as 'simple' as I was hoping for. :-(
Bill Stillwell

[MMcCarthy]

The simple way of doing it and the way I would handle it is to have a label become visible for the duration and then go invisible.

I don't think the notify tray icon will be easy to accomplish but I'll point someone in this direction who may be able to help if you want to try it.

Mary

[Bill Stillwell]

Mary,
Believe it or not, I just fixed it (before reading your post) by coding it a little different than your suggestion, but it worked. I put my message on the form in "white" so it could not be seen. As soon as the back color of the form changed colors (indicating the data on the form was being changed), the white message was visible on the form with the new color. As soon as the option to accept or cancel the change was selected, the form gave a message indicating the data was either changed or the change was cancelled. The form turned white when the final message was presented, which made the message invisable again.
Thanks again for your help,
Bill Stillwell

[MMcCarthy]

Glad you got it sorted. :)