Customer MsgBox by Arvin Meyer - A Question

[True.Kilted.Scot]

Arvin ( or anyone else who can help )

I have altered and am using your code above, to create several customer
message boxes for my application. However, rather than just display
the message and an OK button, I wanted to go one step further.

In my application, the message box can appear in numerous places, and
display numerous messages. As a result, there are times when I would
like more control over how the message box behaves. For example,
rather than display an "Ok" button, I would like to see a "Yes" & "No"
button, with the function / module returning exactly what button was
pressed, thereby allowing me to act accordingly.

For example, if an employee modifies the currently displayed record and
then presses the close button, I would like a customer messagebox to
appear with a "Yes" and "No" button in it. If the employee presses
"Yes", then the modified data will be saved, otherwise it will be
discarded.

I have tried adding the buttons that I require onto the form, with
their "visibkle" property set to FALSE. Then, after changing the coder
form, it passes booleans representing the button I want on the form.
The buttons .visible property is then set to the boolean value that is
passed.

This seems a good idea, in theory. However, when I code it and run it,
I always get a "Yes" button on the form, even although its .visible
property is set to FALSE.

So, my question(s):

1. Is what I want to do possible?
2. Why is it not working the way I am doing it?
3. If it is possible, how do I do it?

Many thanks & regards

Duncan

 

[Douglas J Steele]

While I'm sure Arvin will probably chime in with other suggestions, one
possibility is to look at my May, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access"

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[True.Kilted.Scot]

Doug,

Thanks for your reply and a look at your suggested code.

Unfortunately, I don't think the code is quite what I'm looking for,
nor is it easily incorporated into my database.

You see, with Arvin's original code, I modified the "MsgBox Coder"
window to allow 8 lines of text, any of which could be bold, coloured
or aligned. This suits my needs for displaying certain messages.

With your code, I'm not entirely sure how I could alter it to use the
original MsgBox function, with 8 separate lines of formatted text.

I will of course still look and see if there is anyway I can take the
code relative to the buttons, and use it, if that is OK with you?

However, if anyone has any other ideas, I am all ears!!

Regards

Duncs