TOC By Subject
Home Up Past Meetings Notes Links of Interest Site Map FAQs

[ TOC By Subject ] [ TOC By Date ] [ Applications ] [ Topic CrossRef ] [ Book Reviews ] [ Key Threads ] 

VBA User Functions
VBA Subroutines
VBA Code Examples by Topic
PowerPoint
Visual Studio for Office
Key Reference Documents

Other SIGS:
HAL-PC Web Technologies

Best Practices:

bulletSpreadsheet Design Best Practices: Stephen Rasey, HAL-PC Feb. 2000 - HTM Word
bulletSpreadsheet Modeling Best Practices: Read, Baston, Business Dynamics: April 1999.   102 p. PDF

Security:

bulletDigital Certificates and Trusted Sources for Running Excel Macros under High Macro Security 
bulletLink: Access Security: www.ltcomputerdesigns.com/Security.htm
bulletWindows XP Service Pack 2 - the major security upgrade
bulletOffice 2003 Service Pack 1 - Info, Links, and Opinions
bulletSecurity Tip: Do NOT Hide confidential data. Eliminate it.
bulletDo NOT paste Excel Workbooks into PowerPoint Presentations 
bulletRemove all REVISION MARKS from Word Documents before distribution.

Excel: Lists and Validation

bulletTip: Linked Validation  -  Make the validation pull-down list for Tasks depend upon the Project selected in another pull down list.

Access:

bulletMaking the current record the top record on a continuous form.
bulletlinking to two tables in different databases (under different security)    3-Sept-2004  .access.tablesdbdesign
bulletCreate and run an SQL-Server Stored Procedure from an Access frontend
bulletSQLServer Connection String Example:
bulletYou can control the Query Plan in an Access Query by the order you select the relationships in the Query Designer.

For questions or comments concerning content on this website: Stephen Rasey
Design of this site by Cheryl D. Wise
Copyright © 2000-2004 by WiserWays. All rights reserved.
Revised: 2005-07-10 01:09 .