NEW 123 Error Handler Wizard for Access

This Wizard reviews your database and identifies all procedures without error-handling, and reports the On Error... statement for all other procedures. You then select which procedures to add error-handling. The Wizard then adds error-handling to the selected procedures in one automated operation. Options include global error-reporting and error-logging.

123 Error-Handler

SmartForm+ v1.2.1

New version 1.2.1 adds the option to create a continuous form.

Download v1.2.1

Office 2003 News

Office 2003 Beta Site

The Office 2003 Beta Web Site provides the full lowdown on product editions. There will not be an Office2003 Developer Edition.

Access 2003 Developer Extensions will be bundled with Visual Studio 2003.

An interesting development is the new Office Marketplace, which offers the opportunity for 3rd party Office add-on vendors to apply for a free listing of their product. This link will only work in the US. For non-US visitors:

1. Go to: http://officebeta.microsoft.com
2. Click on “Office Worldwide” in the left navigation bar in the Related Web Sites section
3. Click on “United States” – this will set the “right” cookie in your browser
4. Go to http://office.microsoft.com/marketplace/omp.aspx

New Features in Access2003

Smart Tags
Extensible smart tags now supported. Embed smart tags into any Access field. Any control on a form, report or data page will have a property for specifying smart tags. Any field or column on a table will also have this property. The columns in a query will inherit this property from the table the query is based on.

XML
Importing and Exporting XML files more flexible. Work with XML files of any schema and import them into the existing structure of an Access database, or continue to use an XSL Transform (XSLT). A new Export option allows application of an XSLT during the export, and creation of an XML file in a custom schema.

Linked Tables Between Access and Windows SharePoint Services
Link tables to lists on SharePoint Web sites. Windows SharePoint Services used as an Access database server using the Link Table feature by specifying the link type and selecting the URL and list name.

Backup Database
Backup Jet database files from within Access, which automatically names the backup file based on the current date to the last backup directory location, after a Compact and Repair.

Dependent Objects
New Dependent Objects feature sets out the dependents of any object in a Jet database. There is a new “Dependents...” command added to the shortcut menu when right-clicking on a Table, Query, Form or Report. The “Dependents…” command is also available in the View menu.

Font Control for the SQL Window
Control the font and fontsize of the text in the SQL window from the Tools menu, under Options, by selecting the Tables/Queries tab.

Error Checking
In Microsoft Office XP, Excel 2002 introduced the idea of using the AutoCorrect On Object User Interface to note common spreadsheet errors and give the user options for how to correct them. For Office 2003, Access will use a SmartTag to flag common errors on forms and offer options for correction.

Make Local Table
Copy a linked table to the clipboard and paste it back into the database to make it a local table.

Propagate Field Properties
Modify a field property in one place and propagate that new value to all controls that are bound to that same field.

Design View Shortcut In the Access Database window, to open an object in Design view, hold down the <Ctrl> key and double-click on the object's icon. More tips, samples, articles & code on the FreeAccess Access Utilities CD IIf Reloaded In response last month's tip, Use the IIf Function for True-False Comparisons in Queries, Tobias Migge from Germany, has rightly pointed out that IIf always evaluates both the truepart and falsepart, even though it returns only one of them. For example: If evaluating falsepart results in a division by zero error, an error occurs even if the expression is True. In such cases, call a module-level function that uses the If... Then statement. Avoid complex calculations in one or both of the truepart and falsepart. Standardise your Forms and Reports with AutoFormat Design a form/report that uses your standard fonts, colors, borders, background settings, and control properties. In Design view, from the Menubar select Format, AutoFormat... , and then in the AutoFormat Dialog click Customize... Under Customize options in the Customize AutoFormat dialog box, select Create A New AutoFormat Based On The Form/Report and click OK. Enter a name for the standard style in the New Style Name dialog, and click OK. Click Close. To apply the custom format to a form/report, open the form/report in Design view, select Format, AutoFormat... , then select the new format from the Form/Report AutoFormats list, and click OK. Change the Default Position of Attached Labels Access attaches a label to the left of a control by default. To change the default position of a control's attached label you can set the left and top co-ordinates of the label using the control's Label X and Label Y properties. For example, to change the default so that the label appears to the right of a text box: In Design view, double-click the form's Properties button to open the form's Properties window. In the Toolbox, click the Text Box button, to display the default Text Box properties in the Properties window. On the Format tab, change the default from -1 to 1in (or -3 to 3cm) for the Label X property. You can also change the default position of the attached label so it is located above the text box, by setting the Label X property to 0 and the Label Y property to -0.25in (or -0.75cm). Get the Name of the ActiveControl The ActiveControl object does not have a Name property, so you need to use the Control object class: Function GetActiveCtlName() As String __Dim ctlCurrentControl As Control __Set ctlCurrentControl = Screen.ActiveControl __GetActiveCtlName = ctlCurrentControl.Name End Function Windows Keyboard Shortcuts Windows Keyboard Shortcuts Primer

