By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,010 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

VBA Syntex

P: n/a
I'm a newbe to the world of VBA so to say that I am lost is a major
understatement. I recently was helped with a major problem I had (thanks
Cheese_whiz) but now I need to tweak my VB code to make the project look more
professional. I'm not going to repeat what I just went through with my error
messages, rather you can view the thread on New Users, under the topic -
Macros, Error Messages, and Forms.

The solution worked, and it worked well. I even discovered how to send the
cursor to the field I wanted. All by trial and error, and a lot of reading.
Now my issues:

I need to make my error dialog boxes display a proper title. When I encounter
the custom error message my dialog box reads "Microsoft Office Access".

I need to change this to read "Vessel Maintenance Database" (or whatever my
boss decides to name this thing). How do I do that in VB? And to what
property do I attach it to? Currently my custom error message is attached to
my Save button (since I could never get the macros to work properly).

This is only the first of many questions I will have about this topic and the
changes I need to make. Any assistance from anyone would be most appreciated
as my paycheck depends on this. (Well sorta. Maybe not the paycheck but
perhaps a pay raise.)

--
Message posted via http://www.accessmonster.com

Mar 1 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mar 1, 5:14 pm, "thebiggermac via AccessMonster.com" <u31786@uwe>
wrote:
I'm a newbe to the world of VBA so to say that I am lost is a major
understatement. I recently was helped with a major problem I had (thanks
Cheese_whiz) but now I need to tweak my VB code to make the project look more
professional. I'm not going to repeat what I just went through with my error
messages, rather you can view the thread on New Users, under the topic -
Macros, Error Messages, and Forms.

The solution worked, and it worked well. I even discovered how to send the
cursor to the field I wanted. All by trial and error, and a lot of reading.
Now my issues:

I need to make my error dialog boxes display a proper title. When I encounter
the custom error message my dialog box reads "Microsoft Office Access".

I need to change this to read "Vessel Maintenance Database" (or whatever my
boss decides to name this thing). How do I do that in VB? And to what
property do I attach it to? Currently my custom error message is attached to
my Save button (since I could never get the macros to work properly).

This is only the first of many questions I will have about this topic and the
changes I need to make. Any assistance from anyone would be most appreciated
as my paycheck depends on this. (Well sorta. Maybe not the paycheck but
perhaps a pay raise.)

--
Message posted viahttp://www.accessmonster.com

Any message box that does not have a caption defined for it will
display the Title of the database/project. If it has not been given a
name it will display Microsoft Access. Give the database a name by
setting it in the Tools Startup menu.

Mar 1 '07 #2

P: n/a
Already done. It has an appropriate database name: "Vessel Maintenance
Database"

The error message dialog box still displays something else.

storrboy wrote:
>On Mar 1, 5:14 pm, "thebiggermac via AccessMonster.com" <u31786@uwe>
wrote:
>I'm a newbe to the world of VBA so to say that I am lost is a major
understatement. I recently was helped with a major problem I had (thanks
[quoted text clipped - 22 lines]
>--
Message posted viahttp://www.accessmonster.com

Any message box that does not have a caption defined for it will
display the Title of the database/project. If it has not been given a
name it will display Microsoft Access. Give the database a name by
setting it in the Tools Startup menu.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200703/1

Mar 1 '07 #3

P: n/a
You can use
MsgBox Str(Err) & " " & Err.Description, vbCritical, "A big Cock up"

the vbCritical can be a vbInformation (or lots of other things) and the
Title "A big Cock Up" may not go down well with the boss. so something like
"Insuficient Information" might go down better.

See the help file

HTH

Phil

"thebiggermac via AccessMonster.com" <u31786@uwewrote in message
news:6e8ce29c8bf7c@uwe...
Already done. It has an appropriate database name: "Vessel Maintenance
Database"

The error message dialog box still displays something else.

storrboy wrote:
>>On Mar 1, 5:14 pm, "thebiggermac via AccessMonster.com" <u31786@uwe>
wrote:
>>I'm a newbe to the world of VBA so to say that I am lost is a major
understatement. I recently was helped with a major problem I had (thanks
[quoted text clipped - 22 lines]
>>--
Message posted viahttp://www.accessmonster.com

Any message box that does not have a caption defined for it will
display the Title of the database/project. If it has not been given a
name it will display Microsoft Access. Give the database a name by
setting it in the Tools Startup menu.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200703/1

Mar 1 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.