An unexpected Beta 3 release in late April has delayed shipment of the final product until October or November.
A view from builder.com:
The strongest arguments for an upgrade center on collaboration, communications, and XML integration. However, if your project team doesn’t have needs in these areas, then it might just be prudent for you to put off an upgrade to Office 2003.
SmartForm+ Wizard Released
A new version of the SmartForm Wizard that creates a lightweight form with zero code behind it, intelligent navigation buttons, and a standardized global code module. Download
You can split the Access module window into two scrollable panes. Drag the split box (the small rectangle that's directly above the vertical scroll bar) to where you want the split made. To remove the split, double-click on the split line.
Get more tips, samples, articles and code from the
Using the PrintOut method of the DoCmd object method provides a convenient way to fill in the options in the Print dialog box. Place a function in a report's On Detail Format event:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
___Dim rpt as Report ___Dim strMessage As String ___Dim intHorSize As Integer, intVerSize As Integer
___Set rpt = Me ___strMessage = "DisplayMessage"
___'Set scale to pixels, and set FontName and FontSize properties. ___With rpt ______.ScaleMode = 3 ______.FontName = "Courier" ______.FontSize = 24 ___End With
___' Calculate location of text to be displayed. ___Rpt.CurrentX = (Rpt.ScaleWidth/2) - (intHorSize/2) ___Rpt.CurrentY = (Rpt.ScaleHeight/2) - (intVerSize/2)
___' Print text on Report object. ___Rpt.Print strMessage
End Sub
Revert Command in Access 2000/2002
If you have made changes in design view to a form or report, and then want to discard the changes, click File from the main menubar, then Revert. The Revert command restores the form or report to the state it was in before you started the current editing session.
One less mouse-click :)
Jump straight to the module window from a [...] builder button and by-pass the Expression/Macro builders.
Select Tools/Options from the main menubar, click on the Forms/Reports tab, then select the Always Use Event Procedures check box, and click OK.
Easy Commenting - Access 2000/2002
In the Visual Basic Editor, select View/Toolbars/Edit from the menubar to display the Edit Toolbar, which has some useful shortcuts. For example, you can easily comment/uncomment a block of code. Highlight the code block, then click the Comment Block button on the Edit Toolbar. To uncomment back to executable code, select the code lines and click the Uncomment Block button.
New Access 2002 Shortcuts
F4 In Design view, opens the properties sheet
F7 When a form or report is open in Design view (with the focus on the Design view window or a properties sheet), takes the user to the code window, open to the form or report code module
Shift+F7 When the focus is on a properties sheet in Design view, moves the focus back to the design area without closing the properties sheet
F8 In a form or report in Design view, opens the field list; in a data access page in Design view, toggles the field list on or off
Ctrl+Right Arrow Moves to the next view when you’re working with tables, queries, forms, reports, pages, views, and stored procedures
Ctrl+Left Arrow Moves to the previous view when you’re working with tables, queries, forms, reports, pages, views, and stored procedures
Ctrl+Tab Navigates from a form or report section to a subsection
Enter In Design view, with a field selected in the field list in a form or report, adds the selected field to the form or report design surface
Right-click on the link and click Save Target to download the .pdf file.
www.samspublishing.com very generously offer sample chapters, articles, and even source code files, from their current titles, for free download. Do a search on "Access" at their home page.
The function's argument is a string identifying the drive's root folder. The return value is one of the contants declared above, depending on the drive type. If any other value is returned, the drive was not recognized.
The following procedure illustrates the use of this API function. The argument must be in the form required by the GetDriveType function: the drive letter followed by ":\".
Private Sub DriveType(dr as string)
___Dim dr As String ___Dim drivetype as Long
___drivetype = GetDriveType(dr)
___Select Case drivetype ______Case DRIVE_REMOVABLE: _________MsgBox "Drive " & dr & " is a removable drive" ______Case DRIVE_FIXED: _________MsgBox "Drive " & dr & " is a fixed (hard) drive" ______Case DRIVE_REMOTE: _________MsgBox "Drive " & dr & " is a remote (network) drive" ______Case DRIVE_CDROM: _________MsgBox "Drive " & dr & " is a CD-ROM drive" ______Case DRIVE_RAMDISK: _________MsgBox "Drive " & dr & " is a RAM drive" ______Case Else: _________MsgBox "Drive " & dr & " was not recognized" ___End Select
You can use the Microsoft Product Support Centers to view support information, common issues, downloads, related sites, instructions, troubleshooters, and more:
Microsoft's Support Lifecycle policy provides consistent and predictable guidelines for product support availability at the time of product release. The Support Lifecycle policy takes effect October 15, 2002 and applies to most products currently available through retail purchase or volume licensing and most future release products.
Located at http://support.microsoft.com/default.aspx?scid=fh;[LN];lifecycle
Newsgroup Support Boundaries
ACC2002: Microsoft Product Support Guidelines for MS Access http://support.microsoft.com/default.aspx?scid=KB;EN-US;298645 For Microsoft Access 2002
ACC2000: Microsoft Product Support Guidelines for MS Access http://support.microsoft.com/default.aspx?scid=KB;EN-US;298641 For Microsoft Access 2000
ACC: Microsoft Product Support Guidelines for MS Access http://support.microsoft.com/default.aspx?scid=KB;EN-US;166776 For Microsoft Access 97
Microsoft Newsletters
If you go to http://www.microsoft.com/misc/ and enter your .Net Passport username and password, you can select *all* sorts of Microsoft Newsletters to receive by e-mail.
Ezy SQL Editor and Builder Add-In that significantly improves on the Access Edit SQL Window.
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 dig down into XML data using a Windows Explorer like interface.
Sticky Toolbar - an Access form-based Toolbar that moves with a form.
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:
aadconsulting.com_ 
Office 2003 News