Custom form to replace messagebox

Hello:

Two part question:

1.

I want to have a messagebox that will offer the users the following options
if they have overdue books and they try to check out a book:

Continue, and allow the checkout
Cancel the operation
Open their circulation record.

This cannot be done with a standard messagebox, correct?

2. Assuming I am correct about (1), I need to create a form that looks just
like a messagebox. Is there an easy way to do this? I.e., someone has
examples available for download; or the dimensions of the standard Access
message box and its command buttons..? If I want to be finicky, I can sit
with a ruler and make screen measurements, etc., but I wonder if I can avoid
this...

Thanks!
Fred Boer

Hi Fred,

Have you taken a look at Arvin Meyer's Custom MsgBox Creator
found here?:

http://www.datastrat.com/DataStrat2.html

That might be what you need.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Fred Boer" wrote in message:
...

Hello:

Two part question:

1.

I want to have a messagebox that will offer the users the following options
if they have overdue books and they try to check out a book:

Continue, and allow the checkout
Cancel the operation
Open their circulation record.

This cannot be done with a standard messagebox, correct?

2. Assuming I am correct about (1), I need to create a form that looks just
like a messagebox. Is there an easy way to do this? I.e., someone has
examples available for download; or the dimensions of the standard Access
message box and its command buttons..? If I want to be finicky, I can sit
with a ruler and make screen measurements, etc., but I wonder if I can avoid
this...

Thanks!
Fred Boer

How well the standard message box can be used in any given scenario really
depends on the question being asked....or how many times you want to prompt
the user. For example, you COULD use the standard message box with 2
prompts

intResponse = msgbox("The patron has overdue books. Do you want to
continue?", vbyesno,""Overdue Books")

If intResponse = vbNo Then
intResponse = msgbox("Do you want to review the patron's circulation
records?", vbyesno, "Review Records")
If intResponse = vbyes Then
Docmd.OpenForm "frmcirculation"
End if
End if

However, if you're trying to address this logic in one prompt, and you
cannot form the question in a manner that would fit in with the standard
messagebox options...yeah, you'd have to make a custom form. I don't have a
form that addresses the logic in your scenario, but it wouldn't be difficult
to make a generic one.

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


"Fred Boer" wrote in message
...
Hello:

Two part question:

1.

I want to have a messagebox that will offer the users the following
options if they have overdue books and they try to check out a book:

Continue, and allow the checkout
Cancel the operation
Open their circulation record.

This cannot be done with a standard messagebox, correct?

2. Assuming I am correct about (1), I need to create a form that looks
just like a messagebox. Is there an easy way to do this? I.e., someone has
examples available for download; or the dimensions of the standard Access
message box and its command buttons..? If I want to be finicky, I can sit
with a ruler and make screen measurements, etc., but I wonder if I can
avoid this...

Thanks!
Fred Boer

It can be done, you may have to explain yourselft to the user. Try using the
vbYesNoCancel option for the message box.

Then offer Yes = Continue Checkout
No = Do Not Checkout, Open Circulation Record
Cancel = Cancel

"Fred Boer" wrote:

Hello:

Two part question:

1.

I want to have a messagebox that will offer the users the following options
if they have overdue books and they try to check out a book:

Continue, and allow the checkout
Cancel the operation
Open their circulation record.

This cannot be done with a standard messagebox, correct?

2. Assuming I am correct about (1), I need to create a form that looks just
like a messagebox. Is there an easy way to do this? I.e., someone has
examples available for download; or the dimensions of the standard Access
message box and its command buttons..? If I want to be finicky, I can sit
with a ruler and make screen measurements, etc., but I wonder if I can avoid
this...

Thanks!
Fred Boer

Thanks, Jeff! Now that you mention it...

Boy the memory is going! Good thing I still have my looks! g

Fred

"Jeff Conrad" wrote in message
...
Hi Fred,

Have you taken a look at Arvin Meyer's Custom MsgBox Creator
found here?:

http://www.datastrat.com/DataStrat2.html

That might be what you need.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Fred Boer" wrote in message:
...

Hello:

Two part question:

1.

I want to have a messagebox that will offer the users the following
options
if they have overdue books and they try to check out a book:

Continue, and allow the checkout
Cancel the operation
Open their circulation record.

This cannot be done with a standard messagebox, correct?

2. Assuming I am correct about (1), I need to create a form that looks
just
like a messagebox. Is there an easy way to do this? I.e., someone has
examples available for download; or the dimensions of the standard Access
message box and its command buttons..? If I want to be finicky, I can sit
with a ruler and make screen measurements, etc., but I wonder if I can
avoid
this...

Thanks!
Fred Boer

Hi Paul:

Yes, I was hoping to avoid two prompts... And, no, it's not difficult to
create the custom form, (especially now that I've been reminded of Arvin's
solution), but, well, if it already existed somewhere, I could be
"selectively industrious!"

Fred

"Paul Overway" wrote in message
...
How well the standard message box can be used in any given scenario really
depends on the question being asked....or how many times you want to
prompt the user. For example, you COULD use the standard message box with
2 prompts

intResponse = msgbox("The patron has overdue books. Do you want to
continue?", vbyesno,""Overdue Books")

If intResponse = vbNo Then
intResponse = msgbox("Do you want to review the patron's circulation
records?", vbyesno, "Review Records")
If intResponse = vbyes Then
Docmd.OpenForm "frmcirculation"
End if
End if

However, if you're trying to address this logic in one prompt, and you
cannot form the question in a manner that would fit in with the standard
messagebox options...yeah, you'd have to make a custom form. I don't have
a form that addresses the logic in your scenario, but it wouldn't be
difficult to make a generic one.

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


"Fred Boer" wrote in message
...
Hello:

Two part question:

1.

I want to have a messagebox that will offer the users the following
options if they have overdue books and they try to check out a book:

Continue, and allow the checkout
Cancel the operation
Open their circulation record.

This cannot be done with a standard messagebox, correct?

2. Assuming I am correct about (1), I need to create a form that looks
just like a messagebox. Is there an easy way to do this? I.e., someone
has examples available for download; or the dimensions of the standard
Access message box and its command buttons..? If I want to be finicky, I
can sit with a ruler and make screen measurements, etc., but I wonder if
I can avoid this...

Thanks!
Fred Boer

"Fred Boer" wrote in message:
...

Thanks, Jeff! Now that you mention it...

No problem.

Boy the memory is going!

It is to be expected from someone of your advanced years.

Good thing I still have my looks! g

If you want to cling to that illusion Fred, you go right ahead.
g, d, & r
--
Jeff Conrad
Access Junkie
Bend, Oregon

I hadn't thought of that... Another good idea!

Thanks!
Fred


"Klatuu" wrote in message
...
It can be done, you may have to explain yourselft to the user. Try using
the
vbYesNoCancel option for the message box.

Then offer Yes = Continue Checkout
No = Do Not Checkout, Open Circulation Record
Cancel = Cancel

"Fred Boer" wrote:

Hello:

Two part question:

1.

I want to have a messagebox that will offer the users the following
options
if they have overdue books and they try to check out a book:

Continue, and allow the checkout
Cancel the operation
Open their circulation record.

This cannot be done with a standard messagebox, correct?

2. Assuming I am correct about (1), I need to create a form that looks
just
like a messagebox. Is there an easy way to do this? I.e., someone has
examples available for download; or the dimensions of the standard Access
message box and its command buttons..? If I want to be finicky, I can sit
with a ruler and make screen measurements, etc., but I wonder if I can
avoid
this...

Thanks!
Fred Boer