Hope you had a great Christmas and survive the new Millennium OK!
I have found it increasingly difficult to find the necessary time to continue distributing the VBA Tutor Newsletter in its present online format, especially the associated tutorials. Instead, I will distribute a simple newsletter listing some ***** VBA resources, tips and news once a month.
NOTE: These listings will continue to be online as well.
**********
VBA TUTOR MONTHLY NEWSLETTER: #17 ~ 1/1/2001
[ 950 Subscribers ~ ^90 in December ]
**********
VBA UPDATE & NEWS:
I have had several requests for help with getting ACCESS data into VBA for use in both Word and Excel. The easiest and LATEST way is to use ADO (ActiveX Data Objects).
A good place to start is with "Say Hello to ActiveX Data Objects" @
http://msdn.microsoft.com/library/partbook/vb6/sayhellotoactivexdataobjectsado.htm , which states that ...
"With the Internet changing the way people handle data, not only do programmers need to access relational data sources, but also non-relational data such as hyper text markup language (HTML), mail, video, text, legacy system data, and just about anything else you can imagine."
Click on the "TOC" (Table of Contents) link at the top of the above web page to find out all about ADO.
*********
SITE #1 ~ http://archive.baarns.com/Main/
An excellent collection of FAQ's, Tips and Downloads from a VBA Developer site.
SITE #2 ~ http://www.beyondtechnology.com
Some good Excel resources, but make sure you check out “Peedy” the parrot, the “future” (?) of computer software.
SITE #3 ~ http://www.excel-vba-access.com/access/access-vba.htm
Although the “English” of this French Canadian site can be a bit stilted in places, this site has some excellent Access tips.
**********
WORD TIP :
When changing the size of a table's rows and columns by dragging its row and column borders in either direction, press [Alt] as you drag the row or column border. As you do, Word displays the exact row or column dimensions in the ruler.
EXCEL TIP:
Unlike Excel 97 where the Map tool was installed automatically, in Excel 2000 you will have to install the Map feature yourself.
[1] Choose “View | Toolbars | Customize” from the menu bar.
[2] Click on the “Commands” tab and select “Insert” from the Categories list box.
[3] Scroll through the Commands list box to locate “Map” and then click and drag the Map icon up to any of the visible toolbars.
[4] Click “Close” to dismiss the Customize dialog box. You can now launch Microsoft Map by clicking the Map button.
ACCESS TIP:
In the “Other” Tab section of the properties sheet for form controls in ACCESS, you will find the “Tag” property item. This property allows you to associate up to 2,084 characters of text with any form, report, section, or control. It can used to group controls.
Example:
[1] Enter “Hide” into the “Tag” property for a group of controls you wish to hide when the user click a control on a form.
[2] Then, attach the following code to a button's Click event procedure.
‘other code
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Tag = "Hide" Then
ctl.Visible = False
End If
Next
‘other code
[3] When the user clicks on the command button, other controls on the form with the “Tag” property set to “hide’ will be hidden. The reverse would be to show controls that have been hidden.
**********
If you wish to unsubscribe, send an email with "unsubscribe" as the subject to unsubscribe@austarnet.com.au
**********