A new demo Access .mdb featuring four unique Switchboard paradigms: sdi, mdi, outlook-style sidebar, and explorer-like tree. Each implementation uses the native Switchboard Items table created by the Access Switchboard Manager. You can use the Switchboard Demo as a Contacts Manager or buy the source code for only US$15.
Version 2.0 of the popular FreeAccess Access Utilities CD of Access utilities, code samples, sample applications and articles is now available. V2.0 adds another 70mb to v1.0 for a total of 272mb of re-organised content and features a new built-in searchable content browser.
The new Access database Free TLT is a comprehensive HRIS application that tracks employee leave and training, with training profiles and extensive reporting. Review leave and training in the daily, weekly, and monthly lookaheads. Use the exclusive TLT SmartToolbar to filter and find records in all forms.
Keyboard Shortcuts Try these shortcuts in form design view:
F4 or Alt-Enter Switches the focus to the property sheet F5 Switches from design view to form view F7 Opens the Choose Builder dialog box F8 Opens the Field List Shift+F7 Switches the focus from the property sheet back to the form Alt-F11 Switches to the Visual Basic Editor
The Keyboard Shortcuts Tip is from the latest issue of the free Access newsletter ACCESS DEVELOPER NEWS from www.larkware.com.
ACCESS DEVELOPER NEWS is written by Access guru, Mike Gunderloy, and replaces the Smart Access Extra Newsletter, which has been discontinued.
The Access system table, MSysObjects, contains detailed information about the objects in an Access database. To view the table, in the Database Window, select Tools, Options from the Menubar, and in the View tab of the Options dialog, tick "System Tables" in the Show section. All system tables will now be listed in the Tables tab of the Database Window.
There are five key fields in the MSysObjects table:
Name the name of the object
DateCreate the date and time the object was created
DateUpdate the last date and time the object was changed
Connect And Database information on connections and linked tables
Type an integer identifying the object type:
Table 1 Query 5 Form -32768 Report -32764 Data Access Page -32756 'Access2000/2002 only Macro -32766 Module -32761 Relationship 8
You can easily document basic information on your database by querying the MSysObjects table. For example, the SQL query:
SELECT MsysObjects.Name, MsysObjects.DateCreate FROM MsysObjects WHERE ((Left([Name],4)<>"MSys") AND ((MsysObjects.Type)=1)) ORDER BY MsysObjects.Name;
will list each user table and its creation date in your database.
Access 2002 / Office XP Clipboard
In an Office XP application, start the Office Clipboard by selecting Edit, Office Clipboard... from the Menubar (or by holding down the Ctrl key and pressing the C key twice). The Office Clipboard will appear as a pane in the application window and a clipboard icon is placed in the Windows Taskbar icon tray. The Clipboard holds up to 24 items in a thumbnail gallery, including anything you copy or cut from any application, not just Office. Each time an item is added to the clipboard a tool tips type box hovers above the clipboard icon in the icon tray confirming the clipboard action.
You can't drag and drop graphics from the Office Clipboard into a document, but you can click inside the document where you want to paste, then click on the thumbnail in the Clipboard to paste into the document.
In this issue we feature HTML Help Authoring downloads.
HTML Help Center is a valuable resource for tutorials and HTML authoring freeware.
Web2Help is a really neat little freeware application which uses an easy to use wizard-interface to automatically compile a set of .html pages into a searchable .chm file. The .zip file is only 200kb.
Calculate the Number of Days Remaining in Current Year
Function DaysToEndOfYear(dtDate As Date) As Long 'Calculate the number of days remaining in the current year 'from a given date in the current year - dtDate
This newsletter may contain links to sites on the Internet which are owned and operated by third parties. AAD CONSULTING is not responsible for the content of 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 unsubscribe from this mailing list, enter your email address and click OK:
freeaccess.cjb.net 
Get the FreeAccess Access Utilities CD
Highlights: