Hi All
How do I get rid of MSAccess Title in Warning boxes. When a form fails to
open (No Data for example) How do I stop the MsgBox Identifying the
Application as ACCESS by showing a MsgBox "Open Form was Cancelled" that has
ACCESS as it's Title.
tina - 23 Jan 2006 02:14 GMT
AFAIK, you can't change automatic warning messages' titles or content. all
you can do is to trap error codes and supply your own message boxes, using
the MsgBox() function's "Title" argument to show any title you choose.
hth
> Hi All
>
> How do I get rid of MSAccess Title in Warning boxes. When a form fails to
> open (No Data for example) How do I stop the MsgBox Identifying the
> Application as ACCESS by showing a MsgBox "Open Form was Cancelled" that has
> ACCESS as it's Title.
Arvin Meyer [MVP] - 23 Jan 2006 04:25 GMT
Some errors need to be handled by the operating system. That one can be
easily handled by adding error handling.
Right after the the name of the sub, add the line:
On Error Resume Next
If the form can't open, nothing will happen. If you want to give the user a
message, try this:
Sub Whatever()
On Error GoTo Error_Handler
DoCmd.OpenForm "frmWhatever"
Exit_Here:
Exit Sub
Error_Handler:
MsgBox "There's no data!", vbOKOnly, "YourTitleHere"
Resume Exit_Here
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
> Hi All
>
> How do I get rid of MSAccess Title in Warning boxes. When a form fails to
> open (No Data for example) How do I stop the MsgBox Identifying the
> Application as ACCESS by showing a MsgBox "Open Form was Cancelled" that has
> ACCESS as it's Title.
david epsom dot com dot au - 23 Jan 2006 08:14 GMT
Set the Application Title in the Start Up properties
of the database.
This will be used instead "Access" in all of the
"Access" messages.
You will still get "Access" in VBA message boxes,
but if you don't know what I mean by that, it probably
is not going to affect you.
(david)
> Hi All
>
> How do I get rid of MSAccess Title in Warning boxes. When a form fails to
> open (No Data for example) How do I stop the MsgBox Identifying the
> Application as ACCESS by showing a MsgBox "Open Form was Cancelled" that
> has ACCESS as it's Title.
Derek Brown - 23 Jan 2006 11:55 GMT
Thats very comprehensive Thanks to you all!!
> Set the Application Title in the Start Up properties
> of the database.
[quoted text clipped - 14 lines]
>> Application as ACCESS by showing a MsgBox "Open Form was Cancelled" that
>> has ACCESS as it's Title.