What's New at FreeAccess?Developer Toolbar New
Easy access to all your database objects when creating a database.
Smart Form Wizard New Version 5.3.1
Now with the option to select the Filter Fields for Autofiltering
Build ready to run Access forms with navigation and autofiltering.
Ezy Exporter New Version 1.2
Now export data in bulk to .txt and .xml files
Access KB Browser New Version 1.2
Expanded search functionality
The easy way to search the on-line Microsoft Access Knowledge Base.
Handy Functions - look up the details in your Access Help file: - SysCmd
- IsDate
- IsNumeric
- InString
- AutoLookup
- DCount
How to refer to a control on a subform from the parent form: Me.txtTotal.Value = Me.OrdersSubForm.Form!txtOrderTotal Stop the Web Toolbar appearing
when users click a hyperlink in an Access form. Place the following code in the hyperlink's Click_Event: DoCmd.ShowToolbar "Web", acToolbarNo Tips for Faster Queries: - Compact your database often.
- When you join tables, try to index the fields on both sides of a join.
- If you use criteria to restrict the values in a field used in a join,the query may run faster if the criteria is added to the field on the "one" side of the join instead of the "many" side.
- When creating a query, add only the fields you need. In fields used to set criteria, clear the Show checkbox if those fields are not displayed.
- Avoid restrictive criteria on calculated and non-indexed columns.
- Avoid calculated fields in nested queries.
- When grouping records by the values in a joined field, specify Group By for the field that is in the same table as the field you are totalling.
- Use Group By on as few fields as possible.
Access2002 and Access2000 If you install Access2002 on a PC with Access2000, be prepared for problems. While the Access2000 .mdb format is the default in Access2002, you will need to retain Access2000 for testing of databases for Access2000 users. An Access 2000 .mdb built in Access2002 that runs fine in Access2002, can generate errors in Access2000. Also, if you issue .mde's to users, you cannot compile an Access 2000 .mdb in Access 2002, you still need Access2000 to create an Access2000 .mde.
Don't export or import objects to an Access200 .mdb in Access2000, if you also have Access2002/OfficeXP installed on the same PC. Doing so will corrupt the Access 2000 .mdb. To avoid this you must import/export only in Access2002. See the Access 2000 Knowledge Base Article - Error Message: Error Accessing File. Network Connection May Have Been Lost. (Q304548).
This section is now closed as all these files are now available on the FreeAccess Access Utilities CD
VB2TheMax FileBank A World of Data on Our Favorite Desktop Database
Private Sub ExportTablesAsText() 'Purpose:
' 1. Export all tables in the database as text files
' 2. Demonstrate use of the SetWarnings Method of the DocCmd Object
'Date: 10June2002
'By: Tony D'Ambra
'Reference
'Required: DAO 3.5(Access97) or DAO 3.6(Access2000/2002)
On Error GoTo ExportTablesAsTextError Dim db As DAO.Database, tdf As TableDef
Dim stTableName As String, stPrefix1 As String, stPrefix4 As String
Set db = CurrentDb()
For Each tdf In db.TableDefs stTableName = tdf.Name
stPrefix1 = Left$(stTableName, 1)
stPrefix4 = Left$(stTableName, 4)
If stPrefix4 <> "MSys" And stPrefix4 <> "USys" And stPrefix1 <> "~" Then Debug.Print stTableName 'For debugging
'Turn off error trapping in case the file exists
On Error Resume Next
'Turn off Access Warnings, and then
'Execute export of each table with field names as first row to Default Database Folder
DoCmd.SetWarnings False
'Transfer table data to text file
DoCmd.TransferText acExportDelim, , stTableName, stTableName & ".txt", True
'Turn Warnings Back On
DoCmd.SetWarnings True
End If
Next
Exit Sub
ExportTablesAsTextError:
'IMPORTANT: Reset Warnings Back On
DoCmd.SetWarnings True
MsgBox "Export Tables As Text Error " & Err & ". " & Err.Description
Exit Sub End Sub
Other free Access Newsletters: SMART ACCESS eXTRA
To subscribe, send a blank email to: subscribe-6050@uptilt.com Access Unlimited
To subscribe, send a blank email to: tips@gr-fx.com Woody's Access Watch
To subscribe, send a blank email to: waw@woodyswatch.com
A new Access HRIS database application
A comprehensive leave and training tracker
A new version of the Project Management database
Incorporating daily time management
Also on the drawingboard:
Instant Invoicer Wizard
Consolidation Query Wizard
Call Logging Database
Currency Exposure Manager Database
| 