Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / January 2006

Tip: Looking for answers? Try searching our database.

How do I get rid of MSAccess in Warning boxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Derek Brown - 22 Jan 2006 23:23 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.