![[Bytes Link logo]](../../../cgif/bytelnk2.gif)
Office Suites November
by By John Heenan, Jc heenan@ csi.com - December 02, 2000 at 23:24:24:
We went back to review our Access Customer form, again. We emphasized the ease of which a Text Box-type field is changed to a Combo Box and the differences in the properties of two combo box fields. One of these fields was based on a query that contained a single field, while the second field was based on a query that contained two fields and was dependent on the results of the first combo box. There is still a problem to note with this second query. We needed to add to this query a one-line macro or a VB event procedure to again query this Combo box. Otherwise, continued attempts to choose the appropriate postal code would show the postal codes of the city where the query was used for the first time.We then went to our lookup table in Excel. The point of this was to show that the lookup wizard is available to insert the combination of INDEX and MATCH functions that had been inserted into the worksheet manually. This wizard makes it easy to set up a search for an item in any array.
Lastly, we went back to review the uses of a Custom View and its advantage in sorting and printing a portion of an Excel worksheet. We looked at the Print Setup in the File menu to demonstrate the power of this dialog box in producing a sorted list with page and column headings.
Our topic, this month is Word 97 vs. Word 2000. There seemed to be more questions about the uses of Word in different situations.
Next month—We will continue to look into the differences between Word 97 and Word 2000..
Future Topics—Excel 2000 installation, Excel 97 vs. Excel 2000
![[------STRIPE-----]](../../../cgif/str1.gif){kind=small}
Site Disclaimer Suggestions? E-Mail to webmaster@noccc.org