Fabrikam2.0 Office XP Sample Application from Microsoft
"Fabrikam 2.0 is a complete Microsoft Office XP sample solution that demonstrates how developers can build efficient and powerful solutions for enterprises."

Access 2002 Desktop Developer's Handbook
Sample Chapter 15: Application Optimisation

Using the CurrentProject Object - Access 2000/2002

The CurrentProject object has several collections that contain all Access objects in the current database:

Collection	Object type
AllForms	All forms
AllReports	All reports
AllMacros	All macros
AllModules	All modules
AllDataAccessPages	All data access pages

You can use these collections in code to accomplish various tasks. The following example prints the name of each open form in the AllForms collection.

Sub AllForms()
    Dim obj As AccessObject, dbs As Object
    Set dbs = Application.CurrentProject
    ' Search for open forms in the AllForms collection.
    For Each obj In dbs.AllForms
        If obj.IsLoaded = True Then
            ' Print name of obj.
            Debug.Print obj.Name
        End If
    Next obj
End Sub

Access Help provides extensive documentation on the CurrentProject object and many useful code examples.

The Code Project - Free Source Code and Tutorials

Planet Source-Code

4Developers.com

• Access Copy Protector An Access application that copy protects an .mde, so that it will run only on the machine that it is installed on. 
  
• 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.

 

ACC2000:

Q823332 Availability of Access 2000 Post-Service Pack 3 Hotfix Rollup Package

Q823336 Availability of Access 2000 Post-Service Pack 3 Hotfix Rollup Package

Q821787 You Receive an Error Message When You Overwrite or When You Delete a Kandji + Dakuten (Japanese Voiced Sound Mark) String

Q814093 Access Quits Unexpectedly When Viewing Report Preview

ACC2002:

Q295251 Access Crashes When You Sort a Table That Has a Subdatasheet

Q821809 Microsoft Access Quits When You Link ODBC Tables

Q823337 Availability of Access 2002 Post-Service Pack 2 Hotfix Rollup Package

Q814094 Error Message: Cannot Apply Filter on One or More Fields That Are Specified in the Filter Property

Q302525 "Run-Time Error '3709'" Error Message When You Enter a Large Amount of Text in a Memo Field That Contains an Index

Q295255 "Login Failed for User 'NT AUTHORITY\ANONYMOUS LOGON'." Error When You Try to Link a Table

Q291539 Create and Drop Tables and Relationships Using SQL DDL

Q289681 "File Already in Use" Error Message When You Open a Database That Is Located on a Novell NetWare Server

Q291162 AutoNumber Field Duplicates Previous Values After You Compact and Repair a Database

Q303968 How to Create an SQL Pass-Through Query

 

No 21 July 2003
No 20 June 2003
No 19 May 2003
No 18 April 2003
No 17 March 2003
No 16 February 2003
No 15 December 2002 / January 2003
No 14 November 2002
No 13 October 2002

Download a Searchable Compendium of Issues 1-12  

Download a .Zip File of All Issues 1-22  

Visit our Link Partner: Superior Software for Windows Access, SQLServer and .NET Downloads www.ssw.com.au

Top

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

Have questions or comments?
Send them to me.

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.

Access is a trademark of Microsoft Corporation.

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

Top