Turning off message boxes in code

[SueBK]

I have some users who (I think) possibly have a psycological block with databases. Therefore, everything is just too hard and confusing.
To try and overcome their fear I've added messages boxes with OK/cancel to each of my command buttons that says what the button does.
However, I can see that once they develop some confidence the messages are really going to tick them off.

Is it possible to code a separate button that will enable them to turn off all message boxes?

If there is, is it possible to 'reset' the messages when the database is exited (or would that happen automatically)?

 

[John Big Booty]

If you are talking about the native warning messages, the;

DoCmd.SetWarnings = False

Will switch them off, and;

DoCmd.SetWarnings = True

Will turn them back on.

 

[Isskint]

JBB, no i think she is talking custom message boxes. I have something similar for new users.


SueBK, This can be done and the best way is, assuming you have a user table (for UserID, passwords etc), add a field - ProvideInfo - as a Yes/No. When the user clicks a command button, have the code check ProvideInfo (Dlookup()) for the current user and only provide the 'comfort' message if ProvideInfo = TRUE. Switching it on and off can be done by providing either a 'profile page' form where they can set/unset ProvideInfo OR ask at logon/logoff.

 

[SueBK]

Isskint - that is exactly what I was looking for. Thanks.
I'm thinking that without user profile, I could simply have a checkbox on the form "Do you wish to see all the wonderfully helpful mesage that took me hours to program?" which could then run the same code behind each of my command buttons.

 

[Isskint]

Yes you could do that also. However without a table/field to store the value of the property, you would have to tick this box every time you use the DB.

 

[SueBK]

Decided that the easiest way was to turn all my message boxes into tool tips. They (the users) have irritated me enough for me to run out of hand-holding patience. They can just wait 5 seconds for the tool tip to show up.
However, I will stash away your assistance for another day.

 

[Isskint]

Database design and development would be a piece of cake it is wasnt for users


Wait until users start asking for different settings:- Font size, Fore Colours, Background Colurs etc :banghead: