Sunday, June 13, 2004

Quick MS Access Tips:

Give your applications a quick makeover by globally replacing MS Sans Serif font with Tahoma.

Overcome the limited color choices offered by the Format menu for the backcolor of cells in datasheets by using VBA:

Private Sub Form_Open(Cancel As Integer)
Me.DatasheetBackColor = 12910591 'a soft yellow
End Sub

Free Evaluation of InstallShield X The new InstallShield X creates Windows Installer (MSI), InstallScript, and cross-platform installations and extends them to database servers, Web services, and mobile devices.

Tutorial: Validating XML Learn what validation is and how to check a document against a Document Type Definition (DTD) or XML Schema document.

I recently discovered the MSDN Library Archive for older content.

New Articles:

Bind an Access Form's Record Source from an XML File at Runtime Learn how to bind a form dynamically to a recordset created from an XML file.

Excel 2002/2003 Add-in for SQL Server Analysis Services Access multidimensional data, perform in-depth analysis, and create flexible, interactive reports in Microsoft Excel.

Access 2003/2002/2000 Sample: Summing in reports sample database Provides example reports that demonstrate creating group sums, report sums, page sums, running sums, and how to number the rows in your MS Access reports.

Office Talk: Easy Task Reports with Outlook and WordML How to export Outlook 2003 task data to XML and then use this as a source for reports in Word 2003. Sample Files

Recent MS Access Knowledge Base Articles:
Use this URL:;EN-US;xxxxx
where xxxxx is the Article No.

Access 2000

840644 "There are no Office Assistant character files present" error message when you start an Office 2000 program for the second time
841530 Office 2000 post-Service Pack 3 hotfix package: May 13, 2004

Access 2002

839781 You may receive an error message when you try to open a data access page in Access 2002
827983 Access 2002 post-Service Pack 3 hotfix package: May 7, 2004

Access 2003

838983 You may receive "The feature you are trying to use is on a network resource that is unavailable" error message when you try to remove an Access 2003 runtime application from your computer


826137 You may receive the "Can't find the database you specified" error message when you open an Access database by using a shortcut
824165 ActiveX control that is contained in an Access form does not appear when the design-time license is not available
827983 Access 2002 post-Service Pack 3 hotfix package: May 7, 2004
826760 Incorrect object dependencies information appears for database objects in a read-only database
828411 You cannot use the MSODSC control when you insert an Office Chart 11.0 control in a data access page
841779 How to reset the page number and the total page count for each group in a Microsoft Access report
840992 Description of the Office XP post-Service Pack 3 hotfix package: May 8, 2004
828412 Programmatically modifying an action query in an Access database invalidates the digital signature of the Access database
824189 The AutoExpand property may not work when ANSI-92 syntax is enabled and the Combo Box RowSource does not use DISTINCT values
824171 Administrative installation of the Access Run-time Application is not successful
824176 "The Text You Entered Isn't an Item in the List" error message when you programmatically add a new record to a table by using the NotInList event of the Combo Box on a form
824180 Compilation is not successful when you convert a macro to a module
823228 BUG: Field size is changed when you copy and paste a table in an Access project
825445 Data remains unchanged when you modify dates by using the Calendar Control
824279 "Undefined Function '{FunctionName}' in Expression" error message when you open a data access page in Internet Explorer
824261 Jet 4.0 OLE DB Provider requires a Jet 4.0 system data

No comments: