Hi
Although I have had a few more people than normal unsubscribe to this Newsletter since the change to a simpler format, the number of new subscriptions has continued to grow at the rate of about three a day, so thanks for your interest in using VBA in Office.
I hope I can continue to provide you with a range of Office 2000 information and tips that will be relevant and help to improve your productivity.
Gary Radley
GRSoftware
**********
VBA TUTOR MONTHLY NEWSLETTER: #19 ~ 1/3/2001
[ 1120 Subscribers ~ ^110 in February ]
**********
VBA UPDATE & NEWS:
*********
SITE #1 ~ http://cma.zdnet.com/texis/techinfobase/techinfobase/pdisplay.html?docid=55929300
This article looks at the “Small Business Tools” available in Office 2000. It argues that these tools are the main reason why a business should upgrade to Office 2000 from Office ’97.
SITE #2: ~ http://cma.zdnet.com/texis/techinfobase/techinfobase/pdisplay.html?docid=2682118
This is the full text of a recent [19th Feb 2001 ] PC Magazine article on Preventing and Curing Word Macro Viruses.
SITE #3: ~ http://www.cabinc.win.net/Seminars/ICELoForms/index.htm
An article presented at the London VBA Developers Conference, 1998, on using Forms with Access Tables and Queries over the Web. It includes samples and
**********
FORM TIP: [Excel]
If you want to transfer automatically the value (choice) of a combo box or list box to a cell, no need to program. Use the property "LinkedCell" of the control. In design mode, right click on the control, choose properties and insert the cell address on the proper line.
**********
WORD TIP:
Positioning tables where you want them can be a tricky feat in Word, especially when you'd like to position document text beside them.
Word 2000 has enhanced table layout capabilities so that they act more like drawing objects, where you can drag and drop tables virtually anywhere on the page as well as wrap text around them. However, you can add similar drag-and-drop and wrapping capabilities to your Word 97 and Word 98 tables by placing them in a text box.
[1] Select ‘Insert | Text Box’ or use the Text Box button on the Drawing toolbar to insert a Text Box.
[2] Place the insertion point inside the text box, if it isn't already there, by clicking inside it.
[3] Insert your table by selecting ‘Table | Insert Table’ from the menu bar or by clicking the Insert Table button on the Standard toolbar.
You can now adjust the table's position and wrapping style by customizing the text box's position and wrapping settings.
EXCEL TIP:
Use the toggle “Ctrl + ` “ to show/hide ALL formulas in a worksheet. [Note: the “ ` ” symbol is on the same key as the tilde symbol ( ~ ) ]
ACCESS TIP:
For a quick and dirty solution accessing to the DAO Database object without requiring you to set a reference to the DAO library, you can use the CurrentDB method. Assuming you're working with an MDB file, the CurrentDB method sets up a hidden reference to the Microsoft DAO 3.6 Object Library, allowing you to work with Database properties and methods.
**********
If you wish to unsubscribe, send an email with "unsubscribe" as the subject to unsubscribe@austarnet.com.au
**********