Search the Web:

Hi

Although I had to have a clear out of 40+ subscribers that were returning “Undeliverable mail” or “User Unknown” messages, I still managed to break the 1000 subscriber level this month, a pleasing result that keeps me going. Thank you!

A new section I have introduced this month is the “FORM TIP”, as I seem to get a lot of request for help with forms. I hope you find this addition helpful. As well, there have been several important “Office” developments from Microsoft. Check them out at Site 1 & Site 2.

Gary Radley

GRSoftware

**********

VBA TUTOR MONTHLY NEWSLETTER: #18  ~ 1/2/2001

[ 1020 Subscribers ~ ^70 in January after removing 40+]

**********

VBA UPDATE & NEWS:

@ http://cma.zdnet.com/texis/techinfobase/techinfobase/pdisplay.html?docid=2678433 , there is an interesting article by Woody Leonhard and Peter Deegan that explains the latest “Melissa” virus problems with VBA macros.

*********

SITE #1 ~ http://officeupdate.microsoft.com/2000/downloadDetails/o2ksmsdd.htm

The Office 2000 “Save My Settings Wizard” allows you to save your Office settings, store them on the Internet, then download and use them on another computer. Your Office 2000 settings, or profile, are a group of settings that defines your Office 2000 program preferences and options, including custom dictionaries and custom templates as well as AutoCorrect and AutoFormat lists.

SITE #2 ~ http://msofficeautoupdate.listbot.com/

The Microsoft Office Auto Update Notification Service is an e-mail list that you can join to find out when new updates are added to the Office Update Web site. The notification e-mail messages contain the name of the update, the download location for the update, a description of the update, and a list of the Office products that will be updated. This is a great way to be notified of critical or helpful Office updates, including additional product functionality or the latest security updates.

**********

FORM TIP:

Sometimes it is a good idea to “lead” the user through a series of sections in a large data input form. This is when you should use “Tabs”, referred to as “MultiPage” in the form design “Toolbox”. As the online Help explains ….

“The MultiPage lets you visually combine related information, while keeping the entire record readily accessible.”

You can let the user click on the tabs to move through the pages, or you can create CommandButtons or use some other “event” to move to the next page by using the following code example….

Private Sub CommandButton1_Click()

MultiPage1.Page1.Visible = False

MultiPage1.Page2.Visible = True

MultiPage1.Page2.Enabled = True

MultiPage1.Page1.Visible = True

End Sub

**********

WORD TIP :

If you want to display all drop down menu items rather than just the recently used ones, just double click on the main Toolbar menu item.

EXCEL TIP:

A drawback of the normal print preview in EXCEL is that the preview image is static. A more effective approach is to use “View | Page Break Preview”.  You will now see an editable view with blue borders indicating where page breaks exist. If you want to resize a page, simply drag and drop the appropriate blue lines

ACCESS TIP:

To improve data entry in ACCESS, you can shade the currently selected field.

First, add the following two statements to a module:

Global Const Orange = 39423
Global Const LightBlue = 16776960

Then, set the OnGotFocus and OnLostFocus events for the controls in the following format:

Private Sub controlName_GotFocus()
controlname.BackColor = Orange
End Sub

Private Sub controlName_LostFocus()
controlname.BackColor = LightBlue
End Sub

**********

If you wish to unsubscribe, send an email with "unsubscribe" as the subject to unsubscribe@austarnet.com.au

**********