| 22754 | When you explore a Web page that you select from the Web toolbar in Microsoft Access 97, the Back button is enabled in Microsoft Internet Explorer version 3.0, but nothing happens when you click it. If you use the Web toolbar in Microsoft Access... |
| 22755 | If you have a workstation installation of Microsoft Access 2.0 or 7.0, and you choose to remove components from the earlier versions when you install Microsoft Access 97 locally, some Microsoft Access 2.0 or 7.0 files are removed from the server.... |
| 22756 | In Microsoft Access 97, when you insert the Web Browser Control on a form, and you are using a computer that has Microsoft Internet Explorer 4.0 installed, you may receive the following error message when you try to display the control: There is... |
| 22757 | After you install the Data Access Pack included in the Microsoft Office 97 ValuPack, the ODBCKEY.INF file in your Windows\System folder may contain German character strings in one of the sections in the file. Follow these steps to remove the... |
| 22758 | When you open a workbook in Microsoft Excel 97, some formulas in the workbook may not be recalculated properly. For example, if cell B5 in Sheet2 contains the following formula =Sheet1!A1 the formula may return a value that was previously in... |
| 22759 | If you export to ASP format a form based on a table in a replicated database, you cannot add new records using the ASP form. If you look at an ODBC trace file, you see the error message: [Microsoft][ODBC Microsoft Access 97 Driver] You cannot... |
| 22760 | When you extract a file from a cabinet file on a source disk, the cabinet's directory structure may be appended to the destination path where the file is copied. This may place the file in an unexpected location on your hard disk. To copy a file... |
| 22761 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you perform an action in the BeforeUpdate event, you receive the following error messages, even if you have canceled the event. In Microsoft Access 7.0 and 97: -... |
| 22762 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you add a record to an SQL table by using Visual Basic for Applications, if the table's unique index field has a default value, and you do not assign a value to that... |
| 22763 | In a secured Microsoft Access 2.0, 7.0, and 97 database, a user with Open/Run permissions for the database can create a new module and obtain the connection string of any linked (attached) table in the database even though the user has no Read... |
| 22764 | This article lists tips to help you optimize performance when you use Open Database Connectivity (ODBC) data sources with Microsoft Access. This article assumes that you are familiar with client/server environments and architectures. Methods of... |
| 22765 | Advanced: Requires expert coding, interoperability, and multiuser skills. You may need to create a database in which some users have the ability to add other users, but don't have the ability to view the design of objects in the database. You can... |
| 22766 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you first link (attach) an external table using an ODBC driver, you have the option to store the User ID and password for the table locally. If you do not store the ID... |
| 22767 | Advanced: Requires expert coding, interoperability, and multiuser skills. Storing SQL database login IDs and passwords locally requires that the database administrator create a unique table on the server. In Microsoft Access, when you link (or... |
| 22768 | Describes how to use code to refresh links to split database files so that they follow the 8.3 naming convention and to relink the tables. |
| 22769 | Microsoft Windows 95 allows you to perform a Quick View of files on the desktop. If you perform this operation on one of the toolbar buttons on the Office Shortcut Bar pointing to an program, it will display a dialog box containing information... |
| 22770 | When Setup is run on a workstation by connecting to a remote server, you may get the error Invalid command line option: 95\ where the server path is \\Server\Office 95\Setup.exe. This message is followed by another error: Usage: setup [/A]. Use... |
| 22771 | After you run the Setup program for one of the programs listed at the beginning of this article, and then choose the Workstation installation option (or the Run From CD option, which is available in the Microsoft Office compact disc versions... |
| 22772 | When you perform a post administrative setup using a modified SETUP.STF file, you receive the following error message: application name Setup was not completed successfully. There are two possible causes for this error message: An invalid... |
| 22773 | Describes the Access Snapshot Viewer issue that is fixed in the Access Snapshot Viewer hotfix package that is dated October 5, 2004. |
| 22774 | Describes a problem that may occur in Access when you convert an Access 2000 or a later version database to an Access 97 database. You may receive the Invalid field data type error message. |
| 22775 | When you try to open an Access 2000 MDE file in Access 97, you may receive the following error message: Unrecognized database format 'database name'. If you try to convert an Access 2000 MDE file to Access 97, you find that the Convert Database... |
| 22776 | You convert a Microsoft Access 97 partial replica to Access 2000. Then you synchronize the Access 97 partial replica with a converted full replica or with Design Master. All the database objects are removed from the converted partial replica... |
| 22777 | No records are returned for a query that joins a Microsoft Access 2000 (Jet 4.0) table to a linked Microsoft Access 97 (Jet 3.5) table. This happens even though you are certain that there are matching records. This behavior can occur only when all... |
| 22778 | When you convert a security-enhanced Microsoft Access 2000 database to Microsoft Access 97 format, the newly created Access 97 database is not secure. Permissions are reset to their defaults in the newly created Access 97 database. This problem... |
| 22779 | Describes that you will receive an error when you try to run the Access Conversion Scanning Tool, ADScanner.exe, from the command prompt if you use not valid command-line arguments. Provides sample scenarios that may cause the problem. |
| 22780 | Describes how to use the Access Conversion Scanning Tool, Adscanner.exe, as a command-line utility. This article describes each argument that is available with this tool. Default settings for the arguments are explained. |
| 22781 | Describes that the information about Access properties for Access databases may not be collected by the scanning tool. This problem occurs when the computer does not have the correct version of Access installed. Install the correct version of Access. |
| 22782 | Describes the RecordCount property, the NoConvertDialog property, and the Compiled State property that are collected by the scanning tool. This article describes what the the property values mean when you view them in the report tool. |
| 22783 | Domain aggregate (totals) functions provide statistical information about sets of records. For example, you can use a domain function to count the number of records in a particular set of records or to determine the average of values in a particular... |
| 22784 | When you add a graph to a report and link its data to a field in the report, the graph is not updated from one record to the next when you view or print the report. |
| 22785 | When you try to open a linked table that uses an ODBC driver, you may receive the following error message: Table 'TMP%#MAU@' already exists. Then the table fails to open. |
| 22786 | The Find Bookmark Wizard is a Microsoft Access add-in that will search the forms, reports, and modules in an Access database for text that references either the Bookmark or the AbsolutePosition property. This wizard should be used to assist you in... |
| 22787 | #Deleted entries are seen when Oracle linked tables containing number datatypes are opened using either Access 97 SR2 or Access 2000. This behavior is seen with both Oracle 7.3.4 server as well as Oracle 8.0.5 server irrespective of the version of the... |
| 22788 | Special considerations must be made for performance optimization of queries built on attached SQL database tables. An SQL database, for this article, is defined as any client/server database that supports some level of ANSI SQL as an intrinsic part of... |
| 22789 | When attempting to use the Data Access Object (DAO) 3.5 CompactDatabase method to convert a Jet 2.0 .mdb file to a Jet 3.0 file format, the resulting .mdb file is still in a Jet 2.0 file format. |
| 22790 | When you start Microsoft Access 97 by double-clicking the Msaccess.exe file or a shortcut directed to that file, you may receive the following error message: Can't find the database you specified, or you didn't specify a database at all. Specify a... |
| 22791 | This article explains the role and relationship of the workgroup information file (MDW) in Microsoft Access security. |
| 22792 | After you synchronize a replica, the data in a Memo field or OLE Object field in a member of the replica set is missing. Also, a conflict error is generated. |
| 22793 | The Neatcd97.exe file contains 22 sample modules of Visual Basic for Applications code. Topics include complex math, statistics, OLE Automation, data access objects (DAO), class modules, longitude and latitude, string manipulation, string parsing, and... |
| 22794 | When you try to open a replica, you may receive the following error message Name conflicts with existing module, project or object library. and you are unable to open the replica. |
| 22795 | When you open a replica after synchronizing with another replica, you may receive the following error message: Automation error |
| 22796 | After you have opened an object, such as a query or a form, the status bar continues to display the message Calculating... |
| 22797 | The Qbf.exe file contains a database created by Ken Getz that demonstrates how to create a custom Filter-by-Form, which you can use in any application, including a run-time application. The following file is available for download from the Microsoft... |
| 22798 | Toolbars, menu bars, and shortcut menus enable you to organize the commands in Microsoft Access the way that you want so that you can find and use the commands quickly. In earlier versions of Microsoft Access, toolbars only contained buttons. In... |
| 22799 | Advanced: Requires expert coding, interoperability, and multiuser skills. An Add-in is a tool such as wizard, builder, or menu item that you can create to provide additional functionality to Microsoft Access. When developing an add-in, you may receive... |
| 22800 | You can programmatically control the Microsoft Office Assistant to provide information for the user by using balloon pop-ups. The information inside the balloon can be a simple message, a request for more information, or a list of choices for the... |
| 22801 | TestDSN.htm and TestDSN.asp are Web files that you can copy to your Web server. Use them to test a System DSN on your Web server that connects to a Microsoft Access 97 database. If the System DSN is valid, you receive a record count from a table in... |
| 22802 | Active Messaging 1.1 supports programmatic access to MAPI Address Books through the AddressEntries collection of an AddressList object. Each AddressList object corresponds to a MAPI address book and is a member of the AddressLists collection of the... |
| 22803 | This article describes how to display only the last two digits of the year. The expression =Year(Now()) displays all four digits of the current year (for example, 1993). In order to display only the last two digits of the year (for example, 93), use... |
| 22804 | When you export a report to HTML format, and then view the report in your Web browser, you may receive one of the following error messages when you click on one of the page links: HTTP/1.0 500 Server Error (161) -or- HTTP/1.0 400 Bad Request |
| 22805 | When you import a delimited text file containing a field with values in a Medium Date format (DDMMMYY), the data for that field is not imported and an import errors table is created. |
| 22806 | When you export a form from Microsoft Access 97 as an Active Server Page, and that form has custom buttons that move from one record to the next, the buttons will not work on your Active Server Page form. This happens because the Visual Basic code... |
| 22807 | If you connect to a Microsoft Access database and then you create more than 64 connections in one process, you may receive one of the following error messages: In Microsoft Visual Studio .NET: Unspecified error In Microsoft Visual Basic 6.0, if you... |
| 22808 | When you try to start Microsoft Access 97, you may receive the following error message Can't find file MSO9.DLL and Access doesn't start. |
| 22809 | This article shows you two examples of how to use the Microsoft Internet Transfer ActiveX Control that is included with the Microsoft Office Developer Edition 97. This article assumes that you are familiar with Visual Basic for Applications and with... |
| 22810 | This article shows you how to create a sample procedure that converts Julian days to dates in Microsoft Access, and a sample procedure that converts Microsoft Access dates to Julian days. You can change the Julian day format used in the examples to a... |
| 22811 | In a replicable Microsoft Access database, if you try to delete an OLE Object field in the Design view of a table, you may see the following alert Couldn't find field 'Table1' followed by the message: Errors were encountered during the save operation. |
| 22812 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you create a database from a Microsoft Visual SourceSafe project, the Description property of your database objects does not appear. This also happens when you perform a... |
| 22813 | Microsoft Access 97 provides features that enable you to publish data from your database as Web pages. You can create both static and dynamic Web pages; however, each type of Web page may have different requirements for the server that stores the page... |
| 22814 | When you open a Microsoft Access form that has the AllowEdits property set to No (False), you can still edit the fields on that form. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 22815 | When importing delimited data from a text file into a Jet database, trailing spaces are dropped from fields. |
| 22816 | When importing a delimited text file into a Jet database, leading spaces are truncated from field data. |
| 22817 | This article demonstrates how to copy the individual bytes of data in a multi-byte data type, such as a long integer or a single-precision floating- point number, into a byte array. It also illustrates how to take an array of bytes and turn it into a... |
| 22818 | A Visual Basic for Applications procedure that uses ODBCDirect to create and populate a table in another Microsoft Access database also creates corrupted unique indexes in that table. This behavior occurs if the procedure performs the following steps... |
| 22819 | This article demonstrates how to open and view the contents of a secured Access database using Visual Basic. The steps below outline this process: Secure the database: From Microsoft Access, set the appropriate user and group permissions to secure the... |
| 22820 | Some queries that are based on one or more linked ODBC Microsoft Visual FoxPro tables may return inconsistent results each time that you run the queries. Examples of queries that might exhibit this behavior are queries that are based on one or more... |
| 22821 | DAO is a COM wrapper around the Jet Engine, which is used by Microsoft Access, Excel, Project, Visual Basic, and the Microsoft Foundation Classes (among others). It can be confusing which version of Jet you are using because so many applications may... |
| 22822 | Advanced: Requires expert coding, interoperability, and multi-user skills. This article assumes that you are familiar with using the client side capabilities of Visual SourceSafe. For more information about Visual SourceSafe, please refer to the... |
| 22823 | Advanced: Requires expert coding, interoperability, and multi-user skills. You notice duplicate relationships appearing in a data (back-end) database under one or both of the following conditions: When you import tables into a new database, and the... |
| 22824 | Advanced: Requires expert coding, interoperability, and multiuser skills. Microsoft Visual SourceSafe integration with Microsoft Access enables you to create a database from the SourceSafe server. This feature enables users to create additional copies... |
| 22825 | When using Microsoft Access 97 to check out an object, the Source Code Control Results dialog box remains open after the check out. This behavior does not occur in other applications. |
| 22826 | Advanced: Requires expert coding, interoperability, and multi-user skills. This article assumes that you are familiar with using the client side capabilities of Microsoft Visual SourceSafe. For more information about Visual SourceSafe, please refer to... |
| 22827 | Advanced: Requires expert coding, interoperability, and multiuser skills. If you have a database under source code control with Microsoft Visual SourceSafe, and the database contains links to a Microsoft Outlook or Microsoft Exchange folder, when you... |
| 22828 | A UserControl (OCX) created in Visual Basic does not print correctly from Microsoft Access. The control is either partially cut off or is blank when previewed or printed. |
| 22829 | Microsoft Access 7.0 and 97 MDB files can be password protected. This article demonstrates how to change the password associated with a Microsoft Access 7.0 or 97 MDB file. |
| 22830 | Advanced: Requires expert coding, interoperability, and multi-user skills. This article assumes that you are using Microsoft Visual SourceSafe to control the source code for your Microsoft Access 97 database, and that you are familiar with the... |
| 22831 | When you try to open a form in Filter-by-Form view programmatically in a Microsoft Access 97 run-time application, you may receive the following error message Run-time error '2501': The RunCommand action was canceled. followed by: Execution of this... |
| 22832 | The Microsoft TreeView control version 5.0 ships with Microsoft Office 97 Developer Edition. Use the Clear method to remove all nodes in a TreeView control. This article assumes that you are familiar with Visual Basic for Applications and with... |
| 22833 | After you have opened a Microsoft Access 97 database in Microsoft Access 2002 and converted it to the current file format, Label reports do not display some data correctly. Data from fields named Name , which were presented correctly in the Access 97... |
| 22834 | In Microsoft Access, you can use Microsoft Graph to embed a graph object in a form or report. However, if you export the form or report to a Microsoft Excel worksheet, the graph does not appear in the worksheet. This article describes how to export a... |
| 22835 | The default ODBC LoginTimeout property setting for Microsoft Jet databases is 20. Depending on which version of Microsoft Access you have, the ODBC LoginTimeout setting is stored in the following registry key. In Microsoft Access 97... |
| 22836 | In many of the programs listed at the beginning of this article, you can prevent unauthorized users from opening a file by applying a password to the file. When you attempt to open the file, the program requests the password; if you do not enter the... |
| 22837 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to use Automation to populate a list box with values from a Microsoft Excel worksheet. This article assumes that you are familiar with Visual Basic... |
| 22838 | This article presents a step-by-step example on how to programmatically change the short date format of the system's Regional Settings. Otherwise the short date format can be manually changed through the Regional Settings applet in Control Panel. |
| 22839 | If you have a procedure that contains a Visual Basic for Applications function, and your database contains a reference to a missing object library or type library, you may receive the following error message when you compile your modules or run the... |
| 22840 | When you use the Visual Basic for Applications MsgBox command, the Close button (the X in the upper-right corner) on the message box title bar is unavailable. |
| 22841 | When you open a module from the Debug window, from the Object Browser, or with the Find or Replace commands on the Edit menu, Microsoft Access does not prompt you to check out the module, and you cannot save your changes. This article assumes that you... |
| 22842 | When you add a database to Microsoft Visual SourceSafe, you may receive the following error: File Name is an invalid DOS 8.3 name This article assumes that you are familiar with using the client and server side capabilities of Visual SourceSafe. For... |
| 22843 | This article shows you how to use Automation to rotate a chart created in Microsoft Graph. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools... |
| 22844 | This article shows you how to use Automation to add, remove, and set trend lines on a Microsoft Graph object. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the... |
| 22845 | In Microsoft Windows NT or Microsoft Windows 95 or later, you can use the Win32 application programming interface (API) to retrieve network information, such as the user name, workgroup, domain, and computer name, about the currently running computer.... |
| 22846 | Many new Microsoft Access 7.0 and 97 users want to import data immediately from the systems they are currently using. The Import dialog box in Microsoft Access is designed to import one table at a time. Most of the time, this capability is enough.... |
| 22847 | Microsoft Access has set the scope of procedures in form and report modules to be as consistent with object-oriented programming as possible. Variables in Microsoft Access class modules can be declared as Public in order to be available to other... |
| 22848 | This article shows you how to merge the current record in a Microsoft Access 7.0 and 97 object into a Microsoft Word 97 document, print it, and then close Microsoft Word 97. This article assumes that you are familiar with Visual Basic for Applications... |
| 22849 | When you try to import or link a Microsoft Excel spreadsheet, if you click Show Named Ranges in the Import Spreadsheet Wizard or the Link Spreadsheet Wizard, you may receive the following error message. In Microsoft Access 97 The Microsoft Jet... |
| 22850 | When you run the Setup program, the Online Registration button may not appear in the Setup maintenance mode dialog box or in the Setup was completed successfully dialog box. |
| 22851 | After you run the Setup program, the Mscreate.dir file appears in every new folder created by the Setup program. |
| 22852 | When you run the Setup program for one of the programs listed at the beginning of this article, and you click the Remove All button (in maintenance mode) the shortcut for the program that you remove may still be available in Windows. |
| 22853 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to create sample Visual Basic for Applications code that uses Automation to create a Microsoft PowerPoint presentation. This article assumes that you... |
| 22854 | When you use the Microsoft Office 97 Developer Edition Tools (ODE) Setup wizard or the Microsoft Access 7.0 Developer's Toolkit (ADT) to create a custom Setup program, and you include a database file name on the screen that asks Do you want to run an... |
| 22855 | In a self-written ODBC program that executes a prepared statement at a SQL Server (set up with an OEM code page, such as code page 437 or 850) the data in the buffer passed in the rgbValue parameter of SQLBindParameter is converted from ANSI to OEM... |
| 22856 | When you browse to an ASP file that was exported with Microsoft Access 97, the Format property of fields in Microsoft Access forms is not preserved. This article discusses the workaround for this behavior. |
| 22857 | Microsoft Office products include features that enable specific collaboration scenarios and features that are designed to help make your documents and files more secure. Features that enable collaboration scenarios function correctly in collaboration... |
| 22858 | In Microsoft Access 97 on a computer running Microsoft Windows NT 4.0, you can only enter a maximum of 3 digits (instead of 5 digits) in the Pages From and To text boxes under the Print Range option group in the Print dialog box. On a computer running... |
| 22859 | Records from a linked SQL Server table are sorted incorrectly in Microsoft Access datasheets and forms if the following conditions are true: A Microsoft Access user opens a long-running query or a form based on a long-running query. The query returns... |
| 22860 | This article shows you how to use Automation to add a task or a reminder to Microsoft Outlook. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools... |
| 22861 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article provides information and examples on how to use Microsoft Access 7.0 or 97 as an Automation server. With Visual Basic for Applications, you can manipulate the... |
| 22862 | This article shows you how to use Automation to modify properties of the Border object in a Microsoft Graph object. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the... |
| 22863 | If you convert a database from Microsoft Access 2.0 to Microsoft Access 7.0 or Microsoft Access 97, and that converted database has a user-defined procedure and a module with the same name, you may receive the following error message when the... |
| 22864 | Advanced: Requires expert coding, interoperability, and multiuser skills. You can use Microsoft Windows API functions to capture screen shots of any object on the Microsoft Windows desktop. You can capture screen shots of the Microsoft Access user... |
| 22865 | This article describes a method to copy data from a Microsoft Excel worksheet to a Microsoft Access table using a drag-and-drop operation. |
| 22866 | This article show you how to use Automation to create and manipulate a Microsoft Excel Worksheet. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools... |
| 22867 | When you customize your toolbars to use large icons in Microsoft Office 97 or Microsoft Office 97 Professional Edition, only the top level toolbars display large icons. Any toolbars below the top level continue to display small icons. |
| 22868 | After you install Microsoft Office 97 Professional Edition or Microsoft Access 97, if you still have Microsoft Access 7.0 on your computer the Blank Database icon in Microsoft Access 7.0 is missing. |
| 22869 | This article answers common questions concerning Automation to Microsoft Office from Visual C++. |
| 22871 | Microsoft Access does not restrict the use of special characters such as a number sign (#), a period (.), or a double quotation () in the database object names or in the database field names. However, if you do use the special characters you may... |
| 22872 | An ATL ActiveX Control does not appear or appears incorrectly when added to a Microsoft Access Report. The same control displays correctly when the Report is in design mode or if the control is added to an Access Form. |
| 22873 | If Microsoft Access 97 or Microsoft Access 2000 is used to link SQL Server 6.5 or 7.0 tables, which have numeric and text field columns, #deleted is seen in alternate rows if the SQL Server database is created using non default code pages and Sort... |
| 22874 | This article shows you how to use Automation to print a Microsoft Word document that you are working with in a Microsoft Access function or in a Microsoft Access form's object frame. This article assumes that you are familiar with Visual Basic for... |
| 22875 | If you use Microsoft Access and you link to the SQL Server Pubs_info table, by using the logo field, which is Image data, you cannot open the Image. This error occurs: A problem occurred while Microsoft Access was communicating with the ole server.... |
| 22876 | When you reset a menu on a built-in menu bar using Microsoft Visual Basic for Applications code, none of the menu items are available. |
| 22877 | This article shows you how to use Automation to create a Microsoft Word 97 mail merge document to insert merge fields, and then to run the merge. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft... |
| 22878 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to use Automation to run a Microsoft Word 97 for Windows mail merge in Microsoft Access version 7.0 or 97. For information about how to run a Word 7.0... |
| 22879 | This article shows you how to use Automation in Microsoft Access to open a Microsoft Word 97 document and to move to a specific location in the document. For information about how to move to a specific location in a Microsoft Word version 6.0 or 7.0... |
| 22880 | By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 95 or later, or Microsoft Windows NT 4.0 taskbar. This article shows you how to create the two functions that you need to hide and unhide the... |
| 22881 | This article explains how to create and use a parameter query using Data Access Objects (DAO). A parameter query is a type of QueryDef specific to the Microsoft Jet database engine used by Visual Basic, Microsoft Access, and other products. Parameter... |
| 22882 | The InStr() function provides a method to search for the first occurrence of one string (substring) inside another string. However, there is no intrinsic method to search for the last occurrence of a substring. This article provides a sample function... |
| 22883 | The Format function does not always return the expected number format with certain international settings. This article explains this behavior and describes how the Format function interprets its parameters. |
| 22884 | This article provides a procedure for parsing a single variable containing US City, State, and Zip Code information into three separate variables. The routine supports: Either 5- or 9-digit zip code. Multi-word state names (if preceded by a comma).... |
| 22885 | This article provides a procedure for parsing a single variable containing a person's name into up to 6 parts: Title (Mr., Ms., etc.) First Name Middle Initial(s) Last Name Pedigree (Jr., Sr., III, etc.) Degree(s) (B.S., PhD, etc.) |
| 22886 | When you run an action query by using Data Access Objects (DAO) and the Microsoft Jet database engine against an ODBC table, if you specify the dbFailOnError argument, the RecordsAffected property always returns 0, regardless of the number of records... |
| 22887 | In Microsoft Visual Basic for Applications, you can create a dimensioned array, such as A(6,6), that is available to all procedures in all modules. This article includes sample Visual Basic for Applications routines that demonstrate how this can be... |
| 22888 | This article contains sample Microsoft Visual Basic for Applications code that determines the drive letter of the first CD-ROM drive and returns it to a variable as a string. It is then output to a message box. This would be useful for accessing files... |
| 22889 | This article provides two procedures that allow you to read and modify user- defined properties in a Microsoft Jet database. |
| 22890 | If you run a macro that uses objects from the Microsoft Remote Data Object 2.0 library, you may receive the following error message: Run-time error '429' ActiveX component can't create object |
| 22891 | The More Information section of this article contains sample Microsoft Visual Basic for Applications code that calls WNetGetUser (a Windows API function in the file Mpr.dll) to retrieve the user name used to establish a network connection. |
| 22892 | In the Microsoft Office products listed at the beginning of this article, when you display a UserForm that contains a TextBox control, by default the cursor position in the TextBox control is indented. If you want the initial cursor position in the... |
| 22893 | You can use Automation to run a Microsoft Visual Basic for Applications Sub procedure that exists in a document of another Microsoft Office program. This article shows you how to run Sub procedures from four of the Microsoft Office programs that... |
| 22894 | This article describes how to use a Microsoft Visual Basic for Applications sub-procedure (or macro) and a Windows application programming interface (API) call to return the universal naming convention (UNC) path for a mapped network drive. |
| 22895 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to use Automation from a Microsoft Access form to start Microsoft Outlook and display a new contact screen for input. You can change just one line of... |
| 22896 | Using Jet 3.5x, a user can call unsafe Visual Basic for Applications functions in query statements from all types of Jet applications, such as ODBC or Access. For example, the following statement would result in all files being deleted from a... |
| 22897 | When you try to open a Microsoft Access 97 database that was converted from a Microsoft Pocket Access database, you may receive the following error message: Unrecognized format After you receive this error message, you cannot open the file in Access... |
| 22898 | This article contains a list of Microsoft Office Developer samples and tools that are available in the Microsoft Download Center. |
| 22899 | When a new record is added to an ActiveX Data Objects (ADO) Recordset that contains an Autonumber field, immediately reporting the value of the Autonumber field for the inserted record returns a value of 0. This article describes how to retrieve the... |
| 22900 | When you browse to an Active Server Pages (ASP) file that was exported from Microsoft Access 97, and the file contains a large query, you may receive the following error message: Microsoft VBScript compilation error '800a03e9' Out of Memory |
| 22901 | When using the Data Access Objects (DAO), Remote Data Objects (RDO) or the ADO GetChunk method, on a long binary field of a Microsoft Access database, binary data may appear corrupt if the binary information previously stored was read from disk using... |
| 22902 | This article describes how to import a Works Database file into an Access 95 (version 7.0) or Access 97 database. |
| 22903 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to use Automation to run a Microsoft Word 7.0 macro. For more information about how to use Automation to run a Microsoft Word 97 macro, please see the... |
| 22904 | Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. on why Microsoft does not recommend automation under this context 257757 INFO: Considerations for Server-Side Automation of Office... |
| 22905 | In Microsoft Access (and other Microsoft Office applications), you can use the Shell command in Visual Basic for Applications (VBA) code to start another application. Although you can start most applications in this manner, there are some applications... |
| 22906 | This article shows you how to use Automation to manipulate a Microsoft Project for Windows 95, version 4.1a (*.mpp) file. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications... |
| 22907 | When you export a query to Microsoft Word that contains field names which have been renamed in the query, the field names that are exported to Microsoft Word are different from the field names that are displayed in the query. |
| 22908 | When you convert a Microsoft Access version 2.0 database to a Microsoft Access 7.0 or Microsoft Access 97 database, you may receive one of the following error messages if your database contains an ActiveX control. In Microsoft Access 97, when you open... |
| 22909 | When you set the Window Color to black and the Font Color to white in Control Panel instead of accepting the default white Window Color and black Font Color, and then you output a Microsoft Access report to Microsoft Word or Microsoft Excel, the... |
| 22910 | If you size an Office program window so that a toolbar that is docked at the top of the window does not fit in the window, some toolbar buttons on the toolbar may not be visible, and a small symbol () appears on the right side of the toolbar. If you... |
| 22911 | When you run the Setup program for one of the programs listed at the beginning of this article and choose the Complete/Custom installation option, if the Space Available On C: value is less than the Space Required On C: value, one of the following... |
| 22912 | In the Microsoft Office 97 programs listed at the beginning of this article, if you attempt to open a file on a network server, you may not be able to access the share and the directories or files it contains, or you may receive one of the following... |
| 22913 | The CorelDRAW! (.cdr) filter that is included with Microsoft Publisher can actually import other types of CorelDRAW! files besides those with a .cdr extension. It also imports Pattern (.pat) and Corel Template (.cdt) files. These file types do not,... |
| 22914 | When inserting records into a Microsoft Access database, immediately attempting to reselect them occasionally does not return all inserted records. This occurs even when the records are inserted and reselected on the same connection. The problem... |
| 22915 | In any of the programs listed at the beginning of this article, if you click the Help menu, point to Microsoft on the Web, and then click Best of the Web, you may receive an error message: Internet Explorer cannot open the Internet site... |
| 22916 | When you save a file from any Microsoft Office 97 program to a Microsoft Windows 95 folder, you receive the following error message The file filename already exists. Do you want to replace existing file? where filename is the name of the file you... |
| 22917 | The Microsoft Windows operating system provides two routines that can be called by Microsoft Office 97 programs to get the Windows and the Windows System directories. |
| 22918 | When you open a Microsoft Office 97 document on a computer that is running Microsoft Windows NT Workstation or Windows NT Server, you receive the following error message: Access Denied. |
| 22919 | In any of the Microsoft Office 97 programs listed at the beginning of this article, you receive the following error message: Clip Gallery cannot launch the software component to handle path to a WAV file. |
| 22920 | In a 16-bit version of Microsoft Mail for Windows, if you double-click a document that is created in any of the Office programs listed at the beginning of this article, you may receive the following error message Microsoft Mail The application for the... |
| 22921 | When you click a Help topic from the Office Assistant, the Help topic is not displayed. |
| 22922 | When you close an Office 97 file, you may receive the following error message: This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor. If you click Details, an error message similar... |
| 22923 | In any of the programs listed at the beginning of this article, when you use the Control Toolbox to insert a control (an .ocx file), you may receive an error message similar to the following: An application error has occurred and an application error... |
| 22924 | When you attempt to follow a hyperlink in the products listed at the beginning of this article, you receive the following error message: An unexpected error has occurred. |
| 22925 | In the programs listed at the beginning of this article, ToolTips for your toolbar buttons may stop working unexpectedly. |
| 22927 | When you run any of the programs included with Microsoft Office 97 and you use a lower screen resolution (640 x 480, for example) or if you have many windows open or if your screen is very cluttered, you may find that the Office Assistant window is... |
| 22928 | In Microsoft Office 97 for Windows programs, when you point to an item on a menu, no information about the menu item appears in the status bar. |
| 22929 | When you drag a Microsoft Office file into the Windows Briefcase, if you make changes to both the original copy of the file, and the copy of the file in the Briefcase, you can only replace either copy with the other; you cannot merge the changes made... |
| 22930 | In the programs listed at the beginning of this article, the following symptoms may occur: When you start an Office program, the Office Assistant does not appear. -and- When you click the Office Assistant on the Standard toolbar, the Office Assistant... |
| 22931 | Office Assistant Actor (.act) files may remain on your computer after you perform a Remove All through the Setup program. |
| 22932 | When you use any of the programs listed at the beginning of this article, if you click OK or Cancel in the Office Assistant dialog box, you may receive the following error message: This program has performed an illegal operation and will be shut down.... |
| 22934 | In any of the Microsoft Office 97 programs listed at the beginning of this article, the font that is used for the menu may appear to be too small or scrambled, making the text on the menu unreadable. |
| 22935 | When you ask the Office Assistant a question about Microsoft Visual Basic for Applications, you receive one of the following responses depending on your type of computer. Office 97 for Windows The Office Assistant cannot currently answer your... |
| 22936 | When you run a Visual Basic for Applications macro in any of the programs listed at the beginning of this article, you may receive the following error message: This program has performed an illegal operation and will be shut down. If the problem... |
| 22937 | While debugging your code that uses Automation to control Microsoft Access, you may receive one of the following errors. When automating Microsoft Access 95: MSACCESS caused an Invalid Page Fault in module MSACCESS.EXE at 0137:5000f878 -or- MSACCESS... |
| 22938 | When you use the /runtime switch to start Microsoft Access 97 on a computer that does not have the Microsoft Office 97 Developer Edition Tools (ODE) or a custom application created by using the ODE installed, you may receive the following error... |
| 22939 | When you open a spreadsheet in Microsoft Excel that has an established link to a Microsoft Access table through the Paste Link command, you may receive the following message: The Workbook you opened contains automatic links to information in another... |
| 22940 | When you run the Linked Table Manager, you receive the following error message: Invalid procedure call or argument. Even if you delete the linked table(s), you continue to receive this error message until you quit and then restart Microsoft Access. |
| 22941 | This article shows you two methods of using the NotInList event to add a new record to a combo box on a form. This article assumes that you are familiar with Visual Basic for Applications and that you are also familiar with creating Microsoft Access... |
| 22942 | This article shows you how to create and how to maintain a log of users who open a Microsoft Access database. This includes the dates and the times that the users open the database. |
| 22943 | Microsoft Access 7.0 and 97 do not create an Import Errors table after an import of a text file or spreadsheet fails. |
| 22944 | When you run the Microsoft Access 97 Setup program from an administrative installation on a server, you may receive the following error message: Setup Error 914 Object 27 Your Setup files may be damaged. Try restarting the Setup program from where you... |
| 22945 | When you try to start Microsoft Access by using the /pwd command-line option to open a database that is password-protected, the Logon dialog box is displayed, even if you supply the correct password. |
| 22946 | Microsoft Jet Replication does not have a property that specifies whether a replica is the Design Master of a replica set. However, this article demonstrates how you can use Visual Basic for Applications to determine if a database is the Design... |
| 22947 | In Microsoft Access, if you import data by using an indexed sequential access method (ISAM) driver, you may receive the following error message: ActiveX component cannot create object You may receive this error message regardless of the data type... |
| 22948 | After you apply the Outlook E-mail Security Update, some Microsoft Access 97 functionality may not work as expected. |
| 22949 | For special formatting considerations, you may want to include a Microsoft Word object on a Microsoft Access report. For example, you may want to give a user the ability to change the font size of a title without having to switch the report to design... |
| 22950 | When you use the Animation control to display animation on a Microsoft Access 97 form, you may receive the following error message: Run-time error '35752': Unable to open AVI file NOTE: The Animation ActiveX control is installed by Microsoft Office 97... |
| 22951 | If you change toggle button controls in an option group on a form to option buttons (or, in some cases, to check boxes), you may receive the following error message, and then Microsoft Access quits. In Microsoft Windows 95 This program has performed... |
| 22952 | Advanced: Requires expert coding, interoperability, and multiuser skills. Microsoft Access does not have a function to maximize, minimize, and restore Microsoft Access from a module or macro. This article shows you how to use Microsoft Windows API... |
| 22953 | The Setup program for Microsoft Access 7.0, Microsoft Access 97, and Microsoft Office 97, Professional Edition does not create a shortcut for the Workgroup Administrator program on Microsoft Windows 95 or Microsoft Windows NT 4.0 computers. This... |
| 22954 | On Microsoft Windows NT 4.0 Service Pack 3 (SP3), if you try to open a Microsoft Access 97 database from a folder that also contains a large bitmap with the same name as that database, you may receive a fatal error. On Microsoft Windows NT 4.0... |
| 22955 | When you try to open a topic in Microsoft Access 97 Help, you may receive the following error message: WINHLP32 caused an invalid page fault in module unknown at address. When you click Close, Microsoft Access 97 Help quits. |
| 22956 | When you use Data Access Objects (DAO) in a Microsoft Office program to open a Microsoft Access query, you receive the following error message: Run-time error '3085': Undefined function function name in expression. |
| 22957 | One alternative to displaying your application's online Help system in a separate window is to display it in a small, shaded pop-up window within your application. To do this, you can use the Windows API WinHelp() function with its HELP_CONTEXTPOPUP... |
| 22958 | This article shows you how to use Data Access Objects (DAO) in Microsoft Access 95 or 97 to create a Microsoft Access 2.0 database and how to copy entire tables from a Microsoft Access 95 or 97 database to the newly created Microsoft Access 2.0... |
| 22959 | Advanced: Requires expert coding, interoperability, and multiuser skills. By carrying out the DoCmd object's OpenReport method, you can print Microsoft Access reports from any Automation client application, such as the Microsoft Visual Basic... |
| 22960 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to display slides from Microsoft PowerPoint 7.0 or 97 on a form in Microsoft Access 7.0 or 97, respectively. This technique uses OLE Automation in... |
| 22961 | Every time you start Microsoft Access 97, the automatic registration feature registers Msaccess.exe, the supporting Microsoft Access .dll files, the wizards, and the file associations of .mdb and .mda files. This registration process occurs regardless... |
| 22962 | When you perform a Workstation installation of Microsoft Office 97 Professional Edition or Microsoft Access 97 from a network server, you may receive one of the following error messages when you run the Database Documenter or the Table Analyzer... |
| 22963 | If you have a Web server on which you want to create Active Server Pages (ASP) files, the Web server must have installed support for Active Server Pages. To view Active Server Pages (ASP) files created in Microsoft Access 97 on Microsoft Windows 95 or... |
| 22964 | This article shows you how to create a macro and a Visual Basic procedure to fax a report from Microsoft Access. The examples assume that you have Microsoft Exchange, Microsoft Fax, and a fax modem installed and functioning. NOTE: If your fax does not... |
| 22965 | This article shows you how to use Automation to create appointments in a Microsoft Access database and how to add them to the Microsoft Outlook calendar. For information about using Automation to add an appointment to Microsoft Schedule+ for Windows... |
| 22966 | When you link to a Microsoft Excel 7.0 or 97 spreadsheet from a Microsoft Access 7.0 or 97 database, and the fields in the spreadsheet contain both numbers and text, the fields that contain text appear as #Num! in the linked table in Microsoft Access. |
| 22967 | This article shows you how to use Automation to create a Microsoft Graph object on a Microsoft PowerPoint 97 slide from Microsoft Access 97 by using a Microsoft Access table. This article assumes that you are familiar with Visual Basic for... |
| 22968 | This article shows you how to format a fax number in Microsoft Access so that you can merge it with a Microsoft Word document that uses Microsoft Exchange to print to a fax modem. This article assumes that you are familiar with Visual Basic for... |
| 22969 | This article shows you how to use Automation to call Microsoft Excel functions from within Microsoft Access. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the... |
| 22970 | This article show you how to use Automation to run a Microsoft Word 97 macro from Microsoft Access. For information about how to run a macro in earlier versions of Microsoft Word, please see the following article in the Microsoft Knowledge Base:... |
| 22971 | Advanced: Requires expert coding, interoperability, and multi-user skills. To position Microsoft Access on the screen, you need to call the SetWindowPos() Windows API function. This article shows you how to call this function to position Microsoft... |
| 22972 | This article describes how you can use Automation to create and to send a Microsoft Exchange message. This article assumes that you are familiar with Visual Basic for Applications and that you can create Microsoft Access applications by using the... |
| 22973 | This article describes why the User Authentication dialog box may appear in a non-secure database. This article also describes how you can troubleshoot this problem. |
| 22974 | This article shows you how to create a Microsoft Office Binder that includes documents from a variety of Microsoft Office programs. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 22975 | When you reference a form's OLE control in an expression or a procedure, you may receive the following error message. In Microsoft Access 97 Run-time error '2771': The bound or unbound object frame you tried to edit doesn't contain an OLE object. Use... |
| 22976 | When you export a linked table or an object based on a linked table to Active Server Pages (ASP), the resulting file may not work correctly. For example, when you open the ASP file in a browser, you may receive the error: Microsoft OLE DB Provider for... |
| 22977 | In Microsoft Access 97, you point to Get External Data on the File menu and then Import, but one or more of the following applications do not appear in the Files Of Type list box: dBASE III dBASE IV dBASE V Text Files Microsoft Excel However, if you... |
| 22978 | When you use Automation to create an instance of Microsoft Access, the Microsoft Access application window is visible automatically. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 22979 | Microsoft Access does not display all the ActiveX controls that you have installed on your computer in the Insert ActiveX Control dialog box on the Insert menu or in the ActiveX Controls dialog box on the Tools menu. |
| 22980 | In the sample code in the Microsoft Access 97 OldValue Property Help topic that reads as follows, the last line before the End Sub statement (Next ctl) is incorrect: Sub btnUndo_Click() Dim ctlTextbox As Control For Each ctlTextbox in Me.Controls If... |
| 22982 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you use the Microsoft Access for Windows 95 Upsizing Tools to upsize your Microsoft Access database to Microsoft SQL Server, your selected tables are not exported to... |
| 22983 | In a Microsoft Access query, if you use the LIKE operator with a wildcard, such as * or ?, to search for dates, you may see unexpected results. |
| 22984 | When you set a form or report section's height in the Page Setup dialog box under Item Size on the Columns tab (or the Layout tab in Microsoft Access 7.0), the height of the form or report's section does not change. The Page Setup Height setting is... |
| 22985 | If you try to run a wizard while in break mode of a module, you may receive the following message: Microsoft Access can't find the wizard, or there is a syntax error in the Declarations section of a Visual Basic module. |
| 22986 | When you create a table in Microsoft Access, you may receive the following error message: There was an unexpected error when creating a table. Database incomplete. |
| 22987 | When you try to create a system data source name (system DSN), you may receive the following error message: Unable to load msjter40.dll |
| 22988 | The Print Relationship Wizard prints the contents of the Relationships window so that you can document the relationships between tables in your Access 97 database. The following file is available for download from the Microsoft Download Center:... |
| 22989 | In the retail version of Microsoft Access 97, you can't view the Visual Basic for Applications code for wizards. This special version of the wizards contains viewable wizard code for developers to use as a learning tool. The following file is... |
| 22990 | When you run a query, you may receive the following error message when memory is still available: 2004 'Out of Memory.' You may also receive the error message: Query too complex. |
| 22991 | In a linked table from Microsoft SQL Server 6.5, Microsoft SQL Server 7.0, or Microsoft Data Engine (MSDE) you see #Deleted in alternate rows. One row has the typical data, the next contains #Deleted entries, the next typical data, and so on. |
| 22992 | Under certain circumstances, when you start the retail version of Microsoft Access 97 after you have previously installed and uninstalled the run-time version of Microsoft Access, you may receive the following error message: Can't find the... |
| 22993 | Microsoft Access 7.0 and 97 have many combo box and list box enhancements that make combo boxes and list boxes faster and easier to use. This article summarizes the new features and properties for combo boxes and list boxes. |
| 22994 | When you try to open a database file, you may receive the following error message: Invalid database object. When you click OK , you receive the following error message: Microsoft Access couldn't create storage space for Visual basic module. When you... |
| 22995 | In Microsoft Access 97, when you try to do any of the following open a database with a startup form view, create, or execute Visual Basic code in a form's class module start a Microsoft Access 97 Wizard you may receive one of the following error... |
| 22996 | In Access, when you first link (attach) an external table using an ODBC driver, you have the option to store the User ID and password for the table locally. If you do not store the ID and password locally, you will be prompted later for such... |
| 22997 | When you try to use a Microsoft Access 97 Wizard, you may receive one of the following error messages: This feature isn't installed. -or- Microsoft Access Can't Find the Wizard or there is a syntax error in the declaration section of the Visual Basic... |
| 22998 | When you run the Microsoft Access Setup program in Maintenance mode, and you click the Remove All button, some Microsoft Access files are not removed from your computer. This behavior occurs because Setup does not remove any files that may be used by... |
| 22999 | The Paradox, Lotus 1-2-3, and Microsoft Exchange/Outlook indexed sequential access method (ISAM) drivers are not installed with the Microsoft Access 97 or Microsoft Office 97 Professional Setup; however, they are included with the Office 97 ValuPack... |
| 23000 | This article describes how to use a Microsoft SQL Server distributed query to retrieve data from a secured Microsoft Access database. |
| 23001 | Some of the features in the retail version of Microsoft Access are not available for run-time applications that you create using the Microsoft Office 97 Developer Edition Tools Setup wizard. For example, you are not able to redistribute the spelling... |
| 23002 | This article lists the contents and changes in Microsoft Office 97 Developer Edition Service Pack 2 (ODESP2) and explains how to obtain this updated version. |
| 23003 | When you run the Setup program for Microsoft Access 97 on a computer that also has Microsoft Access 2.0 or 7.0 and Microsoft Graph 5.0 installed, and you include the Microsoft Graph 8.0 components in the Setup options, any existing Microsoft Graph 5.0... |
| 23004 | When you purchase the Microsoft Office 97 Developer Edition (ODE), your license agreement permits you to redistribute run-time versions of applications that you create to users who do not have Microsoft Access 97. When recipients of your application... |
| 23005 | When you run the Microsoft Access 97 or Microsoft Office 97 Professional Edition Setup program to remove the Microsoft Access 97 Wizards, Setup also removes the following options to import, export, or link to certain file types: Action File Types... |
| 23006 | This article discusses the causes of fatal system errors in Microsoft Access 97 and 7.0, and provides general troubleshooting steps for solving them. NOTE : This is a general article, and there may be a specific article that addresses the exact error... |
| 23007 | Installing MDAC version 2.1 or later overwrites the Microsoft Access 97 ODBC driver with the Access 2000 ODBC driver without warning. For the reasons documented later in this article, you may want to revert to the Access 97 ODBC driver. Because both... |
| 23008 | When you create a database in Access 97 and include the What's This question mark (?) Help feature on your form, the What's This ? will appear on your form in Microsoft Access. You can click the What's This ?, and it will function. However, when... |
| 23009 | This article discusses code pages and how they affect Microsoft Access. |
| 23010 | Advanced: Requires expert coding, interoperability, and multiuser skills. Tables that you create with macros, Visual Basic code, or make-table queries appear to be checked in. They display the Checked In glyph, or icon, but they are not a part of the... |
| 23011 | When you open an MDE file that was created from a secured database that contains modules, you may receive the following error message: Record(s) can't be read; no read permissions on 'MsysModules2' |
| 23012 | When you use TransferDatabase to copy an object to a target database, you may receive the following error message if the target database already contains the same type of object with the same name: Object invalid or no longer set. That message is... |
| 23013 | When you convert a Microsoft Office Access 2003 database to a Microsoft Access 97 database and then you open a form or a report in the new Access 97 database, you may receive the following error message: There is no object in this control. |
| 23014 | If you want to print a report to a particular printer, you can manually select the printer and all of the print options, or you can automate the process so that with a click of a button, you can switch printers and then print your report with the... |
| 23015 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article demonstrates two sample user-defined Visual Basic for Applications functions that you can use to pass parameters to an SQL pass-through query. This article assumes... |
| 23016 | When you use the RecordsAffected property of a Database or QueryDef object to determine the number of records affected by the Execute method, the value is incorrect with SQL pass-through queries. This article assumes that you are familiar with Visual... |
| 23017 | When you create a main report that has a subreport with snaking (multiple) columns, you will see the following behavior when you print or preview the report: In Microsoft Access 97 The report will only print one column of data for the subreport. In... |
| 23018 | When you set the system date on your computer to a year greater than or equal to 2038, you may receive the following error message: Synchronization between replica file and replica file failed. The Microsoft Jet database engine could not read the... |
| 23019 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you link a Microsoft Access 2.0 database (.mdb) file in Microsoft Access 7.0 or 97, you may receive the following error message: Can't open a database created with a... |
| 23020 | When you import a Microsoft Access object from one database into another database, any reference used by the object is not imported, and you must re-create the reference in the target database. For example, if you insert an ActiveX control on a form,... |
| 23021 | When you run Microsoft Access on a computer that has a Run from Network Server installation of Microsoft Office 97 Professional Edition or Microsoft Access 97, you may receive the following error messages when you try to use a Wizard: This feature... |
| 23022 | If you modify a Print Setup setting while you are previewing a report, Microsoft Access does not ask you to confirm the changes; the changes are automatically saved. This behavior differs from Microsoft Access version 2.0, which prompts you to save... |
| 23023 | After you insert a Microsoft Graph object into a Microsoft Access form or report, the graph object always displays sample data in Design view. This occurs even if you have opened the form or report, and the graph object correctly displays the actual... |
| 23024 | When you start Microsoft Access, you may receive the following error message: Microsoft Access can't start the data access object (DAO) and so it can't continue. You may also receive the following error message: A system error occurred, or there isn't... |
| 23025 | When you connect to a Microsoft Access database from an Active Server Pages (ASP) page, the following error occurs: The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need... |
| 23026 | This article shows you how to use Automation to create and send a Microsoft Outlook message in Microsoft Access 97. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the... |
| 23027 | When you try to use Jetcomp.exe to compact a Microsoft Access 97 run-time database, you may receive one of the following error messages: Can't Initialize VBA. -or- A required .DLL file, VBAJET32.DLL, was not found. -or- The dynamic link library... |
| 23028 | A form with its DefaultView property set to Datasheet and its Modal and PopUp properties set to Yes does not open with all three properties applied. In Microsoft Access 97, the form opens in Datasheet view, but the Modal and PopUp property settings... |
| 23029 | When you use the CreateTableDef method to create a table that is linked to a table in another Microsoft Access database or to an ODBC data source, you cannot set the Attributes property to dbAttachedTable or dbAttachedODBC. These constants are always... |
| 23030 | When you try to change an ActiveX control to an image in Microsoft Access 97, you may receive the following error message: The operation on the ActiveX Control object failed. The OLE server may not be registered. To register the OLE server,... |
| 23031 | When you run a Visual Basic for Applications procedure that uses the Execute method to update data in a Microsoft SQL Server ODBC data source, you may receive the following error message. In Microsoft Windows NT 4.0 An application error has occurred... |
| 23032 | When you open a database replica in Microsoft Access 7.0 or 97, you may receive the following error message: Can't Update. Database or object is read-only. This may be followed by the following error message, depending on your version of Microsoft... |
| 23033 | When you export a Microsoft Access table to Microsoft SQL Server, any AutoNumber fields in the table become Long Integer fields in the SQL Server table. |
| 23034 | When you try to use the BeforeInsert event to populate a bound OLE control on a form, you may receive the following error. In Microsoft Access 97 Run-time Error '2753': A problem occurred while Microsoft Access was communicating with the OLE server.... |
| 23035 | When you create a new database, Microsoft Access automatically adds the .mdb file extension to the database name, even if you type your own file extension in the File Name box. This applies to all dialog boxes in Microsoft Access where you specify a... |
| 23036 | When you open the Object Browser in Microsoft Access 97, you cannot view any of the form or report class modules in a referenced database. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 23037 | When you use Microsoft Internet Explorer to open an ASP file that was created from a form and a subform in Microsoft Access 97, you may receive the following error message: Internet Explorer cannot open the Internet site URL. The site was not found.... |
| 23038 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you open a Microsoft Access version 2.0 database for the first time in Microsoft Access version 7.0 or 97 without converting the database to the later version, you may... |
| 23039 | In Microsoft Access 7.0 or in Microsoft Access 97, you try running a query with a long join criteria, and you find that the query does not return the expected number of records. |
| 23040 | After you convert a Microsoft Access 7.0 database to Microsoft Access 97, you see incorrect objects in the database when you open it, such as Wizard tables or objects from the Northwind sample database. |
| 23041 | Microsoft Office 97 introduces a new type of Help component called the Office Assistant, which is a feature that is shared by all Microsoft Office programs. The Office Assistant is an interactive Help utility that enables you to ask questions about a... |
| 23042 | You may experience the following problem when you export a table or query from a Microsoft Access database to an existing Microsoft Excel workbook, containing a chart sheet. MSACCESS MSEXCL35.DLL 015f:022bdf9c This program has performed an illegal... |
| 23043 | This article lists the new events and properties for reports in Microsoft Access 7.0 and Microsoft Access 97. |
| 23044 | When you follow the usual procedures for merging a Microsoft Access table with a Microsoft Word document, the pictures that are stored in the Access table are not successfully merged into the Word document. |
| 23045 | After installing an add-in, wizard, or builder and setting the permissions or file attributes to Read-Only, you may receive the following error message. In Microsoft Access 97 Microsoft Access can't find the Wizard, or there is a syntax error in the... |
| 23046 | When you open and move through a form that has been exported as a Microsoft Active Server Page (ASP) to a Microsoft Internet Information Server (IIS) using the Publish to the Web Wizard, you may receive the following error message: HTTP/1.0 403... |
| 23047 | The most recently used (MRU) file list is the list of the last four database files that were opened in Microsoft Access. It appears in the Startup screen for Microsoft Access and at the bottom of the File menu. You can remove the names of the last... |
| 23048 | If you format data in a table with a bold font style, and you then export the table from Microsoft Access 7.0 or 97 to Microsoft Excel 7.0 or 97 by using the Analyze It with MS Excel command, the bold font style is replaced by a regular font style.... |
| 23049 | This article describes and gives you examples of how to programmatically create, search, replace, and modify Visual Basic for Applications code within Microsoft Access 97. One of the most common uses for code that itself writes code is a wizard.... |
| 23050 | When you try to view the custom property sheet of an ActiveX control by double-clicking it in Design view of a Microsoft Access form, you may receive one of the following error messages: A problem occurred while Microsoft Access was communicating with... |
| 23051 | When you try to link a Microsoft FoxPro database with an index from a read-only drive, you may receive the following error message: Microsoft Access can't create, open, or write to the index file filename, the information (.inf) file it uses to keep... |
| 23052 | When you use the underline (_) as a line-continuation character in a Visual Basic code module in Microsoft Access 7.0, and then you convert that database in Microsoft Access 97, you may receive the following error message: There were compilation... |
| 23053 | This article describes how to filter a report dynamically in Print Preview by selecting filter criteria from a pop-up form. NOTE: This article explains a technique demonstrated in the sample files, RptSampl.exe (for Microsoft Access for Windows 95... |
| 23054 | If you use the FollowHyperlink method to link to an object in the same Microsoft Access database, and you set the newwindow argument to True, the object will not appear in a new instance of Microsoft Access. The object will instead appear in the... |
| 23055 | The Replic35.exe file contains the Microsoft Jet Database Replication white paper. This document discusses the Microsoft Jet Replication Architecture, as well as how to implement replication, create replicas, synchronize data, resolve conflicts, use... |
| 23056 | You must use an operating system tool, such as NetWatcher (a utility that comes with Microsoft Windows) or the Windows NT Server Manager, to determine which user has a Microsoft Access 7.0 or 97 database open exclusively. |
| 23057 | When you try to convert or open a Microsoft Access 1.x or 2.0 database, you may receive the following error message: In Microsoft Access 97 ---------------------- The process failed because there is no default printer. This may be followed with the... |
| 23059 | The Compliance Checking Program (CCP) in the upgrade versions of Microsoft Office 97, Professional Edition and Microsoft Access 97 fails to recognize Personal ORACLE 7.2 as an application that qualifies for the competitive upgrade program. |
| 23060 | When you open a linked Microsoft SQL Server 7.0 table in a Microsoft Access database, you notice that a field has #S_C_H# in it instead of the actual data. |
| 23061 | This article summarizes many of the new features in Microsoft Access 97. It contains the following sections: Improvements in Performance Features for Working on the Internet Features for Working with Other Products Office Tools Features in the... |
| 23062 | The Microsoft Access version 2.0 ODBC is not licensed for distribution with applications created with the Microsoft Access Developer's Toolkit (ADT). |
| 23063 | This article shows you two examples of how to use the Winsock ActiveX control installed with the Microsoft Office 97 Developer Edition Tools. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft... |
| 23064 | Microsoft Access has no built-in method for disabling the Close button (x) on the application window or the Close command on the System menu of the application window. This article describes how to programmatically disable both of these elements. |
| 23065 | When you export a Microsoft Access 97 form to Active Server Pages (ASP) format, and then view the file with your Web browser program, you notice one of the following problems when you click the Refresh button: The form becomes blank and does not... |
| 23066 | The Microsoft Access Help topic for the OutputTo action states that this macro action outputs data to Microsoft Excel 97 format. However, when you open the exported Microsoft Excel spreadsheet in Microsoft Excel 97, you notice that the format is... |
| 23067 | When you toggle the Visible or Enabled properties of a ListView control, the control loses its records by approximately one-half each time that those properties are cycled. NOTE: This occurs with Microsoft ListView Control, version 5.0, which is... |
| 23068 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to create a one-column Microsoft Access table whose records consist of hyperlinks that correspond to the Internet shortcuts in a folder. |
| 23069 | When you import a table with its Filter property set into a new Microsoft Access database, you find that the filter is no longer available. When you open the table in the new database, the Filter button is disabled. |
| 23070 | The Microsoft Access 97 Help file contains the following incorrect statement about what happens to Visual Basic for Applications code when you rename a database: When you rename a database, compiled code in the database will be decompiled. To... |
| 23071 | When you run your code in Microsoft Access 97 after converting a database from Microsoft Access 7.0, you may receive the following error message: Compile error: User-defined type not defined. |
| 23072 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article discusses the behavior of Hyperlink fields on ASP forms that you create in Microsoft Access 97. Three main problems you may encounter when you export a Microsoft... |
| 23073 | When you use the TransferSpreadsheet macro action or Visual Basic method to import a Microsoft Excel spreadsheet that contains numeric field names, the fields in the new table are named F1, F2, F3, and so on. |
| 23074 | Database replication is a feature of Microsoft Jet database engine 3.0 and later that enables you to make special copies of databases (called replicas) so that users can work on their own copies at different locations. At a later time, users can... |
| 23075 | When you open or make a reference to a linked table in Microsoft Access 7.0 or 97, you may receive the following error message: Couldn't find input table or query 'Name' -or- Couldn't find file 'pathname\filename' |
| 23076 | When you run the Switchboard Manager in a database where the Switchboard Items table is a linked table, you may receive the following error message. In Microsoft Access 97 The Microsoft Jet database engine cannot find the input table or query... |
| 23077 | This article explains why your Microsoft Access databases can change in size when you convert them from an earlier version to Microsoft Access 7.0 or 97. |
| 23078 | When you are viewing a linked Microsoft Excel 7.0 or 97 table, you see the following behavior: #Error appears in all of the data fields. If you try to edit the table at this point, you receive one of the following error messages. In Microsoft Access... |
| 23079 | When you start your Internet browser by clicking a hyperlink in Microsoft Access, the Access window is minimized. |
| 23080 | The ChangeChart_Click() sub procedure on page 271 of the Building Applications with Microsoft Access for Windows 95 manual causes the error, (Run-time error 1000) Application does not have ChartTitle property. |
| 23081 | In Microsoft Access, you can use a tab control to group sets of controls together on different pages. When you select a tab, you see only the controls embedded on that page. Microsoft Access also provides the CreateControl() function, which enables... |
| 23082 | When you use the PrtMip Property example in Help, you may receive the following error message in Microsoft Access 7.0: The setting you entered isn't valid for this property In Microsoft Access 7.0 and 97, the SetMarginsToDefault() sample procedure... |
| 23083 | If you create a report based on a linked table that is of the text file type in Microsoft Access for Windows 95, you may receive the following error message when you reopen the report after quitting and restarting Microsoft Access: The text file... |
| 23084 | When you perform a mail merge to Microsoft Word 97 from Microsoft Access 97, a second instance of Microsoft Access 97 opens. |
| 23085 | When you try to import a Microsoft Excel spreadsheet into a Microsoft Access database, you may receive the following error message: An error occurred trying to import file 'File Name'. The file was not imported. |
| 23086 | When you use the Microsoft Intellimouse with Microsoft Access 97 on Windows 98, you may experience one or more of the following symptoms: In a form that includes a subform in Datasheet view, you can't scroll in a subform with the Intellimouse wheel.... |
| 23087 | When you export a Microsoft Access table that has a date with a year later than 2078 in a Microsoft Excel format, the export works. However, there will be a null in the date field, and an export_errors table is generated in the database. |
| 23088 | Updates you make to a linked Microsoft Excel workbook do not show up when you open the workbook in Microsoft Excel 97. |
| 23089 | The Access 97 Data Outline ActiveX control, version 1.2, was created to provide an upgrade path to Microsoft Access 97 for databases that contain the Data Outline control. Although you can add this Data Outline control to a form in Microsoft Access... |
| 23090 | This article lists the references that you must set when you are working with databases that you create in Microsoft Access, or when you access information in Microsoft Access databases from other applications. The following topics are covered in this... |
| 23091 | When you use the Documenter Wizard in a Microsoft Access database, some objects that are open may produce an error if you try to document them. NOTE: The Documenter Wizard is called the Documentor Wizard in Microsoft Access 7.0. In Microsoft Access... |
| 23092 | This article lists the shortcut keys available in Microsoft Access 7.0 and Microsoft Access 97. |
| 23093 | After converting a Microsoft Access 2002 database to Microsoft Access 97, you receive the following error message when you open a form or report in the new Microsoft Access 97 database: There is no object in this control. |
| 23094 | When you run Setup for Microsoft Access 7.0 on a computer that already has Microsoft Access 97 installed, you may receive one of the following pairs of error messages: Can't load mspdox35.dll (error code=1157) The configuration of the ODBC Microsoft... |
| 23095 | The Rptsmp97.exe file contains a sample database with over 30 sample reports. These samples demonstrate how to create custom reports to organize and present information the way you want. Topics include dynamically sorting and filtering your data,... |
| 23096 | When you import a Microsoft Excel spreadsheet into Microsoft Access, currency is not displayed correctly in the Import Spreadsheet Wizard. The dollar signs ($), as well as the zeros to the right of the decimal place, are missing from the sample data.... |
| 23097 | This article contains a listing of the hardware/system configuration and software requirements needed to install Microsoft Office 97 Developer Edition Tools. |
| 23098 | When you create a Microsoft Access form in Microsoft Excel that is based on data in a spreadsheet, and you then add additional information to that spreadsheet, the data that you added is not updated in the Microsoft Access form, even though it is... |
| 23099 | The Microsoft Office 97 Service Release 1 (SR-1) Patch may fail to upgrade the Microsoft Jet database engine components. |
| 23100 | When you open a workbook in Microsoft Excel, cells within the workbook may display different values, depending on the version of Microsoft Excel you are currently using. For example, if you open Book1.xls in Microsoft Excel version 5.0 or 7.0, cell A1... |
| 23101 | When you try to establish a DDE connection from a Word document to a Microsoft Access table or query by using the Insert Database command in Word, you may receive the following error message: Word could not re-establish a DDE connection to Microsoft... |
| 23102 | Advanced: Requires expert coding, interoperability, and multi-user skills. This article assumes that you are familiar with using the client and server side capabilities of Microsoft Visual SourceSafe. For more information about Visual SourceSafe,... |
| 23103 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you try to add a Microsoft Access 97 database to a Microsoft Visual SourceSafe project database while a module is in break mode, you may receive the following error... |
| 23104 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you try to use the CheckOut, CheckIn, UndoCheckOut, or GetLatestVersion operations on a Microsoft Access 97 object in the Microsoft Visual SourceSafe 5.0 Explorer, you may... |
| 23105 | When concatenating large strings on the order of 50kb or larger (for example, building an HTML table from a database), the length of time to complete can become quite long as the string gets larger. This article demonstrates an alternative to normal... |
| 23106 | Regsvr32.exe is an application that is used to register dynamic-link libraries (DLLs) and ActiveX controls (formerly called OLE Custom Controls) in the Microsoft Windows 95 and Microsoft Windows NT registries. For example, to manually register the... |
| 23107 | If you add a new reference to a Microsoft Access 7.0 database that has previously been opened in Microsoft Access 97, when you open the database again in Microsoft Access 97, you do not see the option to Open or Convert the database, and the new... |
| 23108 | This article provides sample DLL code in Microsoft Visual C++ 4.x that illustrates how to fill a 32-bit VBA array of a user-defined type (UDT) containing fixed-length strings with data. It also provides VBA code that defines the equivalent structure... |
| 23110 | If you have a Microsoft Office 97 Developer Edition (ODE) run-time application that includes functionality to export forms or reports to HTML that contain GIF objects, it requires the file Gifimp32.flt. However, this file is not included in the list... |
| 23111 | The Intrpl97.exe file contains the Microsoft Access 97 Internet Replication white paper. This document discusses how to implement replication on the Internet. Internet synchronization allows users of a replicated database to exchange updates by way of... |
| 23112 | This article demonstrates how to synchronize database replicas over the Internet using data access objects (DAO). This article assumes you have already installed and configured Microsoft Replication Manager on your Internet server to synchronize... |
| 23113 | When you open the License.hlp file that comes with the Microsoft Office Developer Sampler, you will see the following instruction: When you are finish reading the License Agreement, click Accept to return to Setup. This information is incorrect... |
| 23114 | Microsoft Jet is the database engine that is used by default by Microsoft Access. This article provides a list of best practices that you can use to help keep your Jet database in top working condition. This article addresses a database running both... |
| 23115 | Offautmn.exe is a self-extracting executable that contains a white paper supplemented with sample projects that provide the fundamentals for understanding how to Automate Microsoft Office 97 and Microsoft Office 2000 applications. The white paper is... |
| 23116 | This article lists some of the resources that are available to help you learn Microsoft Visual Basic for Applications programming. The article contains the following categories: Online Help Microsoft Press and Third-Party Reference and Learning... |
| 23117 | After you create an anonymous session to the Exchange Server, the system stops responding (hangs) when you attempt to log off. |
| 23118 | When you try to convert a Microsoft Access 1.x or 2.0 database to Microsoft Access 7.0 or 97, the conversion process stops, and you may receive the following error message: Name conflicts with existing module, project, or object library. |
| 23119 | This article lists Microsoft SQL Server and ORACLE ODBC drivers that you can use with various versions of Microsoft Access and Microsoft Windows. In addition, the article lists the sources from which you can obtain the ODBC drivers. |
| 23120 | Forms will always open to a maximized state once any other Microsoft Access window has been maximized (excluding the Microsoft Access Desktop). However, when a Microsoft Access window is maximized, forms may briefly be displayed in a restored state... |
| 23121 | In Microsoft Access 97, if you compile a Microsoft Access 2000 database that has been converted to Microsoft Access 97, you may receive the following error message: Microsoft Access can't find the project or library NOTE: This behavior does not occur... |
| 23122 | When you open a database created with an earlier version of Microsoft Access without converting the database, you are unable to link or import data. You see one of the following error messages: In Microsoft Access 97: The Get External Data command on... |
| 23123 | In Microsoft Access 7.0 and 97, system tables and conflict tables (tables that contain database records that conflicted during the synchronization of two replicas) may not be made replicable by Microsoft Access. The reason for this is that system... |
| 23124 | The Microsoft Access 97 Help Topic Export a table or other object to an existing Microsoft Access database reads as follows: You can export tables, queries, and macros from Microsoft Access version 8.0/97 to 7.0/95 databases, but only tables to... |
| 23125 | Inetsamp.exe contains a sample Microsoft Access database application that demonstrates the use of the Winsock and the Msinet ActiveX controls. These controls are available with the Microsoft Office Developer Edition. You must have Microsoft Access 97... |
| 23126 | When you try to use a shortcut menu on a form in Microsoft Access 97, if the shortcut menu is missing or does not exist, Microsoft Access displays the following message: Microsoft Access can't find the macro 'name of shortcut menu' This message is... |
| 23127 | The Error Search Tool Add-In for Microsoft Access 97 is a resource for locating error descriptions and error numbers. It also lists associated Help topics for Microsoft Access 97 and Microsoft Jet database engine 3.5 error messages. You can store... |
| 23128 | Two new wizards make it easy for you to view and work with information from your mail folders and address books by using Microsoft Access 97. With the Import Exchange/Outlook Wizard, you can import a Microsoft Exchange or Microsoft Outlook folder or... |
| 23129 | In Microsoft Access, you can use Automation to connect to the Microsoft Graph object model. However Microsoft Graph does not support early binding. Therefore, when you use Automation to connect to Microsoft Graph, you must use late binding. |
| 23130 | When you use Microsoft Query or Access 97 to return external data to a worksheet in Microsoft Excel or when you view returned data in Microsoft Query, you may receive the following error message: Microsoft Query Syntax error in FROM clause. Access 97... |
| 23131 | In Microsoft Access 97, when you use the Merge It with MS Word Wizard to merge a Microsoft Access table or query with a Microsoft Word 97 document, Microsoft Word 97 does not close automatically if the merge process fails. |
| 23132 | When you convert a Microsoft Access 1.x, 2.0, or 7.0 database to a Microsoft Access 97 database (or when you convert a Microsoft Access 1.x or 2.0 database to a Microsoft Access 7.0 database) by using the Convert Database command on the Database... |
| 23133 | This article reproduces the text of Acwizard.doc, a Word document that discusses how to modify the Setup Table File (STF) so that Setup installs Microsoft Access 97 wizard files on users' hard drives during Run From Network Server installations.... |
| 23134 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you convert a large database from Microsoft Access version 2.0 to Microsoft Access 7.0 or Microsoft Access 97, you may receive an Out of Memory error message. |
| 23135 | When you use the Paste Special command on the Edit menu to paste a Microsoft Access object into Microsoft Excel or Microsoft Word, and you click to select the Paste Link and the Display As Icon check boxes in the Paste Special dialog box, the image... |
| 23136 | When you use the Microsoft Map feature in Microsoft Access 97 or the Data Map feature in Microsoft Access 7.0 to create a map, you may receive one of the following error messages: In Microsoft Access 97 using Microsoft Excel 97: The following data... |
| 23137 | When you export a Microsoft Access table to a Microsoft FoxPro 3.0 file format, a FoxPro index file (*.cdx) is not created. However, a .cdx file is created when you export a Microsoft Access table that contains an index to a Microsoft FoxPro 2.0, 2.5,... |
| 23138 | The Microsoft Access 97 Help topic Interchange Microsoft Access data with Microsoft Word states the following about merging data with Word: If you are using Microsoft Word version 7.0/95 or later, you can use the Microsoft Word Mail Merge Wizard to... |
| 23139 | When you export data to Microsoft Excel for Windows 95 or Microsoft Excel 97, numeric values are displayed in a more precise way than they were in Microsoft Access, making the values appear to be incorrect. For example a .15 in Microsoft Access... |
| 23140 | The Choose97.exe file contains a document called Choosing the Appropriate Database Development Tool, which discusses the relative strengths of Microsoft's database products: Microsoft Access, Microsoft Visual Basic, Microsoft Visual FoxPro, and... |
| 23142 | A flaw exists in the project-loading code for Visual Basic for Applications (VBA). If the flaw is exploited successfully, this may permit an attacker to run code of their choice in the context of a logged-on user. The problem occurs because of a... |
| 23143 | WARNING: Although this article discusses Microsoft Access security features, any information you send over the Internet with the techniques described in this article is sent unencrypted. To send encrypted information over the Internet, you must use a... |
| 23144 | This article describes how to define relationships in a Microsoft Access database. It includes the following topics: What Are Table Relationships Types of Table Relationships One-To-Many Relationships Many-To-Many Relationships One-To-One... |
| 23145 | This article shows you how to edit records in related tables. It includes the following topics: How to Add or Edit Data in a Datasheet (Table or Query) or in a Form How to Save a Record in a Datasheet or in a Form How to Delete a Record in a Datasheet... |
| 23146 | In Microsoft Access, you can add a field to a table to look up information in another table. You typically use this technique when you want to create relationships between tables. For example, perhaps you have a Products table with a Category field... |
| 23147 | When you start Microsoft Access 7.0 or 97, you may receive the following error message. In Microsoft Access 97: Microsoft Access can't start because there is no license for it on this machine. -or- Can't find the database you specified or you didn't... |
| 23148 | A Pareto chart provides a simple way of analyzing categorical data. In a Pareto chart, categories are arranged in descending order from left to right as histogram columns, based upon a selected numerical criterion, from highest to lowest values. Then,... |
| 23149 | WARNING : To apply this service pack successfully, you need to have Microsoft Jet version 3.51.0623 or later installed on your computer. If your computer has an earlier version of Jet than this, you must upgrade your computer to Microsoft Office 97... |
| 23150 | This article describes a technique you can use to create Internet Database Connector (IDC) files that allow you to type a username and password in an HTML form in order to query a secure Microsoft Access database. WARNING : Although this article... |
| 23151 | In Microsoft Access, you can create a query to retrieve information from a table or from multiple tables. You can then use the query as the basis of a form, a report, or a data access page. This article shows you how to create simple queries in... |
| 23152 | When a macro doesn't perform correctly, use the following methods to help you isolate where the problem is: Single Stepping - This feature steps through a macro one action at a time with a pause between each action. To activate single step mode, click... |
| 23153 | This article demonstrates how to add your own commands or modify existing commands on the Microsoft on the Web Help menu. You can do this by adding or changing registry keys and values for each Web site that you want to link to, using the Registry... |
| 23154 | When you output a report to Microsoft Excel 97, any Memo field is truncated to 255 characters. You may also see this behavior when you click the Analyze It With MS Excel command while you are previewing a report. |
| 23155 | You can use criteria in a query in Microsoft Access to restrict the set of records that the query returns. To query for different records each time that you run a particular query, you may want the query to prompt you for criteria to enter, for... |
| 23156 | This article shows you how to modify query properties in Microsoft Access. This information is useful if you want to perform such tasks as: Change the display of fields. Create top value queries. Add an alias for a table. Change field captions and... |
| 23157 | When you create a table in Microsoft Access 97 that is linked to a Microsoft Exchange folder, there are system-imposed limits on what you can add, change, or delete. This article discusses those restrictions. You can download Microsoft Access wizards... |
| 23158 | The Microsoft Knowledge Base contains a wealth of information about all Microsoft products and technologies. This article introduces you, the Access 97 user, to the Microsoft Knowledge Base and gives you tips to find the information and the technical... |
| 23159 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article describes how to start the Microsoft Access 97 and Microsoft Access 7.0 wizards by using Visual Basic for Applications. CAUTION: If you plan to create a custom... |
| 23160 | When you open a Microsoft Excel spreadsheet file that contains links to another Microsoft Excel spreadsheet file, you receive one of the following messages: This document contains links. Re-establish links? The workbook you opened contains automatic... |
| 23161 | When you call a class module method directly from a query, form, report, or macro, you receive an error message. |
| 23162 | This article shows you how to format a table, and then how to print it. |
| 23163 | On the right side of the Microsoft Access status bar, there are seven panels that indicate filter or keyboard status. These panels are empty unless a filter has been applied or a particular keyboard mode is in effect. This article describes each of... |
| 23164 | In Microsoft Access 97, you may receive one of the following error messages when you try to set or use some form and report properties in your database: Run-time error '13': Type mismatch -or- Run-time error '94': Invalid use of Null NOTE: The same... |
| 23165 | This article describes how you can create two types of shortcuts on the Windows 95 or later desktop, both of which will start Microsoft Access and open to a form of your choosing. You can create such a shortcut either by dragging the form from the... |
| 23166 | This article shows you how to use automation to create and format a chart in Microsoft Excel 97. |
| 23167 | By using crosstab queries, you can create summary views of your data for easier analysis. This article shows you how to create a crosstab query in Microsoft Access with and without using a wizard. |
| 23168 | This article lists the changes to Microsoft Access 97 in both Microsoft Access 97 Service Release 1 and Microsoft Office 97 Service Release 1, and it describes how you can receive the update. NOTE: Stand-alone Microsoft Access 97 Service Release 1 is... |
| 23169 | When you run an append query, you may receive the following error message: Microsoft Access can't append all the records in the append query. Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 0 records to the... |
| 23170 | If you modify the column width while viewing a system table and then close that system table, you receive following prompt: Do you want to save changes to the layout of table 'System Tablename'? If you click Yes, the Save As dialog box appears with... |
| 23171 | Moderate: Requires basic macro, coding, and interoperability skills. When you carry out a SendKeys macro action, you may receive the following error message: The SendKeys action requires the Microsoft Access Utility Add-in to be loaded. Solution Run... |
| 23172 | Moderate: Requires basic macro, coding, and interoperability skills. This article describes the concept of lightweight objects and provides a technique to create a lightweight switchboard form in Microsoft Access 97 that uses the Hyperlink properties... |
| 23173 | This article lists the ActiveX control (formerly called OLE Custom Control) interfaces that Microsoft Access 97 requires, as well as those categories of interfaces that it does and does not support. This information will help you to create custom... |
| 23174 | When you click Exit on the File menu in Microsoft Access, Access does not quit. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with... |
| 23175 | This article lists the file contents of the Data Access Pack, Dataacc.exe, included with the Microsoft Office 97 ValuPack. The Data Access Pack contains additional drivers for Paradox, Lotus 1-2-3, and Microsoft Exchange/Outlook. It is located in the... |
| 23176 | Microsoft Access 97 and Microsoft Jet database engine version 3.5 use the DISTINCTROW predicate differently than did earlier versions. This article discusses the differences in queries that use DISTINCTROW. |
| 23177 | After you create a query with the Simple Query Wizard in Microsoft Access 97, you may receive the following error message if you try to open the query in Design view: Microsoft Access can't represent the join expression ([TableName].[FieldName] =... |
| 23178 | After you uninstall the Microsoft Access Wizards, you receive the following error message when you try to create a new blank database: Can't open the Microsoft Jet engine workgroup information file. |
| 23179 | When you need unlimited users, 24x7 support, and ACID transactions, Microsoft strongly recommends that you use Microsoft SQL Server with Internet Information Server (IIS). Although Active Server Pages (ASP) works with any OLEDB and ODBC-compliant... |
| 23180 | When you use TransferText in a macro or in a Visual Basic procedure to import data into an enabled Microsoft Access 2.0 database in Microsoft Access 7.0 or 97, you receive may the message: You can't import objects into a database created in an earlier... |
| 23181 | Microsoft Access 97 provides many new features not available in earlier versions. When you open a database from an earlier version in Microsoft Access 97, most of the time the database converts with no difficulty. However, there are circumstances... |
| 23182 | When you open a Microsoft Access 97 database file in Access 2002, you receive the following message repeatedly even if you have selected Open Database : You have selected a database created in a previous version of Microsoft Access. You can convert or... |
| 23183 | This article discusses and explains how COM (Component Object Model) determines which version of an Office application is loaded when you use Office Automation. |
| 23184 | When you try to connect to an Access database with the Visual Interdev Data View Window, you may receive the following error message: Can't Find Installable ISAM. You may also receive the following error message intermittently: Error Type: Provider... |
| 23185 | When you are automating an Office application from Visual Basic (VB), the Office application may display a dialog box. The dialog box causes the Visual Basic application to appear to stop responding (or hang) because VB is waiting for the dialog box... |
| 23186 | When a modal form is displayed from an ActiveX EXE component called from VBA, the Office application that made the call does not repaint correctly while the dialog is displayed. |
| 23187 | An Automation client that successfully automated an Office 97 application crashes with the same Office 97 application after the program is recompiled using an Office 2000 or later type library. You might receive an error similar to one of the... |
| 23188 | The easiest way to convert an Access database to SQL Server is to use the Upsizing Wizard. The Upsizing Wizard: Preserves database structure, including data, indexes, and default settings. Automatically converts Access validation rules and default... |
| 23189 | While automating an Office application, you might receive a large error value such as -2147221494. Troubleshooting the error is greatly facilitated by determining the exact description of the error. This article discusses several methods of obtaining... |
| 23190 | After you convert a database from the Access 2000 format to the Access 97 format, you notice that when you open the database in Access 97, a custom toolbar contains one or more blank buttons. When you click one of these buttons, you may receive the... |
| 23191 | The 3706: ADO could not find the specified provider error appears when you try to connect to an Access database through the Jet 3.51 OLE DB provider. |
| 23192 | The utility program described in this article provides the developer with a tool to list the Visual Basic for Automation (VBA) routines stored in a Microsoft Access database (*.mdb). This tool provides a means for auditing databases and for locating... |
| 23193 | Developers can use Automation to Microsoft Office to build custom solutions that utilize the capabilities and features that are built into the Office product. While such programmatic development can be implemented on a client system with relative... |
| 23194 | This article demonstrates how to obtain the window handle of an Office application with Microsoft Foundation Classes (MFC) while automating that application from Visual C++. |
| 23195 | Although Microsoft does not recommend it, you can install and use more than one version of Access on a single computer. This article discusses how to install and use Access 97 and Access 2000 on the same computer. This article also discusses some of... |
| 23196 | You can use Automation to control Microsoft Office components from your Visual C++ applications. This article provides the basic information you need to automate Office, as well as pointers to resources and sample code. |
| 23197 | This article explains how users with different versions of Microsoft Access can share the same data. |
| 23198 | This article lists the minimum security settings that are required to connect to a remote Microsoft Access database from ASP.NET, including: Windows NT File System (NTFS) settings Microsoft Internet Information Services (IIS) settings Local security... |
| 23199 | This article demonstrates how to obtain the window handle of an Microsoft Office application while automating that application from Visual Basic. |
| 23200 | When you start Microsoft Access, you may receive the following error message: Can't find the database you specified, or you didn't specify a database at all. Specify a valid database in the command line and include a path if necessary. |
| 23201 | Session Summary In this session, we will discuss how to work with Microsoft Access 97 and Microsoft Access 2000 on the same computer. The installation programs for Access 97 and Access 2000 install to the same default directory. When any components of... |
| 23202 | This article discusses the different behaviors that occur when you use the GetObject and CreateObject functions with various versions of Microsoft Office applications. GetObject and CreateObject are functions that are provided by Microsoft Visual... |
| 23203 | Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. on why Microsoft does not recommend automation under this context 257757 INFO: Considerations for Server-Side Automation of Office... |
| 23204 | Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. on why Microsoft does not recommend automation under this context 257757 INFO: Considerations for Server-Side Automation of Office... |
| 23205 | When you click a hyperlink in an embedded Microsoft Excel workbook, Excel generates the following error and does not select the range indicated by the hyperlink: An Unexpected Error Has Occurred |
| 23206 | When you try to use GetObject (Microsoft Visual Basic) or GetActiveObject (Microsoft Visual C++) to automate a Microsoft Office application, you get one of the following error messages, even though the Office application is running: Run-time error... |
| 23207 | Microsoft provides a wizard interface for users of Microsoft Data Access Components (MDAC) 2.0 and later to create OLE DB connection strings. This article describes how to set up and use this Universal Data Link (UDL) Wizard. |
| 23208 | If you have Microsoft Visual Studio 6.0 Service Pack 4 (SP4) installed, when you use Visual Data Tools with an Access 97 or 2000 database, you may receive the following warning: This version of the database design tools is not compatible with SQL... |
| 23209 | Microsoft Visual Basic for Applications (VBA) is based on the Microsoft Visual Basic development system. Microsoft Office products include VBA and use it to perform certain functions. You can use VBA to build customized programs that are based on an... |
| 23210 | Session Summary In this session, we will discuss installing the Access Security Manager and describe its main features. The Access Security Manager is able to create logs of a database's security state and then set the database's security from any... |
| 23211 | To use a mail merge with Microsoft Access data, you can export or copy your data to a word processor, or in Microsoft Access 2.0, 7.0 and 97, you can click the Merge It button on the toolbar. However, you can also create a Microsoft Access report to... |
| 23212 | When you install Microsoft Access on a computer that runs Microsoft Windows NT version 3.51 or Microsoft Windows NT version 4.0, you may receive one of the following error messages: Msjtrclr.dll could not be registered. -or- Can't create System.mdw.... |
| 23213 | This article shows you how to create a sample procedure to link a Microsoft Outlook folder as a table in a Microsoft Access database. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 23214 | If you run the Setup program after you install Microsoft Access 97 with the Run From CD-ROM option, and you click Reinstall in the Installation Maintenance dialog box, Microsoft Access 97 no longer starts. In Microsoft Windows 95 or later, and Windows... |
| 23215 | The Rplfaq97.exe file contains a Microsoft Word document titled Frequently Asked Questions About Microsoft Access Replication written by Mary Chipman, Michael Kaplan, Paul Litwin, and Steve Thompson. This document answers many Microsoft Access... |
| 23216 | With the Partial Replica Wizard, you can create a partial replica without having to do any programming. All you do is specify a filter expression for a table, and the wizard sets the data access objects (DAO) properties and uses the DAO methods for... |
| 23217 | When you try to open the Zoom box, you may receive the following message: Microsoft Access can't open the Zoom box. The Microsoft Access Utility add-in is missing or was modified. Rerun Microsoft Access or Microsoft Office Setup to reinstall Microsoft... |
| 23218 | The Qrysmp97.exe file contains a sample database with over 20 query examples. These examples demonstrate how to create many types of queries, including select queries, crosstab queries, totals queries, and SQL pass-through queries. Topics include... |
| 23219 | When you use the RunApp macro action to open Microsoft Money version 4.0 or 5.0, the program does not open properly. The behavior varies depending on the version of Microsoft Money that you are using. Microsoft Money 4.0 The Microsoft Money splash... |
| 23220 | This article describes what happens internally in Microsoft Access when you delete an object (a table, a form, a query, and so on) from a database. |
| 23221 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you create a graph on a form or report and later make some changes to the formatting or to the data itself within Microsoft Graph, these changes may not appear in the form... |
| 23222 | The About MDE files Help Topic contains the following paragraph: If your database contains Visual Basic code, saving your database as an MDE file compiles all modules, removes all editable source code, and compacts the destination database. Your... |
| 23223 | The LinkChildFields and LinkMasterFields properties that are set by the Subform/Subreport Wizard are reset to the default when the subform control is clicked twice. This behavior also occurs if you manually change the LinkChildFields and... |
| 23224 | The FrmSmp97.exe file contains a sample database with over 30 form examples. These examples demonstrate how to create custom forms for data entry and non-data entry purposes. Topics include dynamically synchronizing two forms, opening multiple... |
| 23225 | When you use the Send command on the File menu, the SendObject method, or the SendObject action, you may receive the following error message: Microsoft Access can't open the mail session. Check your mail application to make sure that it's working... |
| 23226 | This article demonstrates how to use the tab control on a form in Microsoft Access 97. |
| 23227 | In Microsoft Access 7.0 and 97, the sort order that you apply to a field in a form is saved when you save the form or datasheet, and is reapplied automatically when you reopen the form or base a new form or report on that form. This behavior is... |
| 23228 | When you try to save a Microsoft Access database as an MDE file, you may receive the following error message: Can't open any more tables. When you click OK, you receive the message: Out of memory. When you click OK again, you receive the message... |
| 23229 | In a Microsoft Access database, if you have a built-in Switchboard or a custom form that contains a class module as a Startup form, and you open the database through a link from a Web page, it may open multiple instances of Access. NOTE : This can... |
| 23231 | There are a number of reasons corruption can occur in a Microsoft Access database. This article provides a list of references to Microsoft Knowledge Base articles that may assist you in resolving corruption in your database. |
| 23232 | With Microsoft Access Snapshot Viewer you can distribute a snapshot of a Microsoft Access database that permits you to view the snapshot without Access installed. For example, you may want to send a supplier an invoice that is generated by using an... |
| 23233 | You cannot access the DefaultEditing form property in the Microsoft Access 7.0 and 97 user interface. Instead, you can use the new AllowEdits, AllowDeletions, AllowAdditions, and DataEntry properties. DefaultEditing is still available programmatically... |
| 23234 | When you create a module in Microsoft Access 97, you are not prompted to save the module if you have not entered data into the module. In Microsoft Access 95, you are prompted to save the module even though the module is empty. This behavior occurs in... |
| 23235 | When you create a parameter query based on a Microsoft Access database in Microsoft Query, you may receive the following error message: Too few parameters. Expected n. If you click Help in the error message box, the topic states, This error was... |
| 23236 | The Jetutils.exe file contains the Understanding Microsoft Jet Locking white paper, the LDBView utility, the DBLock utility, and the Msldbusr.dll. The white paper introduces you to the Microsoft Jet Database Engine versions 2.x and 3.x locking... |
| 23237 | Advanced: Requires expert coding, interoperability, and multiuser skills. The Acc97cnv.exe file contains a Microsoft Word document called the Microsoft Access 97 Conversion White Paper. This document contains a discussion on potential issues arising... |
| 23238 | The following table lists the ActiveX controls that have been tested and verified for use with Microsoft Access 97. The ActiveX controls listed in this article are the only ActiveX controls supported for use with Microsoft Access 97. |
| 23239 | The Microsoft Jet database engine version 3.5 has some functional improvements over earlier versions. This article discusses the enhancements made to Data Access Objects (DAO), the programming interface provided by the Microsoft Jet database engine... |
| 23240 | When you export a table to Microsoft Excel using the OutputTo macro action or a Visual Basic method, Number fields that have an input mask appear as Text fields in Microsoft Excel. |
| 23241 | The Setup program for Microsoft Access 97 and Microsoft Office 97, Professional Edition does not install the SQL Script file, INSTCAT.SQL, to your hard disk. This file is used with the SQL Server ODBC driver to create stored procedures for use with... |
| 23242 | When you import a delimited text file into an existing Microsoft Access table and that table has a default value set for a particular field, the following behavior will occur during the import. In Microsoft Access 7.0 and 97... |
| 23243 | You can use data from a Microsoft Visual FoxPro database in Microsoft Access 97 if you have added a Visual FoxPro ODBC data source as a User Data Source in the ODBC Data Source Administrator. This article describes how to do so. The latest Microsoft... |
| 23244 | When you try to quit Microsoft Access version 97, you find that you are able to close the database, but you are unable to quit Microsoft Access. Instead, Microsoft Access is minimized without generating any errors. |
| 23245 | When you try to use the Microsoft Messaging Driver in your Visual Basic code to import, export, or link a Microsoft Outlook or Microsoft Exchange folder, you may receive the following error message: Run-time error '3170': Couldn't find installable... |
| 23246 | When you use the Microsoft UpDown Control, version 5.0, in Microsoft Access 97, you cannot use any of the Buddy properties of the control. Depending on what you are trying to do, you may receive one or more of the following error messages: Microsoft... |
| 23247 | After you run the Setup program for Microsoft Access 97 or Microsoft Office 97 Professional Edition, your earlier-version Microsoft Access run-time application does not start. |
| 23248 | When you run the Microsoft Office 97 Professional Edition or the Microsoft Access 97 Setup program from the Add/Remove Programs icon in Control Panel, you are prompted with one of the following messages. In Microsoft Office 97 Professional Edition... |
| 23249 | Microsoft Access 97 Service Release 1 and Microsoft Office 97 Service Release 1 enable you to save a static picture of a Microsoft Access 97 report in an external file format (*.snp). You can then make the report available to someone who does not have... |
| 23250 | This article discusses the issues you may encounter when you install Microsoft Access 7.0 after you install Microsoft Access 97, and how to resolve them. Note that these issues also apply if Microsoft Access 7.0 is already installed on your computer,... |
| 23251 | Each time that you open a chart object in Microsoft Graph, the window size of the chart shrinks in Microsoft Graph. When Microsoft Graph closes, it passes the new, smaller size back to the Microsoft Access chart object. Over time, this behavior cause... |
| 23252 | When you preview a report in Microsoft Access 7.0 or Microsoft Access 97, you may receive the following two error messages: Microsoft Access can't find the field 'field name' referred to in your expression. An error occurred while referencing the... |
| 23253 | There is no longer an ISAM available for Btrieve data. |
| 23254 | This article shows you how to view and edit relationships in a Microsoft Access database. |
| 23255 | When you click a hyperlink, you may receive the following error message: Microsoft Access can't follow the hyperlink to Hyperlink Name. Please verify the destination. |
| 23256 | The Grphsm97.exe file contains the Graph Sample Database with examples of graph types, how to manipulate graphs in Microsoft Graph 8.0, and how to modify graph using Visual Basic for Applications code. The following file is available for download from... |
| 23257 | The Microsoft Access 97 Security Manager enables the database-security administrator to make knowledgeable security decisions as the database and its workgroup evolve. By presenting all security settings in a single view, the administrator can set and... |
| 23258 | You can store date values in a Microsoft Jet 3.5 database starting with the year 100 and up to the year 9999. However, many database functions support only a limited range of dates. This article describes the operational date range for a Jet 3.5... |
| 23259 | When you try to register the Microsoft Web Browser control by using the ActiveX Controls dialog box, you may receive the following error message: C:\Windows\System\Shdocvw.dll cannot be added. Either it is not an OLE control or it requires a separate... |
| 23260 | With the Snapshot Viewer, you can view snapshots that are created with any version of Microsoft Access. The download consists of a stand-alone executable program (Snapview.exe), a Snapshot View control (Snapview.ocx), and related files. Note This... |
| 23261 | When the data source that is used in the PivotTable Wizard is a query that contains a parameter, you may receive the following error message when the wizard tries to create the table: An error occurred while trying to use the Microsoft Excel pivot... |
| 23262 | When you use the Microsoft Word Mail Merge Wizard to merge your data into a Word document, it is possible to use an existing Word document that has been previously merged with a different data source. This article demonstrates how to do this. |
| 23263 | This article lists the hardware and software requirements to install Microsoft Access 97. |
| 23264 | This article lists the wizard files included with Microsoft Access 97, and the wizards that each file contains. |
| 23265 | When you use System Monitor in Microsoft Windows 95, Microsoft Windows 98, and Microsoft Windows Millennium Edition (Me) or Performance Monitor in Microsoft Windows NT and Microsoft Windows 2000 to track CPU usage, Microsoft Access is reported to use... |
| 23266 | The WzTreevw.mde file is a Treeview Control Wizard for Microsoft Access 97. When you insert a Treeview Control on your form with this wizard installed, the wizard will guide you through configuring the Treeview Control. The appearance of the Treeview... |
| 23267 | When you try to open the Microsoft Access Readme.txt or Network.txt, you may receive the following error message: Windows cannot find Deskedit.exe This file is needed for opening files of type 'Text Document' |
| 23268 | If you import a Microsoft Excel 97 for Windows worksheet that contains more than 16,384 rows of data into a Microsoft Access database, the resulting table may be truncated to 16,384 records. |
| 23269 | When you create an update query that calculates values for a Numeric field whose FieldSize property is set to Byte, you may not get the results that you expect when the calculated value in the field is larger than what the Byte size data type can... |
| 23270 | The Microsoft Access 97 Readme File, Acread80.wri, is the only Microsoft Office 97 Readme file in WordPad format; all other products' Readme files are in text format. |
| 23271 | The V35perf.exe file contains an overview of Microsoft Jet Database Engine version 3.5. The overview discusses the primary goal of Microsoft Jet Database Engine 3.5, benchmark timings, details on performance enhancements, and configurable performance... |
| 23272 | When you use the Report Wizard in Microsoft Access 7.0 or 97 to create a report that is based on a linked spreadsheet that is more than 10 megabytes (MB) in size, the wizard takes a long time to create the report. In some cases Microsoft Access may... |
| 23273 | The Visual Basic for Applications help file for Microsoft Graph is included in the ValuPack folder on the Microsoft Office 97 compact disc. You can also download the same help file (Vbagrp8.exe). The following file is available for download from the... |
| 23274 | The Unload Statement Help topic included in the Microsoft Access 97 Help system does not apply to procedures that you create in Microsoft Access. Rather, it applies to procedures written in Microsoft Visual Basic version 5.0. |
| 23275 | Microsoft Access 97 does not support the UserForm object or the UserForms collection. Although some methods, properties, events, and statements that apply only to the UserForm object appear in Microsoft Access Help, you cannot use them in Microsoft... |
| 23276 | The database file format in Microsoft Access 97 is different from the file format in earlier versions; however, you can export tables from a Microsoft Access 97 database to a database created by an earlier version. |
| 23277 | When you create a chart in Microsoft Access, Microsoft Graph automatically adjusts the scale of the value axis for each record. This means the displayed range of values may vary from record to record. This article demonstrates how you can manually... |
| 23278 | Migration from earlier versions of Microsoft Access to Microsoft Access 97 is straightforward. When you initially open your database in Microsoft Access 97, you have two choices: to convert the database to version 97, or to open it in version 97. The... |
| 23279 | Earlier versions of Microsoft Access contained a Menu Wizard to assist in creating custom menus. This wizard helps you create custom menus in Microsoft Access 97. The following file is available for download from the Microsoft Download Center:... |
| 23280 | When you run Setup of Microsoft Access 97, you are prompted with the following Microsoft Access 97 Setup message: Setup will install Microsoft Access in the following destination folder. To install to this folder, click OK. To install to a different... |
| 23281 | Some Microsoft Access 97 CD-ROM liners state the following: The Microsoft Access 97 CD-ROM includes the Microsoft Access 97 ValuPack, which contains additional value-added components, such as: Microsoft Internet Explorer 3.0, sounds, additional... |
| 23282 | The Upsizing Microsoft Access Applications to Microsoft SQL Server white paper is intended to help you complete the migration of your Microsoft Access application to Microsoft SQL Server smoothly and to help you optimize your application strategy... |
| 23283 | The Microsoft Access 97 Upsizing Tools consists of the Upsizing Wizard and SQL Server Browser, which enable you to use Microsoft Access to develop and maintain Microsoft SQL Server client/server applications. The Upsizing Wizard takes a Microsoft... |
| 23284 | This article explains how to import or link Lotus Approach (.apr) files in a Microsoft Access database. |
| 23285 | This sample application is designed to be a learning tool for developers who are creating solutions with Microsoft Access 97 and deploying those solutions with Microsoft Office 97 Developer Edition. It contains a Microsoft Access database with several... |
| 23286 | In Microsoft Excel, when you create a link to a Microsoft Access query, the query is not updated dynamically. That is, when you change the query in Microsoft Access, the linked information is not automatically updated in Microsoft Excel, even if both... |
| 23287 | The Microsoft Office Developer Consulting Line is available for customers who need development assistance using Microsoft Office products. The cost is $195/hour. The customers can receive the following services: Technical support for developing... |
| 23288 | You receive an Out of memory error when you try to start Microsoft Access on a computer that has 1 gigabyte (GB) or more of random access memory (RAM). |
| 23289 | When you run the Setup program for Microsoft Access 97 on a computer that also has Microsoft Access 2.0 or 7.0 and Microsoft Graph 5.0 installed, and you include the Microsoft Graph 8.0 components in the Setup options, the following behavior occurs... |
| 23290 | The Microsoft Year 2000 Product Analyzer lists Microsoft Jet as not being compliant, even though you have previously applied Microsoft Jet Service Pack 2 (SP2) and/or Microsoft Jet Service Pack 3 (SP3), which are both year 2000 compliant. |
| 23291 | If you try to invoke the PivotTable Wizard when you have Microsoft Excel version 7.0 or 7.0a installed, the PivotTable Wizard will return the following error message when it starts Microsoft Excel: An error occurred while trying to use Microsoft Excel... |
| 23292 | This article describes how to use Automation to add or remove a title of a graph and how to hide or show a legend for a graph. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 23293 | In Microsoft Access 7.0 and 97, a single action, such as clicking the mouse or pressing a key, can trigger several different events that occur in a particular order. Knowing when and in what order events occur can help you to create macros and... |
| 23294 | When you run the Microsoft Access 7.0 Setup program to uninstall Microsoft Access 7.0 from a computer that also has Microsoft Access 97 installed, the Microsoft Access shortcut on the Programs list of the Start menu is removed. |
| 23295 | When you try to create a Microsoft Access form in Microsoft Excel by using the AccessLinks add-in program, and you are using data from a Microsoft Query data source, you may receive the following error message: Cannot start Microsoft Access form or... |
| 23296 | If you have your operating system configured to hide MS-DOS file extensions, when you try to export a Microsoft Access 97 object to an MDE file you may receive the following error message: Microsoft Access can't find the database file 'MDE File... |
| 23297 | In Microsoft Access 97, when you open a form in the sample database Northwind.mdb and try to save it to a different name, you may receive the following error message. Using Microsoft Windows NT 3.51 or 4.0 MSACCESS.EXE Exception: access violation... |
| 23298 | When you use Microsoft Access 97 to convert a database, open a database, or import a form or report created with an earlier version of Microsoft Access, you may receive some or all of the following error messages. Converting a Database Microsoft... |
| 23299 | In the Microsoft Access 97 Readme file, Acread80.wri, the following code sample in the Microsoft Exchange/Outlook Driver section is incomplete: To open a Microsoft Exchange/Outlook folder directly, use the OpenDatabase method and specify values for... |
| 23300 | When you use the Microsoft Web Browser control on a form in Microsoft Access 97, the control retains its original size even when you open the form in Design view and resize the control. |
| 23301 | After you convert a database that you created with the Database Wizard in Microsoft Access 7.0 in Microsoft Access 97, you may receive the following error message when you click the Change Switchboard Items button on the Main Switchboard form: Command... |
| 23302 | If you have completed a custom installation of Microsoft Access or Microsoft Office on a Novell Netware server and you modified the STF file to specify that the Access wizards be installed locally, when you try to use the Access wizards, you may... |
| 23303 | WARNING : To apply this service pack successfully, you need to have Microsoft Jet version 3.51.0623 or later installed on your computer. If your computer has an earlier version of Jet than this, you must upgrade your computer to Microsoft Office 97... |
| 23304 | When you install an add-in or wizard, such as the Microsoft Access 97 Exchange and Outlook Wizard, the Microsoft Print Relationships Wizard, or the Microsoft Partial Replication Wizard, you may receive the following error message: Setup could not find... |
| 23305 | When you use the FoxPro ISAM driver that is included with Microsoft Access 97 to import or link a Microsoft Visual FoxPro 3.0 file that has fields that contain nulls, you notice that those fields now contain data. |
| 23306 | Creating a wizard in Microsoft Access requires some basic navigation screens and buttons. The Wizard Building Wizard is designed to help you create the basic shell for your own wizards. The following file is available for download from the Microsoft... |
| 23307 | The Wzrplrgl.mde file is an add-in for Microsoft Access 97 that enables you to convert the Design Master database from a replica set to its original, nonreplicated state. The following file is available for download from the Microsoft Download Center:... |
| 23308 | When you customize your toolbars to use large icons in Microsoft Office 97 or Microsoft Office 97 Professional Edition, only the top level toolbars display large icons. Any toolbars below the top level continue to display small icons. |
| 23309 | Custom databases that have multiple queries running may stop responding on Microsoft Windows NT or Microsoft Windows 2000 with the following error: Access Violation (0xc0000005), Address (varies) This problem typically occurs when you open a database... |
| 23310 | When you run the Microsoft Access 97 Setup program in maintenance mode on a computer on which you installed Microsoft Access using DMF floppy disks, and you select the Add/Remove or Remove All option, you are prompted for Disk 7 when the Setup program... |
| 23311 | In Microsoft Access, you can use Automation to connect to the Microsoft Graph object model. However Microsoft Graph does not support early binding. Therefore, when you use Automation to connect to Microsoft Graph, you must use late binding. |
| 23312 | The Error Search Tool Add-In for Microsoft Access 97 is a resource for locating error descriptions and error numbers. It also lists associated Help topics for Microsoft Access 97 and Microsoft Jet database engine 3.5 error messages. You can store... |
| 23313 | Two new wizards make it easy for you to view and work with information from your mail folders and address books by using Microsoft Access 97. With the Import Exchange/Outlook Wizard, you can import a Microsoft Exchange or Microsoft Outlook folder or... |
| 23314 | Inetsamp.exe contains a sample Microsoft Access database application that demonstrates the use of the Winsock and the Msinet ActiveX controls. These controls are available with the Microsoft Office Developer Edition. You must have Microsoft Access 97... |
| 23315 | When you use the Paste Special command on the Edit menu to paste a Microsoft Access object into Microsoft Excel or Microsoft Word, and you click to select the Paste Link and the Display As Icon check boxes in the Paste Special dialog box, the image... |
| 23316 | This article shows you how to edit records in related tables. It includes the following topics: How to Add or Edit Data in a Datasheet (Table or Query) or in a Form How to Save a Record in a Datasheet or in a Form How to Delete a Record in a Datasheet... |
| 23317 | The Choose97.exe file contains a document called Choosing the Appropriate Database Development Tool, which discusses the relative strengths of Microsoft's database products: Microsoft Access, Microsoft Visual Basic, Microsoft Visual FoxPro, and... |
| 23318 | This article describes how to define relationships in a Microsoft Access database. It includes the following topics: What Are Table Relationships Types of Table Relationships One-To-Many Relationships Many-To-Many Relationships One-To-One... |
| 23319 | In Microsoft Access, you can create a query to retrieve information from a table or from multiple tables. You can then use the query as the basis of a form, a report, or a data access page. This article shows you how to create simple queries in... |
| 23320 | In Microsoft Access, you can add a field to a table to look up information in another table. You typically use this technique when you want to create relationships between tables. For example, perhaps you have a Products table with a Category field... |
| 23321 | This article demonstrates how to add your own commands or modify existing commands on the Microsoft on the Web Help menu. You can do this by adding or changing registry keys and values for each Web site that you want to link to, using the Registry... |
| 23322 | You can use criteria in a query in Microsoft Access to restrict the set of records that the query returns. To query for different records each time that you run a particular query, you may want the query to prompt you for criteria to enter, for... |
| 23323 | This article lists the references that you must set when you are working with databases that you create in Microsoft Access, or when you access information in Microsoft Access databases from other applications. The following topics are covered in this... |
| 23324 | This article shows you how to format a table, and then how to print it. |
| 23325 | When you create a table in Microsoft Access 97 that is linked to a Microsoft Exchange folder, there are system-imposed limits on what you can add, change, or delete. This article discusses those restrictions. You can download Microsoft Access wizards... |
| 23326 | If you modify the column width while viewing a system table and then close that system table, you receive following prompt: Do you want to save changes to the layout of table 'System Tablename'? If you click Yes, the Save As dialog box appears with... |
| 23327 | When you export a Microsoft Access table that has a date with a year later than 2078 in a Microsoft Excel format, the export works. However, there will be a null in the date field, and an export_errors table is generated in the database. |
| 23328 | After you uninstall the Microsoft Access Wizards, you receive the following error message when you try to create a new blank database: Can't open the Microsoft Jet engine workgroup information file. |
| 23329 | After you install a Microsoft Access 97 run-time application that was created on a computer running Microsoft Office 97 Service Release 1 (SR-1), the name, the organization, and the product ID (PID) of the registered user on the target computer are... |
| 23330 | When you convert a Microsoft Access for Windows 95 version 7.0 database that contains a custom menu bar called Menu Bar to Microsoft Access 97, the database will contain two toolbars named Menu Bar once the menu bar macro is run. One toolbar is the... |
| 23331 | The Replication Code Sample database provides several samples of Data Access Object code to control Microsoft Access Replication. The samples include making a Design Master, making a full replica, making a partial replica, synchronizing two replicas,... |
| 23332 | This article contains information on known errors, corrections, and comments relating to the Microsoft Press book Jet Database Engine Programmer's Guide, Second Edition, ISBN 1-57231-342-0. The following topics are covered: Page 631: Number of... |
| 23333 | In any of the programs listed at the beginning of this article, if you enter a date that uses a two-digit year in the Custom tab of the Properties dialog box, the date is in the twentieth century (from 1900 to 1999). |
| 23334 | Visual Basic for Applications only supports signed 2- and 4-byte Integers, while other languages, such as C, support both signed and unsigned Integers. This article provides conversion functions between signed and unsigned 4-byte Integers and between... |
| 23335 | This article demonstrates how to use ActiveX Data Objects (ADO) and ADO Extensions for DDL and Security (ADOX) to modify the underlying SQL query of an Access 97 or Access 2000 QueryDef object from a Visual Basic application at run time. |
| 23336 | When you create a multiple-field primary key in Design view of a table, you may receive the following error message: Invalid index definition. This will be followed by: Microsoft Access was unable to create the table. -or- Errors were encountered... |
| 23337 | When you run a query based on a linked (attached) Microsoft SQL Server table that contains a Date/Time field, and the criteria for the Date/Time field contains a literal time value, Microsoft Access returns an empty result set. |
| 23338 | This article discusses the Microsoft Access functions CreateForm() and CreateReport(). If you intend to write your own Form Wizard or Report Wizard, you can use these functions to create and customize a blank form or report to which you can add... |
| 23339 | When you use the ENTER key to select a hyperlink in a combo box, Microsoft Access follows the hyperlink instead of putting your selection in the combo box. |
| 23340 | When you start the Microsoft Access Developer's Toolkit for Windows 95 Setup Wizard, you receive the following error message: Run-time error '53' File Not found Msau7032.dll You may also receive a prompt to convert or enable the database before... |
| 23341 | When you import a Microsoft Word table that contains carriage returns in its cells, the table is not imported correctly because Microsoft Access interprets each carriage return/line feed as a new record delimiter. To avoid this problem, you can... |
| 23342 | The Microsoft Access 97 IsObject Function Help Topic contains the following sentence: You can use the IsNothing function to determine if an object reference has been set to Nothing. This is incorrect. There is no IsNothing function in Microsoft... |
| 23343 | If you install Microsoft Access 7.0 or 97 on a computer that has Microsoft Access 2.0 and Microsoft Access Developer's Toolkit version 2.0 installed, you may receive the following error message when you try to add a Calendar Control object to a form... |
| 23344 | Advanced: Requires expert coding, interoperability, and multiuser skills. Microsoft SQL Server supports updatable views. Microsoft Access can only link (attach) these views as read-only because SQL Server views do not have indexes. Microsoft Access... |
| 23345 | When you export data to Microsoft Excel for Windows 95 or Microsoft Excel 97, numeric values are displayed in a more precise way than they were in Microsoft Access, making the values appear to be incorrect. For example a .15 in Microsoft Access... |
| 23346 | When you export from Microsoft Access to a Lotus 1-2-3 format of *.WK1 or *.WK3, an associated INI file with the same file name is also created. For example, if you export Table1 to the WK1 Lotus 1-2-3 format, an INI file with the name Table1.INI is... |
| 23347 | When you run multiple delete queries in a replicated Microsoft Access database, the size of the database may increase significantly. Compacting the database does not reduce its size. |
| 23348 | You can use the ShowPrintDialog argument of the PrintSnapshot method to prevent the Print dialog box from being displayed. However, in Microsoft Access 97, if you set the ShowPrintDialog argument to False, the Snapshot file is not printed. If you... |
| 23349 | If you create an HTX/IDC or ASP file from a form in Microsoft Access 97, when you open it in your Web browser you see empty fields in your IDC datasheet, or you see #Expression in one or more fields of your ASP form. |
| 23350 | The Wzfunc97.exe file contains a Microsoft Access 97 add-in for automating the creation of code procedures. Common features such as DAO code and error handling are added automatically by the wizard based on options chosen by the user. The following... |
| 23351 | In a Microsoft Access macro, a SendKeys action must precede the DoMenuItem action when you need to send keystrokes to a dialog window. For example, when a DoMenuItem action opens the Print dialog to change a printing parameter, the SendKeys keystrokes... |
| 23352 | The ChangeChart_Click() sub procedure on page 271 of the Building Applications with Microsoft Access for Windows 95 manual causes the error, (Run-time error 1000) Application does not have ChartTitle property. |
| 23353 | The Microsoft Access 97 Help Topic Import or Link Data from a spreadsheet states the following about appending spreadsheet data to an existing table: Although you normally create a new table in Microsoft Access for the data, you can also append the... |
| 23355 | This article describes a technique you can use to create Internet Database Connector (IDC) files that allow you to type a username and password in an HTML form in order to query a secure Microsoft Access database. WARNING : Although this article... |
| 23356 | The Microsoft Access version 2.0 ODBC is not licensed for distribution with applications created with the Microsoft Access Developer's Toolkit (ADT). |
| 23357 | The Microsoft Access 97 Help topic Interchange Microsoft Access data with Microsoft Word states the following about merging data with Word: If you are using Microsoft Word version 7.0/95 or later, you can use the Microsoft Word Mail Merge Wizard to... |
| 23358 | When you use the Linked Table Manager to change the file location from which your tables are linked, or when you change the Connect property of a TableDef, the changes are not synchronized with other members of the replica set. |
| 23359 | This article describes how to locate Microsoft product information and how to make purchases online. |
| 23360 | The .ldb file plays an important role in the multiuser scheme of the Microsoft Jet database engine versions 3.0 and 3.5. The .ldb file is used to determine which records are locked in a shared database and by whom. |
| 23361 | Advanced: Requires expert coding, interoperability, and multiuser skills. If you use the Linked Table Manager to refresh the link to a table that is under Source Code Control, and you do not have Data and Misc. Objects checked out, Microsoft Access... |
| 23362 | This article discusses the three most common error messages returned by the Microsoft Jet database engine 3.x that denote some form of corruption in the database. The article discusses what the messages mean and how to resolve the issue(s) causing the... |
| 23363 | When using a binary field to store text in a Microsoft Jet 2.5 or earlier database, 32-bit applications cannot read text written by 16-bit applications and vice versa. |
| 23364 | An action query always commits changes to data in a table. This occurs even if you click No when Microsoft Access prompts you to commit the changes. |
| 23365 | If you modify an existing query and then export it to another file format without saving it, the expected data may not appear in the resulting file. For example, this behavior can occur when you export a query to a text file (*.txt), to Microsoft... |
| 23366 | When you follow a hyperlink on a form or report, the Web toolbar opens and remains open as long as the Microsoft Access session is open. However if you manually close the Web toolbar, and then follow another hyperlink, the Web toolbar does not reopen. |
| 23367 | If you create a report based on a linked table that is of the text file type in Microsoft Access for Windows 95, you may receive the following error message when you reopen the report after quitting and restarting Microsoft Access: The text file... |
| 23368 | Under certain circumstances, when you start the retail version of Microsoft Access 97 after you have previously installed and uninstalled the run-time version of Microsoft Access, you may receive the following error message: Can't find the... |
| 23369 | Updates you make to a linked Microsoft Excel workbook do not show up when you open the workbook in Microsoft Excel 97. |
| 23370 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you use the Microsoft Access for Windows 95 Upsizing Tools to upsize your Microsoft Access database to Microsoft SQL Server, your selected tables are not exported to... |
| 23371 | When you run the Microsoft Access 97 Setup program from an administrative installation on a server, you may receive the following error message: Setup Error 914 Object 27 Your Setup files may be damaged. Try restarting the Setup program from where you... |
| 23372 | You will not be able to view HTML, IDC, or ASP files exported from Microsoft Access 97 if the required WWW Directory Access permissions are not set on your Internet Server. This article is an overview of the Internet Server WWW Directory Access... |
| 23373 | Under certain conditions, when you try to start Microsoft Access, you may receive the following error message: Microsoft Access can't start because there is no license for it on this machine. The AcLicn97.exe file contains a tool that corrects this... |
| 23374 | When you output a Microsoft Access report to Microsoft Excel file format, a text string that is made up of both alphabetical and numeric characters may be changed to a number, and this number may appear in scientific notation when you open the... |
| 23375 | When you convert the Microsoft Access 2.0 sample database NWIND.MDB to Microsoft Access 97, you receive the following error message: There were compilation errors during the conversion or enabling of this database. |
| 23376 | When you use the Microsoft Intellimouse with Microsoft Access 97 on Windows 98, you may experience one or more of the following symptoms: In a form that includes a subform in Datasheet view, you can't scroll in a subform with the Intellimouse wheel.... |
| 23377 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you convert a large database from Microsoft Access version 2.0 to Microsoft Access 7.0 or Microsoft Access 97, you may receive an Out of Memory error message. |
| 23378 | Microsoft Access 7.0 and 97 do not create an Import Errors table after an import of a text file or spreadsheet fails. |
| 23379 | When you use the CreateTableDef method to create a table that is linked to a table in another Microsoft Access database or to an ODBC data source, you cannot set the Attributes property to dbAttachedTable or dbAttachedODBC. These constants are always... |
| 23380 | When you export a linked table or an object based on a linked table to Active Server Pages (ASP), the resulting file may not work correctly. For example, when you open the ASP file in a browser, you may receive the error: Microsoft OLE DB Provider for... |
| 23381 | If you change toggle button controls in an option group on a form to option buttons (or, in some cases, to check boxes), you may receive the following error message, and then Microsoft Access quits. In Microsoft Windows 95 This program has performed... |
| 23382 | When you try to view the custom property sheet of an ActiveX control by double-clicking it in Design view of a Microsoft Access form, you may receive one of the following error messages: A problem occurred while Microsoft Access was communicating with... |
| 23383 | The Compliance Checking Program (CCP) in the upgrade versions of Microsoft Office 97, Professional Edition and Microsoft Access 97 fails to recognize Personal ORACLE 7.2 as an application that qualifies for the competitive upgrade program. |
| 23384 | The Microsoft Access 97 Help Topic Export a table or other object to an existing Microsoft Access database reads as follows: You can export tables, queries, and macros from Microsoft Access version 8.0/97 to 7.0/95 databases, but only tables to... |
| 23385 | This article describes what happens to Microsoft Access groups, calculations, and labels when you export a report to Microsoft Excel. |
| 23386 | A flaw exists in the project-loading code for Visual Basic for Applications (VBA). If the flaw is exploited successfully, this may permit an attacker to run code of their choice in the context of a logged-on user. The problem occurs because of a... |
| 23387 | You can edit the Jet Registry keys to alter the data access behavior of the Microsoft Jet database engine. However, doing so affects all Jet-based applications, and may have unintended negative consequences for some. By using custom profiles, you can... |
| 23388 | With Microsoft Access Snapshot Viewer you can distribute a snapshot of a Microsoft Access database that permits you to view the snapshot without Access installed. For example, you may want to send a supplier an invoice that is generated by using an... |
| 23389 | After you try to synchronize with a replica that has been deleted, you receive one of the following error messages: Microsoft Access can't open the database 'Database Name'. 'Database Name' isn't a valid path. Make sure that the path name is... |
| 23390 | When you try to run a custom setup program created by using the Microsoft Office 97 Developer Edition Tools (ODE) Setup Wizard, you may receive the following error message: Setup Error 825 Object 425 Your Setup files may be damaged. Try restarting the... |
| 23391 | When you switch a query from Design view to Datasheet view, Microsoft Access prompts you for the same parameter twice; that is, you must type the same parameter value twice in order to view the correct results in Datasheet view. |
| 23392 | This article shows you how to create a sample function that generates a random file name that can be used for a temporary file. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 23393 | When you open the example Browsing the World Wide Web in the sample database Solutions.mdb, you receive the following error: Error Loading Browser You can view this form only on a computer that also has Microsoft Internet Explorer 3.0 or later... |
| 23394 | On a computer that runs Microsoft Windows 2000 Server, when a second user tries to open an Access 97 database (an .mdb file) that you share, the following error message may appear: Couldn't use database path . File already in use. |
| 23395 | The OpenRecordset Method Help Topic in Microsoft Access 97 states the following for the Options parameter: options Optional. A combination of constants that specify characteristics of the new Recordset, as listed in Settings. However, in an ODBCDirect... |
| 23396 | If you try to run a wizard while in break mode of a module, you may receive the following message: Microsoft Access can't find the wizard, or there is a syntax error in the Declarations section of a Visual Basic module. |
| 23397 | If you copy the example from the GetObject Function Help topic in Microsoft Access 97 and paste it into a module, you may receive the following error message when you compile your code: Compile error: Expected: list separator or ) This article... |
| 23398 | When you try to use the BeforeInsert event to populate a bound OLE control on a form, you may receive the following error. In Microsoft Access 97 Run-time Error '2753': A problem occurred while Microsoft Access was communicating with the OLE server.... |
| 23399 | When you create a new database, Microsoft Access automatically adds the .mdb file extension to the database name, even if you type your own file extension in the File Name box. This applies to all dialog boxes in Microsoft Access where you specify a... |
| 23400 | In a Microsoft Access table, if you've added formatting to the numbers in a Number field and you send that data to Microsoft Word through a mail merge, the numbers will lose their formatting when they appear in Microsoft Word. |
| 23401 | Microsoft Access 97 includes the Microsoft Calendar Control. When you view the properties of a Calendar control that you added to a form, you see that the Class property of the control is Mscal.Calendar.7. |
| 23403 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article lists the collating sequence used in Microsoft Access. This sequence is not alterable, and the following sort tables are provided for reference purposes only. |
| 23404 | Advanced: Requires expert coding, interoperability, and multiuser skills. You are not prompted for a user name and password as you would expect when you are using ODBC from an application to open a secured Microsoft Access database. |
| 23405 | In some cases, when you create or load the word list, the Help Topics dialog box may appear to be disabled or may appear to hang (stop responding). |
| 23406 | When you import a Microsoft Access object from one database into another database, any reference used by the object is not imported, and you must re-create the reference in the target database. For example, if you insert an ActiveX control on a form,... |
| 23407 | Advanced: Requires expert coding, interoperability, and multi-user skills. When you try to check out a module for which you have no Microsoft Access permissions, you may receive the following error message: You don't have permissions to modify... |
| 23408 | When you try to commit a record after you have edited an OLE link, you may receive one of the following error messages. In Microsoft Access 7.0 ----------------------- The object application isn't registered. Solution To register the object... |
| 23409 | In a Microsoft Access query, if you use the LIKE operator with a wildcard, such as * or ?, to search for dates, you may see unexpected results. |
| 23410 | When you create access keys for table or query fields by typing an ampersand (&) in the Caption property of table or query fields, the access keys do not work in table or query Datasheet view. In Microsoft Access 7.0 and 97 the literal ampersand... |
| 23411 | When you run the Setup program for the Data Access Pack to uninstall the Paradox, Lotus 1-2-3, or Microsoft Exchange/Outlook drivers, after you click Remove All in the Setup Maintenance dialog box, the driver files and their Windows Registry settings... |
| 23412 | When you try to create labels using the Label Wizard in Microsoft Access 7.0 or 97 on a computer running Windows NT 4.0, the screen may appear completely blank when you try to make selections in the Label Wizard. However, you are able to see the... |
| 23413 | When you run your code in Microsoft Access 97 after converting a database from Microsoft Access 7.0, you may receive the following error message: Compile error: User-defined type not defined. |
| 23414 | Sometimes you may want to display a status message to inform users that they must wait for an action to be completed. For example, you may want to display the text Please Wait while Microsoft Access is initializing a database, running a long query,... |
| 23415 | Advanced: Requires expert coding, interoperability, and multiuser skills. Microsoft Access includes two pseudo actions, or dynamic data exchange (DDE) commands, called OpenDatabase and CloseDatabase. These commands are available through the DDE... |
| 23416 | Advanced: Requires expert coding, interoperability, and multiuser skills. When a user tries to open a table in Design view when that user has modify design permission for the table, the following error message may appear. In Microsoft Access 7.0 and... |
| 23417 | The Microsoft Access 97 Help topic for the OutputTo method incorrectly states that the intrinsic constant to output Active Server Pages (ASP) files is acFormatActiveXServer. |
| 23418 | When you run an update query in a database which has been converted to Microsoft Access 97, you may receive the following error message: Operation must use an updatable query. This occurs even if the update query ran without the error in Microsoft... |
| 23419 | Advanced: Requires expert coding, interoperability, and multiuser skills. You can use data access objects (DAO) in Microsoft Access versions 2.0, 7.0, and 97 to change the ownership of database objects (such as tables, forms, and reports) in... |
| 23420 | When you start your Internet browser by clicking a hyperlink in Microsoft Access, the Access window is minimized. |
| 23421 | When you use Microsoft Internet Explorer to open an ASP file that was created from a form and a subform in Microsoft Access 97, you may receive the following error message: Internet Explorer cannot open the Internet site URL. The site was not found.... |
| 23422 | In the sample code in the Microsoft Access 97 OldValue Property Help topic that reads as follows, the last line before the End Sub statement (Next ctl) is incorrect: Sub btnUndo_Click() Dim ctlTextbox As Control For Each ctlTextbox in Me.Controls If... |
| 23423 | When you press F1 to bring up a Help topic for a Microsoft Office 97 Developer Edition Tools (ODE) ActiveX control while in the Object Browser in Microsoft Access 97, you may receive one of the following error messages: Cannot find vbcmn96.hlp file.... |
| 23424 | The Properties view of the Open dialog box does not display the Hyperlink Base property for Microsoft Access databases. You can view this property in the Open dialog box in other Microsoft Office 97 applications. |
| 23425 | The default ODBC LoginTimeout property setting for Microsoft Jet databases is 20. Depending on which version of Microsoft Access you have, the ODBC LoginTimeout setting is stored in the following registry key. In Microsoft Access 97... |
| 23426 | In order for the SQL Server System Administrator (logged on as SA) to see the SQL Server system tables from within Microsoft Access, the Show System Objects option must be set to Yes in Microsoft Access. |
| 23427 | When you use the Documenter Wizard in a Microsoft Access database, some objects that are open may produce an error if you try to document them. NOTE: The Documenter Wizard is called the Documentor Wizard in Microsoft Access 7.0. In Microsoft Access... |
| 23428 | When you try to use a shortcut menu on a form in Microsoft Access 97, if the shortcut menu is missing or does not exist, Microsoft Access displays the following message: Microsoft Access can't find the macro 'name of shortcut menu' This message is... |
| 23429 | In Microsoft Access 97, when you use the Merge It with MS Word Wizard to merge a Microsoft Access table or query with a Microsoft Word 97 document, Microsoft Word 97 does not close automatically if the merge process fails. |
| 23430 | In Microsoft Access 97, you may receive one of the following error messages when you try to set or use some form and report properties in your database: Run-time error '13': Type mismatch -or- Run-time error '94': Invalid use of Null NOTE: The same... |
| 23431 | When you open a linked Microsoft Excel table from within Microsoft Access, the data in the Excel file may unexpectedly change. |
| 23432 | This article describes how to convert data values of Text data type to Proper Case format (Title case format). |
| 23433 | After you create a query with the Simple Query Wizard in Microsoft Access 97, you may receive the following error message if you try to open the query in Design view: Microsoft Access can't represent the join expression ([TableName].[FieldName] =... |
| 23434 | In the Microsoft applications listed above, when you change or add an extension to a filename in the Save As dialog box, an additional extension may be added to the filename. For example, if you use the Save As dialog box in Microsoft PowerPoint to... |
| 23435 | When you install Microsoft Office and choose to perform a Custom installation, a complete installation is not automatically performed. |
| 23436 | When you open a workbook in Microsoft Excel, cells within the workbook may display different values, depending on the version of Microsoft Excel you are currently using. For example, if you open Book1.xls in Microsoft Excel version 5.0 or 7.0, cell A1... |
| 23437 | When you run the Setup program to install a program to a drive other than the drive that contains Microsoft Windows, the Custom setup dialog box does not display the disk space required on the drive that contains Microsoft Windows, even though the... |
| 23438 | When you add a toolbar to the Microsoft Office Shortcut Bar, the toolbar folder may not appear in the Shortcut Bar folder when you view the folders in Windows Explorer or My Computer. NOTE: The Shortcut Bar folder is in the \Program Files\Microsoft... |
| 23439 | When you install Microsoft Office 97 or Microsoft Office for Windows 95 to a hard disk that has more than 1 gigabyte (GB) of available disk space, the Setup program lists the space available as 999,999K, regardless of the actual available free disk... |
| 23440 | When you run a Maintenance Mode Setup for Microsoft Office and elect to uninstall or remove any or all of the shared programs (such as Microsoft Graph, ClipArt Gallery, and Organization Chart), the files composing the shared programs will not actually... |
| 23441 | If you install Microsoft Office 97 for Windows on a computer that contains an earlier version of Microsoft Office, when you click a button on the Microsoft Office Manager (MOM) toolbar for an application installed by the earlier version of Office, the... |
| 23442 | The Open and Save As dialog boxes for Microsoft Office 7.0 programs and Microsoft Office 97 programs do not include a Network button. |
| 23443 | When you try to establish a DDE connection from a Word document to a Microsoft Access table or query by using the Insert Database command in Word, you may receive the following error message: Word could not re-establish a DDE connection to Microsoft... |
| 23444 | Advanced: Requires expert coding, interoperability, and multiuser skills. Microsoft Visual SourceSafe integration with Microsoft Access enables you to create a database from the SourceSafe server. This feature enables users to create additional copies... |
| 23445 | Advanced: Requires expert coding, interoperability, and multiuser skills. If you have a database under source code control with Microsoft Visual SourceSafe, and the database contains links to a Microsoft Outlook or Microsoft Exchange folder, when you... |
| 23446 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article describes some of the conversions between Visual Basic for Applications in Microsoft Access 7.0 and 97 (or Access Basic in Microsoft Access versions 1.x and 2.0)... |
| 23447 | Because Microsoft Jet allows for variable length fields, you may occasionally receive DAO error 3047: Record Too Large This occurs if the physical storage requirements of a record exceeds the amount of free space available in a data page (about 2000... |
| 23448 | When you install one of the products listed at the beginning of this article, you receive the following error message: Setup Error 168: Setup has encountered a problem updating your system registry. When you try to open one of the products listed at... |
| 23449 | This article describes the limitations of graphics import filters provided with Office 97. This information is also available in Help in each program. (On the Help menu, click Contents And Index. Click the Index tab, type graphics filters (without... |
| 23450 | When you click the Start A New Document button on the Microsoft Office Shortcut Bar Office toolbar or the New command on the File menu in any Office program, you may receive the following error message. Office 97 Program Cannot open the templates in... |
| 23451 | When you drag a Microsoft Office file into the Windows Briefcase, if you make changes to both the original copy of the file, and the copy of the file in the Briefcase, you can only replace either copy with the other; you cannot merge the changes made... |
| 23452 | In the programs listed at the beginning of this article, the The Microsoft Sound.wav file is played whenever you choose About from the Help menu. This wave file is played regardless of the settings in the Windows 95 Sounds control panel. |
| 23453 | When you try to check your spelling in one of the Microsoft Office 97 programs listed above, the following error messages or problems may occur. Microsoft Word 97 When the Check spelling as you type option is selected in the Options dialog box,... |
| 23454 | In the Microsoft Office 97 programs listed above, when you choose a different Office Assistant, the Office Assistant may be unchanged and you do not receive a warning or error message. |
| 23455 | The Microsoft Find Fast Indexer is a utility that is shipped with Microsoft Office 7.0. When you install Find Fast, Find Fast Indexer is installed in the Startup Folder. Find Fast is located in the Control Panel folder. It is used to index the local... |
| 23456 | When you run the Sounds.exe program to install additional sounds for Microsoft Office 97, the Provide feedback with sound option is not selected in your Microsoft Office 97 programs. When you then select the option, you may receive an error message... |
| 23457 | There are two English language versions of Microsoft Office 97: the U.S. English version and the International English version. The only difference between the two English language versions of Microsoft Office 97 Professional Edition for Windows is... |
| 23458 | This article describes how to use a Microsoft SQL Server distributed query to retrieve data from a secured Microsoft Access database. |
| 23459 | This article describes how to create a table in Microsoft Access 97 that will store Microsoft Outlook 97 messages. |
| 23460 | When you start Microsoft Word 97 or Microsoft Outlook 97, or when you click AutoCorrect on the Tools menu in Microsoft Excel 97 or Microsoft Access 97, the following error message may appear: This program has performed an illegal operation and will be... |
| 23461 | When you use Microsoft Query or Access 97 to return external data to a worksheet in Microsoft Excel or when you view returned data in Microsoft Query, you may receive the following error message: Microsoft Query Syntax error in FROM clause. Access 97... |
| 23462 | The Microsoft Small Business Pack for Microsoft Office does not work with any of the programs included with Microsoft Office 97. |
| 23463 | When you attempt to customize the Microsoft Office Shortcut Bar for Microsoft Office for Windows 95, version 7.0, or Microsoft Office 97 for Windows, you may receive the following message: Are you sure you want to delete the buttons listed below? The... |
| 23464 | The Microsoft Access Help topic for the OutputTo action states that this macro action outputs data to Microsoft Excel 97 format. However, when you open the exported Microsoft Excel spreadsheet in Microsoft Excel 97, you notice that the format is... |
| 23465 | When you upgrade to Office 97 or one of the Office 97 programs, you may find that the behavior of the Setup program differs from earlier versions of the Microsoft Office upgrade Setup program. This article discusses the upgrade process and how it... |
| 23466 | When you use the /runtime switch to start Microsoft Access 97 on a computer that does not have the Microsoft Office 97 Developer Edition Tools (ODE) or a custom application created by using the ODE installed, you may receive the following error... |
| 23467 | When you purchase the Microsoft Office 97 Developer Edition (ODE), your license agreement permits you to redistribute run-time versions of applications that you create to users who do not have Microsoft Access 97. When recipients of your application... |
| 23468 | If an application does the following in the Microsoft Access 7.0 or 97 version of the ODBC drivers more than seven times SQLSetConnectOption(hdbc, SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF); SQLTransact(henv, hdbc, SQL_COMMIT); The error generated is:... |
| 23469 | When you try to open a Microsoft Access 97 database that was converted from a Microsoft Pocket Access database, you may receive the following error message: Unrecognized format After you receive this error message, you cannot open the file in Access... |
| 23470 | In a 16-bit version of Microsoft Mail for Windows, if you double-click a document that is created in any of the Office programs listed at the beginning of this article, you may receive the following error message Microsoft Mail The application for the... |
| 23471 | DAO is a COM wrapper around the Jet Engine, which is used by Microsoft Access, Excel, Project, Visual Basic, and the Microsoft Foundation Classes (among others). It can be confusing which version of Jet you are using because so many applications may... |
| 23472 | When using the Data Access Objects (DAO), Remote Data Objects (RDO) or the ADO GetChunk method, on a long binary field of a Microsoft Access database, binary data may appear corrupt if the binary information previously stored was read from disk using... |
| 23473 | The Rplfaq97.exe file contains a Microsoft Word document titled Frequently Asked Questions About Microsoft Access Replication written by Mary Chipman, Michael Kaplan, Paul Litwin, and Steve Thompson. This document answers many Microsoft Access... |
| 23474 | When you use Automation to create an instance of Microsoft Access, the Microsoft Access application window is visible automatically. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 23475 | If you run the Setup program after you install Microsoft Access 97 with the Run From CD-ROM option, and you click Reinstall in the Installation Maintenance dialog box, Microsoft Access 97 no longer starts. In Microsoft Windows 95 or later, and Windows... |
| 23476 | This article shows you how to use Automation to create appointments in a Microsoft Access database and how to add them to the Microsoft Outlook calendar. For information about using Automation to add an appointment to Microsoft Schedule+ for Windows... |
| 23477 | When you install Microsoft Office or one of the individual Microsoft Office applications, the applications are added as separate items to the Programs menu on the Start menu in Windows. If you are used to accessing your applications from a Microsoft... |
| 23478 | With the Partial Replica Wizard, you can create a partial replica without having to do any programming. All you do is specify a filter expression for a table, and the wizard sets the data access objects (DAO) properties and uses the DAO methods for... |
| 23479 | When you try to open the Zoom box, you may receive the following message: Microsoft Access can't open the Zoom box. The Microsoft Access Utility add-in is missing or was modified. Rerun Microsoft Access or Microsoft Office Setup to reinstall Microsoft... |
| 23480 | The Qrysmp97.exe file contains a sample database with over 20 query examples. These examples demonstrate how to create many types of queries, including select queries, crosstab queries, totals queries, and SQL pass-through queries. Topics include... |
| 23481 | When you use the RunApp macro action to open Microsoft Money version 4.0 or 5.0, the program does not open properly. The behavior varies depending on the version of Microsoft Money that you are using. Microsoft Money 4.0 The Microsoft Money splash... |
| 23482 | The LinkChildFields and LinkMasterFields properties that are set by the Subform/Subreport Wizard are reset to the default when the subform control is clicked twice. This behavior also occurs if you manually change the LinkChildFields and... |
| 23483 | The FrmSmp97.exe file contains a sample database with over 30 form examples. These examples demonstrate how to create custom forms for data entry and non-data entry purposes. Topics include dynamically synchronizing two forms, opening multiple... |
| 23484 | The Rptsmp97.exe file contains a sample database with over 30 sample reports. These samples demonstrate how to create custom reports to organize and present information the way you want. Topics include dynamically sorting and filtering your data,... |
| 23485 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you create a graph on a form or report and later make some changes to the formatting or to the data itself within Microsoft Graph, these changes may not appear in the form... |
| 23486 | The About MDE files Help Topic contains the following paragraph: If your database contains Visual Basic code, saving your database as an MDE file compiles all modules, removes all editable source code, and compacts the destination database. Your... |
| 23487 | This article describes how to merge a Word document with a Microsoft Access database using a parameter query. |
| 23488 | When you create a database in Access 97 and include the What's This question mark (?) Help feature on your form, the What's This ? will appear on your form in Microsoft Access. You can click the What's This ?, and it will function. However, when... |
| 23489 | This article discusses code pages and how they affect Microsoft Access. |
| 23490 | When you try to save a Microsoft Access database as an MDE file, you may receive the following error message: Can't open any more tables. When you click OK, you receive the message: Out of memory. When you click OK again, you receive the message... |
| 23491 | In a Microsoft Access database, if you have a built-in Switchboard or a custom form that contains a class module as a Startup form, and you open the database through a link from a Web page, it may open multiple instances of Access. NOTE : This can... |
| 23492 | The Jetutils.exe file contains the Understanding Microsoft Jet Locking white paper, the LDBView utility, the DBLock utility, and the Msldbusr.dll. The white paper introduces you to the Microsoft Jet Database Engine versions 2.x and 3.x locking... |
| 23493 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article contains general information about Microsoft Access and scanners and scanning software. |
| 23494 | When you import a Microsoft Excel spreadsheet into Microsoft Access, currency is not displayed correctly in the Import Spreadsheet Wizard. The dollar signs ($), as well as the zeros to the right of the decimal place, are missing from the sample data.... |
| 23495 | When you start any of the programs that are listed at the beginning of this article, sound events within the programs do not work, even though the Microsoft Office 97 Sounds that are included in the ValuPack in Microsoft Office 97 are installed on the... |
| 23496 | When you create a module in Microsoft Access 97, you are not prompted to save the module if you have not entered data into the module. In Microsoft Access 95, you are prompted to save the module even though the module is empty. This behavior occurs in... |
| 23497 | The Microsoft Jet database engine version 3.5 has some functional improvements over earlier versions. This article discusses the enhancements made to Data Access Objects (DAO), the programming interface provided by the Microsoft Jet database engine... |
| 23498 | The following table lists the ActiveX controls that have been tested and verified for use with Microsoft Access 97. The ActiveX controls listed in this article are the only ActiveX controls supported for use with Microsoft Access 97. |
| 23499 | The Setup program for Microsoft Access 97 and Microsoft Office 97, Professional Edition does not install the SQL Script file, INSTCAT.SQL, to your hard disk. This file is used with the SQL Server ODBC driver to create stored procedures for use with... |
| 23500 | Advanced: Requires expert coding, interoperability, and multiuser skills. The Acc97cnv.exe file contains a Microsoft Word document called the Microsoft Access 97 Conversion White Paper. This document contains a discussion on potential issues arising... |
| 23501 | If Microsoft Access 97 or Microsoft Access 2000 is used to link SQL Server 6.5 or 7.0 tables, which have numeric and text field columns, #deleted is seen in alternate rows if the SQL Server database is created using non default code pages and Sort... |
| 23502 | In Microsoft Access 97, when you try to open a replica that you have compacted with Microsoft Access 2000, you receive the following error message: Reserved Error (-1038) There is no message for this error Then, the database is not opened. |
| 23503 | This article lists the references that you must set when you are working with databases that you create in Microsoft Access or when you access information in Microsoft Access databases from other applications. The following topics are covered in this... |
| 23504 | The Secfaq.exe file contains a Microsoft Word document titled Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions 2.0 through 2000 written by Mary Chipman, Andy Baron, Chris Bell, Michael Kaplan, Paul Litwin, and... |
| 23505 | When you export a query to Microsoft Word that contains field names which have been renamed in the query, the field names that are exported to Microsoft Word are different from the field names that are displayed in the query. |
| 23506 | When you import a delimited text file into an existing Microsoft Access table and that table has a default value set for a particular field, the following behavior will occur during the import. In Microsoft Access 7.0 and 97... |
| 23507 | When you link (attach) a table from an ODBC data source, such as Microsoft SQL Server or ORACLE, and that table contains more than one unique index, Microsoft Access may select the wrong index as the primary key. |
| 23508 | When you click Edit in Microsoft Access for a database template in the Microsoft Office Template Gallery, and that database template requires Access 2000 or later, you may receive the following error message: Microsoft Access cannot be started. If you... |
| 23509 | When you try to quit Microsoft Access version 97, you find that you are able to close the database, but you are unable to quit Microsoft Access. Instead, Microsoft Access is minimized without generating any errors. |
| 23510 | When you try to use the Microsoft Messaging Driver in your Visual Basic code to import, export, or link a Microsoft Outlook or Microsoft Exchange folder, you may receive the following error message: Run-time error '3170': Couldn't find installable... |
| 23511 | When you use the Microsoft UpDown Control, version 5.0, in Microsoft Access 97, you cannot use any of the Buddy properties of the control. Depending on what you are trying to do, you may receive one or more of the following error messages: Microsoft... |
| 23512 | After you run the Setup program for Microsoft Access 97 or Microsoft Office 97 Professional Edition, your earlier-version Microsoft Access run-time application does not start. |
| 23513 | When you run the Microsoft Office 97 Professional Edition or the Microsoft Access 97 Setup program from the Add/Remove Programs icon in Control Panel, you are prompted with one of the following messages. In Microsoft Office 97 Professional Edition... |
| 23514 | Each time that you open a chart object in Microsoft Graph, the window size of the chart shrinks in Microsoft Graph. When Microsoft Graph closes, it passes the new, smaller size back to the Microsoft Access chart object. Over time, this behavior cause... |
| 23515 | It is possible to link (attach) Clipper .dbf files to a Microsoft Access database. To do so, link the file as a dBASE IV file. Note, however, the index may or may not be updatable. Clipper provides an alternative indexing method (.ntx) to the dBASE... |
| 23516 | Each Knowledge Base (KB) Help file contains all the current KB articles for a particular version of Microsoft Access, the Microsoft Access Distribution Kit, the Microsoft Access Developer's Toolkit, and the Microsoft Office Developer Edition Tools. As... |
| 23517 | This article discusses the issues you may encounter when you install Microsoft Access 7.0 after you install Microsoft Access 97, and how to resolve them. Note that these issues also apply if Microsoft Access 7.0 is already installed on your computer,... |
| 23518 | This article shows you how to view and edit relationships in a Microsoft Access database. |
| 23519 | You can store date values in a Microsoft Jet 3.5 database starting with the year 100 and up to the year 9999. However, many database functions support only a limited range of dates. This article describes the operational date range for a Jet 3.5... |
| 23520 | When you click a hyperlink, you may receive the following error message: Microsoft Access can't follow the hyperlink to Hyperlink Name. Please verify the destination. |
| 23521 | The Grphsm97.exe file contains the Graph Sample Database with examples of graph types, how to manipulate graphs in Microsoft Graph 8.0, and how to modify graph using Visual Basic for Applications code. The following file is available for download from... |
| 23522 | The Microsoft Access 97 Security Manager enables the database-security administrator to make knowledgeable security decisions as the database and its workgroup evolve. By presenting all security settings in a single view, the administrator can set and... |
| 23523 | When the data source that is used in the PivotTable Wizard is a query that contains a parameter, you may receive the following error message when the wizard tries to create the table: An error occurred while trying to use the Microsoft Excel pivot... |
| 23524 | This article contains a listing of the hardware/system configuration and software requirements needed to install Microsoft Office 97 Developer Edition Tools. |
| 23525 | When you try to register the Microsoft Web Browser control by using the ActiveX Controls dialog box, you may receive the following error message: C:\Windows\System\Shdocvw.dll cannot be added. Either it is not an OLE control or it requires a separate... |
| 23526 | This article lists the network server and client software that is supported by Microsoft Office 97 for Windows. |
| 23527 | When you create an update query that calculates values for a Numeric field whose FieldSize property is set to Byte, you may not get the results that you expect when the calculated value in the field is larger than what the Byte size data type can... |
| 23528 | Microsoft Access ignores Paradox private directory restrictions and allows you to examine and modify data in tables in them. Paradox, however, ignores any changes made by Microsoft Access because it assumes the directories to be private. |
| 23529 | When you use the Report Wizard in Microsoft Access 7.0 or 97 to create a report that is based on a linked spreadsheet that is more than 10 megabytes (MB) in size, the wizard takes a long time to create the report. In some cases Microsoft Access may... |
| 23530 | If you import a Microsoft Excel 97 for Windows worksheet that contains more than 16,384 rows of data into a Microsoft Access database, the resulting table may be truncated to 16,384 records. |
| 23531 | If you want to import one of your Microsoft Outlook 97 Personal Address Books into a Microsoft Access 97 table or have a Microsoft Access table linked to your Outlook Inbox, you can use Microsoft Access to query your incoming e-mail for specific... |
| 23532 | Microsoft Access documentation lists all SQL keywords that are supported in Microsoft Access but does not list SQL keywords that are not supported. This is so because there are over 200 ANSI SQL keywords that Microsoft Access does not support. Rather... |
| 23533 | Microsoft Access 97 does not support the UserForm object or the UserForms collection. Although some methods, properties, events, and statements that apply only to the UserForm object appear in Microsoft Access Help, you cannot use them in Microsoft... |
| 23534 | With the Snapshot Viewer, you can view snapshots that are created with any version of Microsoft Access. The download consists of a stand-alone executable program (Snapview.exe), a Snapshot View control (Snapview.ocx), and related files. Note This... |
| 23535 | The Upsizing Microsoft Access Applications to Microsoft SQL Server white paper is intended to help you complete the migration of your Microsoft Access application to Microsoft SQL Server smoothly and to help you optimize your application strategy... |
| 23536 | Some Microsoft Access 97 CD-ROM liners state the following: The Microsoft Access 97 CD-ROM includes the Microsoft Access 97 ValuPack, which contains additional value-added components, such as: Microsoft Internet Explorer 3.0, sounds, additional... |
| 23537 | When you run Setup of Microsoft Access 97, you are prompted with the following Microsoft Access 97 Setup message: Setup will install Microsoft Access in the following destination folder. To install to this folder, click OK. To install to a different... |
| 23538 | This sample application is designed to be a learning tool for developers who are creating solutions with Microsoft Access 97 and deploying those solutions with Microsoft Office 97 Developer Edition. It contains a Microsoft Access database with several... |
| 23539 | Earlier versions of Microsoft Access contained a Menu Wizard to assist in creating custom menus. This wizard helps you create custom menus in Microsoft Access 97. The following file is available for download from the Microsoft Download Center:... |
| 23540 | In Microsoft Excel, when you create a link to a Microsoft Access query, the query is not updated dynamically. That is, when you change the query in Microsoft Access, the linked information is not automatically updated in Microsoft Excel, even if both... |
| 23541 | Microsoft Access does not close some OLE servers if you close a table, a form, or a report while editing an OLE object embedded in it. |
| 23542 | You receive an Out of memory error when you try to start Microsoft Access on a computer that has 1 gigabyte (GB) or more of random access memory (RAM). |
| 23543 | The Microsoft Year 2000 Product Analyzer lists Microsoft Jet as not being compliant, even though you have previously applied Microsoft Jet Service Pack 2 (SP2) and/or Microsoft Jet Service Pack 3 (SP3), which are both year 2000 compliant. |
| 23544 | When you open a spreadsheet in Microsoft Excel that has an established link to a Microsoft Access table through the Paste Link command, you may receive the following message: The Workbook you opened contains automatic links to information in another... |
| 23545 | This article describes how to use Automation to add or remove a title of a graph and how to hide or show a legend for a graph. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 23546 | If you try to invoke the PivotTable Wizard when you have Microsoft Excel version 7.0 or 7.0a installed, the PivotTable Wizard will return the following error message when it starts Microsoft Excel: An error occurred while trying to use Microsoft Excel... |
| 23547 | When you run the Microsoft Access 7.0 Setup program to uninstall Microsoft Access 7.0 from a computer that also has Microsoft Access 97 installed, the Microsoft Access shortcut on the Programs list of the Start menu is removed. |
| 23548 | When you try to create a Microsoft Access form in Microsoft Excel by using the AccessLinks add-in program, and you are using data from a Microsoft Query data source, you may receive the following error message: Cannot start Microsoft Access form or... |
| 23549 | When you create a Microsoft Access form in Microsoft Excel that is based on data in a spreadsheet, and you then add additional information to that spreadsheet, the data that you added is not updated in the Microsoft Access form, even though it is... |
| 23550 | Microsoft has added database passwords and security account passwords to Microsoft Access so that you can prevent unauthorized access to important information. If you are unable to access database information because you do not know the correct... |
| 23552 | This article describes how to contact Microsoft for help with the following issues: Replace lost, broken, damaged or defective Microsoft software disks. Purchase product upgrades. Replace broken or defective Microsoft hardware products. Check the... |
| 23553 | If you use code to create a recordset that is based on a form, you can use multiple Dynaset.Close statements without generating an error message. |
| 23555 | Advanced: Requires expert coding, interoperability, and multiuser skills. You can affect a user's ability to edit data in a query's dynaset by changing the settings for the following two permissions: Run With Owner's Permissions, for a query Modify... |
| 23556 | After changing a query definition, you try to save the query but cannot, even though you have full permissions on the query and are a member of the Admins group. |
| 23557 | The Microsoft Access 97 Upsizing Tools consists of the Upsizing Wizard and SQL Server Browser, which enable you to use Microsoft Access to develop and maintain Microsoft SQL Server client/server applications. The Upsizing Wizard takes a Microsoft... |
| 23558 | When you link SQL Server 7.0 tables that have one or more spaces in the table names, you may receive the following error message: ODBC call failed. When you check the ODBC log, you see that the call to SQLPrepare failed. This problem can also occur... |
| 23559 | In an Access database, when you open a table in Datasheet view, and the table is a linked Oracle table to which you have linked with the Oracle ODBC driver from Oracle Corporation, you see #Deleted in all fields. |
| 23560 | When you run a query that uses an ORDER BY statement on a linked table, you may receive the following error message: The ORDER BY clause is not valid because column, col name, is not part of the result table. |
| 23561 | While you are editing data in a field whose data type is Single and whose Format property is set to Currency, the data is displayed as a number of data type Double. As a result, you may see unexpected values in the digits to the right of the decimal... |
| 23562 | This article shows you how to create a label that will print at the top of each report page when a data group spans multiple pages. The events used in this technique capture the value of the group in the page footer. If this value is the same as the... |
| 23563 | When you use code (for example, on a command button) to close a form that contains a control bound to a field that has its Required property set to Yes, and you enter no data for that control, you do not receive an error message. If you close the same... |
| 23564 | This article describes how to create a sample user-defined function that uses the FileSearch object contained in the Application object to locate a file on a particular drive. This article assumes that you are familiar with Visual Basic for... |
| 23565 | In certain situations, the BuildCriteria method does not work as expected or returns values that cannot be used by other methods or SQL statements. This article addresses the following topics: Searching for a string containing a quotation mark ()... |
| 23566 | When you have a list of names for which you would like to generate mailing labels, there are frequently two people listed at the same address. This article demonstrates a technique to create a query from which to print a single mailing label for two... |
| 23567 | The information in this article applies to a database that you created by using the Database Wizard and the Time And Billing.mdz template. Each time that you open the Time Cards form and click the new record navigation button on the form, rather then... |
| 23568 | You are unable to type data into a text box or combo box on a tab control that contains a TreeView control on another page. However, you are able to set the value of the text box or combo box with a macro or with Visual Basic for Applications code.... |
| 23569 | When you run a macro that carries out an OpenReport action, and then carries out a SetValue action that sets the value for controls on the report being opened, the controls on the first page of the report are not updated by the SetValue action. |
| 23570 | If you create a custom shortcut menu, you will be unable to rename or delete the menu until you change its type to Toolbar. |
| 23571 | If you include the number sign (#) character in a hyperlink file name, you may receive the following error message: Unable to open filename. Cannot open the specified file. -or- The Windows Explorer will open the folder where the file is located. |
| 23572 | When you use the Lookup Wizard in Design view of a table to look up a Currency, Date/Time, or Hyperlink field in another table, you may receive the following error messages You entered an expression that has an invalid reference to the property |. and... |
| 23573 | When you retrieve, insert, or update records in a linked ODBC table, each field in a record contains the #Deleted error message. When you retrieve, insert, or update records using code, you receive the error message Record is deleted. |
| 23574 | Novice: Requires knowledge of the user interface on single-user computers. The insertion point disappears when you use the TAB key to move between the controls on a subform that is wider than the main-form window or the screen. |
| 23575 | Advanced: Requires expert coding, interoperability, and multiuser skills. When you run an action query SQL statement, either in a RunSQL macro statement or as the RowSource property for a control in a secured database, you may receive the following... |
| 23576 | When you create a chart in Microsoft Graph, data is automatically summarized for each distinct value on the x axis, which is also known as the independent axis. For example, if you plot a field containing dates along the x axis, and if more than one... |
| 23577 | When a Microsoft Word Mail Merge document displays AutoLookup fields from a table, the fields do not return the AutoLookup values as expected. |
| 23578 | When you set the RowSourceType property of a bound or unbound object frame, you may receive one of the following error messages, depending on the type of OLE object that is contained in the frame: For Microsoft Excel Charts: The operation on the OLE... |
| 23579 | If a report contains a form as a subreport, and the form is in Datasheet view, if you try to output the report to another file format such as text (*.txt), Microsoft Excel (*.xls), or rich text format (*.rtf) you may see the following unexpected... |
| 23580 | This article contains a listing of all the Open Database Connectivity (ODBC) drivers installed by Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97, the Microsoft Data Access Components versions 1.5c and 2.1, the Microsoft ODBC 3.0 drivers for Windows... |
| 23581 | Novice: Requires knowledge of the user interface on single-user computers. Microsoft Access does not detect a type mismatch error involving joins created in a query until you run the query. |
| 23582 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article describes how to find the version of catalog stored procedures in Microsoft SQL Server. |
| 23583 | This article shows you how to order data in a graph by changing the graph's RowSource property to a query name rather than by using the SQL statement that Microsoft Access generates. |
| 23584 | If the Expression argument of a SetValue macro action evaluates to a text expression that begins with a letter, you may receive the following error message when a SetValue macro action tries to set the value of a control. In Microsoft Access 7.0 and... |
| 23585 | When you browse to an Active Server Page (ASP) created from Microsoft Access 97, you may receive the following error message: Too few parameters. Expected number. |
| 23586 | If you try to create an MDE database file from an existing database, and the target disk where you save the MDE file does not contain enough free disk space, Microsoft Access fails to create the MDE file and no error occurs. |
| 23587 | The Microsoft Access 97 Help file contains the following incorrect statement about what happens to Visual Basic for Applications code when you rename a database: When you rename a database, compiled code in the database will be decompiled. To... |
| 23588 | Microsoft Access 7.0 and 97 have several new properties that give developers control over forms used for data entry. One of these properties is the AllowAdditions property. Developers can use this property to determine whether users can or cannot add... |
| 23589 | When you try to export data to Microsoft FoxPro, Paradox, dBASE, Lotus 1-2-3, Text, or Microsoft Excel files, you may receive the following error message: Couldn't find installable ISAM You may also receive this error message when you try to import... |
| 23590 | When you enter data into a new record on a form that is based on a query or an SQL statement, you receive one of the following error messages. In Microsoft Access version 2.0 and 7.0 Field can't be updated. In Microsoft Access 97 Field can't be... |
| 23591 | Although Microsoft Access can use a custom paper size, you must first create the custom paper size by clicking the Start button, pointing to Settings, and then clicking Printers. In Microsoft Windows 95 and later, you would then click the Paper tab in... |
| 23592 | In a linked table from Microsoft SQL Server 6.5, Microsoft SQL Server 7.0, or Microsoft Data Engine (MSDE) you see #Deleted in alternate rows. One row has the typical data, the next contains #Deleted entries, the next typical data, and so on. |
| 23593 | Advanced: Requires expert coding, interoperability, and multiuser skills. Two users on the same network can open the same System.mdw file in Microsoft Access 97 and 7.0 (SYSTEM.MDA file in 1.x and 2.0) exclusively. Microsoft Access ignores the... |
| 23594 | When you edit an attached SQL Server table that does not have a unique index defined, Microsoft Access beeps and displays one of the following messages in the status bar. In Microsoft Access 1.0 and 1.1 ------------------------------- Form is read... |
| 23595 | Microsoft Access 97 and Microsoft Jet database engine version 3.5 use the DISTINCTROW predicate differently than did earlier versions. This article discusses the differences in queries that use DISTINCTROW. |
| 23596 | In Microsoft Access 7.0 and 97, the sort order that you apply to a field in a form is saved when you save the form or datasheet, and is reapplied automatically when you reopen the form or base a new form or report on that form. This behavior is... |
| 23597 | When you create a parameter query based on a Microsoft Access database in Microsoft Query, you may receive the following error message: Too few parameters. Expected n. If you click Help in the error message box, the topic states, This error was... |
| 23598 | When you export a table to Microsoft Excel using the OutputTo macro action or a Visual Basic method, Number fields that have an input mask appear as Text fields in Microsoft Excel. |
| 23599 | You can use data from a Microsoft Visual FoxPro database in Microsoft Access 97 if you have added a Visual FoxPro ODBC data source as a User Data Source in the ODBC Data Source Administrator. This article describes how to do so. The latest Microsoft... |
| 23600 | This article provides sample DLL code in Microsoft Visual C++ 4.x that illustrates how to fill a 32-bit VBA array of a user-defined type (UDT) containing fixed-length strings with data. It also provides VBA code that defines the equivalent structure... |
| 23601 | When you run the Repair Database command, you may receive the following error message: Database Name isn't an index in this table NOTE: This same behavior may occur in Microsoft Access 97 with databases that are converted from Microsoft Access 7.0.... |
| 23602 | This article shows you how to create a lookup table that contains the necessary information to register an Open Database Connectivity (ODBC) Data Source Name (DSN) and to create new, or refresh, existing ODBC tables in your application. This article... |
| 23603 | When you perform calculations in a report, the calculations may be incorrect when you print from the Print Preview view or when you preview the report. |
| 23604 | This article shows you two methods of using the NotInList event to add a new record to a combo box on a form. This article assumes that you are familiar with Visual Basic for Applications and that you are also familiar with creating Microsoft Access... |
| 23605 | Building concatenated SQL statements based on user-typed text values can result in invalid SQL statements. This article provides a solution to the problem of building concatenated SQL. NOTE : Microsoft Visual Basic 6.0 and later products and Microsoft... |
| 23606 | This article describes how to use a form to specify the criteria for a query in Microsoft Access. This technique is called query by form (QBF). |
| 23607 | When trying to determine whether a child window of an application is open, you need to know whether it is a child of the main application window, a grandchild, or an independent window. This article provides a method of creating a hierarchical listing... |
| 23608 | This article contains a list of articles in the Microsoft Knowledge Base that describe year 2000 related problems that are corrected in Microsoft Office 97 Service Release 2 (SR-2). |
| 23609 | A UserControl (OCX) created in Visual Basic does not print correctly from Microsoft Access. The control is either partially cut off or is blank when previewed or printed. |
| 23610 | This article provides an overview of how you can secure a database so that it is not changed or copied by other Microsoft Access users. This article assumes that you have a thorough understanding of the pieces that make up the Microsoft Access... |
| 23611 | WARNING: Although this article discusses Microsoft Access security features, any information you send over the Internet with the techniques described in this article is sent unencrypted. To send encrypted information over the Internet, you must use a... |
| 23612 | After you edit the value of the DisabledExtensions key in the system registry, you see the following error message when you use the Text Import Wizard to import data: MSACCESS caused and invalid page fault in module MSACCESS.EXE |
| 23613 | When you attempt to open a table that is linked to a Microsoft Visual FoxPro .dbf file, Access 97 may stop responding (hang) if the following conditions are true: The same table may open without an error and without hanging on a computer that runs... |
| 23614 | Visual Basic code that references the Application FileSearch object may cause the following error on a computer that is running Microsoft Windows 2000 if the code includes a wildcard character in the FileName property: Run-time error '5': Invalid... |
| 23615 | Service Pack 2 for Microsoft Windows NT 4.0, includes new files that correct some problems that you may encounter while using the programs included in Microsoft Office 97. This article contains a list of the corrected problems. |
| 23616 | If you remove Microsoft Internet Explorer 4.0 from a computer on which Microsoft Office 97 is installed, the following problems may occur when you run the programs included in Microsoft Office 97: When you attempt to insert a hyperlink in Microsoft... |
| 23618 | In a self-written ODBC program that executes a prepared statement at a SQL Server (set up with an OEM code page, such as code page 437 or 850) the data in the buffer passed in the rgbValue parameter of SQLBindParameter is converted from ANSI to OEM... |
| 23619 | When run on an attached ODBC table, the CREATE INDEX statement fails silently when more than 10 fields are specified for the index. |
| 23620 | When you use the Open, Save, or Save As dialog box in any of the Office 97 programs, you may receive one of the following error messages: Case 1 When you select My Computer in the Look In box in the Open dialog box, you receive the following error... |
| 23621 | After you install the latest service pack for Microsoft Jet 3.5, when you import text files, you may receive the following error message: Can't update. Database or object is read-only. This is followed by: An error occurred trying to import file... |
| 23622 | When you open a Microsoft Access database (an .mdb file), you may see a password prompt, even though you never set a password on the database. Nothing that you enter will allow you past the password prompt. |
| 23623 | When you run the SendObject macro action or the SendObject Visual Basic for Applications method with the EditMessage argument set to No, you may receive the following message: A program is trying to automatically send e-mail on your behalf. Do you... |
| 23625 | After you apply the Outlook E-mail Security Update, some Microsoft Access 97 functionality may not work as expected. |
| 23626 | If you have Microsoft Visual Studio 6.0 Service Pack 4 (SP4) installed, when you use Visual Data Tools with an Access 97 or 2000 database, you may receive the following warning: This version of the database design tools is not compatible with SQL... |
| 23627 | When you export Microsoft Access 97 objects to ASP format, you provide the name of a System DSN on your Web server, which Microsoft Access uses in the ConnectionString property of the ASP script that it generates. You can modify the ASP script so that... |
| 23628 | When you try to send a snapshot to a fax service by using the Send command on the File menu in the Microsoft Access Database window and selecting Snapshot Format in the Send dialog box, you may not be able to send it successfully. |
| 23629 | When you use Microsoft Access 97 on a Windows 2000-based computer and you are logged on to the computer with a Restricted user account, you cannot use some of the Access 97 wizards (for example, you cannot use the Input Mask Wizard) on the table... |
| 23630 | When you run the Setup program for one of the programs listed at the beginning of this article, and you click the Remove All button (in maintenance mode) the shortcut for the program that you remove may still be available in Windows. |
| 23631 | When you run an update query from Microsoft Access to copy the contents of one SQL Server Memo field into another SQL Server Memo field, the data in the new field will be truncated at 255 characters. |
| 23632 | The CABFILE Viewer is a new utility for Windows 95 that is used to browse the contents of a cabinet file. This utility allows you to see what files are compressed in the cabinet, without extracting each file. |
| 23633 | In the Advanced Find dialog box, the default file location folder (or the current folder), may not be displayed in the Look In drop-down list. |
| 23634 | After you run Setup to remove the sample databases for Microsoft Access 97, your most recently used file list is missing from the File menu. For information about how to deliberately remove the most recently used list, please see the following article... |
| 23635 | After you use maintenance mode Setup to remove the Office Assistant, it still appears when you start Microsoft Office. |
| 23636 | When you use a network administrative setup (setup /a) to install one of the Microsoft applications listed above on a network drive, you may receive one of the following error messages: Cannot change the properties of SETUP.INI -or- Cannot change the... |
| 23637 | Microsoft provides a wizard interface for users of Microsoft Data Access Components (MDAC) 2.0 and later to create OLE DB connection strings. This article describes how to set up and use this Universal Data Link (UDL) Wizard. |
| 23638 | In any of the Microsoft Office 97 programs listed at the beginning of this article, you receive the following error message: Clip Gallery cannot launch the software component to handle path to a WAV file. |
| 23639 | When you open a Switchboard form in a Microsoft Access 97 database that was converted from Microsoft Access 2000, you receive the following error message: Compile error: Method or data member not found. Microsoft Access then highlights the following... |
| 23640 | Accessibility aids may not work with the programs listed at the beginning of this article. The More Information section of this article contains information about specific accessibility aids and how to obtain updated versions of these programs. |
| 23642 | In the Microsoft programs listed above, the AutoCorrect feature does not work when you enter text in any dialog box, including the Properties dialog box. |
| 23643 | When you add an entry to the AutoCorrect list in your Microsoft program, the entry may no longer appear in the list when you close and then restart the program. |
| 23644 | When you use the User-Level Security Wizard to secure a database that references libraries other than those included by default, code in the resulting database may not compile correctly. You receive the following error messages: Compile Error:... |
| 23645 | Environmental factors may leave your database file damaged. The symptoms of a corrupted database can range from #Deleted appearing in certain records, to the inability to open one of the objects in the database, to the complete inability to open the... |
| 23646 | When you open a Microsoft Office 97 document on a computer that is running Microsoft Windows NT Workstation or Windows NT Server, you receive the following error message: Access Denied. |
| 23647 | When you delete a file using the Open or Save As dialog boxes, the file is sent to the Recycle Bin without displaying the Confirm File Delete dialog box. |
| 23648 | When you ask the Office Assistant a question about Microsoft Visual Basic for Applications, you receive one of the following responses depending on your type of computer. Office 97 for Windows The Office Assistant cannot currently answer your... |
| 23649 | This article contains information about how you can enable support for the Euro currency symbol in the programs listed at the beginning of this article. |
| 23650 | When you perform a Workstation installation of Microsoft Office 97 Professional Edition or Microsoft Access 97 from a network server, you may receive one of the following error messages when you run the Database Documenter or the Table Analyzer... |
| 23651 | The Microsoft Office Assistant is a new Help feature in Microsoft Office 97. Its functionality is similar to the Answer Wizard Help feature in Microsoft Office 95. You can make the Microsoft Office Assistant less interactive. Certain features, such as... |
| 23652 | When you run the Setup program for your program in maintenance mode and you select a component to add, the Space Required On drive value displayed in the Setup dialog box (where drive is the drive to which the component will be installed) is... |
| 23653 | On a computer on which you have installed both Microsoft Access 97 and Microsoft Access 2000, you find that one or both versions of Access are using the wrong workgroup information file (default name, System.mdw). This change can cause one of the... |
| 23655 | When you reference the Application object of an Automation server, such as Microsoft Access 97, Microsoft Excel 97, or Microsoft Word 97, you may receive the following Dr. Watson error message on a computer that is running Microsoft Windows NT 4.0,... |
| 23656 | When you convert a Microsoft Access version 1.x or 2.0 database to a Microsoft Access 7.0 or Microsoft Access 97 database, the conversion process may display a warning message or stop altogether because of an incompatibility with new features and... |
| 23657 | This article discusses how to modify the Setup Table File (STF) of Microsoft Office 97 Service Release 1 so that Setup installs Microsoft Access 97 wizard files on users' hard drives during Run From Network Server installations. The information in... |
| 23658 | This article discusses how to modify the Setup Table File (STF) of Microsoft Office 97 Service Release 1 so that Setup installs Microsoft Access 97 wizard files on users' hard drives during Run From Network Server installations. The information in... |
| 23659 | The Microsoft Office 97 Service Release 1 (SR-1) Patch may fail to upgrade the Microsoft Jet database engine components. |
| 23660 | This article discusses some of the Microsoft Windows NT and Microsoft Windows 2000 permissions issues that you may encounter when you create and use Internet Database Connector (IDC) files or Active Server Page (ASP) files from a Microsoft Access... |
| 23661 | When you view a Microsoft Office 97 document in Microsoft Internet Explorer version 3.0, the Show Office Toolbars button may not be visible on the toolbar, and you are unable to use toolbars belonging to the Microsoft Office 97 program. |
| 23662 | Microsoft Office 97 for Windows requires that Microsoft Internet Explorer 3.01 or later be installed for proper Internet and Hypertext Markup Language (HTML) functionality. |
| 23663 | Unlike earlier versions of Microsoft Graph, Microsoft Graph 97 for Windows does not automatically register itself when you run it. Therefore, if the Graph 97 information in the Microsoft Windows 95 or Windows NT registry is missing or incorrect, you... |
| 23664 | When you run the Setup program for one of the programs listed at the beginning of this article and choose the Complete/Custom installation option, if the Space Available On C: value is less than the Space Required On C: value, one of the following... |
| 23665 | When you run the Setup program for one of the programs listed at the beginning of this article, you receive the following error message: Bad Setup Version field followed by: Processing Top Level information failed -and- Setup was not completed... |
| 23666 | Both Microsoft Office 97 Professional Edition and the stand-alone version of Microsoft Access 97 have a Calendar ActiveX control that you can use in Microsoft Office applications. However, you are not licensed to redistribute the Calendar control... |
| 23667 | If you have a Web server on which you want to create Active Server Pages (ASP) files, the Web server must have installed support for Active Server Pages. To view Active Server Pages (ASP) files created in Microsoft Access 97 on Microsoft Windows 95 or... |
| 23669 | This article shows you how to fill a list box or a combo box with values by setting the RowSourceType property of the list box or combo box to the name of a custom procedure. This article assumes that you are familiar with Visual Basic for |
| 23670 | Microsoft Access internally converts values with implicit data type definitions before assigning those values to variables. This may result in unexpected rounding of numbers, or in the following error message: Invalid Number Invalid |
| 23671 | If you enter a credit card expiration date (month/year) in a Date/Time field on a form, Microsoft Access assumes that the card expires on the first day of the month. This article shows you how to create a function to correctly calculate the |
| 23672 | Microsoft Access enables you to create temporary instances of reports and forms in Visual Basic code by using the New keyword. This functionality enables you to create an instance of an object on demand. A new instance of a form or report |
| 23673 | SUMMARY The Data Access Object (DAO) documentation that comes with Microsoft Access and Visual Basic Online help shows how to open a Paradox table. However, it does not show how to open a table that is password protected. |
| 23674 | SUMMARY Microsoft Access has the ability to import or export tables to another database, or save an existing definition as a new table. However, this is not readily achievable using DAO code. This article gives a function to copy a table definition |
| 23675 | Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. on why Microsoft does not recommend automation under this context 257757 INFO: Considerations for Server-Side Automation of Office... |
| 23676 | This article lists some techniques that you can use to determine indirect causes of error messages when using linked (attached) SQL tables: |
| 23677 | This article shows you how to use Automation to create and send a Microsoft Outlook message in Microsoft Access 97. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the... |
| 23678 | When you add a database to Microsoft Visual SourceSafe, you may receive the following error: File Name is an invalid DOS 8.3 name This article assumes that you are familiar with using the client and server side capabilities of Visual SourceSafe. For... |
| 23679 | When you sort on a field in a linked DB2 table in Datasheet view, you may receive the following error message: |
| 23680 | If you create a crosstab query that uses an implicit parameter [XXX] in a WHERE clause (criteria), you may receive the following error message: |
| 23681 | In Microsoft Access 7.0 and earlier, a Microsoft Graph object appears dimmed or grayed in Form view. |
| 23682 | When you perform an outer join to a linked ORACLE table that has a pseudo index, you may receive the following error message: |
| 23683 | If you try to import, export, or link (attach) a file by using an indexed sequential access method (ISAM) driver, you may receive an error message if Microsoft Access cannot find the ISAM driver. |
| 23684 | When you create a chart in Microsoft Access, Microsoft Graph automatically adjusts the scale of the value axis for each record. This means the displayed range of values may vary from record to record. This article demonstrates how you can manually... |
| 23685 | This article describes how you can reference the parameters of a report's RecordSource query. You can use this method to display the parameters in a text box in the report. |
| 23686 | This article describes how to group rows of data using a value range rather than having a single row per value. |
| 23687 | When you use the Microsoft Map feature in Microsoft Access 97 or the Data Map feature in Microsoft Access 7.0 to create a map, you may receive one of the following error messages: In Microsoft Access 97 using Microsoft Excel 97: The following data... |
| 23688 | When you are adding a record through a form that is based on an AutoLookup query, you may receive one of the following error messages when you try to enter anything in the foreign key field: |
| 23689 | When you import a fixed-width file with two Date fields with different formats, individually you can import them, but if you try to import them together you may receive the following error message: |
| 23690 | When you try to open a shared dBASE (.dbf) database, you may receive one of the following error messages: |
| 23691 | If you try to import a Microsoft Excel file that was created with Microsoft Access version 2.0 into Microsoft Access 7.0 or 97, you may receive one of the following error messages: |
| 23692 | This article demonstrates how Microsoft Access handles Currency, Date/Time, and Number formats when you change the regional settings values in Control Panel. |
| 23693 | Code written in Access Basic that uses |
| 23694 | When you convert a Microsoft Access version 2.0 database to a Microsoft Access 7.0 or Microsoft Access 97 database, you may receive one of the following error messages if your database contains an ActiveX control. In Microsoft Access 97, when you open... |
| 23695 | If you use the Error() or Error$() functions to get the textual description of an error message, you may receive the following error message: |
| 23696 | When you try to convert a Microsoft Access 1.x or 2.0 database to Microsoft Access 7.0 or 97, the conversion process stops, and you may receive the following error message: Name conflicts with existing module, project, or object library. |
| 23697 | If you reference a subreport control from a main report when the subreport does not return any matching records, you may receive a "#ERROR" message for the referenced subreport control. |
| 23698 | When you start Microsoft Access on a network workstation, you may receive the following error messages: |
| 23699 | When you compile a database in Microsoft Access 7.0 or 97, you may receive the following error message: A Module is not a valid type. |
| 23700 | When you create expressions in Microsoft Access using Visual Basic for Applications or Access Basic, you can use variables to refer to objects, such as controls, forms, reports, and recordsets. However, when you reference object variables, |
| 23701 | When you edit a record in a form, the editing changes are not processed when the form is closed with a macro's Close action. However, you are not prompted with any error messages as to why the changes are not saved. |
| 23702 | When you reference a form's OLE control in an expression or a procedure, you may receive the following error message. In Microsoft Access 97 Run-time error '2771': The bound or unbound object frame you tried to edit doesn't contain an OLE object. Use... |
| 23703 | When you set the MultiSelect property of a list box to Simple or Extended, the selection behavior may work differently than you expect. For example, if the MultiSelect property is set to Simple, the SHIFT and CTRL keys have no effect when you click... |
| 23704 | When you run an ApplyFilter, OpenForm, or OpenReport action using a macro or custom function with a Where Condition argument, you may receive an error message such as the following: |
| 23705 | When you make editing changes to a main form record and one or more subform records, and then click Undo Saved Record on the Edit menu, Microsoft Access does not undo changes made to the main form and the subform together. |
| 23706 | You cannot access the DefaultEditing form property in the Microsoft Access 7.0 and 97 user interface. Instead, you can use the new AllowEdits, AllowDeletions, AllowAdditions, and DataEntry properties. DefaultEditing is still available programmatically... |
| 23707 | Microsoft Access supports the use of subqueries. A subquery is a select query inside another select or action query that acts as a criteria for a field. A subquery can refer to a table that is part of the current query, or to a table that i |
| 23708 | When you try to delete the user Admin, you may receive the following error message: |
| 23709 | This article lists sample expressions that you can use to extract a portion of a text string. These expressions are commonly used in the Update To line of an update query to place a portion of a larger field into a new field. You can adapt |
| 23710 | To refer to a control's current value during a Change event, use the control's Text property. |
| 23711 | The data from a union query appears to be sorted automatically according to values in the first column selected even when the query does not have an explicit ORDER BY clause. This happens because, by default, union queries do not return dup |
| 23712 | If you create a query based on two or more tables that have matching field names with matching data types, and one of the tables has a primary key defined, Microsoft Access will automatically join the tables on the matching field names. |
| 23713 | Microsoft Access includes a Data Definition Language (DDL) that you can use to create and delete (drop) tables and relationships. These same operations can also be performed with Visual Basic for Applications (or Access Basic in version 2.0 |
| 23714 | You can delete objects programmatically by using either the Delete method or the DeleteObject method. You can also use the DeleteObject action in macros. |
| 23715 | This article describes how to refer to controls on subforms or subreports, and describes some common problems you may encounter when you refer to controls on subforms or subreports. |
| 23716 | When you try to save a table that has a field name, control name, or user- defined function in a validation rule or default value, you may receive the following error messages: |
| 23717 | You can use the SetFocus method for forms and form controls in Microsoft Access to select a field or control on an open form, form datasheet, table datasheet, or query dynaset, or to select other forms. |
| 23718 | All versions of Microsoft Access (except Microsoft Access 1.x) enforce field and record validation rules defined at the table level, regardless of the data input or editing method. |
| 23719 | Event procedure code does not run when you expect it to. |
| 23720 | If your server supports the creation of SQL views, you can achieve a compromise between pass-through and Microsoft Access queries by creating a view on the server and then linking (attaching) it. The Microsoft Jet database engine treats a l |
| 23721 | Extended characters (ANSI characters greater than 128) that you enter in a linked (attached) FoxPro table are converted to other characters when you commit the record. |
| 23722 | This article lists several things that you can do to improve the speed and performance of your subforms. |
| 23723 | Microsoft Access supports in-place activation of OLE objects in a form's Form view. In a form or report's Design view, or in a table, query, or form's Datasheet view, activation of an OLE object will cause the object's original application |
| 23724 | When you try to use a SQL-specific pass-through query as the RecordSource property setting for a subform or a subreport, you may receive the following error message: |
| 23725 | This article discusses how you can optimize query performance in Microsoft Access 2.0, 7.0, and 97. The topics include the Microsoft Jet database engine's query Optimizer, query timing, analyzing performance, and design tips for improving q |
| 23726 | This article describes a technique that you can use to create a cyclic tab order on a form, so that pressing TAB in the last control on a form moves you back to the first control on the form (instead of moving you to the first control on th |
| 23727 | When you select a row from a multicolumn list box or combo box, controls that reference the Column property of the list box or combo box retrieve data from a different row in the list box or combo box. |
| 23728 | This article describes some of the anomalies that can occur when you are using Microsoft Access with networks that have not been tested with Microsoft Access. These networks include DEC Pathworks, Sun PC-NFS, IBM PC-LAN Server, and others. |
| 23729 | Join lines between tables are used to clarify relationships among data in the joined tables and to sort and order the data. However, there are some situations where it is not necessary to have join lines between tables. This article demonst |
| 23730 | Microsoft Access cannot link (attach) or import Paradox version 1.0 for Windows tables directly. |
| 23731 | In order to back up a multiuser database correctly, you must make sure that you have exclusive access to the database. If you back up a database while others are using it, you risk damaging the backup database. |
| 23732 | This article describes a method of dynamically creating a filter by applying expressions on a form using a macro. The same technique can also be adapted to a Query by Form (QBF) method. |
| 23733 | Exporting a Microsoft Access table to a Microsoft Word for Windows merge file creates a text file with a .txt extension instead of a Word for Windows document with a .doc extension, as you would expect. |
| 23734 | If you use an invalid key combination in an AutoKeys macro in Microsoft Access 7.0 or 97, you may receive the following error message: |
| 23735 | You may receive unexpected results when you use the IIf() (Immediate If) function to evaluate an expression. Your results will depend on the use of double quotation marks in the function's arguments. |
| 23736 | If you use the Format() function on the result of a Month() function, Microsoft Access returns an incorrect result. |
| 23737 | The following information describes how to prepare data in a Microsoft Access database to use in a mail merge in WordPerfect for DOS or WordPerfect for Windows. |
| 23738 | When you run Microsoft Access from the |
| 23739 | When you move to a new record on a form that has a combo box or a list box, the combo box will be blank or the list box will not have any value selected. The combo box or list box may have a table or query defined in its RowSource property |
| 23740 | If you turn off system messages with a SetWarnings macro action, system messages will be off only while that macro or set of macro actions is running. |
| 23741 | When you run a make-table query to create a new table, the table does not inherit all the properties from the table on which the query is based. |
| 23742 | When you are adding records, Microsoft Access does not normally check the values in primary key fields for duplicates until you move to the next record. If you enter an invalid or duplicate value in a control and move to the next record, yo |
| 23743 | A text box control does not display text in the color that you specified. Instead, the text is displayed as if you did not specify any color. |
| 23744 | When you print or preview a report, you may receive the following error message. |
| 23745 | By using a macro, or some code and a report's section properties, you can design a report that breaks the page for each new entry in a group and resets the report's page number. For example, in Microsoft Access 7.0 and 97, the Employee Sale |
| 23746 | When you open multiple instances of a Microsoft Access database, even though multiuser options have been set, you may receive the following error message. |
| 23747 | When you run a query, a form, or a report based on a query, you may receive an "Out of Memory" or "Query too Complex" error message. |
| 23748 | To create labels that print on dot-matrix or tractor-feed printers, you usually need to adjust the page size. Before you create a mailing label report for these printers, first set the default printer and paper size in Control Panel. |
| 23749 | When you try to open another database with a macro containing DoMenuItem (RunCommand in Access 97) and Sendkeys actions, the macro does not seem to run. |
| 23750 | When you set the |
| 23751 | This article describes how to duplicate the Microsoft Excel FillDown method in Microsoft Access. |
| 23752 | This article describes how to create form controls that increment or decrement a date. After a date control is initialized to the date stored in the computer, command buttons are used to increment or decrement the displayed date. |
| 23753 | In Microsoft Access, you can use variable parameters in queries. This article discusses how to construct a query that requires more than one prompt. Each parameter can be used both as criteria and as a field to allow complicated evaluation |
| 23754 | When you print Avery 5267 labels, the text may appear to creep down the page. |
| 23755 | When you export a table that includes a Date/Time field to a text file, Microsoft Access automatically adds the time format to the date in the exported text file. The Date/Time field appears in the text file in mm/dd/yy hh:nn:ss format. |
| 23756 | When you run a query that takes its parameters from a form, no records are returned by the query if you leave the field blank. If you type an asterisk (*) in the field, only records with non-Null values are returned. |
| 23757 | In Microsoft Access 7.0 and 97, if you leave the Echo On argument out of the Echo action in a module, you may receive the error message, "Argument Not Optional." |
| 23758 | This article demonstrates a sample macro that repairs and compacts a database. |
| 23759 | Microsoft Access addresses linked (attached) data differently than it does its own native data. This article discusses how Microsoft Access retrieves linked ODBC data. |
| 23760 | There is no CanShrink property for check boxes or option buttons on a form or report. |
| 23761 | When you print a form or report that contains a subform/subreport that calls an ApplyFilter macro action in its OnOpen event, you receive the following error message: |
| 23762 | In Microsoft Access 1.1, 2.0, 7.0, and 97, you can import from, export to, and link (attach) data in FoxPro versions 2.0 and 2.5. |
| 23763 | This article describes how to print separately the odd and even pages of a report for duplex printing or to print reports with different margins for binder storage. |
| 23764 | This article lists sample expressions that you can use to count the occurrences of Yes, No, or Null in a field with a Yes/No data type. |
| 23765 | This article lists four different methods of moving to a specific record based on a combo box selection. |
| 23766 | The macro or function attached to the BeforeUpdate or AfterUpdate property of a bound control does not run when expected. |
| 23767 | If a macro is attached to the OnEnter or OnExit property of the first control in the tab order of a subform, the macro will run each time you move from one record to another in the main form. |
| 23768 | Session Summary In this session, we will discuss how to work with Microsoft Access 97 and Microsoft Access 2000 on the same computer. The installation programs for Access 97 and Access 2000 install to the same default directory. When any components of... |
| 23769 | When you link (attach) an SQL Server table that has a column with a NOT NULL restriction in Microsoft Access, add a value to the restricted column in the linked table, then delete the value and attempt to commit the record, you may receive |
| 23770 | When you link (attach) a password-protected Paradox table nonexclusively to a Microsoft Access database, the table behaves normally, enabling you to view the table's contents after you supply the correct password. However, once the password |
| 23771 | This article lists the wizard files included with Microsoft Access 97, and the wizards that each file contains. |
| 23772 | After you insert a Microsoft Graph object into a Microsoft Access form or report, the graph object always displays sample data in Design view. This occurs even if you have opened the form or report, and the graph object correctly displays the actual... |
| 23773 | Titles often begin with the article A, An, or The. When you sort such title fields, you may not get the desired result of having the titles sorted in alphabetical order by their most meaningful words. For example, movie titles, such as The... |
| 23774 | When you append data from a spreadsheet to an existing table by using a TransferSpreadsheet macro action or a TransferSpreadsheet method in Visual Basic for Applications, you may receive the following error message: |
| 23775 | This article describes how to sort the values on a form based on field names that you select from a combo box. |
| 23776 | When you import or link a fixed-width text file with fields that contain an embedded carriage-return and line feed control characters (ASCII decimal values 13 and 10 respectively), Microsoft Access interpret this character set as being the |
| 23777 | When you try to link a Microsoft FoxPro database with an index from a read-only drive, you may receive the following error message: Microsoft Access can't create, open, or write to the index file filename, the information (.inf) file it uses to keep... |
| 23778 | This article describes two methods that you can use to export Null fields with delimiters. |
| 23779 | Vertical Line controls do not increase in height when you place them in a report section whose CanGrow property is set to Yes. NOTE: This article explains a technique demonstrated in the sample files, RptSampl.exe (for Microsoft Access for Windows 95... |
| 23780 | When you run an update query with more than 127 fields selected, you may receive the error message, "Too many fields defined." However, this same query will run correctly when you select 127 fields or fewer. |
| 23781 | A Pareto chart provides a simple way of analyzing categorical data. In a Pareto chart, categories are arranged in descending order from left to right as histogram columns, based upon a selected numerical criterion, from highest to lowest values. Then,... |
| 23782 | In the retail version of Microsoft Access 97, you can't view the Visual Basic for Applications code for wizards. This special version of the wizards contains viewable wizard code for developers to use as a learning tool. |
| 23783 | In the retail version of Microsoft Access 97, you can't view the Visual Basic for Applications code for wizards. This special version of the wizards contains viewable wizard code for developers to use as a learning tool. |
| 23784 | In the retail version of Microsoft Access 97, you can't view the Visual Basic for Applications code for wizards. This special version of the wizards contains viewable wizard code for developers to use as a learning tool. The following file is... |
| 23785 | When you import a text file, one of the options in the Import Text Wizard is the "Choose my own Primary Key" option. However, this option will allow you to select only one field for a primary key. |
| 23786 | When you use an OutputTo action or method to save a report to an MS-DOS Text (.txt) format, the text file adds blank lines randomly to the data. |
| 23787 | Microsoft Access repeats both text boxes and labels in the detail section when you set up a report to print multiple columns. This article describes a method that you can use to print just the labels in the first column and just the text bo |
| 23788 | Setting the Filter property of a form doesn't apply a filter. |
| 23789 | In Microsoft Access, you can select multiple records in a form using the record selector at the left side of the form. In Microsoft Access 7.0 and 97, you can use the new SelTop and SelHeight form properties to specify or determine the numb |
| 23790 | The Microsoft Access Chart Wizard (or Graph Wizard in Microsoft Access version 2.0) enables you to format a label for each axis of a chart. You can modify the label formats in Microsoft Graph and then save those changes for later use. Under |
| 23791 | This article describes how to create a pop-up form for setting the sort order of data in a report. |
| 23792 | When you use double quotation marks (") around the values in a pass-through update query, or you send a string that contains a single quotation mark (') as in (like ''O Brien') to Microsoft SQL 6.0, you may receive an ODBC call Failed error |
| 23793 | This article describes how to filter a report dynamically in Print Preview by selecting filter criteria from a pop-up form. NOTE: This article explains a technique demonstrated in the sample files, RptSampl.exe (for Microsoft Access for Windows 95... |
| 23794 | This article lists Microsoft SQL Server and ORACLE ODBC drivers that you can use with various versions of Microsoft Access and Microsoft Windows. In addition, the article lists the sources from which you can obtain the ODBC drivers. |
| 23795 | This article describes how to create a button on a filtered form that opens a report and applies the same filter that is on the form to the report. |
| 23796 | Subreports and text box controls do not have a KeepTogether property to prevent the controls' data from printing across two or more pages. However, you can simulate the KeepTogether property behavior by creating "artificial" group sections |
| 23797 | There is no longer an ISAM available for Btrieve data. |
| 23798 | The GotoRecord macro action doesn't behave as you would expect when you use it in an AutoKeys macro. Instead of changing the record of the active form, it changes the record of a form in the background. |
| 23799 | In Microsoft Access, you may receive the following error message if you refer to the Column property of a combo box in a query's criteria row (query by form): |
| 23800 | This article explains the HasContinued and WillContinue properties that are included in Microsoft Access 7.0 and 97, their usage, and their limitations. |
| 23801 | When you open or make a reference to a linked table in Microsoft Access 7.0 or 97, you may receive the following error message: Couldn't find input table or query 'Name' -or- Couldn't find file 'pathname\filename' |
| 23802 | This article demonstrates how you can create an AutoKeys macro to work with a specific form rather than with all the objects in the database. |
| 23803 | This article demonstrates three methods that you can use to sum a calculated control in a report. Because the Sum() function, as well as the other aggregate (totals) functions can reference only a field and not a control, you must use one o |
| 23804 | When you try to make changes to a linked (attached) SQL Server table, you cannot update the table. |
| 23805 | When you run a query based on two tables (in this example, called table A and table B) with an outer join to include all the records from table A, and you apply a WHERE clause to table B, only those records from table B that have a matching |
| 23806 | This article show you how to use Visual Basic for Applications code (or Access Basic code in version 2.0) to cancel the records that have been selected in a form by using the record selectors. |
| 23807 | When you call a user-defined function from within an aggregate (totals) function, such as the Sum() function, in a report, you may receive the following error message: |
| 23808 | When you try to add a new record to a subform, you receive the following error message: |
| 23809 | When you save a report to MS-DOS Text (.TXT) format or Rich Text Format (.RTF), the text in the resulting file is wrapped differently than in the original report or is truncated differently. |
| 23810 | When you reference the Dirty property of an unbound form (a form that is not based on a table or query), you may receive the following error message. |
| 23811 | When you open a linked (attached) dBASE or FoxPro table in Design view, the table's index is missing, even though you specified an index when you linked the table. |
| 23812 | Microsoft Access will not perform an AutoLookup query if it determines that the tables in the query have a one-to-one relationship. |
| 23813 | When you run a SQL-specific union query that contains an OLE Object field, you may receive the following error message: |
| 23814 | This article describes how to invoke the Find dialog box with different default settings. |
| 23815 | The owner of a query cannot transfer its ownership if the query's RunPermissions property is set to Owner's. This is true even if the owner has Administer permission for the query. |
| 23816 | When you type a unique value in a combo box and then press ENTER, you may receive the following error message even though the combo box's LimitToList property is set to No: |
| 23817 | You usually use code to compare data among records in a table. This article describes how to use a query instead of code to compare data among records. |
| 23818 | In Microsoft Access 7.0 and 97, when you add tables to the Relationships window, you may receive the error message "There is not enough memory to perform this operation. Close unneeded applications and then try the operation again." In Micr |
| 23819 | Changing a control's property setting (such as the BackColor property setting) in a continuous form causes all instances of that control in all records to be changed. |
| 23820 | This article describes how to repeat a subreport's header when the subreport spans multiple pages. |
| 23821 | If your Microsoft Access database contains a reference to multiple library databases, type libraries, or object libraries, it is possible for the same class name to exist in more than one referenced file. If you want to declare a variable of that |
| 23822 | When you click Exit on the File menu in Microsoft Access, Access does not quit. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with... |
| 23823 | When you use Microsoft Access intrinsic constants in expressions in a query, on a form or a report, or in the Condition column of a macro, you receive an error or you are prompted to enter a parameter. For example, when you use the StrConv() |
| 23824 | This article shows you how you can automate importing all files of a particular type from a specific folder on your hard disk. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access |
| 23825 | This article shows you how to dim or disable items on a menu bar, toolbar, or shortcut menu in Microsoft Access 97. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the... |
| 23826 | This article show you how to use Automation to run a Microsoft Word 97 macro from Microsoft Access. For information about how to run a macro in earlier versions of Microsoft Word, please see the following article in the Microsoft Knowledge Base:... |
| 23827 | This article shows you how to create a sample procedure to link a Microsoft Outlook folder as a table in a Microsoft Access database. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 23828 | When you use Automation to control another application, such as Microsoft Word or Microsoft Excel, the application quits as soon as your procedure finishes running. This article assumes that you are familiar with Visual Basic for Applications |
| 23829 | When you use the OutputTo method in Visual Basic for Applications to output a form or report module to a text file, you may receive the following error message: Microsoft Access Run-time error '2501' The OutputTo action was canceled. |
| 23830 | When you link to a Microsoft Excel 7.0 or 97 spreadsheet from a Microsoft Access 7.0 or 97 database, and the fields in the spreadsheet contain both numbers and text, the fields that contain text appear as #Num! in the linked table in Microsoft Access. |
| 23831 | When you use an Active Server Pages (ASP) form to add or modify data in a Microsoft Access database, if you type the percent (%), plus (+) or caret (^) symbols on the form, those characters may not translate correctly in the database. This article |
| 23832 | After you use the "Publish to the Web" Wizard to create Dynamic HTX/IDC or Dynamic ASP (Microsoft Active Server Pages) file formats on your Web server, you may receive the following error message when you try to view those files with your W |
| 23833 | Session Summary In this session, we will discuss installing the Access Security Manager and describe its main features. The Access Security Manager is able to create logs of a database's security state and then set the database's security from any... |
| 23834 | When you print a form or report to an Epson 9-pin printer, the last two characters of the label controls may be truncated. The label controls are displayed correctly when you preview the report. |
| 23835 | This article shows you how to write a macro that will place the current date into a LastModified field in a table each time that a record is modified. You can use this method when you are editing records on a form. |
| 23836 | Although the Requery, Repaint, and Records Refresh items are different, you can use each of them to ensure that what you see on the screen is updated. |
| 23837 | When you run Setup for Microsoft Access 7.0 on a computer that already has Microsoft Access 97 installed, you may receive one of the following pairs of error messages: Can't load mspdox35.dll (error code=1157) The configuration of the ODBC Microsoft... |
| 23838 | When you use TransferText in a macro or in a Visual Basic procedure to import data into an enabled Microsoft Access 2.0 database in Microsoft Access 7.0 or 97, you receive may the message: You can't import objects into a database created in an earlier... |
| 23839 | The Paradox, Lotus 1-2-3, and Microsoft Exchange/Outlook indexed sequential access method (ISAM) drivers are not installed with the Microsoft Access 97 or Microsoft Office 97 Professional Setup; however, they are included with the Office 97 ValuPack... |
| 23840 | The Setup program for Microsoft Access 7.0, Microsoft Access 97, and Microsoft Office 97, Professional Edition does not create a shortcut for the Workgroup Administrator program on Microsoft Windows 95 or Microsoft Windows NT 4.0 computers. This... |
| 23841 | When you use the Microsoft Word Mail Merge Wizard to merge your data into a Word document, it is possible to use an existing Word document that has been previously merged with a different data source. This article demonstrates how to do this. |
| 23842 | This article describes a method for using a keystroke-plus-click combination with a command button. For example, you might want click, ALT+Click, and CTRL+Click to have different actions on the same command button. |
| 23843 | When you use the PrtMip Property example in Help, you may receive the following error message in Microsoft Access 7.0: The setting you entered isn't valid for this property In Microsoft Access 7.0 and 97, the SetMarginsToDefault() sample procedure... |
| 23844 | When you use the Find dialog box to search for a value in a query, you may receive the following error message. |
| 23845 | In Microsoft Access, you can use Microsoft Graph to embed a graph object in a form or report. However, if you export the form or report to a Microsoft Excel worksheet, the graph does not appear in the worksheet. This article describes how to export a... |
| 23846 | This article describes how you can display a horizontal line after specific detail records in a report, where the criteria for displaying the line changes on a sliding scale. |
| 23847 | This article describes how to create a graph that is bound to two combo boxes. You control the data that is displayed in the graph by making selections from the combo boxes. |
| 23848 | When you are creating a query and you select crosstab as the query type, by default, all the columns in the query by example (QBE) grid have Group By in the Total row. If you then change the query type to make-table, the columns still have |
| 23849 | The AutoRepeat property for command buttons does not work in conjunction with the GoToRecord/Next macro action for moving to successive records on a form. In other words, if your form uses command buttons instead of the record selector butt |
| 23850 | Form and report sections have a KeepTogether property that you can set to Yes or No. The KeepTogether property setting for sections determines whether Microsoft Access prints the controls located in that section on a single page or on more |
| 23851 | A system object always retains the original system object attributes. Operations performed on system objects, such as Import, Rename, and Copy, preserve the flags in MSysObjects table. |
| 23852 | If the ControlSource property of a combo box is set to a field that has an AutoNumber data type (or Counter in versions 1.x and 2.0), when you try to change the value in the combo box, you receive the following message on the status bar: |
| 23853 | In the Print Preview window in reports, you can move forward and backward, page by page, to view your report before printing it. When previewing a large report, you may notice that it takes longer to move backward than it takes to move forw |
| 23854 | When you open a database, Microsoft Access remembers the database name and displays the name in the Recent File List on the File menu. The four most recently opened databases are displayed on the list. However, if you delete a database on t |
| 23855 | Microsoft Access provides an automatic "row fix-up" feature that uses links between tables to update (fix up) records in queries and forms. You can use this feature to enter a single value, and Microsoft Access automatically looks up and di |
| 23856 | When you type the letter "y" or "n" into a field, you may receive the following error message: |
| 23857 | In Microsoft Access 2.0, 7.0, and 97, if a control's Visible property is set to No, the control will be visible in Datasheet view, but invisible in Form view. You do not need to do anything special to see the field in Datasheet view. |
| 23858 | If you open a form in Form view and have two or more calculated controls, you may receive a "#Name?" error in all of the calculated controls on the form, even if the expression for an individual control is valid. |
| 23859 | When Microsoft Access performs a database compact operation, the status bar indicates the percentage of the task that is complete. At times, the status bar may remain on one value for a very long time, and it may appear that Microsoft Acces |
| 23860 | If two users are simultaneously modifying the same record in the same table, the user who tries to save the record last may receive the following error message: |
| 23861 | In Microsoft Access 97, when you import a Paradox file that does not contain a file extension as part of its name or does not follow the MS-DOS 8.3 file name format (that is, an 8-character name followed by a 3-character extension), you may |
| 23862 | If you enter data that has one or more trailing spaces in a form control, Microsoft Access ignores the trailing space(s); therefore, the data you enter may not be valid as a means of comparison. Also, if variables in Visual Basic for Applic |
| 23863 | Microsoft Access will set the field length of a Text field to the length of the entered text if the text entered is shorter than the maximum field size. |
| 23864 | If the data in a field that is used as a column heading in a crosstab query contains a period (.), an exclamation mark (!), or a bracket ([ or ]), the character will be changed to an underscore character (_) in the column heading. This does |
| 23865 | Microsoft Access cannot import DataEase data files directly, but you can export DataEase data to a formatted disk file that Microsoft Access can import. The information in this article applies to DataEase versions 4.2, 4.5, and 4.53. DataEa |
| 23866 | The following table shows the default values for the AutoLabel and AddColon properties for the different form and report objects: |
| 23867 | The TransferDatabase action is the macro equivalent of the Link Tables command (or Attach Table command in versions 1.x and 2.0). However, Microsoft Access does not have an action to delete a link to a linked (attached) table. To remove a l |
| 23868 | Microsoft Access does not ship with an ISAM driver that supports linking (attaching) R:BASE tables to Microsoft Access databases. However, R:BASE can export tables into several different formats that Microsoft Access can import. |
| 23869 | The default grid area is independent of how a report or form is printed. The controls that you place in the document determine the size. |
| 23870 | When you try to open a table in Design view, you may receive the following error message, depending on your version of Microsoft Access. |
| 23871 | When you scroll through records in the main form, the subform is not updated. The records on the main form and the subform are not synchronized. |
| 23872 | You can improve the performance of Microsoft Access if you periodically defragment your hard disk and compact your database. |
| 23873 | When you try to open a table in Design view in Microsoft Access 7.0 or 97, you may receive the following error message: |
| 23874 | You cannot link (attach) a Paradox table (*.DB) located on a read-only drive. If you try to link a Paradox table on a read-only drive, you receive the following error message: |
| 23875 | The BeforeUpdate macro appears to be running twice rather than only once. |
| 23876 | One way to get Microsoft Access output from forms or reports into a text file is to use the Windows Generic print driver and print to a file. However, using the Generic print driver (TTY.DRV) can be a little tricky. Listed below are some hi |
| 23877 | Microsoft Access saves printer driver information with each form or report that it generates. This means you do not have to set up the printer with the correct driver in order to print out a form or report--the form or report "remembers" th |
| 23878 | If you want to copy an SQL statement from the RowSource or ControlSource property of a control, or the RecordSource property of a form or report, and paste it into a query, you must use the CTRL+C method to copy the SQL statement to the Cli |
| 23879 | When you use a query to perform a count, Null values are ignored. |
| 23880 | Linked (attached) tables, such as Microsoft Access, Paradox, Btrieve, FoxPro, or dBASE tables, are different from native Microsoft Access tables in four ways: |
| 23881 | The AutoExec macro will not run when a previously hidden database is unhidden or when a minimized Database window is maximized again. |
| 23882 | You can hide and show a subform by using a command button or toggle button. This article shows you how to create either a macro or a sample user-defined function that uses a command button or toggle button to hide and show the Quarterly Ord |
| 23883 | A field returns a "#Error" error message when the ControlSource property (bound field) contains the Name property in an expression. However, in an unbound text box, the same expression generates the expected value rather than "#Error." |
| 23884 | This article describes what happens internally in Microsoft Access when you delete an object (a table, a form, a query, and so on) from a database. |
| 23885 | Microsoft Access does not prompt you for the second parameter in a query, even though it does prompt you for the first parameter. |
| 23886 | Icons do not always stay where you expect them to. See the "Steps to Reproduce Behavior" section later in this article for more details. |
| 23887 | When you use wildcards (for example, * or ?) to search for a string, you must use Like or Not Like in the Criteria field, rather than the Equal to (=) or Not Equal to (<>) operators. When you use the = or <> operator, Microsoft Access treat |
| 23888 | When you are using a combo box on a form and the data source is a linked (attached) table, the scroll box does not always move down the scroll bar when you click the scroll arrow. Once you reach the bottom of the list, however, the scroll b |
| 23889 | This article shows you how to create a parameter query to search for all the records in a table that begin with, or that contain, a certain letter. |
| 23890 | If you attempt to create a select, update, or append query that groups by a Memo field or OLE Object field, you may receive the following error message: |
| 23891 | You can sort or group a query by using only a portion of a field's value. This technique is useful if a field contains values with a set number of leading or trailing characters that are insignificant to your sorting task. An example of thi |
| 23892 | When you paste link a table from Microsoft Access to Microsoft Excel versions 3.0 and earlier, only the first field name of that table appears in the spreadsheet. |
| 23893 | You may not be able to edit a record on a form, even though the AllowEdits property of the form is set to Yes. When you try to update data on the form, you may receive the message, "This Recordset is not updatable." |
| 23894 | When you try to run a query, the query fails, and you receive the following error message: |
| 23895 | An empty or null row of a list box can be selected. |
| 23896 | When you export a Microsoft Access 7.0 or 97 table with a primary key field to any of the dBASE or Microsoft FoxPro formats, an index is created. This does not happen in Microsoft Access 1.x and 2.0. Exporting to a Paradox format does not c |
| 23897 | When a form contains an option group with two option buttons, and the values of the option buttons are set to values 0 and 1 respectively, and the option group is bound to a Yes/No field in a table, only the option button with value 0 can b |
| 23898 | When you type an expression in the ValidationRule property of a text box, and the expression contains a function name that has no parentheses or parameters, Microsoft Access evaluates the expression as a string instead of a function. |
| 23899 | When you try to switch a form from Design view to Form view, the attempt fails, and you receive the following message: |
| 23900 | If the LimitToList property of a combo box is set to Yes, and you type a portion of an entry into the combo box and press ENTER, you may receive the following error message: |
| 23901 | When you are looking at the contents of a Memo field in a combo box, the entire contents of the Memo field are not visible. Instead, only the first 255 characters of the Memo field are visible. |
| 23902 | In Microsoft Access version 1.x, when you add a command button to a form, Microsoft Access places a label in the top-left corner of the command button control. In Microsoft Access 2.0, 7.0, and 97, a label is not placed in the top left corn |
| 23903 | When you open a form in Form view, the form is completely blank. There are no controls or text. Everything is blank, except for the form header. |
| 23904 | When you try to enter an expression that requires a list separator in the QBE grid field or criteria rows, or as the ControlSource property setting for a text box in a form or report, the attempt fails, and you may receive the following err |
| 23905 | When you run a query, you may receive the following error message: |
| 23907 | When you try to import or link a Microsoft Excel spreadsheet, if you click Show Named Ranges in the Import Spreadsheet Wizard or the Link Spreadsheet Wizard, you may receive the following error message. In Microsoft Access 97 The Microsoft Jet... |
| 23908 | When you run a query in an unreplicated database, you may receive the following error message: |
| 23909 | When you click the Office Assistant, and then click Tips on the Office Assistant menu, or you click the See Tips option on the Office Assistant shortcut menu, the Next button is unavailable and the Back button is available. |
| 23910 | You have a Microsoft Access 2.0 or 7.0 database that uses a literal date between 1900 and 1929 as criteria in a query. After you convert or enable that database in Microsoft Access 97, the query returns the wrong records or no records at al |
| 23911 | When you open the License.hlp file that comes with the Microsoft Office Developer Sampler, you will see the following instruction: When you are finish reading the License Agreement, click Accept to return to Setup. This information is incorrect... |
| 23912 | You may receive the following warning message when you open Microsoft Access 97 after installing the Microsoft Office 97 Developer Edition Tools (ODE Tools): |
| 23913 | When you try to create a relationship that enforces referential integrity, and the relationship involves a multiple-field primary key, you may receive the following error. |
| 23914 | When you type a date in the format M/D/YY where YY is a number from 00 through 29, Microsoft Access defaults to the years 2000 through 2029. |
| 23915 | When you try to convert or open a Microsoft Access 1.x or 2.0 database, you may receive the following error message: In Microsoft Access 97 ---------------------- The process failed because there is no default printer. This may be followed with the... |
| 23916 | If you have a table that contains a number field with more than 2 decimal places, and you export the table to a text file, the decimal places will be truncated to 2 positions. |
| 23917 | When you print to a file by using the Print To File option in the Print dialog box, the file created with a Generic/Text Only printer driver contains characters not supported by Microsoft Windows 95. |
| 23918 | When you print or preview a report or a form, a text box does not display data, even though the records have data in that field. |
| 23919 | The spelling checker flags words that are already added to a custom dictionary file. |
| 23920 | When you view and switch between maximized forms, all forms may suddenly become "un-maximized" (restored). |
| 23921 | When you save the results of a query after you apply additional filters using Filter By Selection or Filter By Form, the saved recordset consists of all records that were returned before you applied the additional filters. |
| 23922 | When you try to link a table that is located on a read-only drive, a write-protected diskette, or a CD-ROM in Microsoft Access, you may receive the following error message: |
| 23923 | If you try to preview a report that contains a bound field whose ControlSource property is set to a field named Application, you may receive the following error message. |
| 23924 | When you specify Text criteria for a Text field with Count in the Total row of a totals query, you may receive the following error message: |
| 23925 | After you convert a Microsoft Access 7.0 database to Microsoft Access 97, you see incorrect objects in the database when you open it, such as Wizard tables or objects from the Northwind sample database. |
| 23926 | Forms will always open to a maximized state once any other Microsoft Access window has been maximized (excluding the Microsoft Access Desktop). However, when a Microsoft Access window is maximized, forms may briefly be displayed in a restored state... |
| 23927 | When you set the Picture property of a mailing label report to a watermark (picture), the watermark appears only once when you preview the report instead of once for each label. |
| 23928 | List boxes have a property called MultiSelect that enables you to make multiple selections in one control. If the MultiSelect property is set to Extended, any selections that you make will be cleared if the list box is requeried. This behav |
| 23929 | When you open a form that has the AllowAdditions property set to No, the form opens, allowing you to add records. |
| 23930 | When you import a Microsoft Excel spreadsheet whose cell table goes beyond the last cell that actually contains data, you may get blank columns in the Microsoft Access table. This occurs with the TransferSpreadsheet macro and the Import Men |
| 23931 | When you use the Import Spreadsheet Wizard, you cannot append spreadsheet data to an existing table in either a Microsoft Access 7.0 or a Microsoft Access 97 database. If you try to specify an existing table as the import destination, you m |
| 23932 | When you try to create a new report, you may receive one of the following error messages. |
| 23933 | If you add an input mask to a table that already contains data, the Find feature fails to work properly when the field's data does not meet the criteria of the input mask. For example, in Microsoft Access 2.0, a Find action fails if you typ |
| 23934 | When you try to omit fields from the export specification in the Export Text Wizard (or Text Export Wizard in Microsoft Access 7.0), you may receive the following error message: |
| 23935 | When you convert a Microsoft Access 1.x, 2.0, or 7.0 database to a Microsoft Access 97 database (or when you convert a Microsoft Access 1.x or 2.0 database to a Microsoft Access 7.0 database) by using the Convert Database command on the Database... |
| 23936 | When you set a form or report section's height in the Page Setup dialog box under Item Size on the Columns tab (or the Layout tab in Microsoft Access 7.0), the height of the form or report's section does not change. The Page Setup Height setting is... |
| 23937 | When you use a Database Wizard to create a new database in Microsoft Access 97 or 7.0 on a computer running Windows 95 with limited virtual memory available, you may receive one of the following error messages: |
| 23938 | When you base a report on a query that has a sort order defined, the sort order is retained in the report. However, if you add a field to the report footer, the sort order from the query is no longer used. |
| 23939 | When you preview a report in Microsoft Access 7.0 or Microsoft Access 97, you may receive the following two error messages: Microsoft Access can't find the field 'field name' referred to in your expression. An error occurred while referencing the... |
| 23940 | A form with its DefaultView property set to Datasheet and its Modal and PopUp properties set to Yes does not open with all three properties applied. In Microsoft Access 97, the form opens in Datasheet view, but the Modal and PopUp property settings... |
| 23941 | When you start Microsoft Access, you may receive the following error message: Microsoft Access can't start the data access object (DAO) and so it can't continue. You may also receive the following error message: A system error occurred, or there isn't... |
| 23942 | When you install Microsoft Access on a computer that runs Microsoft Windows NT version 3.51 or Microsoft Windows NT version 4.0, you may receive one of the following error messages: Msjtrclr.dll could not be registered. -or- Can't create System.mdw.... |
| 23943 | In Microsoft Access 7.0 and 97, system tables and conflict tables (tables that contain database records that conflicted during the synchronization of two replicas) may not be made replicable by Microsoft Access. The reason for this is that system... |
| 23944 | When you try to create a one-to-one relationship between two tables and enforce referential integrity, the one-to-one relationship type is not available in the Relationships dialog box. |
| 23945 | If you modify a Print Setup setting while you are previewing a report, Microsoft Access does not ask you to confirm the changes; the changes are automatically saved. This behavior differs from Microsoft Access version 2.0, which prompts you to save... |
| 23946 | You may receive the following error message when you try to print or preview a Microsoft Access 7.0 or 97 report that has been converted from Microsoft Access version 2.0: |
| 23947 | When you use the Import Spreadsheet Wizard, you cannot select or enter a non-named range of cells. As a result, you must import the entire spreadsheet instead of only a selected portion. |
| 23948 | When you try to open the Microsoft Access Readme.txt or Network.txt, you may receive the following error message: Windows cannot find Deskedit.exe This file is needed for opening files of type 'Text Document' |
| 23949 | If you highlight part of the text in the text box portion of a combo box and click Filter By Selection on the toolbar, no records are returned. |
| 23950 | When you print a report, a blank page appears between every printed page of the report or a blank mailing label appears between every printed label. |
| 23951 | When you navigate to a subform control, edits you make to a main form record are automatically saved. Validation rules for the main form record are evaluated and the BeforeUpdate and AfterUpdate events run. |
| 23952 | When you try to import a delimited text file, you may receive the following error message: |
| 23953 | When you open a Microsoft Access version 1.x database in Microsoft Access 97, Microsoft Access 7.0, or Microsoft Access 2.0, you may receive the following error message: |
| 23954 | When you print a mailing label report, Microsoft Access skips some of the labels even though all of the records are printed. |
| 23955 | All the commands in the Add-ins submenu are unavailable (appear dimmed). |
| 23956 | You cannot enforce referential integrity when you are defining a relationship between tables. |
| 23957 | Microsoft Access can import Microsoft Works version 2.0 spreadsheet (.wks) files directly. This article explains how to transfer your spreadsheet files from Microsoft Works into a Microsoft Access database (.mdb). |
| 23958 | To use a mail merge with Microsoft Access data, you can export or copy your data to a word processor, or in Microsoft Access 2.0, 7.0 and 97, you can click the Merge It button on the toolbar. However, you can also create a Microsoft Access report to... |
| 23959 | If you enter a partial date in a field formatted with the Date/Time data type, Microsoft Access fills in the current year automatically. |
| 23960 | This article discusses the reasons why Microsoft Access does not use record numbers, as some other database products do. |
| 23961 | This article describes how to import data from a Microsoft Word for Windows print merge data file for use in Microsoft Access. |
| 23962 | Microsoft Access 97 Service Release 1 and Microsoft Office 97 Service Release 1 enable you to save a static picture of a Microsoft Access 97 report in an external file format (*.snp). You can then make the report available to someone who does not have... |
| 23963 | Ureldes.doc shows you how to plan and design a database from the ground up. For practical examples, it uses the database design of the Northwind Traders sample database included in the Microsoft Access package. |
| 23964 | The database file format in Microsoft Access 97 is different from the file format in earlier versions; however, you can export tables from a Microsoft Access 97 database to a database created by an earlier version. |
| 23965 | When you run the Microsoft Access Setup program in Maintenance mode, and you click the Remove All button, some Microsoft Access files are not removed from your computer. This behavior occurs because Setup does not remove any files that may be used by... |
| 23966 | This article lists the file contents of the Data Access Pack, Dataacc.exe, included with the Microsoft Office 97 ValuPack. The Data Access Pack contains additional drivers for Paradox, Lotus 1-2-3, and Microsoft Exchange/Outlook. It is located in the... |
| 23967 | Migration from earlier versions of Microsoft Access to Microsoft Access 97 is straightforward. When you initially open your database in Microsoft Access 97, you have two choices: to convert the database to version 97, or to open it in version 97. The... |
| 23968 | When you click a hyperlink that opens a Microsoft Access database or an Internet Web page, a new instance of Microsoft Access or Microsoft Internet Explorer starts even if one is already started on your computer. |
| 23969 | The Microsoft Access 97 Readme File, Acread80.wri, is the only Microsoft Office 97 Readme file in WordPad format; all other products' Readme files are in text format. |
| 23970 | The WzTreevw.mde file is a Treeview Control Wizard for Microsoft Access 97. When you insert a Treeview Control on your form with this wizard installed, the wizard will guide you through configuring the Treeview Control. The appearance of the Treeview... |
| 23971 | This article demonstrates how to use the tab control on a form in Microsoft Access 97. |
| 23972 | This article lists the hardware and software requirements to install Microsoft Access 97. |
| 23973 | You can install multiple versions of Microsoft Access 97 and earlier on the same computer, and you can even run the separate versions simultaneously with one exception: you cannot run Microsoft Access 1.x and Microsoft Access 2.0 at the sam |
| 23974 | When you try to encrypt a database, you may receive the following error message: |
| 23975 | The "RecordSource Property" topic in the Microsoft Access 97 Help system contains a syntax error. The example in the "Sample setting" section of the Help topic reads as follows: |
| 23976 | In some cases, you may want to export data to a quotation-mark- and comma-delimited file, and you may want each value to be surrounded by quotation marks. By design, Microsoft Access will only place quotation marks around text values and no |
| 23977 | Microsoft Access 7.0 and 97 have a feature called "morphing." This feature enables you to change one type of control into another type of control. However, there are limits to which kinds of controls you can morph. For example, you cannot m |
| 23978 | In Microsoft Access 7.0 and 97, a single action, such as clicking the mouse or pressing a key, can trigger several different events that occur in a particular order. Knowing when and in what order events occur can help you to create macros and... |
| 23979 | In Microsoft Access 97, 7.0 and 2.0, you can only overlap controls of the same window type. This is different from the behavior that is present in Microsoft Access 1.x. In Microsoft Access 1.x you can overlay any control over any other cont |
| 23980 | This article demonstrates how to design a query to return the records from one table in a many-to-many relationship where each of the records returned is related to two records in the other table in the relationship. Note that the many-to-m |
| 23981 | This article lists words and symbols that should be avoided in field, object, and variable names because they are "reserved words," words that have a specific meaning to Microsoft Access or the Microsoft Jet database engine. If you use a re |
| 23982 | Column, or field, data types are different for each database management system. This means that when you are accessing table structures from other database management systems, a conversion, or data type mapping, must occur. This article des |
| 23983 | This article describes how to import data into Microsoft Access from WordPerfect DataPerfect. |
| 23984 | To remove the menu bar from a form, enter =1 (or any Visual or Access Basic function that evaluates to a numeric result) in the MenuBar property of the form in Microsoft Access 2.0, 7.0, and 97, or in the OnMenu property of the form in Micr |
| 23985 | When you want to have a user enter a date value on a form, you can improve usability of the form by providing a Calendar control on the form. To reduce clutter on the form, you can simulate a feature of Microsoft Outlook by having the calendar pop up |
| 23986 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 23987 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 23988 | When you use the underline (_) as a line-continuation character in a Visual Basic code module in Microsoft Access 7.0, and then you convert that database in Microsoft Access 97, you may receive the following error message: There were compilation... |
| 23989 | This article shows you how to use code to set the RowSource property of a Graph object in a Microsoft Access report. |
| 23990 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 23991 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 23992 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 23993 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 23994 | This article shows you how to use the TabStrip ActiveX control in the sample database Northwind to view the Customers and the Suppliers tables using the SourceObject property of a subform. |
| 23995 | This article shows you how to use Automation to rotate a chart created in Microsoft Graph. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools... |
| 23996 | This article shows you how to use Automation to modify properties of the Border object in a Microsoft Graph object. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the... |
| 23997 | This article shows you how to format a fax number in Microsoft Access so that you can merge it with a Microsoft Word document that uses Microsoft Exchange to print to a fax modem. This article assumes that you are familiar with Visual Basic for... |
| 23998 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 23999 | This article shows you how to use Automation to add, remove, and set trend lines on a Microsoft Graph object. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the... |
| 24000 | This article shows you how to use Automation to change the chart type of a Microsoft Graph object. |
| 24001 | This article describes how you can use Automation to create and to send a Microsoft Exchange message. This article assumes that you are familiar with Visual Basic for Applications and that you can create Microsoft Access applications by using the... |
| 24002 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24003 | This article shows you how to use Automation to call Microsoft Excel functions from within Microsoft Access. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the... |
| 24004 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24005 | This article shows you how to test the validity of a user-defined filter when using the Filter By Form feature of Microsoft Access. The sample procedure demonstrates some of the validation techniques that you can use to ensure that the filt |
| 24006 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24007 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24008 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24009 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24010 | This article shows you how to create a Microsoft Office Binder that includes documents from a variety of Microsoft Office programs. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access... |
| 24011 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24012 | When you try to export a query in dBASE (any version) file format, you receive the following error message: |
| 24013 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24014 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24015 | Advanced: Requires expert coding, interoperability, and multiuser skills. Microsoft Access does not have a function to maximize, minimize, and restore Microsoft Access from a module or macro. This article shows you how to use Microsoft Windows API... |
| 24016 | In Microsoft Windows NT or Microsoft Windows 95 or later, you can use the Win32 application programming interface (API) to retrieve network information, such as the user name, workgroup, domain, and computer name, about the currently running computer.... |
| 24017 | Advanced: Requires expert coding, interoperability, and multi-user skills. To position Microsoft Access on the screen, you need to call the SetWindowPos() Windows API function. This article shows you how to call this function to position Microsoft... |
| 24018 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24019 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24020 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24021 | When you use the Import Text Wizard to import certain text files, you may see one of the following symptoms: |
| 24022 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24023 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24024 | If you convert a database from Microsoft Access 2.0 to Microsoft Access 7.0 or Microsoft Access 97, and that converted database has a user-defined procedure and a module with the same name, you may receive the following error message when the... |
| 24025 | Advanced: Requires expert coding, interoperability, and multi-user skills. |
| 24026 | Advanced: Requires expert coding, interoperability, and multi-user skills. |
| 24027 | Advanced: Requires expert coding, interoperability, and multiuser skills. You can use Microsoft Windows API functions to capture screen shots of any object on the Microsoft Windows desktop. You can capture screen shots of the Microsoft Access user... |
| 24028 | Advanced: Requires expert coding, interoperability, and multi-user skills. |
| 24029 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24030 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24031 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to display slides from Microsoft PowerPoint 7.0 or 97 on a form in Microsoft Access 7.0 or 97, respectively. This technique uses OLE Automation in... |
| 24032 | This article show you how to use a Schema.ini file and Data Access Objects (DAO) to programmatically open or link to a text file. A Schema.ini file contains the specifics on how data is formatted in a particular text file and is used by the |
| 24033 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24034 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24035 | By design, the DFirst() and DLast() functions always return the first and last record that you entered in the underlying table, not the first and last record as ordered by the table's index or the query's sort order. DFirst() and DLast() ig |
| 24036 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24037 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24038 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24039 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24040 | Advanced: Requires expert coding, interoperability, and multiuser skills. By carrying out the DoCmd object's OpenReport method, you can print Microsoft Access reports from any Automation client application, such as the Microsoft Visual Basic... |
| 24041 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24042 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24043 | This article shows you how to use Data Access Objects (DAO) in Microsoft Access 95 or 97 to create a Microsoft Access 2.0 database and how to copy entire tables from a Microsoft Access 95 or 97 database to the newly created Microsoft Access 2.0... |
| 24044 | If you issue a DbEngine.RepairDatabase method after you change your project references from Microsoft DAO 3.51 Object Library to Microsoft DAO 3.6 Object Library, you may receive the following error message: Error # 3251 was generated by |
| 24045 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24046 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24047 | When you try to perform an Internet synchronization, you may receive the following error message: |
| 24048 | When you perform a mail merge to Microsoft Word 97 from Microsoft Access 97, a second instance of Microsoft Access 97 opens. |
| 24049 | Certain Microsoft Access dialog boxes may be orphaned--not visible--on a Microsoft Windows system that once had two or more monitors installed at the same time. You cannot select the dialog box to move it back to the primary monitor. |
| 24050 | When you click Open or Save on the File menu for any of the programs listed at the beginning of this article and click the Look In list, you may receive the following error message: |
| 24051 | When you use the Save As HTML command to export a Microsoft Access object to HTML, you have the option on the final page of the "Publish to the Web Wizard" to run the Web Publishing Wizard. When you select this option and click Next, you ma |
| 24052 | When you run a query, you may receive the following error message when memory is still available: 2004 'Out of Memory.' You may also receive the error message: Query too complex. |
| 24053 | In the programs listed at the beginning of this article, the following symptoms may occur: When you start an Office program, the Office Assistant does not appear. -and- When you click the Office Assistant on the Standard toolbar, the Office Assistant... |
| 24054 | When you start any of the programs listed at the beginning of this article, either of the following error messages may appear: |
| 24055 | This article contains troubleshooting steps that you can use if error messages appear when you run any Microsoft Office 97 program or the Setup program on a computer that is running Microsoft Windows NT 4.0. |
| 24056 | The stand-alone version of Microsoft Access 97 comes with a registration card that has incorrect information for the Standard Support offerings. The registration card states the following: |
| 24057 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24058 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24059 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24060 | Many new Microsoft Access 7.0 and 97 users want to import data immediately from the systems they are currently using. The Import dialog box in Microsoft Access is designed to import one table at a time. Most of the time, this capability is enough.... |
| 24061 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24062 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24063 | : Requires knowledge of the user interface on single-user computers. |
| 24064 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24065 | When you run the Setup program for Microsoft Access 97 on a computer that also has Microsoft Access 2.0 or 7.0 and Microsoft Graph 5.0 installed, and you include the Microsoft Graph 8.0 components in the Setup options, any existing Microsoft Graph 5.0... |
| 24066 | This article shows you how to create a macro and a Visual Basic procedure to fax a report from Microsoft Access. The examples assume that you have Microsoft Exchange, Microsoft Fax, and a fax modem installed and functioning. NOTE: If your fax does not... |
| 24067 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24068 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24069 | This article shows you how to create a Visual Basic for Applications Sub procedure called GetFormDimensions to get a form window's right and down measurements so that you can use them in the MoveSize macro action. This article also demonstr |
| 24070 | This article shows you how to create a sample Visual Basic for Applications function to compute a moving average for a set of values in a table based on a given period of time. For example, if you have data that has been collected weekly fo |
| 24071 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24072 | This article show you how to use Automation to create and manipulate a Microsoft Excel Worksheet. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools... |
| 24073 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24074 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24075 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24076 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24077 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24078 | Advanced: Requires expert coding, interoperability, and multi-user skills. |
| 24079 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24080 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24082 | This article describes how to create an ActiveX DLL to prevent users from using the mouse wheel to scroll through records on a form. |
| 24083 | When you attempt to run a query, a form, or a report, you may receive one of the following error messages: |
| 24084 | This article explains how to use the Common Dialog API to replace the Common Dialog Box functionality that is included only with the Office 97 Developer Edition. |
| 24085 | Because Microsoft Access has a limit of 255 columns in a table or a query, you cannot export text files that must have more than 255 columns as you usually would. This article shows you how you can export text files (sometimes referred to a |
| 24086 | When you try to paste append a record into a form that has bound fields on a tab control, the following error message may appear: Some of the field names for the data you tried to paste don't match field names on the form. NOTE : This problem also... |
| 24087 | This article shows you how to use ODBCDirect to pass parameters to and return parameters from a SQL Server stored procedure. |
| 24088 | This article shows you how to create and how to maintain a log of users who open a Microsoft Access database. This includes the dates and the times that the users open the database. |
| 24089 | Advanced: Requires expert coding, interoperability, and multi-user skills. If you want to set up a many-to-many relationship between two tables, you need to set up a third table called a junction (or cross-reference) table, and then establish two,... |
| 24090 | When you run an action query by using Data Access Objects (DAO) and the Microsoft Jet database engine against an ODBC table, if you specify the dbFailOnError argument, the RecordsAffected property always returns 0, regardless of the number of records... |
| 24091 | This article shows you how to programmatically create an MDE file from an existing database. |
| 24092 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24093 | In the Totals row of the query design grid, you can choose the First() or Last() function to return the value of a specified field in the first or last record, respectively, of the result set returned by the query. However, these functions |
| 24094 | When you place a Hyperlink field in a report header or section header, it may not be displayed in the proper format. The text box is displayed with number signs (#), as shown below, instead of just "Display Text" or "Link to File or URL:" |
| 24095 | For special formatting considerations, you may want to include a Microsoft Word object on a Microsoft Access report. For example, you may want to give a user the ability to change the font size of a title without having to switch the report to design... |
| 24096 | This article shows you how to open a form and have it automatically load the most recently viewed record. |
| 24097 | Application must wait (duration=PageTimeout) before being able to see changes made by other applications to a Jet database, even when using the dbRefreshCache flag of the DBEngine.Idle method. |
| 24098 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24099 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24100 | This article describes and gives you examples of how to programmatically create, search, replace, and modify Visual Basic for Applications code within Microsoft Access 97. One of the most common uses for code that itself writes code is a wizard.... |
| 24101 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24102 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24103 | This article shows you how to create a sample user-defined procedure that enables you to cycle through the records in a combo box by using a double-click. |
| 24104 | This article shows you how to use automation to create and format a chart in Microsoft Excel 97. |
| 24105 | By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 95 or later, or Microsoft Windows NT 4.0 taskbar. This article shows you how to create the two functions that you need to hide and unhide the... |
| 24106 | Advanced: Requires expert coding, interoperability, and multiuser skills. In Microsoft Access 97, the .ldb file is used to determine which records are locked in a shared database and by whom. It is created automatically when any user opens a database... |
| 24107 | When you view the location of references with the Tools References dialog box, the trailing portion of the path name may be truncated because of the limitations of the dialog box. This article shows you how to use a Visual Basic for Applications... |
| 24108 | In the versions of Microsoft Access listed at the beginning of this article, if you use Data Access Objects (DAO) to open a recordset and don't explicitly close the recordset, DAO may hold onto the memory that it used for its previous compi |
| 24109 | Advanced: Requires expert coding, interoperability, and multi-user skills. This article shows you how to create sample Visual Basic for Applications code that creates Internet shortcuts from a Microsoft Access table that contains a Hyperlink field... |
| 24110 | Advanced: Requires expert coding, interoperability, and multi-user skills. |
| 24111 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to create a one-column Microsoft Access table whose records consist of hyperlinks that correspond to the Internet shortcuts in a folder. |
| 24112 | You can change the colors of a chart dynamically to correspond with the data in the current record of a form or a report, or to reflect special conditions of the data. During the Current, Format, and Print events, the data displayed in a chart is not... |
| 24113 | Every time you start Microsoft Access 97, the automatic registration feature registers Msaccess.exe, the supporting Microsoft Access .dll files, the wizards, and the file associations of .mdb and .mda files. This registration process occurs regardless... |
| 24114 | This article describes how you can create a procedure in Visual Basic for Applications that keeps an audit trail of the changes that are made to a record in a form. |
| 24115 | This article shows you how to export all modules in a database to text files. |
| 24116 | Advanced: Requires expert coding, interoperability, and multiuser skills. The Database Documenter does not enable you to view a report on a per user basis or to have a report that is grouped by users and groups display the permissions for the objects... |
| 24117 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24118 | If you use an input mask to format a field that contains phone numbers, but you choose not to store the formatting characters, the phone numbers in this field do not appear formatted when you use the table as the data source of a mail merge |
| 24119 | This article contains sample Microsoft Visual Basic for Applications code that determines the drive letter of the first CD-ROM drive and returns it to a variable as a string. It is then output to a message box. This would be useful for accessing files... |
| 24120 | The Database object provided by Microsoft Data Access Objects (DAO) has a Name property. However, this property returns the full path and the file name of the database. In order to retrieve either the path or the file name separately, you m |
| 24121 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24122 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24123 | At times, you may want to set the number of copies that print for a report without opening the Printer dialog box. You can do so by using the PrintOut method or action. This article shows you how to use the PrintOut method in a module to se |
| 24124 | This article shows you how to create a sample user-defined Visual Basic for Applications procedure that uses the PrtDevMode property to set different paper tray sources for the pages of a report. |
| 24125 | Microsoft Access has two built-in security features for protecting your database: User/Group accounts and permissions, and database passwords. |
| 24126 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24127 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24128 | When you run the Shell() function in a Visual Basic for Applications procedure, it starts an executable program asynchronously and returns control to the procedure. This shelled program continues to run independently of your procedure until |
| 24129 | You can use Automation to run a Microsoft Visual Basic for Applications Sub procedure that exists in a document of another Microsoft Office program. This article shows you how to run Sub procedures from four of the Microsoft Office programs that... |
| 24130 | You can use data access objects (DAO) to programmatically link a Microsoft Excel spreadsheet using Microsoft Visual Basic for Applications code. |
| 24131 | When you run a Visual Basic for Applications macro in any of the programs listed at the beginning of this article, you may receive the following error message: This program has performed an illegal operation and will be shut down. If the problem... |
| 24132 | Microsoft Access "Building Applications with Microsoft Access 97," Chapter 21, "Developing Applications for the Internet and the World Wide Web," page 620 states: |
| 24133 | This article shows you how to combine multiple child records into one record. In the following example, which uses the Northwind.mdb sample database, the SQL query passes the category name to the CombineChildRecords function. The function creates a... |
| 24134 | This article explains how to populate several text boxes with the selections made in a multicolumn combo box, and then save the contents of the text boxes as one record in a table. |
| 24135 | One alternative to displaying your application's online Help system in a separate window is to display it in a small, shaded pop-up window within your application. To do this, you can use the Windows API WinHelp() function with its HELP_CONTEXTPOPUP... |
| 24136 | Data corruption can occur when concurrently appending data from multiple instances of Microsoft Access to the end of a Memo field. Once corrupted, the field displays a |
| 24137 | This article explains how to recover a deleted or missing AutoFormat style in Microsoft Access. The procedure requires that you have a second copy of Access. The second copy can either be one that is installed on a different computer or one |
| 24138 | If you try to type text in a memo field, you may receive the following error message: |
| 24139 | In a Microsoft Access Jet 3.5 |
| 24140 | You can use the Find Unmatched Query Wizard to create a select query that finds records in one table that do not have related records in another table. |
| 24141 | When you try to connect to an Access database with the Visual Interdev Data View Window, you may receive the following error message: Can't Find Installable ISAM. You may also receive the following error message intermittently: Error Type: Provider... |
| 24142 | When you run a pass-through query, the last character is truncated. |
| 24143 | When you click |
| 24144 | Office programs close suddenly when you try to save or open (on the |
| 24145 | When you run a query, you may receive the following error message: Function isn't available in expressions in query expression. You may see a #Name error on forms and reports in controls that use an expression for the ControlSource property. This... |
| 24146 | If you try to type text in a memo field, you may receive the following error message: |
| 24147 | This article explains how to determine whether Microsoft Office 97 (SR-1) is installed. |
| 24148 | When inserting records into a Microsoft Access database, immediately attempting to reselect them occasionally does not return all inserted records. This occurs even when the records are inserted and reselected on the same connection. The problem... |
| 24149 | You can programmatically create toolbars and menu bars, as well as add and remove items from those bars. This article demonstrates how to do this. |
| 24150 | When you try to open a Microsoft Access 97 database, you may receive the following error message: |
| 24151 | This article shows you how to use Automation to send a Microsoft Outlook e-mail message to multiple recipients whose addresses are listed in a Microsoft Access table. This article also uses Microsoft Access form controls to add the message |
| 24152 | If you want to print a report to a particular printer, you can manually select the printer and all of the print options, or you can automate the process so that with a click of a button, you can switch printers and then print your report with the... |
| 24153 | This article shows you how to combine multiple child records into one record. In the following example, which uses the Northwind.mdb sample database, the SQL query passes the category name to the |
| 24154 | You can use the Find Unmatched Query Wizard to create a select query that finds records in one table that do not have related records in another table. |
| 24155 | This article explains how to recover a deleted or missing AutoFormat style in Microsoft Access. The procedure requires that you have a second copy of Access. The second copy can either be one that is installed on a different computer or one that is... |
| 24156 | This article explains how to populate several text boxes with the selections made in a multicolumn combo box, and then save the contents of the text boxes as one record in a table. |
| 24157 | When you try to create a system data source name (system DSN), you may receive the following error message: Unable to load msjter40.dll |
| 24158 | When you try to convert a Microsoft Access 2000 database to a Microsoft Access 97 database format, you may receive the following error message: |
| 24159 | When you use the New operator or CreateObject function in Microsoft Visual Basic to create an instance of a Microsoft Office application, you may get the following error message: Run-time error '429': ActiveX component can't create object |
| 24160 | When you reset a menu on a built-in menu bar using Microsoft Visual Basic for Applications code, none of the menu items are available. |
| 24161 | A Visual Basic for Applications procedure that uses ODBCDirect to create and populate a table in another Microsoft Access database also creates corrupted unique indexes in that table. This behavior occurs if the procedure performs the following steps... |
| 24162 | The Unload Statement Help topic included in the Microsoft Access 97 Help system does not apply to procedures that you create in Microsoft Access. Rather, it applies to procedures written in Microsoft Visual Basic version 5.0. |
| 24163 | This article shows you how to use Automation to create a Microsoft Word 97 mail merge document to insert merge fields, and then to run the merge. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft... |
| 24164 | If you use Microsoft Access and you link to the SQL Server Pubs_info table, by using the logo field, which is Image data, you cannot open the Image. This error occurs: A problem occurred while Microsoft Access was communicating with the ole server.... |
| 24165 | It is possible to connect to a remote Microsoft Access database from Active Server Pages on an IIS Web server. To do this, you need to set up your connection string just as you would if the database were on the local server as described in the |
| 24166 | When adding records to a Jet table, the user is allowed to enter empty strings even though the AllowZeroLength field property is set to False. |
| 24167 | While debugging your code that uses Automation to control Microsoft Access, you may receive one of the following errors. When automating Microsoft Access 95: MSACCESS caused an Invalid Page Fault in module MSACCESS.EXE at 0137:5000f878 -or- MSACCESS... |
| 24168 | There is no Automation method in the object model of Access that allows Visual Basic to open a secured Access database without getting a prompt requesting a username and password. However, it is possible to accomplish this using the Shell command. |
| 24169 | The utility program described in this article provides the developer with a tool to list the Visual Basic for Automation (VBA) routines stored in a Microsoft Access database (*.mdb). This tool provides a means for auditing databases and for locating... |
| 24170 | The easiest way to convert an Access database to SQL Server is to use the Upsizing Wizard. The Upsizing Wizard: Preserves database structure, including data, indexes, and default settings. Automatically converts Access validation rules and default... |
| 24171 | The "More Information" section of this article discusses how to troubleshoot floppy disk problems that you encounter during the Setup program for the Windows 95 applications listed at the beginning of this article. |
| 24172 | In Microsoft Access 97 on a computer running Microsoft Windows NT 4.0, you can only enter a maximum of 3 digits (instead of 5 digits) in the Pages From and To text boxes under the Print Range option group in the Print dialog box. On a computer running... |
| 24173 | When you save a Microsoft Access report to HTML format, the following problems may occur: |
| 24174 | In the retail version of Microsoft Access 97, you can't view the Visual Basic for Applications code for wizards. This special version of the wizards contains viewable wizard code for developers to use as a learning tool. |
| 24175 | When you make a change to the data in a form record, you find that the changed data is saved to the wrong record. |
| 24176 | When you try to open a database file, you may receive the following error message: Invalid database object. When you click OK , you receive the following error message: Microsoft Access couldn't create storage space for Visual basic module. When you... |
| 24177 | Novice: Requires knowledge of the user interface on single- user computers. |
| 24178 | When you design applications in Microsoft Access, you may want to modify the appearance of forms, manipulate the Microsoft Access application window, or display or hide objects for enhanced display. This article lists several Microsoft Know |
| 24179 | This article describes the differences between the MaxRecords property and the TopValues property. |
| 24180 | When you use the |
| 24181 | When you try to open an Access database after you install Microsoft Windows 2000, you may receive the following error message: |
| 24182 | This article shows you how to create a Visual Basic for Applications procedure to open a table, read the data, and find the statistical median. The median is a measure of central tendency, another "middle" of a data set, like the mean or av |
| 24183 | The Microsoft Knowledge Base contains a wealth of information about all Microsoft products and technologies. This article introduces you, the Access 97 user, to the Microsoft Knowledge Base and gives you tips to find the information and the technical... |
| 24184 | This article discusses and explains how COM (Component Object Model) determines which version of an Office application is loaded when you use Office Automation. |
| 24185 | If you decide to store the data for your solution in an Access database or in another relational database, designing the database structure is likely to be the most challenging part of building the solution. Although it is fairly easy to mo |
| 24186 | Microsoft Access 97 is available in two versions: a retail version and an upgrade version. The retail version will run on any computer that meets the system requirements for Microsoft Access 97. The upgrade version sells at a reduced price, |
| 24187 | The V35perf.exe file contains an overview of Microsoft Jet Database Engine version 3.5. The overview discusses the primary goal of Microsoft Jet Database Engine 3.5, benchmark timings, details on performance enhancements, and configurable performance... |
| 24188 | When you run the Setup program for Microsoft Access 97 on a computer that also has Microsoft Access 2.0 or 7.0 and Microsoft Graph 5.0 installed, and you include the Microsoft Graph 8.0 components in the Setup options, the following behavior occurs... |
| 24189 | After you install Microsoft Office 97 Professional Edition or Microsoft Access 97, if you still have Microsoft Access 7.0 on your computer the Blank Database icon in Microsoft Access 7.0 is missing. |
| 24190 | When you run the Microsoft Office 97 Setup program, the default folder that is used to store your documents is not changed. This is true even when you change the default folder for documents in the Microsoft Office Network Installation Wiza |
| 24191 | When you try to print a black line on a report, the line is not printed. However, if you view the report in Print Preview, you see the line. If you change the line's BorderColor property to a color other than black (0), the line is printed. This... |
| 24192 | This article shows you how to fill a ListView control on a form with the contents of a table or query. |
| 24193 | When you switch the focus away from a form in a Microsoft Access database, the Resize event occurs unexpectedly for the form losing focus. |
| 24194 | The Microsoft Office Developer Consulting Line is available for customers who need development assistance using Microsoft Office products. The cost is $195/hour. The customers can receive the following services: Technical support for developing... |
| 24195 | Novice: Requires knowledge of the user interface on single-user computers. |
| 24196 | This article shows you how to create a form for playing and recording sounds using the Windows Sound Recorder. The technique uses Visual Basic for Applications to open the Windows Sound Recorder and to control its functionality from Microso |
| 24197 | When you try to open a query, a form, or a report that calls a user-defined function, you may receive one of the following error messages: |
| 24198 | When you are automating an Office application from Visual Basic (VB), the Office application may display a dialog box. The dialog box causes the Visual Basic application to appear to stop responding (or hang) because VB is waiting for the dialog box... |
| 24199 | This article explains how you can examine the registry at run time to determine the installation path and version of an Office application. |
| 24200 | When you start Microsoft Access, you may receive the following error message: Microsoft Access can't change the working directory to Microsoft Access can't change the working directory to where is the path that appears as the default |
| 24201 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24202 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24203 | Novice: Requires knowledge of the user interface on single-user computers. |
| 24204 | Unexpected characters, specifically characters Chr(236) and Chr(10), appear approximately every 65th character in a Memo field in an imported dBASE IV database or Paradox database. |
| 24205 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24206 | This article shows you how to sort alphanumeric string values based on their numeric values. |
| 24207 | Novice: Requires knowledge of the user interface on single-user computers. |
| 24208 | You can display multiple fields in a combo box or list box on a form or report, even when those fields come from a table that is not bound to the form or report. You can also update controls, such as text boxes, with new information based o |
| 24209 | The insertion point in a multi-line text box does not move to the next line in the text box when you press ENTER; instead it moves to the next control in the tab order on the form. |
| 24210 | When you create a main report that has a subreport with snaking (multiple) columns, you will see the following behavior when you print or preview the report: In Microsoft Access 97 The report will only print one column of data for the subreport. In... |
| 24211 | By default, Microsoft Access displays the name of a form in the caption bar of the form. |
| 24213 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article describes how to start the Microsoft Access 97 and Microsoft Access 7.0 wizards by using Visual Basic for Applications. CAUTION: If you plan to create a custom... |
| 24214 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24215 | Database replication is a feature of Microsoft Jet database engine 3.0 and later that enables you to make special copies of databases (called replicas) so that users can work on their own copies at different locations. At a later time, users can... |
| 24216 | This article shows you how to create a sample, user-defined function that you can use on a multiple-page form that contains page breaks to determine which page of the form is current. |
| 24217 | Novice: Requires knowledge of the user interface on single-user computers. |
| 24218 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24219 | Novice: Requires knowledge of the user interface on single-user computers. |
| 24220 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24221 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24222 | To transfer data between two tables, you can create an additional field in one of the tables to store the common data, and then create an update query to accomplish the transfer. |
| 24223 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24224 | This article shows you how to substitute your own custom message for the generic error message that occurs when you violate an input mask. The generic error message for input mask violation is: |
| 24225 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24226 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24227 | This article describes how to create a constant number of lines per data group on a report. You can use this method to consistently print 15 lines per data group, regardless of the actual number of items within the group. Note that if the g |
| 24228 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24229 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24230 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24231 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24232 | This article shows you how to use the Circle method to create a filled-in "pie slice" on a report. |
| 24233 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24234 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24235 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24236 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24237 | Novice: Requires knowledge of the user interface on single-user computers. |
| 24238 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24239 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24240 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24241 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24242 | When you use a Microsoft Access or Microsoft FoxPro database in a Word document (for example, a Word mail merge), pictures in the database do not appear. |
| 24243 | This article shows you how to shade every other detail line on a Microsoft Access report. |
| 24244 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24245 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24246 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24247 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24248 | To speed up iterative (looping) processes through large numbers of rows in Visual Basic for Applications (or Access Basic in version 2.0), declare all field references explicitly. |
| 24249 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24250 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24251 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24252 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24253 | When you calculate using floating-point numbers, the result is not always what you expect. For example, if you use the CInt() (convert to integer) function in the calculation |
| 24254 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24255 | When you import a text file that contains tabs or other special characters into Microsoft Access, the special characters are converted and displayed as boxes. You cannot use the Find and Replace commands to find these converted characters. |
| 24256 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24257 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24258 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24259 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24260 | Data in a snapshot that includes a Memo or OLE field can be changed if the data in the underlying table for the snapshot changes. |
| 24261 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24262 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24263 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24264 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24265 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24266 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24267 | Novice: Requires knowledge of the user interface on single-user computers. |
| 24268 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24269 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24270 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24271 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24272 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24273 | Novice: Requires knowledge of the user interface on single-user computers. |
| 24274 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24275 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24276 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24277 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24278 | You can store large data objects (such as sound, video, or graphic data) in a field with the OLE Object data type in a Microsoft Access table. Some large binary data objects cannot be represented, however, if they do not have an OLE server |
| 24279 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24280 | Reports have a RunningSum property; forms do not. This article shows you how to create a running sum on a form. |
| 24281 | Novice: Requires knowledge of the user interface on single-user computers. |
| 24282 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24283 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24284 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24285 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24286 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24287 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24288 | This article demonstrates two methods that you can use to close Microsoft Access from a different application. The first method uses the Quit macro action to quit Microsoft Access over a dynamic data exchange (DDE) channel. The second metho |
| 24289 | This article shows you how to create a function to calculate the age of a person or thing based on a given date. |
| 24290 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24291 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24292 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24293 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24294 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24295 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24296 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24297 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24298 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24299 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24300 | When you try to log in to Microsoft SQL Server through ODBC by using Visual Basic for Applications code, the code that seems most direct does not trap ODBC login errors. Instead, it returns a connection failure error message. |
| 24301 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24302 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24303 | In some situations, you may want to delete multiple tables quickly, rather than to delete them one at a time. For example, when you import data from another product, an error table may be created. After many imports, there may be several er |
| 24304 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24305 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24306 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24307 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24308 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24309 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24310 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24311 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24312 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24313 | This article shows you how to create a sample user-defined Visual Basic function called AddAllToList(). You can use this function to add "(all)" as the first row of any existing combo box or list box control in a Microsoft Access applicatio |
| 24314 | In a Microsoft Access report, you can sum a column of numbers by group or over the entire report, but there is no built-in way to print the sum of a column on each page of a report. This article shows you how you can use code to print the s |
| 24315 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24316 | This article demonstrates how you can remove an entry from a list box or combo box after you have selected that entry. This technique uses a parameter query to delete the selected entry from the underlying recordset and then requeries the l |
| 24317 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24318 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24319 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24320 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24321 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24322 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24323 | This article shows you how to create a user-defined function to set the AllowZeroLength property to Yes for all the Text and Memo fields in every table in a database. |
| 24324 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24325 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24326 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article demonstrates two sample user-defined Visual Basic for Applications functions that you can use to pass parameters to an SQL pass-through query. This article assumes... |
| 24327 | This article shows you how to merge the current record in a Microsoft Access 7.0 and 97 object into a Microsoft Word 97 document, print it, and then close Microsoft Word 97. This article assumes that you are familiar with Visual Basic for Applications... |
| 24328 | This article shows you how to create a table of contents or an index for a report. |
| 24329 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24330 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24331 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24332 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24333 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24334 | When you attempt to print a page that requires more printer memory than the printer driver is configured for, you may receive the following error message: |
| 24335 | This article shows you how you can use a single, bound control for both finding records and for entering data in a form. You can use this technique to find whether the value entered in a field already exists in another record. If the value |
| 24336 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24337 | This article shows you how to use Visual Basic for Applications to open multiple instances of a form. Being able to open multiple instances of a form enables you to work on more than one record at once. For example, in an Order Entry applic |
| 24338 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24339 | This article shows you how to use a multiple-selection list box to restrict records in a recordset. The two methods described in this article are more flexible than other techniques, such as applying a query or an SQL WHERE clause because t |
| 24340 | When you attempt to start any of the programs listed at the beginning of this article, and your computer has less than 4 megabytes (MB) of free random access memory (RAM), you may receive various error messages that indicate that there is n |
| 24341 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24342 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24343 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24344 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24345 | When you use the /q switch to run a quiet mode installation of Microsoft Office for Windows 95, version 7.0 or Microsoft Office 97 for Windows from a CD-ROM, you receive the following error message: |
| 24346 | Advanced: Requires expert coding, interoperability, and multiuser skills |
| 24347 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24348 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24349 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24350 | Microsoft Jet Replication does not have a property that specifies whether a replica is the Design Master of a replica set. However, this article demonstrates how you can use Visual Basic for Applications to determine if a database is the Design... |
| 24351 | Microsoft Access has set the scope of procedures in form and report modules to be as consistent with object-oriented programming as possible. Variables in Microsoft Access class modules can be declared as Public in order to be available to other... |
| 24352 | Moderate: Requires basic macro, coding, and interoperability skills. A multiple-selection list box bound to a field in a form's underlying record source through the ControlSource property returns a Null value regardless of the selection or selections... |
| 24353 | This article describes how you can use the GetVersionEx() Windows API function to determine the version number of the operating system (Microsoft Windows NT or Windows 95) running on the computer. |
| 24354 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24355 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24356 | Microsoft Access does not have a command that sends information to the Clipboard. To post information to the Clipboard, you need to define a Visual Basic for Applications function that calls several Windows API functions. This article shows |
| 24357 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24358 | When you start Microsoft Access 7.0 or 97, you may receive the following error message. In Microsoft Access 97: Microsoft Access can't start because there is no license for it on this machine. -or- Can't find the database you specified or you didn't... |
| 24359 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24360 | This article demonstrates two techniques for creating a data entry form in ASP format. |
| 24361 | This article describes the resources and documentation available to you for automating Microsoft Office applications. This information can be applied regardless of the programming language you choose for automating an Office application. Th |
| 24362 | Microsoft Jet is the database engine that is used by default by Microsoft Access. This article provides a list of best practices that you can use to help keep your Jet database in top working condition. This article addresses a database running both... |
| 24363 | The Data Outline control is not included with the Microsoft Office 97 Developer Edition (ODE) as it is in the Microsoft Access Developer's Toolkit versions 2.0 and 7.0. The TreeView control enables you to display a hierarchical list of item |
| 24364 | This article contains a list of Microsoft Office Developer samples and tools that are available in the Microsoft Download Center. |
| 24365 | When you run Setup, you may receive one or both of the following error messages after all files have been copied to the hard disk on your computer. |
| 24366 | If you run a macro that uses objects from the Microsoft Remote Data Object 2.0 library, you may receive the following error message: Run-time error '429' ActiveX component can't create object |
| 24367 | Developers can use Automation to Microsoft Office to build custom solutions that utilize the capabilities and features that are built into the Office product. While such programmatic development can be implemented on a client system with relative... |
| 24368 | When timing code to identify performance bottlenecks, you want to use the highest resolution timer the system has to offer. This article describes how to use the QueryPerformanceCounter function to time application code. |
| 24369 | This article lists some of the resources that are available to help you learn Microsoft Visual Basic for Applications programming. The article contains the following categories: Online Help Microsoft Press and Third-Party Reference and Learning... |
| 24370 | This article contains a discussion of ASCII to EBCDIC conversion issues, translation tables, and code to translate from ASCII to EBCDIC and vice- versa. |
| 24371 | When you use Visual SourceSafe integration with Visual C++, you may experience significant performance loss under the following conditions: |
| 24372 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to use Automation to populate a list box with values from a Microsoft Excel worksheet. This article assumes that you are familiar with Visual Basic... |
| 24374 | When you start any of the programs listed at the beginning of this article, you may receive the following error message: |
| 24375 | This article lists some of the resources available on the Microsoft World Wide Web site that can help you get the answers you need to questions about Microsoft Access. |
| 24377 | This article contains information about troubleshooting and eliminating invalid page faults that occur in module Kernel32.dll when you work with a Microsoft Office program under Microsoft Windows 95. When a Kernel32.dll error message appear |
| 24378 | The Visual Basic for Applications help file for Microsoft Graph is included in the ValuPack folder on the Microsoft Office 97 compact disc. You can also download the same help file (Vbagrp8.exe). The following file is available for download from the... |
| 24379 | This article shows you how to use Automation to manipulate a Microsoft Project for Windows 95, version 4.1a (*.mpp) file. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications... |
| 24380 | This article contains information about troubleshooting and eliminating invalid page faults that occur in module Kernel32.dll when you work with a Microsoft Office program under Microsoft Windows 98. A Kernel32.dll message will be similar t |
| 24381 | When you set the Window Color to black and the Font Color to white in Control Panel instead of accepting the default white Window Color and black Font Color, and then you output a Microsoft Access report to Microsoft Word or Microsoft Excel, the... |
| 24382 | This article shows you how to use Automation to print a Microsoft Word document that you are working with in a Microsoft Access function or in a Microsoft Access form's object frame. This article assumes that you are familiar with Visual Basic for... |
| 24383 | This article shows you how to use Automation in Microsoft Access to open a Microsoft Word 97 document and to move to a specific location in the document. For information about how to move to a specific location in a Microsoft Word version 6.0 or 7.0... |
| 24384 | This article discusses what is necessary to take advantage of ActiveX Data Objects (ADO) with Microsoft Access 95 and 97. |
| 24385 | This article lists the minimum security settings that are required to connect to a remote Microsoft Access database from ASP.NET, including: Windows NT File System (NTFS) settings Microsoft Internet Information Services (IIS) settings Local security... |
| 24386 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24387 | This article explains how to retrieve the Database window if the Database window seems to be lost or is hidden from view. |
| 24388 | When you attempt to preview a report, open a report in Design view, or gain access to the page setup properties of a report, you may receive an error message that is similar to the following error message: |
| 24389 | There are a number of reasons corruption can occur in a Microsoft Access database. This article provides a list of references to Microsoft Knowledge Base articles that may assist you in resolving corruption in your database. |
| 24390 | When you try to create a blank database in Access 97, the following error message may appear: |
| 24391 | This article demonstrates how to reset a report's page-numbering scheme and the total page count so that each new group of pages starts with "1." |
| 24392 | When you try to access the |
| 24393 | When you run an append query, you may receive the following error message: Microsoft Access can't append all the records in the append query. Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 0 records to the... |
| 24394 | The More Information section of this article contains sample Microsoft Visual Basic for Applications code that calls WNetGetUser (a Windows API function in the file Mpr.dll) to retrieve the user name used to establish a network connection. |
| 24395 | In Microsoft Visual Basic for Applications, you can create a dimensioned array, such as A(6,6), that is available to all procedures in all modules. This article includes sample Visual Basic for Applications routines that demonstrate how this can be... |
| 24396 | This article shows you how to use Automation to create a Microsoft Graph object on a Microsoft PowerPoint 97 slide from Microsoft Access 97 by using a Microsoft Access table. This article assumes that you are familiar with Visual Basic for... |
| 24397 | If you start Microsoft Access minimized and automatically load a database that contains an AutoExec macro that opens a form that has its AutoCenter or AutoResize property (or both properties) set to Yes, the form's size and location may be |
| 24398 | This article explains how to dynamically populate a list box that is based on table data or database object names. |
| 24399 | This article explains how to import or link Lotus Approach (.apr) files in a Microsoft Access database. |
| 24400 | In Microsoft Access (and other Microsoft Office applications), you can use the Shell command in Visual Basic for Applications (VBA) code to start another application. Although you can start most applications in this manner, there are some applications... |
| 24401 | When you attempt to compact or convert a database file (.mdb or .mde), one of the following error messages may appear: |
| 24402 | When you try to start Access 97 as a Microsoft Windows 2000 or Microsoft Windows NT 4.0 Terminal Server Edition client, Access may not start, and you may receive one of the following error messages: |
| 24403 | When you create a report that has the Detail section's |
| 24404 | When you edit a field on a subform that has a linked SQL table as its record source, and you try to edit a field on the main form that is based on the same linked SQL table, you may receive the following message: |
| 24405 | When you try to open a Microsoft Access database, you may receive the following error message: Disk Error -- Reserved error (-1601) NOTE: Compacting and repairing the database does not resolve the issue. |
| 24406 | This article explains how to base the background color of a text box on a value that is determined by a report at run time. |
| 24407 | When you try to use the Access 97 Office Links wizards, you may receive the following error message: |
| 24408 | This article describes how to create a Visual Basic module (PrintDevMode) to format a report so that you can print or preview the report in Landscape mode on legal-size paper. The instructions in the article include code for a command butto |
| 24409 | When you try to use the Expression Builder in Microsoft Access, the Expression Builder may not work as expected. |
| 24410 | When you try to start Access 97, the following error message may appear: |
| 24411 | When you are working in an application that connects to a Microsoft Access database on a Novell file server, and you try to delete a large block of records (for example, more than 5,000) from a table, you may receive the following error mes |
| 24412 | When you click a tab in a Tab control on your form in Microsoft Access, the form may scroll downward so that the tabs are no longer visible. |
| 24413 | This article describes how you to use Data Access Objects (DAO) to import all objects from one Microsoft Access database into the current Access database. In some situations, this code can be used to recover database objects from a corrupte |
| 24414 | When you run the English versions of both Microsoft Access and your computer's operating system, you may receive Jet error messages in another language. |
| 24415 | When you try to link or embed a Word document, you may receive one of the following error messages: |
| 24416 | When you attempt to install Snapshot viewer 9.0, you receive the following error message: |
| 24417 | If you remove Microsoft Office 2000 from your computer and then install Microsoft Access 97 or earlier, you may receive the following error message when you attempt to start Access: |
| 24418 | When you use a Microsoft Excel worksheet as a Data Access Object (DAO) data source for Microsoft Access, you may receive an error message similar to the following: |
| 24419 | This article explains how users with different versions of Microsoft Access can share the same data. |
| 24420 | In Microsoft Access, if you import data by using an indexed sequential access method (ISAM) driver, you may receive the following error message: ActiveX component cannot create object You may receive this error message regardless of the data type... |
| 24421 | When you use the Send command on the File menu, the SendObject method, or the SendObject action, you may receive the following error message: Microsoft Access can't open the mail session. Check your mail application to make sure that it's working... |
| 24422 | When you export a report that contains a Memo field to an RTF format file, the data of the Memo field may be truncated. Furthermore, when you view the file in a word processor, the last pages of the file may contain random fragments of the |
| 24423 | When you open a database, you receive the following error message: |
| 24424 | You receive the following write conflict error when you try to update records in a linked SQL Server table: |
| 24425 | Microsoft Access has no built-in method for disabling the Close button (x) on the application window or the Close command on the System menu of the application window. This article describes how to programmatically disable both of these elements. |
| 24426 | A JPEG file that you are linking is displayed as an icon when you view it in an OLE Object field on a form. |
| 24427 | When you open a linked Microsoft SQL Server 7.0 table in a Microsoft Access database, you notice that a field has #S_C_H# in it instead of the actual data. |
| 24428 | In a Microsoft Access 97 database, you can display barcodes on forms and reports. You would most commonly use this display functionality on reports, but the formatting instructions are the same for forms, and they depend on how the data was |
| 24429 | When you are working with a Microsoft Access 97 MDE database, you may receive one or more of the following errors: |
| 24430 | This article shows you how to share a secured Microsoft Jet database on a network. For a group of users to gain access to a secured database, the users must join the same workgroup information file. In Access 2.0, the workgroup information |
| 24431 | When you double-click a database file on a Novell NetWare server, you may receive the following error message |
| 24432 | In Visual Basic for Applications code, when you try opening a table or query from a secure database with the |
| 24433 | When you try to convert or import data from an unsecured Microsoft Access database created in an earlier version of Access into Access 97, you may receive one of the following error messages: |
| 24434 | If you try to use the Import Spreadsheet Wizard to import a Microsoft Excel worksheet into an existing Microsoft Access 97 table, you may receive the following error message: |
| 24435 | This article discusses the causes of fatal system errors in Microsoft Access 97 and 7.0, and provides general troubleshooting steps for solving them. NOTE : This is a general article, and there may be a specific article that addresses the exact error... |
| 24436 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article provides information and examples on how to use Microsoft Access 7.0 or 97 as an Automation server. With Visual Basic for Applications, you can manipulate the... |
| 24437 | This article presents the guidelines that Microsoft Product Support Services (PSS) support professionals follow when supporting Microsoft Access customers and also lists support options available for Microsoft Access. |
| 24438 | Advanced: Requires expert coding, interoperability, and multiuser skills. |
| 24439 | Moderate: Requires basic macro, coding, and interoperability skills. |
| 24440 | When you run the Setup program for one of the programs listed at the beginning of this article from floppy disks, after you remove Disk 1, insert Disk 2, and press ENTER, Setup repeatedly prompts you to insert Disk 2 again. |
| 24441 | When you use Microsoft Access, you receive the following error message: |