Highlights

• FreeAccess Access Control Center ('FACC') Beta v1.0.3 is now available.
  FACC is stand-alone application to manage all your Access projects from within an integrated project environment. Projects are managed centrally and .mdb's are opened by the appropriate Access version automatically. The Shortcut Wizard creates desktop shortcuts for secured and unsecured databases with optional command-line switches. Beta Version 1.2 with one bug fix and many new features will be available shortly.
  
• The new Version 4.0 Beta of the Super Command Button Access Wizard is also available for download from.  Now you can customize your buttons before they are placed on a form. You can also save unlimited custom buttons formats, and apply them to your forms with a mouse-click.
  
  These Beta versions are free. Final versions will be sold for a nominal license fee.

Use the Distribute Setting Access 2000/2002 Only You can evenly distribute text within  a control by setting the TextAlign property to Distribute. Use Office XP Dialogs Access2002 Only Office XP has it own File Dialogs. You no longer need use API calls or the CommonDialog .ocx. Private Sub OpenFileDialog() ___Application.FileDialog(msoFileDialogOpen).Show End Sub This MS KB Article will get you started: How to Display and Use the FileDialog in Access 2002 Get more tips, samples, articles and   code from the FreeAccess Access Utilities CD Automatically Open a ComboBox Private Sub cboExample_GotFocus() ___Me.cboExample.Dropdown End Sub Size To Fit Forms Easily size your popup forms in Access by opening the form in FormView. The form should not be maximized and the form's BorderStyle should be Resizable. Then select Window, Size To Form from the MenuBar. Save the form by pressing Ctl+s.  You can now reset the BorderStyle in need. Form/Datasheet Keyboard Shortcuts Navigate between fields and record Move to the next field Move to the previous field Move to last field in current record if  a field is selected   Move to last field in  last record if a field is selected   Move to first field in  current record if a field is selected Move to  first field in first record  if a field is already selected Move to the current field in the next record Move to the current field in the previous record    Add a new record Delete the current record Save changes to the current record Toggle between the values in a check box or option button  Navigate between sections of a record    To cycle forward through sections To cycle back through section Navigate in forms with more than one page   To go down one page; at the end of the record,     moves to the equivalent page on the next record    To go up one page; at the end of the record,     moves to the equivalent page on the previous record Navigate between the main form and subform    To enter subform from the preceding field in the main form  To enter subform from the following field in the main form To exit subform and move to next field in the master form or next record To exit subform and move to previous field in main form or previous record Option Groups    Move to the next option or option group Move to the previous option or option group    Move between options in the selected drop-down list box or  between some options in a group of options    Perform action assigned to selected button;  select or clear the check box List Boxes    Open a drop-down list box Close a drop-down list box    Move between options in the selected drop-down list box   Cancel the command and close the list box TAB SHIFT+ TAB END CTRL+ END HOME CTRL+ HOME CTRL+ PAGEDOWN   CTRL+ PAGE UP SIGN (+)  CTRL+ PLUS SIGN (-)   CTRL+ MINUS SHIFT+ ENTER SPACEBAR F6 SHIFT+ F6 PAGE DOWN PAGE UP TAB SHIFT+TAB CTRL+TAB CTRL+ SHIFT+TAB TAB SHIFT+TAB Arrow keys SPACEBAR ALT+ DOWN ARROW ESC Arrow Keys ESC

MS Access - Listen Software

DBToFile

AccessTools

Irie Free Software

Microsoft Universal Data Access Download Page

Compact a Database Using Jet Function CompactDb(strSourceDB As String, strDestDB As String) Dim jetEngine As JRO.JetEngine Dim strSourceConnect As String Dim strDestConnect As String ' Build connection strings for SourceConnection ' and DestConnection arguments strSourceConnect = "Data Source=" & strSourceDB strDestConnect = "Data Source=" & strDestDB Set jetEngine = New JRO.JetEngine jetEngine.CompactDatabase strSourceConnect, strDestConnect Set jetEngine = Nothing End Function

Article and Code by David Nishimoto - As featured at devx.com Explains how to build a Data Manipulation Language (DML) transaction log to recover data in the event an Access database becomes corrupt.

mssqlserver.com The best place for MS SQL Server information

Computer Books Online

CONNECTIONSTRINGS.COM

MS Access Tips

Microsoft Access Help Center

Microsoft Access How to COPY-PROTECT Access Application

CodeHound VB - The Visual Basic Developer's Search Engine!

A P R E S S . C O M Books for Professionals, by Professionals ...

Aspen Learning Management Server

MS Office Product Documentation

Microsoft Access Help

Index for Access Tips

Allexperts Using MS Access Q&A

Microsoft Office Assistance Center Tips

DevArticles - Development articles, tutorials, help, guides

DevArticles - Visual Basic articles, tutorials, help, guides

Online Books - CNET.com

 

• A new version of the SmartForm Wizard that will create a lightweight form with zero code behind it, intelligent navigation buttons, and a standardised global code module.

•  XML Explorer Add-In Explore XML documents with this Access Add-In As XML documents are structured as trees of data., with this tool  you can did down into XML data using a Windows Explorer like interface.

 

No 15 December 2002 / Janaury 2003
No 14 November 2002
No 13 October 2002

Download a Searchable Compendium of Issues 1-12  

Other Access Newsletters/Sites

Access Developer News by Mike Gunderloy http://www.larkware.com

Superior Software for Windows Access SQLServer .NET Downloads http://www.ssw.com.au

Top

Subscription to this newsletter is free.

This newsletter may contain links to sites or files on the Internet which are owned and operated by third parties. AAD CONSULTING is not responsible for the content of or files from any such third-party site.

Any files are provided "as is", without warranty of any kind. AAD CONSULTING does not assume any liability for use or the consequences of use.

To subscribe or unsubscribe from this mailing list, select a choice from combo-box below, enter your email address and click OK:

Subscribe Unsubscribe

Have questions or comments?
Send them to us.

Access is a trademark of Microsoft Corporation.

©2001-2003
Anthony D'Ambra.
All rights reserved.

Top