| 18731 | Issues that you may encounter when you open or are using a Microsoft Office Access database on a computer that is running Windows Vista |
| 18732 | Description of the security update for Office 2000 and for Project 2000: February 13, 2007 |
| 18733 | Description of the security update for Office 2000, for Office 2000 MUI, and for Project 2000: February 13, 2007 |
| 18734 | A table field appears incorrectly in Datasheet view when you add the field by using the Microsoft DAO Object Library and you set the OrdinalPosition property in Access |
| 18735 | You cannot import the data from a comma-delimited text file by using the Import Text Wizard in Office Access 2003, in Access 2002, or in Access 2000 |
| 18736 | Users experience problems when they try to use Internet Explorer or a shortcut to open an Access database if the database is already opened by a user |
| 18737 | Description of the Jet 4.0 Database Engine post-837001 hotfix package: April 12, 2005 |
| 18738 | Description of the security update for Office 2000: October 10, 2006 |
| 18739 | Description of the Jet 4.0 Database Engine post-837001 hotfix package: May 11, 2006 |
| 18740 | Description of the security update for Office 2000: August 8. 2006 |
| 18741 | Description of the security update for Office 2000, for Access 2000 Runtime, and for Project 2000: August 8, 2006 |
| 18742 | Description of the security update for Office 2000 and for Project 2000: July 11, 2006 |
| 18743 | Description of the security update for Office 2000: July 11, 2006 |
| 18744 | MS06-038: Vulnerabilities in Microsoft Office could allow remote code execution |
| 18745 | A file does not open in the program that you expect when you try to open the file in Office |
| 18746 | After you install the Access 2000 and SQL Server 2000 Readiness Update and try to run the Upsizing Wizard, the Linked Table Manager, or the Add-in Manager, you receive the following error message: Microsoft Access can't find the wizard, or there... |
| 18747 | Provides a step-by-step description on how to use the Query by Form technique in Access 2000. You are also shown some samples to show you how to filter data by QBF parameter criteria. |
| 18748 | Describes that you can use a form to specify the criteria for a query and use the QueryDef object to dynamically create the query in Access 2000. You can see a demonstration of the technique in a downloadable sample. |
| 18749 | You receive an error message when you start Visual Basic for Applications code in an Access database |
| 18750 | #Deleted is displayed in the records when you open a linked ODBC table from an Oracle 10g database in Access 2003, in Access 2002, or in Access 2000 |
| 18751 | When you export a data definition query or a SQL pass-through query to HTML format, you may receive the following error message: Microsoft Access The command or action 'OutputTo' isn't available now. You may be in a read-only database or an... |
| 18752 | When you use the Lookup Wizard in Design view of a given 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... |
| 18753 | When you run a query, you may receive the following error message: The Microsoft Jet database engine cannot find the input table or query 'Table1'. Make sure it exists and that its name is spelled correctly. When you open the query in Design view,... |
| 18754 | Jet 4.0 data engine update fixes issues that may occur on a Windows XP-based computer |
| 18755 | How to troubleshoot video issues in Office programs |
| 18756 | You are unexpectedly prompted to restart the computer after you install an Office service pack or an Office update |
| 18757 | Custom changes that you made in the HKEY_CLASSES_ROOT subtree are overwritten after you update or repair the Office installation |
| 18758 | How to troubleshoot problems that you may experience when you try to activate an Office product |
| 18760 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). When you try to open a table in Design view, you may receive the following warning message: You can't open... |
| 18761 | 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. In a mail merge,... |
| 18762 | 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... |
| 18763 | Describes that you may receive A program is trying to automatically send e-mail on your behalf message when you run the SendObject macro action. Or, you may receive a run-time error '2293' when calling the SendObject VBA method in Access. |
| 18764 | Describes a problem in Office Access where you receive an error message when you run a query. Or, you do not receive an error message but a Memo field is truncated to 255 characters. |
| 18765 | In Access 2000, if you have not installed the Microsoft Data Engine (MSDE), you can still create Microsoft Access projects and connect to Microsoft SQL Server databases on other computers through a network connection; however, the dialog box for... |
| 18766 | When you export a table from Microsoft Access to Microsoft SQL Server, you may receive the following error message [Microsoft][ODBC SQL Server Driver][SQL Server] CREATE TABLE permission denied, database database, owner owner [#262] where... |
| 18767 | 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. By setting the AllowZeroLength property, you can control whether a zero-length... |
| 18768 | When a SQL Server System Administrator tries to import or link SQL Server tables to a Microsoft Access database, the administrator can see most of the SQL Server tables, but not the system tables. The System Objects check box in Microsoft Access... |
| 18769 | Describes how to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients. |
| 18770 | 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... |
| 18771 | When you open a Microsoft Access 97 database in Microsoft Access 2000, and if the database password has 14 or more characters, you may receive the following error message: Not a valid password. To work around this behavior, follow these steps:... |
| 18772 | 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 following error message: This Recordset is not updateable. If the form is... |
| 18773 | 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... |
| 18774 | 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. |
| 18775 | When you print a form or a report that contains a subform/subreport that calls an ApplyFilter macro action in its OnOpen event, you receive the following error message: The action or method is invalid because the form or report isn't bound to a table... |
| 18776 | When you run code that uses the OldValue property of a control on a form, you may receive the following error message: Run-time error '3251': Operation is not supported for this type of object. |
| 18777 | 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. This article describes a method... |
| 18778 | When you import data into an existing Microsoft Access table that has default values specified for certain fields, the default values will not be used to populate any blank fields for the imported data. |
| 18779 | When you open a form or a report, you may see the following behavior: #Error or #Name? is displayed in a text box in the form footer. A parameter box prompts you for the field that is specified in a sum expression within a report. |
| 18780 | When you run a procedure from an object's events, you may receive the following error message: The expression [event name] you entered as the event property setting produced the following error: The expression you entered has a function name that... |
| 18781 | An update query that tries to update more than one table may yield unexpected results. |
| 18782 | When you click the Subform Field Linker Build button next to the LinkChildFields or LinkMasterFields property of a bound subform property sheet, you may receive the following error message: Can't build a link between unbound forms. |
| 18783 | Novice: Requires knowledge of the user interface on single-user computers. If you output a report from Microsoft Access to another file format, such as .rtf, .txt, .xls, or .html, an OLE object that has been inserted into the report does not appear. |
| 18784 | This article shows you 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-many... |
| 18785 | When you click Options on the Tools menu, some of the option items are not visible. |
| 18786 | When you open a main form that has a subform, and the subform contains a hyperlink, the hyperlink appears to be active. However, if you click the hyperlink to follow it, nothing happens. |
| 18787 | When you try to save a table that has a field name, control name, or user-defined function in a validation rule, you may receive the following error message: Invalid SQL syntax - cannot use multiple columns in a column-level CHECK constraint. |
| 18788 | When you create a totals query that uses the SQL aggregate (totals) functions First () or Last () on a Hyperlink field, the query results do not display a usable Hyperlink field. Instead, you see the Displaytext, Address, and Subaddress portions of... |
| 18789 | The AllowZeroLength property determines whether a zero-length string () is a valid entry. The Required property determines whether a Null value is a valid value. Although these two properties work together, the AllowZeroLength property overrides the... |
| 18790 | When you run a query or add a field to a query in an unreplicated database, you may receive the following error message: The Replication ID you entered is invalid. |
| 18791 | Novice: Requires knowledge of the user interface on single-user computers. 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... |
| 18792 | When you click in a text box that has a defined InputMask property, the insertion point remains where it was in the text box when you clicked the mouse button instead of moving to the beginning of the text box. This behavior occurs whether there is... |
| 18793 | Novice: Requires knowledge of the user interface on single-user computers. When trying to reference the properties of an ActiveX control on a form from the Expression Builder, the properties of the ActiveX control do not appear in the list of... |
| 18794 | This article demonstrates a shortcut method for creating an SQL union query using a second scratchpad query to create the second half of the SQL UNION statement. |
| 18795 | When you try to delete the Admin user, you may receive the following message: Are you sure you want to delete this account? You can't undo the deletion of a user or group account. To restore a user or group account that has been deleted, you must... |
| 18796 | If you place controls on an ActiveX tab control in any area except the page area, you cannot see the control in Form view. |
| 18797 | Lists some useful sample expressions that you can commonly use to extract a portion of a text string. For example, you can use it in the Update To line of an update query to place a portion of a larger field into a new field. |
| 18798 | When you set the options for Datasheet view of a table, query, or form on the Datasheet tab of the Options dialog box (Tools|Options), you can change the color of the gridlines. The color that you select is visible on your screen in Datasheet view;... |
| 18799 | When you click No to installing the sample database Northwind.mdb, you receive the following error message: Microsoft Access can't find the database file 'Northwind Sample Database.mdb.' Make sure you entered the correct the path and file name. |
| 18800 | Novice: Requires knowledge of the user interface on single-user computers. When you are viewing a linked Microsoft Excel table, you see #Error in all of the data fields. If you try to edit the table at this point, you receive the following error... |
| 18801 | 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... |
| 18802 | When you copy and paste a linked table, the resulting new table is also a linked table. This occurs if you use the Copy and Paste commands on the Edit menu, the Save As command on the File menu, the TransferDatabase (with the option to import) macro... |
| 18803 | When you add a control to a data access page or set the ControlSource property of a control on a data access page, you may receive the following error message: Caption and record navigation section cannot contain bound fields. The control remains in... |
| 18804 | When you use the MSDatashape provider to create a hierarchical recordset, and you then assign the recordset to a subform, you may receive the following error message: Run-time error '2147417848 (80010108)': Method 'Recordset' of object '_Form_form... |
| 18805 | When you apply a filter or a sort to a form and then click Remove Filter/Sort on the Records menu, it appears that the filter or sort has been removed. However, if you check the Filter property and OrderBy property in a Visual Basic for Applications... |
| 18806 | This article shows you how to create a running sum per group in a Microsoft Access query. |
| 18807 | If you export a module to or import a module from another Microsoft Access database or project, or if you drag a module from one instance of the Visual Basic Editor to another instance of the Editor, you may receive the following error message: This... |
| 18808 | You cannot use the acOLEDelete argument of the Action method to clear an unbound object frame. |
| 18809 | When you import a table into a Microsoft Access project, you may not get the number of records that you expect. |
| 18810 | You are unable to insert the Microsoft DataCombo or DataList ActiveX controls into Microsoft Access forms and reports. |
| 18811 | Describes how to troubleshoot printing problems in Windows 2000. |
| 18812 | If you have used Microsoft Jet database engine security to assign a password to the Admin account, and you then try using a wizard or an add-in in a Microsoft Access project (ADP) file, Microsoft Access may prompt you with a logon dialog box. After... |
| 18813 | Describes that Conflict Viewer does not list the tables in synchronization conflicts between the replicas of an Access database. This occurs if one of the replicas in the replica set is corrupted. Resolve the conflict manually. |
| 18814 | Explains that initiating Internet synchronization may cause an error when the Internet server computer is on a local area network that uses a Network Address Translation router. Edit the hosts file on the Internet server computer to fix the problem. |
| 18815 | This article demonstrates how to create a Visual Basic for Applications procedure that uses the DLookup() function to check for duplicate values in a field before you leave that field. |
| 18816 | When you try to save design changes that you made to a Microsoft Access object that contains a module (form, report, or standard module), it may take longer to save the object than it did in earlier versions of Microsoft Access. This is especially... |
| 18817 | Although you chose to keep an earlier version of Microsoft Access on your computer when you installed Microsoft Access 2000, Microsoft Access overwrote your existing Microsoft Access shortcut, instead of creating a new Microsoft Access 2000 shortcut. |
| 18818 | On the Microsoft Windows Desktop, if you use the shortcut menu to create a new Microsoft Access application, Microsoft Access is started, but you can only choose MDB in the Files of Type box. You can not use this method to create new data access pages... |
| 18819 | A Microsoft Graph object appears as empty or blank in Form view. |
| 18820 | When you run a query based on a linked 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 recordset. |
| 18821 | This article shows you how to prepare data in a Microsoft Access database so that you can use it in a mail merge in WordPerfect for Windows or WordPerfect for DOS. |
| 18822 | This article contains definitions for the most frequently used terms in an Access database environment. |
| 18823 | In a Microsoft Access project, the Encrypt/Decrypt Database command is not available (on the Tools menu, point to Security ). |
| 18824 | This article describes how you can open a connection to a Microsoft Exchange or to a Microsoft Outlook mailbox by using ActiveX Data Objects (ADO) and the Jet OLE DB provider. |
| 18825 | Event procedure code does not run when you expect it to. |
| 18826 | When you convert or open a database created with an earlier version of Microsoft Access, you may receive one or more of the following error messages. The form or report form name has too many controls. Reduce the number of controls on the form or... |
| 18827 | Novice: Requires knowledge of the user interface on single-user computers. When you run an action query and respond to the prompt to commit the changes by clicking No , the changes are committed anyway. |
| 18828 | When you select a form or report wizard, the wizard's move buttons are not available (dimmed) and no fields appear in the Available Fields list when you select the form or report wizard. |
| 18829 | When you make a design change to a data access page from within an e-mail message, the change is not saved to the page in the database. You do not get a prompt to save the page or a warning that you will lose the change. |
| 18830 | When you try to add a list box or drop-down list box to a data access page, you may receive the following error: The Wizard will only run when your current database is the datasource for your page. |
| 18831 | If you output the data in a report, the only controls that are included in the output file are text boxes (for .xls output files), or text boxes and labels (for .rtf, .txt, and .html output files). All other controls are ignored. This article show you... |
| 18832 | When you try to open a Microsoft Access table in Design view, you may receive the following message: You can't open the table 'tablename' for modification. A query or form bound to the table is open, you may not have permission to open this table in... |
| 18833 | You can store date values in a Microsoft Jet 4.0 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 4.0... |
| 18834 | You find that you cannot delete, update, or insert new records in a table in an Access project. |
| 18835 | Novice: Requires knowledge of the user interface on single-user computers. In the Customize dialog box, the option Standard and Formatting toolbars share one row on the Options tab is dimmed. This option is never selectable because Access does not... |
| 18836 | When you use Microsoft Access Help, you can't seem to find any information about built-in functions, about properties, or about methods of objects or collections. -or- When you use Microsoft Access Help, you find Help topics that seem to be related to... |
| 18837 | Microsoft Access supports in-place activation of OLE objects in a form's Form view. Also, in a form or report's Design view, activation of an OLE object causes the object's original application to run in the background as a server application (if the... |
| 18838 | When you click Paste Special on the Edit menu after copying a picture to the Clipboard, the Paste Special dialog box displays the following two choices for Device Independent Bitmap (DIB) Picture (Device Independent Bitmap) Device Independent Bitmap... |
| 18839 | Although the spelling checker has been installed correctly, it ignores misspelled words. |
| 18840 | This article describes a method that you can use to control the number of records printed per page in a report. |
| 18841 | This article shows you how to print a variable-length character string. You can use this method to print a dotted line (or a line composed of the character of your choice) between two fields of variable length on a report. |
| 18842 | When you set the Visiblity property of a control on a data access page to Hidden , the associated label for that control remains visible. |
| 18843 | When you use the Label Wizard to create labels in Microsoft Access, you are not able to move field names to the next line of the label by pressing ENTER or ALT+ENTER. |
| 18844 | When you try to open a Home page by clicking the Start Page button on the Web toolbar in Microsoft Access, you may receive the following error message: Unable to open http://. Cannot connect to the Internet server. |
| 18845 | When you add an option button to a data access page as a stand-alone control, you are not able to select the button by default. For an option button to work correctly, you must set a value for both the ID and Name properties. When you create an option... |
| 18846 | This article shows you how to start another application from a Microsoft Access data access page. |
| 18847 | If you have versions of Microsoft Access earlier than Access 2000 on the same computer that you install Microsoft Access 2000 on, you may see templates used for creating legacy databases when you create a new database in Access 2000. When you try to... |
| 18848 | When you click Quick View in the Microsoft Script Editor to view a data access page, the onbeforeunload window event is not executed. |
| 18849 | Microsoft Access or Microsoft Internet Explorer unexpectedly quits when you browse to a data access page that tries to reference the PreviousSection property. |
| 18850 | 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... |
| 18851 | Microsoft Replication Manager is a tool included with Microsoft Office 2000 Developer. An important feature of Microsoft Replication Manager is its ability to manage members of a replica set and schedule synchronizations between them. One of the... |
| 18852 | This article describes how you can start another application from a text box on a Microsoft Access form. NOTE : This article explains a technique demonstrated in the sample file, FrmSmp00.mdb. For information about how to obtain this sample file,... |
| 18853 | Novice: Requires knowledge of the user interface on single-user computers. You cannot save a blank, new record in a table or form. |
| 18854 | When you open a table, a query, a form, or a report, you may see any of the following error values: #Error #Num! #Name? #Div/0! #Deleted #Locked Microsoft Access places one of these error values in a field when it cannot find necessary information,... |
| 18855 | When you open a form that contains a subform or a report that contains a subreport, you may receive an unexpected prompt to enter a parameter value. |
| 18856 | When you import a text file by using the TransferText method or action with an import specification that applies indexes to a field, the resulting table does not contain the expected indexes. |
| 18857 | Moderate: Requires basic macro, coding, and interoperability skills. 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. |
| 18858 | This article shows you how to create a label that prints 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 page... |
| 18859 | This article lists several things that you can do to improve the speed and performance of your subforms. |
| 18860 | When a Microsoft Word Mail Merge document displays AutoLookup fields from a table, the fields do not return the AutoLookup values as expected. |
| 18861 | You you try to use the GoToControl method or the SetFocus method in the AfterUpdate event of a control to set focus back the control that is being updated, the GoToControl or SetFocus method will be ignored. For example, the following code, will not... |
| 18862 | If you type a value into a field whose data type is Single, and that value is greater than what the Single data type allows, you do not receive a warning message. Instead, Microsoft Access automatically replaces the value that you typed with the... |
| 18863 | In Microsoft Access, you can import a named range from a Microsoft Excel worksheet. However, you cannot import a named range limited to a single cell. |
| 18864 | Novice: Requires knowledge of the user interface on single-user computers. When you use the Database Wizard to create a database, optional fields are not added to the database. You must manually select optional fields before the wizard includes them. |
| 18865 | When you use the Lookup Wizard to create a field that looks up or lists values from a table, and the first field name in the lookup table has the same field name as the Lookup field that you are creating, you may receive the error message: You already... |
| 18866 | Certain shortcut keys that you use in Microsoft Access databases (.mdb files) do not function as expected when you use them in Microsoft Access projects (.adp files). |
| 18867 | You may have a need to copy an existing database from Microsoft SQL Server 7.0 and to place the database on another computer that is running Microsoft Data Engine (MSDE). This article describes how to do so. To summarize, the process involves... |
| 18868 | After you hide a module in the Microsoft Access Database window by setting its Hidden property, you can see the module in the Project Explorer in the Microsoft Visual Basic Editor. |
| 18869 | 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... |
| 18870 | Microsoft has added database passwords, security account passwords, and Visual Basic for Applications (VBA) passwords to Microsoft Access so that you can prevent unauthorized access to important information. If you are unable to access database... |
| 18871 | When you try to create a Microsoft Access report by using the Microsoft Access Report Wizard, you may receive the following error message: STOP 0x0000001E (KMODE_EXCEPTION_NOT_HANDLED) |
| 18872 | When you run a union query with two linked Microsoft Visual FoxPro tables, you may receive the following error message: ODBC call failed [Microsoft] [ODBC Visual F(#200)] |
| 18873 | The Microsoft Access Expression Builder is not available in the Visual Basic Environment. |
| 18874 | When you start the Internet browser by clicking a hyperlink in Microsoft Access, the Microsoft Access window is minimized. |
| 18875 | When you use the Visual FoxPro ODBC driver, you are unable to export to any folder except the default database folder. When you try to export to any other folder, you receive the following error message: The Microsoft Jet database engine could not... |
| 18876 | This article shows you how to sum calculations in a Microsoft Access data access page. |
| 18877 | When you create a database diagram in a Microsoft Access project, it is not stored on SQL Server or Microsoft Data Engine (MSDE) as an object (as a table, a view, or a stored procedure would be). Database diagrams are dynamically rendered, based on... |
| 18878 | After you install the Microsoft Data Engine (MSDE) on a computer running Microsoft Access 2000, you are unable to use the following menu commands in a Microsoft Access project: Database Security Synchronize Now Create Publication Pull Subscription... |
| 18879 | This article describes how to find the version of catalog stored procedures in Microsoft SQL Server. |
| 18880 | After you create a query with the Simple Query Wizard in Microsoft Access, 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>] =... |
| 18881 | If you try to insert the HHCtrl.ocx ActiveX control into a Microsoft Access form, you may receive the following error message: The operation on the OLE object failed. The OLE Server may not be registered. To register the OLE Server, reinstall it. |
| 18882 | This article explains how to create a Data Access Page that is linked to an Access database in a FrontPage web. |
| 18883 | If you include the number sign (#) character in a hyperlink file name, the hyperlink URL is truncated after the number sign. When you click the hyperlink, you may receive the following error message: Unable to open <file name>. Cannot open the... |
| 18884 | When you declare a fixed-length string variable that is larger than 65,535 bytes, the following message appears: Compile error: Invalid length for fixed-length string |
| 18885 | This article shows how to use Visual Basic for Applications to change the title bar text, which is also referred to as the Application Title. |
| 18886 | When you enter a hyperlink address in the Criteria cell of a query to return all the records that are associated with that hyperlink, no records are returned. This happens even though records in the table appear to meet the criteria that you specified. |
| 18887 | Certain actions you perform in the DblClick event of a form control do not appear to do anything. For example, if you set the OnDblClick property of a text box control to a macro or Visual Basic procedure that is supposed to select all of the text in... |
| 18888 | When you run or compile a procedure in a Microsoft Access database that references a field that has the same name as a data access method of a Recordset object, you may receive one of the following error messages: Expected Function or variable -or-... |
| 18889 | 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. |
| 18890 | If you format data in a table with a bold font style, and you then export the table from Microsoft Access to Microsoft Excel by using the Analyze It with MS Excel command or by clicking Export on the File menu, the bold font style is replaced by a... |
| 18891 | 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. If you have a query open in either Datasheet or Design view when you document it with the Documenter, you... |
| 18892 | This article explains the importance of synchronizing all the databases in a replica set before you make schema changes in the Design Master database. |
| 18893 | The information in this article applies to a database that you create 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... |
| 18894 | 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. |
| 18895 | Novice: Requires knowledge of the user interface on single-user computers. When you press F1 after starting any of the following Add-ins Add-In Manager Database Splitter Linked Table Manager you receive the following error message: Cannot find the... |
| 18896 | When you click the navigation control on a data access page and use the Font box on the Format toolbar to change the font, the FontName property of the navigation control is not updated to reflect the font change that you made. |
| 18897 | A text box control does not display text in the color that you specified. Instead, the text is displayed as if you had not specified any color. |
| 18898 | 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... |
| 18899 | If you turn off system messages with a SetWarnings macro action, system messages remain off only while that macro or set of macro actions is running. |
| 18900 | This article shows you two techniques that you can use to limit the number of characters that can be typed in an unbound text box on a form. |
| 18901 | This article describes how you can remove duplicate records from a table by using primary keys. By using this method, you can check for duplicate values in up to 10 fields in the table. |
| 18902 | When you set the RowSourceType property of a bound or unbound object frame, you may receive a message similar to one of the following error messages, depending on the type of OLE object that is contained in the frame: For Microsoft Excel charts: The... |
| 18903 | The Pages option button of the CommonDialog ActiveX control is unavailable when the Flags property is set to cdlPDPageNums . |
| 18904 | When you type 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: Field cannot be updated. or Multiple-step operation generated errors. Check each status value. When you click... |
| 18905 | When you export a query that contains an expression that results in more than 255 characters, the expression is truncated in the exported file. |
| 18906 | 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. NOTE : A list box may appear to work as expected,... |
| 18907 | This article shows you two methods that you can use to return every Nth record from a table. The first method is the simplest. It uses an AutoNumber field, but this method is not always reliable. The second method is reliable although a little more... |
| 18908 | This article describes how to group values in a crosstab query by using a fixed number of headings, rather than by having a column for every value. NOTE : You can see a demonstration of the technique that is used in this article in the sample file... |
| 18909 | Join lines between tables are used to clarify relationships between data in the joined tables, and to sort and order the data. However, there are some situations in which it is not necessary to have join lines between tables. This article illustrates... |
| 18910 | When you click a hyperlink that opens a Microsoft Access database or an Internet Web page, a new instance of Access or Internet Explorer starts, even if one is already started on your computer. |
| 18911 | There are several reasons why you may not be able to enforce referential integrity when you define a relationship, including the following: Existing data in the tables violates referential integrity. For example, you have a child record that does not... |
| 18912 | When you export an AutoReport to an external file, the report name that is displayed in the OutputTo message box is not the name that you gave to the AutoReport when you saved it. |
| 18913 | Novice: Requires knowledge of the user interface on single-user computers. Under Windows 95 or later, when you insert a graphic into a Microsoft Access report and then export that report to the Snapshot Format (*.SNP), the snapshot may not display any... |
| 18914 | An action query modifies data or copies data from one table to another. An action query does not produce a recordset of the completed action that you can view in Datasheet view. To view the results of an action query, you must open the table that the... |
| 18915 | While you are previewing an object in the Database window, if you click Print Preview on the File menu, the object closes. |
| 18916 | If you try to run a wizard while in break mode of a module, you may receive one of the following error messages: Microsoft Access can't find the wizard, or there is a syntax error in the Declarations section of a Visual Basic module. or This feature... |
| 18918 | Novice: Requires knowledge of the user interface on single-user computers. When you create a link to a text file from Microsoft Access and then move the text file to another folder, you may receive the following error message when you try to use the... |
| 18919 | If a field has a validation rule and you leave the field blank (or Null) in a table's Datasheet view, you may be unable to save the record. |
| 18920 | 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,... |
| 18921 | When you try to encrypt a database, you may receive the following error message: You can't encrypt a database that you didn't create or don't own. See the owner of the database or your workgroup administrator. This message is incomplete. It should... |
| 18922 | When you use the Upsizing Wizard to upsize a table that contains a field with an Access data type of Text, the resulting upsizing report indicates that the field was upsized to a data type of varchar , when actually the field was upsized to a data... |
| 18923 | When you add an object, such as a table or query, that has a hyperlink reference to the Favorites folder from within Microsoft Access, the type of shortcut that is added to the folder is determined as follows: If you open the Favorites folder by... |
| 18924 | When you distribute a secured database as a run-time application, you must take certain precautions to ensure that you can install the application on another computer. This article lists the steps that you should follow to distribute a secured... |
| 18925 | If you set the ControlSource property of a field on an unbound data access page to an expression, you may receive the following error message: The setting you entered isn't valid for this property. To see the valid settings for this property, search... |
| 18926 | When you paste data that you copied from a selected field in a datasheet, you may see the column name returned instead of the copied data. |
| 18927 | Describes beginner database normalization terminology. Requires basic familiarity with the user interface on a single-user computer. Describes forms and gives examples. |
| 18928 | The INSTCAT.SQL file is used with the SQL Server ODBC driver to create stored procedures for use with SQL Server version 6.5. This file is included in SQL Server 6.5. NOTE: The functionality provided in the INSTCAT.SQL file is integrated into SQL... |
| 18929 | After creating a SQL Server or MSDE publication on a Microsoft Windows 95 or 98 computer, remote users are able to create pull subscriptions to it. However, all attempts to synchronize with the publication are unsuccessful. If you use SQL Server... |
| 18930 | When you upsize a table containing a field with the AllowZeroLength property set to No , the Microsoft Access 2000 Upsizing Wizard does not create a trigger or CHECK constraint in an attempt to enforce the rule. |
| 18931 | The Access 2000 Upsizing Tools white paper (Upsize00.doc) describes how to use the improved Upsizing Tools included in Access 2000. Use the document as an aid in preparing to migrate the data in an Access 2000 database to SQL Server or the Microsoft... |
| 18932 | You can create temporary tables in both SQL Server and the Microsoft Data Engine (MSDE) using Access Client/Server. Even though you cannot see the tables in the Table pane of the Database window, temporary tables are available for use through stored... |
| 18933 | In a Microsoft Access project, you can use the SQL Server Security Tools to modify security permissions for objects, but you cannot change permissions on any of the following statements: CREATE TABLE CREATE VIEW CREATE PROCEDURE CREATE DEFAULT CREATE... |
| 18934 | This article shows you how to use a form to specify the criteria for a query in a Microsoft Access project. |
| 18935 | You cannot create, view, or administer SQL Server rules through the Microsoft Access Client-Server user interface. |
| 18936 | Data Transformation Services (DTS) is an alternative method that you can use to move data from a Microsoft Access database to Microsoft SQL Server or Microsoft Data Engine (MSDE). NOTE : Using DTS to import Access tables creates the Unicode character... |
| 18937 | Describes an issue that occurs when you use a batch file to run a custom Excel 2002 program in a Terminal Services session and then lock your computer, you receive an error message when you unlock your computer and Excel may stop responding. |
| 18938 | Describes the problem that you will receive an error message if you try to add a new record to a table by using the NotInList event of the combo box on a form.And privides a workaround. |
| 18939 | Describes how to reset the page number and the total count of the pages for each group in a report in Microsoft Access. The article also describes how to display the page number and the total count in the Page of Pages format. |
| 18940 | Describes the issue that is fixed in the Office 2000 post-Service Pack 3 hotfix package that is dated May 13, 2004. |
| 18941 | Explains that the AutoDialer feature ignores the dialing rules that are set in Access. This article also provides the workaround for resolving the problem. |
| 18942 | Describes a problem with the Office Assistant when you run both Office 2000 and Office 2003 on the same computer. |
| 18943 | Discusses that the data in a linked table that is linked to an Excel spreadsheet is limited to 255 characters in an Access database. To work around this problem, import the Excel spreadsheet rather than linking to the spreadsheet in your database. |
| 18944 | Explains the exclusive lock error that occurs when you try to open a form, a report, or a module in Design view in Access 2000. To work around the problem, rename or move the database file to a different folder, or open the database exclusively. |
| 18945 | Describes an issue where you may be prompted to provide the Office source files when you install a full file version of an Office hotfix or update. |
| 18946 | Describes an issue that occurs when you click a value in a combo box and then the selected value disappears from the combo box. Provides a resolution. |
| 18947 | Describes a problem that may occur when both Access 2000 and Access 2000 Runtime co-exist on the same computer. When you open an .mde file, an error may occur. Access wizards may fail. Remove Access 2000 Runtime for the workaround. |
| 18948 | Describes a problem that occurs if your database password ends with a backslash (password\). You cannot open your database. You receive a Not a valid password error message. To work around this problem, import your database objects to a new database. |
| 18949 | Lists the available Office XP service packs for Access 2002 Runtime. |
| 18950 | Describes a problem that occurs when you sort a Number field that contains negative decimal values, and you do the sort in descending order. This article describes how to work around this problem by creating an index on the Number field. |
| 18951 | After you compact a Microsoft Access database or an Access project that exists in a folder in an NTFS file system partition, you may notice that the custom NTFS permissions for the Access database file (.mdb) or for the Access project file (.adp) are... |
| 18952 | 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 with the Double data type. As a result, you may see unexpected digits to the right of the decimal point.... |
| 18953 | When you open an Access 2000 database in a multi-user environment and then you run Trend Micro antivirus software on your computer, the Access database may stop responding. If you use Windows Task Manager to try to end the task that corresponds to the... |
| 18954 | When you use FileMon or another utility to monitor file activity, if an application uses DAO 3.6 x with Jet 4.0, you receive the following error message: FILE NOT FOUND for the following dynamic-link libraries (DLLs): MSJET49.DLL MSJET48.DLL... |
| 18955 | When you work with the DataSourceControl (DSC) of an Office Web Component, you may specify a CommandTimeOut value for the Connection object. When you then build a query or RecordsetDef based on the Connection object, your CommandTimeOut value is... |
| 18956 | If you create a main form with a subform that contains subdatasheets, and the first record in the main form does not contain corresponding data in the related table, the expand indicator (+) for the subdatasheet is not visible. Note This behavior does... |
| 18957 | When you try to run an append query in a large Microsoft Access database file, you may receive the following error message: Invalid argument. This problem occurs when the size of the Access database file approaches the 2 gigabyte (GB) size limitation. |
| 18958 | You can link a table from an Oracle 8 relational database management system (RDBMS) to a Microsoft Access 2000 database. However, if the Oracle table name is not in uppercase characters, you receive the following error message: The Microsoft Jet... |
| 18959 | Storing SQL database login IDs and passwords locally requires that the database administrator create a unique table on the server. |
| 18960 | This article demonstrates a method that you can use to hide the drop-down arrow on a combo box until the combo box is selected. NOTE : This article explains a technique demonstrated in the sample file, FrmSmp00.mdb. about how to obtain this sample... |
| 18961 | When you update records in an Access database using the ODBC cursor library and you previously added a date/time field in Access without a date using the CRecordset (with TIMESTAMP_STRUCT) classes, MFC throws the following exception: No Rows Affected |
| 18962 | Describes an update to Office 2000 to reduce the chance that the Office Setup program will need access to your Office 2000 source CD-ROM when you install Office updates in certain scenarios. |
| 18963 | When you run a query in a Microsoft Access database that uses one of the aggregate (totals) functions such as the Sum() aggregate function, the Min() aggregate function, or the Max() aggregate function, the query may not run successfully. You may... |
| 18964 | In Microsoft Outlook, you cannot open the Personal Folders file (.PST) folder on a share across the network. In Microsoft Office, you cannot save documents on a Distributed File System (DFS) share. When you modify files on a network file server, you... |
| 18965 | When you use Help in a Microsoft Office program (click Microsoft program Help on the Help menu), both the Answer Wizard and the Index tabs may be blank. |
| 18966 | 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... |
| 18967 | This article describes the Microsoft Office 2000 Proofing Tools issue that is fixed in the Office 2000 Ukrainian Proofing Tools Post-Service Pack 3 hotfix package that is dated November 11, 2003. back to the top Issues that are fixed in the hotfix... |
| 18968 | The performance of a query that is run against an Open Database Connectivity (ODBC) data source may significantly decrease if the query contains a user-defined function. |
| 18969 | In Microsoft Office 2000, when you use the MsgBox function in Visual Basic for Applications to display a Help button in a message box, the procedure may be different from the procedure that you used in earlier versions of the product. The... |
| 18970 | When you visit the Microsoft Office Update Web site to look for updates to your Microsoft Office programs, you may receive the following warning message: Warning: You are viewing this page with an unsupported Web browser. This Web site works best with... |
| 18971 | 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... |
| 18972 | 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... |
| 18973 | This article answers common questions concerning Automation to Microsoft Office from Visual C++. |
| 18975 | 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... |
| 18976 | The intrinsic DAO data control in Visual Basic 5.0 cannot be bound directly to a Microsoft Access 2000 table. The known workaround to address this limitation is to assign a DAO 3.6 recordset object to its Recordset property at run time with Visual... |
| 18977 | 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. |
| 18978 | In Microsoft Access, when you import a dBase, FoxPro, or Paradox file that does not follow the MS-DOS 8.3 file name format (that is, its name before the period exceeds eight characters, or it lacks a three-character extension following the period),... |
| 18980 | According to Microsoft Knowledge Base article 275561 ACC2000: New Features in Microsoft Jet 4.0: To minimize the impact of the increased page size and respond to a long-standing request from developers building applications based on the Microsoft... |
| 18981 | 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... |
| 18982 | This article demonstrates some common DDL (Data Definition Language) SQL statements for the Microsoft Jet database engine. |
| 18983 | 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.... |
| 18984 | 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. |
| 18985 | The product versions listed at the beginning of this article do not support tiled TIFFs. |
| 18986 | This article contains a list of Microsoft Office Developer samples and tools that are available in the Microsoft Download Center. |
| 18987 | Microsoft Office products may change from one release to the next. Typically, the type library for an Office product will have the same functions that were present in the earlier product version, but some functions may have additions to the number of... |
| 18988 | Microsoft Office 2000 and later support a new, uniform design architecture for building application add-ins to enhance and control Office applications. These add-ins are called COM Add-Ins. This article will demonstrate how to build a COM Add-In using... |
| 18989 | 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... |
| 18990 | Incorrect CREATE TABLE statements are created when Microsoft Jet database engine 4.0 exports tables through ODBC drivers that do not require identifier quote characters. If an ODBC trace is generated, a you see a statement similar to the following:... |
| 18991 | Microsoft has created new Paradox and dBASE ISAM drivers for Microsoft Jet 4.0 that do not require the installation of the Borland Database Engine (BDE) to provide full read/write access to Paradox and dBASE files. The current Jet 4.0-based Paradox... |
| 18992 | When you run a SQL query containing more than 22 UNION statements using Microsoft Jet 4.0 the following error appears: Not a valid alias name. The same query worked without error when using Microsoft Jet 3.x. |
| 18993 | In any of the Office 2000 programs or Project 2000, if you ask the Office Assistant for help and click any of the Help topics, the following error message appears: Help requires Microsoft Internet Explorer 3.0 or greater. You can install the latest... |
| 18994 | When you start any of the Office programs or when you start the Office Assistant, the following error message may appear: The Office Assistant could not be started. Please repair the Assistant by running Office 2000 setup and selecting Repair Office... |
| 18995 | When you save your Office document as a Web page, some of the text may appear incorrectly. Some words may be missing, and some text may overlap the text on the next line. |
| 18996 | When you create or rename a folder or file, the following error message may appear: You may not have access privileges to create a new folder in this location. |
| 18997 | When you start 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 persists, contact the program vendor. If you... |
| 18998 | If you want to troubleshoot a problem with your printer driver, try printing with a different printer driver. If you determine that the problem does not occur when you use a different driver, you may need to update or reinstall the original printer... |
| 18999 | In any Office program, when you click More Buttons on a toolbar, Add or Remove Buttons will be unavailable. |
| 19000 | When you browse the Office Assistants on the Gallery tab of the Office Assistant dialog box, the Motionless Office Assistant is not displayed. |
| 19001 | When you preview Web pages created from an Office program, animated GIF files may play very rapidly. In contrast, the same GIF file may play more slowly when viewed directly from your Web browser. |
| 19002 | When you use any of the programs listed at the beginning of this article, you may notice any of the following problems: When you attempt to start one of the programs, the following error message may appear: This program has performed an illegal... |
| 19003 | When you copy an item in any of the Office 2000 programs, you may receive the following error message This item was not copied because the Office Clipboard is full. To free space on the Clipboard, paste the items where you want them, and then click... |
| 19004 | When running code that calls the Common Dialog Control (Comdlg32.ocx) on a computer other than the one on which the code was developed, you may receive the following error message: Run-time error 429: ActiveX component can't create object. |
| 19005 | When you click Open or Save As on the File menu, the Places Bar is available even though the Hide the common dialog places bar group policy has been enforced on your computer. |
| 19006 | When you click a hyperlink to a Microsoft Excel workbook, you may receive the following error message '\\ Server ' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the... |
| 19007 | When the Microsoft Find Fast Indexer program runs, the following error message appears: For the Find Fast program to continue indexing, you must repair the damaged document, or move the document to a drive or folder that you are not indexing with Find... |
| 19009 | When you try to delete a file in either the If the file is open by another user, or you have the file open in another session of Microsoft Excel on the same computer, close the file before trying to delete it. When Excel opens a file, the file is... |
| 19010 | When you access Help in any of the Microsoft Office 2000 programs, you may receive the following error message: The feature that you are trying to use is on a network resource that is unavailable. Click OK to try again, or enter an alternate path in... |
| 19011 | When you run or open a Microsoft Visual Basic for Applications macro with a UserForm, the following error message appears: System Error &H80004005 (-2147467259). Unspecified error. This may be followed by these error messages: Out of memory Run-time... |
| 19012 | 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... |
| 19013 | When you start the Visual Basic Editor in one of the Microsoft Office 2000 programs listed at the beginning of this article and then press F1 to start online Help, the Visual Basic Editor (VBE) window may be resized to make room for the Help window. |
| 19014 | If you attempt to delete an ActiveX object contained in a custom user form or to remove a user form from a workbook in any of the Microsoft Office 2000 programs listed in the beginning of this article, you may receive an error similar to following:... |
| 19015 | When you click Open , Save , or Save As on the File menu in any of the Microsoft Office 2000 programs listed at the beginning of this article, you may experience one of the following symptoms: When the current folder has subfolders, all subfolders... |
| 19016 | When you start one of the Microsoft Office programs listed at the beginning of this article after you install Microsoft Project 2000 or Microsoft Visio 2000, the program quits immediately after it starts. |
| 19018 | Microsoft has released an update that eliminates a security vulnerability in Microsoft Office 2000 and all of the programs listed at the beginning of this article. The vulnerability could allow a malicious Web site operator or e-mail author to take... |
| 19019 | When you attempt to start the Visual Basic Editor in Microsoft Excel 2000, the following error message appears: An error occurred initializing the VBA libraries (1004). When you attempt to start the Visual Basic Editor in Microsoft Word 2000, the... |
| 19020 | When you first start a Microsoft Office program, the menus and toolbars display basic commands and buttons. As you work with an Office program, the commands and buttons that you use most often are stored as personalized settings and displayed on menus... |
| 19021 | When you attempt to type some data into a Microsoft Office program, the following error message appears: Program name can't use AutoCorrect lists. Program name cannot install the necessary files due to Windows installer error 87. The parameter is... |
| 19022 | In any Office program, the version number displayed in About Microsoft program may be different than the version number displayed for that program in either Microsoft System Information (MSInfo), or from a Microsoft Visual Basic macro. For example,... |
| 19023 | When you type certain words or characters in a Microsoft Office program (such as Microsoft Word, Microsoft Excel, or Microsoft PowerPoint), they may be replaced with Xs. For example, if you type an inappropriate four-letter word, each letter of the... |
| 19024 | When you turn on the Provide feedback with sound option in any of the programs listed in the Applies to section of this article, the following error message may appear after you click OK in the Options dialog box: Microsoft Office Sounds are not... |
| 19025 | When you click System Information on the Help menu in any Office program, system information is not displayed, or you receive the following error in Microsoft Outlook: Can't find the system information. |
| 19026 | When you open one of the Microsoft Office programs listed at the beginning of this article, the program may open slowly. |
| 19027 | In any of the Microsoft Office 2000 programs or Microsoft Project 2000, if you ask the Office Assistant for help and click any of the Help topics, the following error message appears: Help requires Microsoft Internet Explorer 3.0 or greater. You can... |
| 19028 | In Microsoft Office, you can use a variety of special characters when creating or saving files. Microsoft Windows also allows you to use special characters for naming files or folders. However, some of these special characters hold special meaning in... |
| 19029 | The Microsoft Jet database engine runs in several different modes depending on whether it is called from Microsoft Access, Data Access Objects, the Microsoft OLE DB Provider for Microsoft Jet, or the Microsoft Access ODBC driver. It can be run in... |
| 19030 | When you run a Visual Basic macro that adds or manipulates toolbar buttons or menu commands for the CommandBars object, the controls may be added to a different CommandBar, or an error message similar to the following may appear: Run-time error '5':... |
| 19031 | 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, the following error message may appear: This program has performed an illegal operation and will be shut down. If... |
| 19032 | When you try to use shortcut keys in dialog boxes, the shortcut keys do not work. |
| 19033 | The following error message may appear when your macro evaluates a statement that uses the euro symbol: Run-time error '13': Type mismatch |
| 19034 | When you use any Office program, 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. When you click Details, you see: program caused... |
| 19035 | When you click a feature in one of the Office programs listed at the beginning of this article, you receive the following error message: These errors occur when you install some features of Office to install on demand from a resource such as a CD-ROM... |
| 19036 | You may receive the following error message: This problem occurs when the following conditions occur: After you have specified the find criteria and you click OFF2000 XL2000 |
| 19037 | When you start any of the Microsoft Office 2000 programs listed at the beginning of this article, you may receive the following error message: There was a problem starting the Office Assistant. Would you like to try reinstalling it? If you click Yes ,... |
| 19038 | This article describes how to publish a Microsoft Office document to a Web server by using the File Transfer Protocol (FTP). |
| 19039 | When you ask the Office Assistant a question about Microsoft Visual Basic for Applications, you receive one of the following responses: The Office Assistant cannot currently answer your questions. Run Setup again to make sure all the necessary Help... |
| 19040 | 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: The Object Browser Microsoft Press and Third-Party Reference and Learning... |
| 19041 | If you try to open a specific file in one of the Microsoft Office 2000 programs listed at the beginning of this article, you may receive one of the following error messages: Filename is not valid. -or- The file could not be accessed. -or- The path you... |
| 19042 | When you click Print on the File menu in any of the Microsoft Office programs listed at the beginning of this article, you may receive a blank Print dialog box, and your document may not be printed. NOTE : You can print your document by using the... |
| 19043 | When you try to start a Microsoft Office program, you may receive an error message similar to the following Windows cannot find Program.exe . This program is needed for opening files of type 'Application'. Location of Program.exe : where Program.exe... |
| 19044 | In any of the Microsoft Office 2000 programs, when you ask the Office Assistant for help, clicking any of the topics presented does not start Help. |
| 19045 | When you print a document that was created by using the right-to-left language features in a Microsoft Office 2000 program, the document may be printed with unreadable characters, missing sections, or incorrect formatting. |
| 19046 | When you click any of the menus in a Microsoft Office program and then try to select a menu command, the following problems may occur: You cannot select any menu items. -or- The mouse pointer may unexpectedly shift position on the screen. -or- When... |
| 19047 | When you use hyperlinks to switch multiple times between your Web browser and Microsoft Office programs, your system slows down and begins to run low on available memory. If you press CTRL+ALT+DELETE to display the Close Programs dialog box in... |
| 19048 | When you work with one of the Microsoft Office 2000 programs listed at the beginning of this article, one of the following symptoms occurs: When you attempt to open or save a Microsoft Word document, you receive the following error message: Word has... |
| 19049 | This article describes how to clear the Most Recently Used list (MRU) for the Microsoft Office programs listed at the beginning of this article. To clear the MRU, follow the steps for the program that you are using. Microsoft Access, Excel, PhotoDraw,... |
| 19050 | Office 2000 includes a new clipboard called the Office Clipboard. You can use this clipboard to collect and paste multiple items. For example, you can copy a drawing object in Microsoft Excel, switch to Microsoft PowerPoint and copy a bulleted list,... |
| 19051 | When you insert an object from one program (for example, a Microsoft Excel worksheet object) into another program (for example, Microsoft Word), and you deactivate and reactivate the inserted object, the Undo command may behave differently in each... |
| 19052 | When you double-click any Microsoft Office file that was created in Microsoft Office version 4.3, the following error message may appear: Windows cannot find Program. This program is needed for opening files of type ProgramFileType where Program... |
| 19053 | When you show the Microsoft Office Assistant by clicking Show the Office Assistant on the Help menu, the Microsoft Office program stops responding, or the following message appears: This program has performed an illegal operation and will be shut... |
| 19054 | The Microsoft Windows operating system provides two routines that can be called by Microsoft Office 2000 programs to get the \Windows and the \Windows\System folders. |
| 19055 | When you start a non-English (U.S.) version of any of the Microsoft Office 2000 programs, one of the following symptoms may occur. Microsoft Access 2000 You receive the following error message: Can't find language dll Microsoft Excel 2000 No error... |
| 19056 | When you view a Microsoft Office 2000 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. |
| 19057 | When you click None of the above, look for more help on the Web in a Microsoft Office Assistant balloon, a Help window is opened. When you click Send and go to the Web , Microsoft Internet Explorer is started even though it is not set as your default... |
| 19059 | This article describes the limitations of graphics import filters that are provided with Microsoft Office 2000. This information is also available in Help in each program. (On the Help menu, click Microsoft application Help . In the Answer Wizard or... |
| 19060 | When you use Access 2000 Service Release 1 (SR-1) with Microsoft Jet 4.0 Service Pack 5 (SP5) to query tables linked from two separate databases on the same server, you may find that Jet does not pass the WHERE clause parameters to the ODBC data... |
| 19061 | After you upgrade to Microsoft Windows NT 4.0 Service Pack 6/6a on a client computer without upgrading the server to the same service pack, opening Access objects such as forms, reports, macros, or modules in Design View across a network is unusually... |
| 19062 | This article describes how to disable the functionality of the SHIFT key that permits you to bypass the startup options. This article also describes how to enforce the startup options in a Microsoft Access database project. |
| 19063 | When you open a form in a Microsoft Access 2000 database, the database may be set to open exclusively if the following conditions are true: A form that contains a subform is opened, and that form has a control that references a subform control. A form... |
| 19064 | In Microsoft Visual Basic Editor, when you add a reference to the ActiveX Data Objects (ADO) 2.7 Object Library or later, and then you press F1 to obtain context-sensitive Help for ADO, a blank window may appear for Microsoft Visual Basic Help. |
| 19065 | If you do not check out Data and Misc. Objects (*.acb) from source code control before you make changes to the project properties of your database, your changes are saved locally but you are not able to check them into source code control. When Data... |
| 19066 | When import ing , export ing , or link ing a file , you may receive an error message if Microsoft Access cannot find the ISAM (indexed sequential access method) driver for that type of file . You may also receive this error message if you are trying... |
| 19067 | When you try to set New database sort order in Access, you may notice that the database sort order appears as Macedonian instead of FYRO Macedonian . |
| 19068 | The Text IISAM allows you to manipulate text files without checking the file name extension. This creates a potential security risk because it can be used to read or write to a system text file. |
| 19069 | Microsoft Access 2000 can import or link data from other Microsoft Access databases (version 2.0, 7.0/95, 8.0/97 and 9.0/2000), as well as data from other programs and file formats, such as Microsoft Excel, dBASE, or Paradox. You can also import or... |
| 19070 | By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 95/98 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 taskbar. |
| 19071 | 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... |
| 19072 | When you run the Microsoft Script Editor in any of the Microsoft Office 2000 programs, the menus and toolbars are not visible. |
| 19073 | The dBASE database driver works in one of the following two modes: The latest Microsoft Jet 4.0 service pack or the Borland Database Engine (BDE) is installed. Neither the latest Jet 4.0 service pack or the BDE is installed. The dBASE data is only... |
| 19074 | When you try to save an Access database file (.mdb) as an MDE file (.mde), or when you try to save an Access project file (.adp) as an ADE (.ade) file, Access may stop responding. You may receive the following error message: Microsoft Access has... |
| 19075 | When you import a comma delimited text file by using the Import Text Wizard, the following behaviors occur: When you import a text file by using the Import Text Wizard, a field that contains data that exceeds the range of Long Integer is still mapped... |
| 19076 | When you try to export an object from Access 2000, you may receive the following error message: Cannot update. Database or object is read-only. You receive this error message no matter which file format you are exporting to. |
| 19077 | In DAO 3.60 using the Bookmark property of a recordset to navigate to a specific record places you on the wrong record. This is likely to surface when saving a Bookmark and moving to a different record, and then moving back to the bookmarked record by... |
| 19078 | 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... |
| 19079 | After you install the latest service pack for Microsoft Jet 4.0, when you import text files or try to export an Access object to text format, you may receive the following error message: Can't update. Database or object is read-only. When importing,... |
| 19080 | When you link an Oracle table that has a decimal value in a field that is defined just as a number to a Microsoft Access 2000 database, the row displays #Error. |
| 19081 | The Paradox database driver works in one of two modes. One mode is when either the Microsoft Jet 4.0 Service Pack 5 (SP5) or the Borland Database Engine (BDE) is installed. The other mode is when neither of these are installed. Paradox data is only... |
| 19082 | This article discusses common errors that you may see when you use Replication in Microsoft Access. The first section gives general troubleshooting steps that you can try. The second section gives an error message and then steps that Microsoft uses to... |
| 19083 | When you use Microsoft Access 2000 to delete or update a record in a linked ODBC table, you receive the following message: No Current Record In some cases you also receive the following error message ODBC Call Failed followed by a vendor-specific... |
| 19084 | When you run a query that includes a Memo, an OLE, or a Hyperlink field on a computer that is running Microsoft Jet 4.0 Service Pack 5 (SP5), you receive the following error message: Run-time error '3114': Cannot include Memo, OLE or Hyperlink Object... |
| 19085 | 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 OLE DB and ODBC-compliant... |
| 19086 | When you try to export a Microsoft Access 2000 table to a Sybase database, you receive the following error message: ODBC--call failed. [Intersolve][ODBC SQL Server Driver](#102) The same process worked fine in Microsoft Access 97. |
| 19087 | After you apply Microsoft Jet 4.0 Service Pack 4 (SP4) or Microsoft Jet 4.0 Service Pack 5 (SP5) to the system, some queries in Access run five times slower. Note Microsoft Jet 4.0 Service Pack 4 (SP4) is included with Microsoft Windows 2000 Service... |
| 19088 | In the programs listed at the beginning of this article, the steps for creating a new toolbar may differ from steps that you use in earlier versions of these programs. This article lists the steps to use when you want to add a command to a new toolbar. |
| 19089 | After you compact and after you repair a database that includes a table that has an AutoNumber field, you notice that when you enter new data, the AutoNumber is a duplicate of an earlier AutoNumber. |
| 19090 | When you attempt to use custom graph formats created in Microsoft Graph, the custom formats may not be available to all users of the computer. |
| 19091 | When you run certain queries, such as a union query, you may receive the following error message: Not a valid alias name. |
| 19092 | When you call a custom function from the criteria of a query, the function runs multiple times when it should run only one time. |
| 19093 | After you enter thousands of characters of text into a Memo field, at a certain point, you notice that question marks appear, instead of text. |
| 19094 | When you run a query against data that contains dashes, and you are using the LIKE operator as criteria in the query, no rows are returned. |
| 19095 | When you try to link a password-protected Paradox file from an Access 2000 database by using the Paradox ISAM, you may receive one of the following errors: Unexpected error from external database driver (10498). -or- Invalid Index Definition, so... |
| 19096 | When you click a Help topic from the Office Assistant, nothing happens and the Help topic is not displayed. |
| 19097 | You have an append query that takes values from a linked SQL Server table that contains a field of type UniqueIdentifier and appends the values to another linked SQL Server table. When you open the table to which the records are appended, you find... |
| 19098 | When you have multiple documents open in any of the programs listed, only one icon for the program appears in the taskbar even though the Windows in Taskbar option in the Options dialog box is selected. |
| 19099 | When you add a new record to a linked Microsoft SQL Server table and then move to a different record, you may notice one of the following symptoms: When you press the TAB key to move to the next new record after entering any part of a new record in a... |
| 19100 | When you use Access 2000 to link a Microsoft SQL Server table that contains a UniqueIdentifier column as the primary key, #DELETED appears for all records in the result set. |
| 19101 | When you look at your version number for a Microsoft Office 2000 program that is listed in the Applies To section of this article, the version number may be different from the version that is included with Microsoft Office 2000, which is version... |
| 19102 | When you create a nested query against linked SQL Server tables and the top level query contains an outer join, you receive the following error message when you try to run the query: ODBC--Call Failed. [Microsoft][ODBC SQL Server Driver][SQL Server]... |
| 19103 | When you look in the About Microsoft program name box in one of the Microsoft Office 2000 programs listed at the beginning of this article, you may see the following: Microsoft program name ; 2000 Service Release 1 where program name is the name of... |
| 19104 | When you install a Microsoft Office 2000 service pack, update, or security update on your computer, you may be prompted to insert your Microsoft Office 2000 CD-ROM. This article discusses why Office 2000 service packs, updates, and security updates... |
| 19105 | This article describes the Microsoft Office 2000 issue that is fixed in the Office 2000 Post-Service Pack 3 hotfix package that is dated October 27, 2003. back to the top Issues That Are Fixed in the Hotfix Package The following issue is fixed in this... |
| 19106 | When you try to open a Microsoft Access 2000 database, you may receive the following error message: Unable to load msjter40.dll After you receive the error message, if you try to repair or to reinstall Microsoft Office 2000, you may receive error... |
| 19107 | Unlike Microsoft Access version 2.0 and earlier, Access 2002 does not create a .ldb file when a database is opened exclusively. Because of this, you can no longer use the .ldb file to determine which user has a database open for exclusive use. |
| 19108 | This article lists tips to optimize the performance of Open Database Connectivity (ODBC) data sources in Microsoft Access. NOTE : This article assumes that you are familiar with client/server environments and architectures. |
| 19109 | When you initiate an Update query and then try to cancel the query, the records in the underlying table may still be modified. |
| 19110 | This article describes how to retrieve selected items from a multiple selection list box and then store the selected items as a comma-delimited string. |
| 19111 | When one or more users process many transactions in a multi-user environment, the transactions may fail with the following error message: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. |
| 19112 | When you start a Microsoft Access 2000 run-time application after you uninstall Microsoft Access 2002, including a Microsoft Access 2002 run-time application, you may experience either of the following symptoms: Visual Basic for Applications code... |
| 19113 | This article describes the Microsoft Access 2000 issues that are fixed in the Access 2000 Post-Service Pack hotfix package that is dated July 8, 2003. Issues That Are Fixed in the Hotfix Package The following issue is fixed in this hotfix package but... |
| 19114 | This article describes the Microsoft Access 2000 issues that are fixed in the Access 2000 Post-Service Pack 3 hotfix package that is dated July 2, 2003. Issues That Are Fixed in the Hotfix Package The following issue is fixed in this hotfix package.... |
| 19115 | This article describes how to use a Microsoft SQL Server distributed query to retrieve data from a secured Microsoft Access database. |
| 19116 | When you view a report preview window, Access 2000 may quit unexpectedly. |
| 19117 | When you try to use the Database Documenter, the Import Text Wizard, the Import Spreadsheet Wizard, or any wizard, one or both of the following error messages may appear: There is no object in this control Object or with block variable not set |
| 19118 | 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... |
| 19119 | Session Summary In this session, we will discuss how to design a relational database system. The session will cover creating effective table structures and relationships, and database normalization. This is a Level 100 session that was recorded June... |
| 19120 | This article shows you how to look up values within data access pages by using the existing relationships or by using ActiveX Data Objects (ADO) rather than by using domain functions. In most Microsoft Access objects, such as forms and reports, you... |
| 19121 | 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... |
| 19122 | This article shows you how to create appointments in a Microsoft Access database and how to use Automation to add the appointments to a Microsoft Outlook calendar. |
| 19123 | 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... |
| 19124 | 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 for SQL pass-through queries. |
| 19125 | This article describes the differences between the MaxRecords property and the TopValues property. |
| 19126 | Unrelated rows in a subreport or a subform may be returned when the LinkMaster property or the LinkChild property uses fields of the Decimal data type and the table is linked through ODBC. |
| 19127 | In an Access project, when you try to make a design change to a very large table (in most cases in excess of 1 million records), you may receive the following error message: Errors were encountered during the save process. Some of the database objects... |
| 19128 | When you set the focus to the Header section of a subform, the GotFocus event of the first control in the tab order of the subform's Detail section is fired. This behavior occurs even if the control is not focused. |
| 19129 | When you try to insert a Null into a TimeStamp field on SQL Server, you may receive the following error message: ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]The user can't INSERT a non-null value into a TIMESTAMP column. Use... |
| 19130 | The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a SQL Server 2000-compatible data storage server that is included with Microsoft Office XP Developer, with rights to redistribute. The Office XP Developer Packaging Wizard has an option for... |
| 19131 | This article describes the Microsoft Office 2000 issue that is fixed in the Microsoft Office 2000 Post-Service Pack 3 hotfix package that is dated October 8, 2003. back to the top Issues That Are Fixed in the Hotfix Package The following issue is... |
| 19132 | When you are automating an Office application from Visual Basic .NET, the Office application may display a dialog box. The dialog box causes the Visual Basic .NET application to appear to stop responding (hang) because the Visual Basic .NET... |
| 19133 | When you attempt to use a wizard or to open a switchboard in Access 2000, you receive the following error message: Method 'connection' of object '_currentproject' failed. |
| 19134 | When you open a .dbf file in dBase III/III+, the following error message appears. Not a dBase database. The .dbf file does not open. |
| 19135 | When you import data from a comma-delimited text file to an existing table by using the Import Text Wizard, the data in the fields that you have selected to skip in the Import Specification dialog box are imported to the existing table. |
| 19136 | This article describes the Microsoft Access 2000 issues that are fixed in the Access 2000 Post-Service Pack 3 hotfix package that is dated October 13, 2003. back to the top Issues That Are Fixed in the Hotfix Package The following issue is fixed in... |
| 19137 | This article describes some of the conversions between Visual Basic for Applications and C arguments. |
| 19138 | You can delete objects programmatically by using either the Delete method or the DeleteObject method. You can also use the DeleteObject action in macros. |
| 19139 | When you install the Microsoft Access 2000 Run-Time component on a computer, you see a screen titled Ready to Install . This screen shows the default installation location as follows: C:\Program Files\Microsoft Office\ The following behavior may... |
| 19140 | Automation clients written for Microsoft Access 97 that use either early binding (VB, ATL with #import) or dispid binding (MFC) might unexpectedly fail when trying to automate Microsoft Access 2000 or 2002. Among the possible errors you might receive... |
| 19141 | Support for the definition of stored procedures has been added to Microsoft Jet 4.0. This article provides Visual Basic for Applications (VBA) code examples that demonstrate how to create and run a parameterized Microsoft Jet stored procedure. NOTE :... |
| 19142 | You can use Microsoft Graph to embed a graph object in a Microsoft Access form or report. However, if you export the form or report to an Excel worksheet, the graph does not appear in the worksheet. This article describes how to export a Microsoft... |
| 19143 | This step-by-step article discusses how to use the object models for Office applications to avoid dialog boxes during Automation. It also provides an example of how to simulate user input to programmatically dismiss a dialog box that cannot be avoided... |
| 19144 | This step-by-step article demonstrates how to automate Excel from Visual C++ .NET to create a command bar that contains buttons, drop-down list boxes, combo boxes, and pop-up menus. The Visual C++ .NET application catches and responds to the Click and... |
| 19145 | When you type a word or number into a document in one of the programs listed at the beginning of this article, the text may be unexpectedly changed into a different word or number. |
| 19146 | Deploying the Microsoft Data Engine (MSDE) with your Microsoft Access project (ADP) involves the following three steps: First, you create code in the ADP to start the MSDE server, copy the data file (*.mdf) to the server, register the MDF, and connect... |
| 19147 | When you start one of the Office 2000 programs that are listed at the beginning of this article after April 15, 2003, you may receive a prompt to register Office. This symptom may occur if Office has previously been registered or if the version of... |
| 19148 | When you try to install, update, or remove any Windows Installer-based program, you may receive an error message similar to the following: The MSIEXEC.EXE file is linked to a missing export MSI.DLL:222. After you click OK , you receive an error... |
| 19149 | You may experience any of the following symptoms: When you copy a file over the network in Windows XP, if the source file is located on a Windows 2000-based network share, you may receive either of the following error messages: File or network path no... |
| 19150 | If you type or check the spelling of text with the language set as Portuguese (Brazil), Word may suggest an incorrect spelling or correct the word to an incorrect spelling. For example, if you type the word Petrobras, the word is either corrected to... |
| 19151 | When you try to install a patch for Office 2000 or for one of the Office programs that is listed at the beginning of this article, you may receive a message that prompts you to insert a CD-ROM for another program or patch. |
| 19152 | This article shows you how to capture a screen object and save it as a graphics file. |
| 19153 | When you run Setup for any of the programs listed at the beginning of this article, you may receive the following error message: Error 1919. Error configuring ODBC data source: MS Access Database. ODBC error 6: Component not found in the registry.... |
| 19154 | When you install any of the Office products listed at the beginning of this article, you may receive an error message similar to the following: Internal Error 2889: Please contact product support for assistance. |
| 19155 | After you install Office 2000 or Office XP, the Activation Wizard appears each time that you start an Office program. |
| 19156 | When you use the Windows Installer Cleanup utility, you may receive an error message similar to the following: Error creating process (msiexec.exec/l msicu.msi). Reason: The system cannot find the file specified. |
| 19157 | 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... |
| 19158 | Merge replication to Jet 4.0 subscribers may fail during the process of applying the initial snapshot, with the following errors reported in the output file for the merge agent: Category:AGENT Source: MS.Jet.4.0 Number: -1507 Message: Could not find... |
| 19159 | In Access 2000, when you query a linked SQL Server 2000 table that contains a field defined with a data type of BigInt, returned data is incorrectly mapped to Binary instead of to TEXT, which can appear in the form of indecipherable symbols within the... |
| 19160 | The Show Desktop button on the Quick Launch portion of the taskbar minimizes all the open windows on the desktop. When you click it a second time, the windows are not restored as expected but remain minimized. |
| 19161 | This article discusses and explains how COM (Component Object Model) determines which version of an Office application is loaded when you use Office Automation. |
| 19162 | When you display the Open dialog box in any of the programs listed at the beginning of this article (on the File menu, click Open ), and then you try to access a directory on either your local computer or a network server, the Office program stops... |
| 19163 | You receive the following write conflict error when you try to update records in a linked SQL Server table: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other... |
| 19164 | If your regional settings are configured to use a comma as the decimal separator (for example, in the German regional settings), filtering by selection on a Decimal field may generate the following error message when you link to an Open Database... |
| 19165 | An Access database exists on a Netware 5 Server volume that is running only the TCP/IP protocol. When you use either Open Database Connectivity (ODBC) or OLE Provider for Jet, a error message appears that states that the file cannot be found. There... |
| 19166 | In the Office 2000 programs listed at the beginning of this article, when you click Open on the File menu, you can browse to restricted drives, even though drive access is restricted via Group Policy. |
| 19167 | 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... |
| 19168 | In an Office 2000 program, when you use the Open dialog box to select an Office document and then click the Tools list, the Find command is not displayed. |
| 19169 | If you click the Up One Level button in the Open or Save As dialog box while the current location is the My Documents folder, the desktop appears. Also, if you click Look in or Save in , there are no subfolders shown for My Documents. If your... |
| 19170 | 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. |
| 19171 | 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... |
| 19172 | 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... |
| 19173 | 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... |
| 19174 | Each time you start an Office program, a dialog box for Windows Installer appears with the following message: Preparing to install... This is followed by another dialog box, with the following message: Please wait while Windows configures Office... |
| 19175 | 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... |
| 19176 | If you convert an Access database created in an earlier version of Access that is also not the same language version, you may see unexpected characters, including extended characters, in the converted database. |
| 19177 | When you use the OutputTo action or method to output a report to another format, you receive one of the following errors: Run-time error '2024': The report snapshot was not created because you do not have enough free disk space for temporary work... |
| 19178 | When you use one of the new Visual Basic for Applications functions as an expression, you may receive the #Name? error value. For example, if you set the ControlSource property of a text box to the expression =WeekdayName(6) , the text box returns... |
| 19179 | When you have the Name AutoCorrect feature enabled, and you make changes to a query's record source, such as changing a table name, a query name, or a field name, and you then run the query, the query may: Prompt for the old field name value. Return... |
| 19180 | This article shows you how to calculate the number of working days between two dates. |
| 19181 | This article shows you how to create a sample, user-defined function named ConvertCurrencyToEnglish() to convert a numeric value to an English word representation. For example, the function will return the following words for the number 1234.56: One... |
| 19182 | When you try use Help in any of the Office 2000 programs, either the Help window does not appear, or no results are returned when you search Help. |
| 19183 | This article describes the numbering scheme used by Office-family programs and utilities. |
| 19184 | 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 group... |
| 19185 | When you run a SQL-specific union query that contains an OLE Object field, you may receive the following error message: Cannot use Memo, OLE, or Hyperlink Object field 'fieldname' in the SELECT clause of a union query. You observe this behavior when... |
| 19186 | After you open many code windows, the Visual Basic Editor reports the error Out of memory and you cannot open the Visual Basic Editor. |
| 19187 | 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... |
| 19188 | This article explains how to add user-defined entries to the Places Bar in the Office 2000 Save As and Open dialog boxes. If you want to do this, you must modify or add the registry keys and entries described below. Office 2000 applications can... |
| 19189 | 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. |
| 19190 | 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... |
| 19191 | 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. |
| 19192 | If you call a procedure in a form class module from the OnAction property of a command bar control, the function runs three times. |
| 19193 | 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... |
| 19194 | This article illustrates by example how you can create an MFC Automation client to retrieve a list of Visual Basic for Automation (VBA) macros ( Sub and Function procedures) from a Microsoft Office document. |
| 19195 | 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... |
| 19196 | In a Microsoft Access Database Project, two forms may be based on the same recordset. If you edit a record in one form, and then you try to save the record by using the BeforeUpdate event procedure, an incorrect record may be referred to in the... |
| 19197 | Data access pages permit you to create data-bound Web pages that you can view in Microsoft Internet Explorer 5.0 or later. These Web pages are typically intended for intranet use. However, with special considerations, data access pages can be deployed... |
| 19198 | 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... |
| 19199 | When you try to install one of the programs listed at the beginning of this article on a computer that is running Microsoft Windows 2000 or Microsoft Windows XP, you may receive an error message that is similar to one of the following: Error 1305.... |
| 19200 | In a Microsoft Access database, if you view a report in the Print Preview mode that is linked to a subreport by using an AutoNumber field, and if the Field Size property of the field is set to Replication ID , the subreport may not display any data. |
| 19201 | This step-by-step article describes how to reset a menu in a Microsoft Office program back to its default first-run condition. In addition, this article describes the following: What the Personalized Menus and Toolbars feature is. Two methods for... |
| 19202 | 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... |
| 19204 | 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++. |
| 19205 | 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. |
| 19206 | You may use the Export option in Access to export a report to Microsoft Excel. If the report has numeric values in the text field, the resultant Excel worksheet may have incorrect values. This problem may also occur when you use the Analyze It with... |
| 19207 | Using Jet 4.x, a user is able to call unsafe Visual Basic for Applications functions in query statements from Microsoft Access. For example, the following statement would result in all files being deleted from a computer's current folder: SELECT... |
| 19208 | When you try to install one of the programs listed at the beginning of this article, on a computer that is running Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows Millennium (Me) you may receive the following error message: Error... |
| 19209 | The Microsoft Office 2000 client updates and patches that were published after September 2002 may require Windows Installer 2.0. This article provides more information about this requirement. |
| 19210 | 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. |
| 19211 | This article explains how users with different versions of Microsoft Access can share the same data. |
| 19212 | 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 Use the Object Browser Microsoft Press and Third-Party... |
| 19213 | 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... |
| 19214 | If you try to install an Office 2000 program on a Microsoft Windows 2000-based computer, you may receive the following error message: Windows File Protection: Windows files must be installed for your installation to proceed. When you click OK ,... |
| 19215 | When you try to open an Access 2.0 database file (.mdb) in Microsoft Access 2000 or Access 2002, you may receive an error message that is similar to the following: Disk or network error. |
| 19216 | This article describes the Access 2000 (Japanese) issue that is fixed in the Microsoft Access 2000 (Japanese) Snapshot Viewer Post-Service Pack 3 Hotfix package that is dated August 18, 2003. Issue That Is Fixed in the Hotfix Package The following... |
| 19217 | This article demonstrates how to use the Windows Installer to find the installation path of Microsoft Office or an Office XP or an Office 2003 applications. |
| 19218 | This article includes sample code that illustrates how you can programmatically determine the installation path for a Microsoft Office application given the ProgID for that application. |
| 19219 | Microsoft Office applications can act as ActiveX Servers. They provide client applications design-time access to an Object library, or type library, that enables client applications to view an Office application's objects, properties, methods, and... |
| 19220 | This article demonstrates how to obtain the window handle of an Microsoft Office application while automating that application from Visual Basic. |
| 19221 | The following symptom occurs with Microsoft Visual Basic for Applications code that relies on the Dir function to return an empty string as the termination condition of a file-processing loop: The code runs endlessly if the files are modified while... |
| 19222 | When you click a Help topic in one of the Microsoft Office 2000 programs, you receive a Windows Installer dialog box with the following text: Preparing to install... You then receive the following text in the dialog box: Please wait while Windows... |
| 19223 | The new SQL grammar exposed by Microsoft Jet database engine version 4.0 allows users to specify business rules that can span more than one table. These are called check constraints and allow users to exceed a single validation rule per table. In this... |
| 19224 | When you set the Recordset property of a form programmatically, if the source of the recordset's data is not a local object, you receive one of the following error messages when you open or close the form: The Microsoft Jet database engine cannot find... |
| 19225 | If you try to gain access to an Access 2000 or Access 2002 database, you may receive one of the following errors within your Visual Basic program. If you are using Microsoft ActiveX Data Objects (ADO) (or the ADO Data Control), you receive the... |
| 19226 | Microsoft Office 2000 saves in one location all of the new custom template files that you create in any Microsoft Office applications. This article explains the location of templates in Office 2000, how the New dialog box (on the File menu, click New... |
| 19227 | This article describes how to recover data from a corrupted table in an Access database. You can do this by using the Microsoft Data Access Objects (DAO) db.Execute method. You can use the db.Execute method when you cannot recover your data by using... |
| 19228 | When you run a procedure in Microsoft Access 2000 or later, you may receive the following error message: The expression Event_Name you entered as the event property setting produced the following error: Ambiguous name detected: EventProcedure_Name . |
| 19229 | Microsoft has released an update to Microsoft Access 2000. This update fixes a flaw in the Microsoft Access Snapshot Viewer control that could enable an attacker to execute code of their choice on a user's system if the user visits a mailicious Web... |
| 19230 | When you delete a column from a table that is opened in the Datasheet view in Microsoft Access, the ColumnOrder property of the ActiveDatasheet property may display an incorrect value. |
| 19231 | If you enable the keyboard layout of your computer to use a right-to-left (bidirectional) language (such as Syriac) in a Microsoft Access database project, and you try to create a table in Design view, the column names in the table may appear as a... |
| 19232 | When you calculate a running sum in your report in Microsoft Access 2000, the running sum field may display incorrect results. |
| 19233 | 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... |
| 19234 | After you establish a group policy to restrict access to a drive by selecting the Hide these specified drives in My Computer and Prevent access to drives from My Computer options, you can use a Microsoft Office program to browse and read the contents... |
| 19235 | 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... |
| 19237 | When you query a table that is linked to a Microsoft Excel spreadsheet, you may receive the following error message: Numeric field overflow. |
| 19238 | 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... |
| 19239 | This article shows you how to create and automate a chart in Microsoft Word from Visual Basic. |
| 19240 | There is an undocumented limit on the number of ANDs that you can use in an SQL Select statement. The limit is 99 ANDs in a WHERE clause and 99 ANDs in a HAVING clause. Microsoft Access 2000 returns the following error messages when you exceed this... |
| 19241 | 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... |
| 19242 | When you export a table to Microsoft Excel using the OutputTo macro action or OutputTo Visual Basic method, Number fields that have an input mask appear as Text fields in Excel. |
| 19243 | This article shows you how to use Visual Basic for Applications to import an entire worksheet from a Microsoft Excel workbook without specifying a range. |
| 19244 | When you try to do any of the following: Open a database with a startup form View, create, or run Visual Basic code in a form's class module Start a Wizard you may receive one of the following error messages. In Microsoft Windows 95 or Microsoft... |
| 19245 | This article lists the updates for Microsoft Office 2000 that are currently released by Microsoft. |
| 19246 | When you attempt to upsize a Microsoft Access 2000 database to Microsoft SQL Server 2000, you may receive the following error message: Overflow You may also receive the same error message when you try to create an Access project that connects to an... |
| 19247 | When you update linked ODBC tables in a Microsoft Access database, an access violation occurs with the following message: The instruction at '0x1b01a333' referenced memory at '0x0000000c'. The memory could not be 'read'. This error message occurs when... |
| 19248 | To start Microsoft Access by using the Microsoft Windows NT scheduling service, you must do the following: Create a batch file with the command line options that you want to run. On the Scheduler Service, instead of using a system account, log on as a... |
| 19249 | 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 |
| 19250 | The following Microsoft Access 2000 Help topics Create a switchboard form by using the Switchboard Manager Create a new switchboard that you can open from the opening switchboard Make a change to an existing switchboard Change which switchboard... |
| 19251 | When you run a query in a Microsoft Access database that joins linked Microsoft SQL Server tables from different sources or databases, the query may not return any data. However, when you run a similar query that refers to the linked SQL Server tables... |
| 19252 | When you try to obtain information about the Timer event from Microsoft Access Help in Access 2000 or Access 2002, the maximum value of the TimerInterval property of an Access form is incorrectly listed as 65,535 milliseconds. |
| 19253 | When you try to roll back a record, Microsoft Jet may commit the record instead. |
| 19254 | This article contains information about Microsoft Jet 4.0 database engine Service Pack 8 (SP8). about how to obtain the latest service pack for Jet 4.0 239114 How to Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine For... |
| 19255 | In the Microsoft Office 2000 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. |
| 19256 | When you attempt to import tables from an Access 2000 or 2002 database to Outlook 2000 or 2002, the following error message may appear: An ODBC error has occurred in the Microsoft Access translator while opening a file to build a field map.... |
| 19257 | When you use Microsoft Office 2000, if you click a button on the Microsoft Office Shortcut Bar (OSB), the program that you select may not start. WordPad may start instead. You receive the following error message: File is too big to open in WordPad,... |
| 19258 | When you click a hyperlink in a Microsoft Office document in an Office program, you may receive an error message similar to the following: This operation has been canceled due to restrictions on this computer. Please contact your system administrator. |
| 19259 | When you attempt to use a Microsoft Office 2000 program on a Microsoft Windows XP-based computer, you may receive an error message similar to one of the following: Program name executable for Windows has encountered a problem and needs to close. We... |
| 19260 | When you try to save a modified query or run a query, Microsoft Access may quit unexpectedly without an error message. |
| 19261 | When you run a parameter query so you can query a table that is linked to Microsoft SQL Server, the query may return no records. However, you expect some records to be returned. |
| 19262 | When you undo the checkout of Data and Misc. Objects for a Microsoft Access database under Microsoft Visual SourceSafe control, you lose any tables or links to a data access page that you created after you checked out the object. |
| 19263 | 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... |
| 19264 | When you attempt to use any of the Web features in the Microsoft Office 2000 programs listed at the beginning of this article, and Microsoft Internet Explorer is installed, you may receive an error message similar to one of the following Program name... |
| 19265 | 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. |
| 19266 | 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... |
| 19267 | When you attempt to start Help in Microsoft Outlook 2000, you may receive an error message similar to the following: Microsoft Outlook cannot display Office Assistant Help. Microsoft Outlook cannot install the necessary files due to Windows Installer... |
| 19268 | When you use indirect synchronization to synchronize your replica set on either Microsoft Windows NT 4.0 or Microsoft Windows 2000 Server, the synchronizer leaks file search handles. As a result, Error 2009 is logged in the Event Log for the server.... |
| 19269 | When you try to open a Microsoft Access database, you may receive an error message similar to the following: The Microsoft Jet database engine cannot open the file Filename . It is already opened exclusively by another user, or you need permission to... |
| 19270 | When you try to preview or print a report in Microsoft Access, you may see the following error message: Microsoft Access is having difficulty communicating with the printer. You may receive this error for one of the following reasons: Before beginning... |
| 19271 | Microsoft Office 2000 includes a program that you can use to create digital certificates for signing Microsoft Visual Basic for Applications (VBA) projects. The program is called SelfCert.exe. You can use it to create test certificates that you can... |
| 19272 | 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... |
| 19273 | In Microsoft Windows Explorer, when you click a shortcut representing a Microsoft Office 2000 program, Windows Installer unexpectedly starts to install the program. |
| 19274 | The Places COM Add-in was developed for Microsoft Office 2000 applications that use Microsoft Visual Basic 6.0. |
| 19275 | When you insert an Enhanced Metafile (EMF) image, such as a Barcode Control, into your document, the characters in the EMF or barcode are displayed upside down. This issue occurs only on computers running Microsoft Windows NT 4.0 or Microsoft Windows... |
| 19276 | When you assign Microsoft Visual Basic code to run for a command button that is displayed in the Visual Basic Editor (not its corresponding Microsoft Office program) by using the OnAction property, the code does not run as expected when you click the... |
| 19277 | You can remove Microsoft Office 2000 Suite editions and stand-alone Office programs remotely with Microsoft Systems Management Server or by other means. To remove a program or suite remotely, you need the product's globally unique identifier (GUID).... |
| 19278 | When you use the Oracle ODBC driver to export an Access table that has fields of data type Single or Double, the driver fails to export those fields as follows. The Microsoft Oracle driver displays the following error message: Microsoft Access was... |
| 19279 | The Microsoft Access Help topic for the OutputTo action states that this macro action outputs data to the Microsoft Excel 98 format. However, when you open the exported Microsoft Excel spreadsheet in Microsoft Excel 2000, you notice that the format is... |
| 19280 | When you click either Microsoft Access or Data Files , in the Files of type list, for the following dialog boxes you cannot see the entire list of extensions for Microsoft Access or Data Files: Open Export object name Import Link |
| 19281 | When you use Microsoft Access 2000 to open or convert an MDE file created with Microsoft Access 97, you may receive the following error message: You can't convert or enable an MDE file. |
| 19282 | When you use any of the Microsoft Office XP or Microsoft Office 2000 programs, you may notice one or more of the following behaviors: Publisher document icons are displayed as generic icons. Microsoft Publisher is no longer displayed under Programs on... |
| 19283 | This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you save a Microsoft Access report to HTML format, the following problems may occur: Column headers and fields may not be aligned in the same... |
| 19284 | Microsoft has adopted a standardized naming schema for all hotfix (patch or update) packages for Office that are created and distributed by Microsoft. The new naming schema will go into effect for all hotfix packages in May, 2003. Note An Office... |
| 19285 | When you use = Null instead of Is Null as the criteria for a query, the query may not return the expected results. For example, a query may return no records if you use = Null as the criteria in a field that has records that have no data.... |
| 19286 | Session Summary In this session, we will discuss common combo box usage in a Microsoft Access database. This session will cover what combo boxes are, how they are created, and the distinct properties of a combo box. It will also introduce various... |
| 19287 | This article describes how to determine the current Microsoft Jet 4.0 database engine service pack level. This article permits you to download the latest Service Pack to the Jet 4.0 database engine, provides you setup instructions, lists the files... |
| 19288 | When you start Microsoft Access 2000 or a run-time application with a custom profile, you receive the following error message: An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now? After you... |
| 19289 | This article explains how to download and install the Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) Update from the Microsoft Tools on the Web site. NOTE : For information about obtaining the latest Office 2000 Service Pack, please see the... |
| 19290 | 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. |
| 19291 | When you try to start any of the Microsoft Access wizards, the wizard does not start. You may see either the busy mouse pointer or nothing, and then the focus returns to Access as if you had not tried to start the wizard. |
| 19292 | When you try to open a Microsoft Visual Basic for Applications (VBA) project in Access 2000, and that project was created by using Office Access 2003, you may receive the following error message: Project is unviewable When you open the same VBA... |
| 19293 | When you try to edit a record in Microsoft Office Access that is being edited by another user, the record may not be shown as locked. Also, Access may stop responding for a significant period of time during the attempt to edit a record that is... |
| 19294 | The Microsoft Office XP Setup program and the Microsoft Access 2002 Setup program only update system files in certain situations and to a certain level. Therefore, after you install Access you may not have the latest version of the Microsoft Jet 4.0... |
| 19295 | 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... |
| 19296 | 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... |
| 19297 | The RptSmp00.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 that you want. Topics include dynamically sorting and filtering your data,... |
| 19298 | The Microsoft Access 2000 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... |
| 19300 | 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... |
| 19301 | This article describes some of the irregular behaviors that can occur when you try to use Microsoft Access with networks that have not been tested with Microsoft Access. These networks include DEC Pathworks, UNIX NFS, and others. |
| 19302 | The Microsoft Jet replication update, Jet40Repl.exe, is a Setup program that updates certain files that are used by Access and by Microsoft Replication Manager 4.0. These files were updated with the release of Microsoft Jet 4.0 Service Pack 7 (SP7).... |
| 19303 | Using Microsoft Jet version 4.0, sorting is different than in previous versions. For example, assume you have the following records in an Access table: FIELD1 W W- WB W-B In previous versions of the Jet database engine, issuing SELECT * FROM Table1... |
| 19304 | 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... |
| 19305 | Microsoft has made available a downloadable Help file that contains automation theory and multiple examples showing how to automate the Microsoft Office XP programs listed at the beginning of this article. |
| 19306 | The Auto2000.exe file contains the Microsoft Office 2000 Automation Help file created by Microsoft Technical Support. This Help file contains Automation theory and has multiple examples that show you how to automate the Office 2000 products (Microsoft... |
| 19308 | 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. |
| 19309 | You may use the Export option in Access to export a report to Microsoft Excel. If the report has numeric values in the text field, the resultant Excel worksheet may have incorrect values. This problem may also occur when you use the Analyze It with... |
| 19310 | This article contains information about Microsoft Jet 4.0 database engine Service Pack 8 (SP8). about how to obtain the latest service pack for Jet 4.0 239114 How to Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine For... |
| 19311 | After you open many code windows, the Visual Basic Editor reports the error Out of memory and you cannot open the Visual Basic Editor. |
| 19312 | In a Microsoft Access Database Project, two forms may be based on the same recordset. If you edit a record in one form, and then you try to save the record by using the BeforeUpdate event procedure, an incorrect record may be referred to in the... |
| 19313 | In a Microsoft Access database, if you view a report in the Print Preview mode that is linked to a subreport by using an AutoNumber field, and if the Field Size property of the field is set to Replication ID , the subreport may not display any data. |
| 19314 | This article describes the Access 2000 (Japanese) issue that is fixed in the Microsoft Access 2000 (Japanese) Snapshot Viewer Post-Service Pack 3 Hotfix package that is dated August 18, 2003. Issue That Is Fixed in the Hotfix Package The following... |
| 19315 | When you try to do any of the following: Open a database with a startup form View, create, or run Visual Basic code in a form's class module Start a Wizard you may receive one of the following error messages. In Microsoft Windows 95 or Microsoft... |
| 19316 | The following Microsoft Access 2000 Help topics Create a switchboard form by using the Switchboard Manager Create a new switchboard that you can open from the opening switchboard Make a change to an existing switchboard Change which switchboard... |
| 19317 | Microsoft has released an update to Microsoft Access 2000. This update fixes a flaw in the Microsoft Access Snapshot Viewer control that could enable an attacker to execute code of their choice on a user's system if the user visits a mailicious Web... |
| 19318 | When you delete a column from a table that is opened in the Datasheet view in Microsoft Access, the ColumnOrder property of the ActiveDatasheet property may display an incorrect value. |
| 19319 | If you enable the keyboard layout of your computer to use a right-to-left (bidirectional) language (such as Syriac) in a Microsoft Access database project, and you try to create a table in Design view, the column names in the table may appear as a... |
| 19320 | When you run the Package and Deployment wizard and then select Include Access Runtime , you may receive the following error message: The Access Runtime files could not be automatically located. Please insert your Microsoft Office 2000 Developer media... |
| 19321 | To start Microsoft Access by using the Microsoft Windows NT scheduling service, you must do the following: Create a batch file with the command line options that you want to run. On the Scheduler Service, instead of using a system account, log on as a... |
| 19322 | Merge replication to Jet 4.0 subscribers may fail during the process of applying the initial snapshot, with the following errors reported in the output file for the merge agent: Category:AGENT Source: MS.Jet.4.0 Number: -1507 Message: Could not find... |
| 19323 | When you open a .dbf file in dBase III/III+, the following error message appears. Not a dBase database. The .dbf file does not open. |
| 19324 | Data access pages permit you to create data-bound Web pages that you can view in Microsoft Internet Explorer 5.0 or later. These Web pages are typically intended for intranet use. However, with special considerations, data access pages can be deployed... |
| 19325 | 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... |
| 19326 | When you try to obtain information about the Timer event from Microsoft Access Help in Access 2000 or Access 2002, the maximum value of the TimerInterval property of an Access form is incorrectly listed as 65,535 milliseconds. |
| 19327 | There is an undocumented limit on the number of ANDs that you can use in an SQL Select statement. The limit is 99 ANDs in a WHERE clause and 99 ANDs in a HAVING clause. Microsoft Access 2000 returns the following error messages when you exceed this... |
| 19328 | When you attempt to import or link certain types of files from a File Transfer Protocol (FTP) site in Microsoft Access, you may receive an error message. If you try to import or link a table from an Access database, you may receive the following error... |
| 19329 | The Reldes.doc Word document 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 Microsoft Access 2000. The following file is... |
| 19330 | This article describes how to locate Microsoft product information and how to make purchases online. |
| 19331 | Regsvr32.exe is a program that you can use to register dynamic-link libraries (DLLs) and ActiveX controls (formerly called OLE Custom Controls) in the registry. For example, to manually register the Sample.ocx ActiveX control, you would type the... |
| 19332 | When you use the Convert Macros to Visual Basic command to convert a macro that contains a reference to a user-defined item on a form or report to a Visual Basic for Applications event procedure, the code syntax that is created from the conversion... |
| 19333 | You can use the Errors collection to trap specific Open Database Connectivity (ODBC) errors. However, you must loop through all of the elements in the collection to access the ODBC error information. The first element contains only a number and... |
| 19334 | Microsoft Access allows you to create temporary instances of reports and forms in Visual Basic code by using the New keyword. This functionality allows you to create an instance of an object on demand. A new instance of a form or report keeps the... |
| 19335 | The Qrysmp00.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... |
| 19336 | This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you save a Microsoft Access report to HTML format, the following problems may occur: Column headers and fields may not be aligned in the same... |
| 19337 | 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... |
| 19338 | 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. NOTE : You can see a demonstration of the technique that is used in this article in the sample... |
| 19339 | When you try to edit a record in Microsoft Office Access that is being edited by another user, the record may not be shown as locked. Also, Access may stop responding for a significant period of time during the attempt to edit a record that is... |
| 19340 | 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... |
| 19341 | When you upgrade a computer from Microsoft Access 97 to Microsoft Access 2000, and an Access 97 run-time application is subsequently installed, you may receive the following error message: The current user account doesn't have permission to convert or... |
| 19342 | When you try to close a form in an Access database, Access stops responding. The form instantiates a class module that contains a WithEvents procedure. The form also contains a Close event or an Unload event where the class is set to equal Nothing. |
| 19343 | This article describes how to recover data from a corrupted table in an Access database. You can do this by using the Microsoft Data Access Objects (DAO) db.Execute method. You can use the db.Execute method when you cannot recover your data by using... |
| 19344 | When you try to open a Microsoft Visual Basic for Applications (VBA) project in Access 2000, and that project was created by using Office Access 2003, you may receive the following error message: Project is unviewable When you open the same VBA... |
| 19345 | When you set the Recordset property of a form programmatically, if the source of the recordset's data is not a local object, you receive one of the following error messages when you open or close the form: The Microsoft Jet database engine cannot find... |
| 19346 | When you try to set New database sort order in Access, you may notice that the database sort order appears as Macedonian instead of FYRO Macedonian . |
| 19347 | 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... |
| 19348 | When you start Microsoft Access 2000 or a run-time application with a custom profile, you receive the following error message: An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now? After you... |
| 19349 | If you call a procedure in a form class module from the OnAction property of a command bar control, the function runs three times. |
| 19350 | When you print a Snapshot Viewer file that contains Japanese characters, one or more of the following symptoms may occur: Extra spaces are printed with each character. Printed characters overlap each other. Characters are printed out of sequence.... |
| 19351 | When you run a parameter query so you can query a table that is linked to Microsoft SQL Server, the query may return no records. However, you expect some records to be returned. |
| 19352 | When you double-click an Access application (.mdb) file in Microsoft Windows Explorer, you may receive the following error message: Cannot find the file filepath\filename.mdb (or one of its components). Make sure the path and filename are correct... |
| 19353 | If you are running Microsoft Access 2000 on Windows 2000 running Terminal Services, you cannot start two Lookup Wizards at the same time. If you try to do so, you may receive the following error message: You can only run one instance of the Lookup... |
| 19354 | When you try to open a linked table from a DB2 database that is running on AS400, you may receive the following error message: Microsoft Access cannot open this table in datasheet view. |
| 19355 | The Microsoft Access 2000 Conversion White Paper contains useful information about converting databases created in earlier versions of Access into the Access 2000 file format. This paper also describes the issues you may encounter when saving a... |
| 19356 | You cannot use a variable in the Criteria row of the design grid because Microsoft Access assumes that the variable name is a literal text string. However, you can use a function name in the design grid and have the function return the value of the... |
| 19357 | When you try to open a Microsoft Access database, you may receive an error message similar to the following: The Microsoft Jet database engine cannot open the file Filename . It is already opened exclusively by another user, or you need permission to... |
| 19358 | When you view a report preview window, Access 2000 may quit unexpectedly. |
| 19359 | When you type a Kanji + dakuon/handakuon string in a field that uses the Furigana property, and then overwrite the string or delete the string, you may receive the following error message: There isn't enough memory to perform this operation. Close... |
| 19360 | This article describes the Microsoft Access 2000 issues that are fixed in the Access 2000 Post-Service Pack hotfix package that is dated July 8, 2003. Issues That Are Fixed in the Hotfix Package The following issue is fixed in this hotfix package but... |
| 19361 | This article describes the Access 2000 issues that are fixed in the Access 2000 Post-Service Pack 3 hotfix package that is dated July 9, 2003. Issues That Are Fixed in the Hotfix Package The following issue is fixed in this hotfix package but was not... |
| 19362 | This article describes the Microsoft Access 2000 issues that are fixed in the Access 2000 Post-Service Pack 3 hotfix package that is dated July 2, 2003. Issues That Are Fixed in the Hotfix Package The following issue is fixed in this hotfix package.... |
| 19363 | This article describes how to convert data values of Text data type to Proper Case format (Title case format). |
| 19364 | When you run a procedure in Microsoft Access 2000 or later, you may receive the following error message: The expression Event_Name you entered as the event property setting produced the following error: Ambiguous name detected: EventProcedure_Name . |
| 19365 | When you try to roll back a record, Microsoft Jet may commit the record instead. |
| 19366 | When you try to compact and repair a database by using the Compact and Repair Database utility, you may receive the following error message: Table 'TempMSysAccessObjects' already exists |
| 19367 | When you start one of the Office 2000 programs that are listed at the beginning of this article after April 15, 2003, you may receive a prompt to register Office. This symptom may occur if Office has previously been registered or if the version of... |
| 19368 | 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. |
| 19369 | When inserting a record into a table that has a field that does not allow nulls, records inserted through the VFPODBC driver react differently than native Visual FoxPro. When you are inserting the record into a linked table through the Microsoft... |
| 19370 | This article describes how to use a Microsoft SQL Server distributed query to retrieve data from a secured Microsoft Access database. |
| 19371 | According to Microsoft Knowledge Base article 275561 ACC2000: New Features in Microsoft Jet 4.0: To minimize the impact of the increased page size and respond to a long-standing request from developers building applications based on the Microsoft... |
| 19372 | 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... |
| 19373 | When you use the Oracle ODBC driver to export an Access table that has fields of data type Single or Double, the driver fails to export those fields as follows. The Microsoft Oracle driver displays the following error message: Microsoft Access was... |
| 19374 | 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. |
| 19375 | This article describes how to store various Microsoft Outlook 2000 items in a Microsoft Access 2000 database file. |
| 19376 | When you run a stored procedure in Access project and that stored procedure creates and fetches a cursor, the stored procedure may fail. You may receive the following error messages: The data provider or other service returned an E_FAIL status.... |
| 19377 | The ReplFAQ2K.exe file contains a Microsoft Word document titled Frequently Asked Questions About Microsoft Access 2000 Replication written by Michael Kaplan, Mary Chipman, Paul Litwin, Steve Thompson, and John Blaine. This document answers many... |
| 19378 | 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... |
| 19379 | 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... |
| 19380 | When you insert a device-independent bitmap (DIB) into an OLE object field in Microsoft Access, the bitmap is not displayed. |
| 19381 | The FrmSmp00.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... |
| 19382 | The RptSmp00.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 that you want. Topics include dynamically sorting and filtering your data,... |
| 19383 | 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... |
| 19384 | The Microsoft Access 2000 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... |
| 19385 | 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... |
| 19386 | When you query a table that is linked to a Microsoft Excel spreadsheet, you may receive the following error message: Numeric field overflow. |
| 19387 | Microsoft has adopted a standardized naming schema for all hotfix (patch or update) packages for Office that are created and distributed by Microsoft. The new naming schema will go into effect for all hotfix packages in May, 2003. Note An Office... |
| 19388 | By modifying 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 2000, the Employee Sales by Country report in the sample... |
| 19389 | If you type or check the spelling of text with the language set as Portuguese (Brazil), Word may suggest an incorrect spelling or correct the word to an incorrect spelling. For example, if you type the word Petrobras, the word is either corrected to... |
| 19390 | 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... |
| 19391 | Novice: Requires knowledge of the user interface on single-user computers. The following table shows the default values for the AutoLabel and AddColon properties for the different form and report objects: Toolbox objectAutoLabelAddColonText boxYesYesOption groupYesNoToggle |
| 19392 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). In Microsoft Access 2000, the at sign (@) does not provide special formatting when you use it with the MsgBox |
| 19393 | When you initiate an Update query and then try to cancel the query, the records in the underlying table may still be modified. |
| 19394 | 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 filter that you... |
| 19395 | In the Microsoft Visual Basic 2000 Help topic Derived Math Functions, a compile error occurs when you copy and paste some of the functions containing a minus sign (-) into a module. |
| 19396 | This article shows you how to use Automation to modify properties of the Border object in a Microsoft Graph object. |
| 19397 | This article shows you how to use Automation to rotate a chart created in Microsoft Graph. NOTE : Only graphs of the three-dimensional type can be rotated. |
| 19398 | A limitation of the Microsoft Visual Basic for Applications Collection object is that it cannot contain a user-defined data type. You can achieve similar functionality, however, by creating a collection that contains the elements that you would... |
| 19399 | Microsoft Access 2000 supports the use of subqueries. A subquery is a select query inside another select or action query that acts as a criterion for a field. A subquery can refer to a table that is part of the current query, or to a table that is not... |
| 19400 | This step-by-step article describes how to reset an AutoNumber field value in Access. The AutoNumber field value in Access does not automatically reset when you delete some rows or all rows in a table. To reset the AutoNumber field value and to... |
| 19401 | This article describes errors that may occur in Access 2000 when you update data in queries and in forms. This article also describes the causes of the errors and how to troubleshoot those errors. When you try to update data in a query or in a form,... |
| 19402 | This article shows you how to simulate an array of controls on a form or report similar to the indexed control array functionality in Microsoft Visual Basic. Control arrays are not directly supported in Visual Basic for Applications, but you can... |
| 19403 | This article shows two examples of how to use the Animation ActiveX Control in a Microsoft Access database. The Animation ActiveX Control ships with Microsoft Office Developer Edition Tools. |
| 19404 | When you choose a new printer in Microsoft Access 2000, some of the printer settings for your forms and reports are changed. |
| 19405 | Two users on the same network can open the same System.mdw file using the Open Exclusive option in the Open dialog box. However, Microsoft Access ignores the exclusive lock on a System.mdw file in a multiuser installation. |
| 19406 | When you use Microsoft Visual C++ to create a custom ActiveX control that uses the KeyDown event as part of its functionality, you may notice that not all keys start the event. |
| 19407 | 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. |
| 19408 | When you use the TransferText action in a macro or in a Microsoft Visual Basic procedure to import data into an enabled Microsoft Access 2.0 database in Access 2000, you may receive the following error message: You can't import objects into a database... |
| 19409 | When you link a Microsoft SQL Server table that contains fields with Binary, Varbinary, or Timestamp data types, the data in these fields is displayed as seemingly random characters. Also, when you insert data from Microsoft Access into these fields... |
| 19410 | This article describes how to start a macro, a function, or another Microsoft Windows-based application by selecting it from a combo box or list box on a Microsoft Access form. |
| 19411 | When you browse to an Active Server Page (ASP) created from Microsoft Access 2000, you may receive an error message similar to the following: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver]... |
| 19412 | Microsoft Access does not display all the Microsoft ActiveX controls that you have installed on your computer. They are not displayed in the Insert ActiveX Control dialog box nor in the ActiveX Controls dialog box. |
| 19413 | When you export data to Microsoft Excel 2000, numeric values are displayed in a more precise way than they were in Microsoft Access, making the values appear to be incorrect. For example .15 in Microsoft Access appears as 0.150000006 when exported to... |
| 19414 | In Microsoft Access 2000, you are unable to save tables, queries, or forms as a dynamic Active Server Page (ASP) like you can in Microsoft Access 97. |
| 19415 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). The NPV (Net Present Value) function is only available in Visual Basic for Applications. However, you can write a |
| 19416 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). A data access page that is based on a query or view that has more than one table will not be automatically updateable |
| 19417 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). You may notice that linked tables in your database have slower performance when you open tables, or that performing updates takes longer than you |
| 19418 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 2002 version of this article, see 298605. When you type text data into a Text or Memo |
| 19419 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you use Visual Basic for Applications (VBA) code to retrieve and display the value of a Jet Replication ID or a |
| 19420 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access database (.mdb). The user-defined properties that you set for all columns in a query may be deleted. If you are using Data Access Objects (DAO) code, the query does |
| 19421 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access project (.adp). AutoLookup (also known as Row Fix-Up) is a process in which Microsoft Access automatically refreshes data from the primary table of a one-to-many |
| 19422 | 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 Knowledge Base... |
| 19423 | This article describes how to create sample Visual Basic for Applications code that uses Automation to create a Microsoft PowerPoint presentation. |
| 19424 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access project (.adp). For a Microsoft Access 2002 version of this article, see 292791. When you try to examine properties of the ADOX Views collection connected to SQL |
| 19425 | This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). Novice: Requires knowledge of the user interface on single-user computers. This article shows you how to create a Top 10 report, which is a report that lists the first 10 records, based |
| 19426 | This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). Moderate: Requires basic macro, coding, and interoperability skills. Access Help states that the ApplyFilter action and method has three arguments. However, there is no way to enter the |
| 19427 | This article describes several tips for improving performance when you access data from an ODBC data source. |
| 19428 | You can manipulate ZIP codes in Microsoft Access by changing the data type, input mask, or format of a ZIP code field. This article shows you how to manipulate ZIP codes that are already stored in a table and how to format ZIP codes when you enter... |
| 19429 | When you run Microsoft Access from the Start menu or a shortcut menu, you can use command-line switches to modify the startup process. For example, you can open a particular database, run a macro, or supply a password. |
| 19430 | In versions of Microsoft Access later than 2.0, 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... |
| 19431 | When a macro doesn't perform correctly, use the following methods to help you determine where the problem is located: Single Stepping - This feature steps through a macro one action at a time, with a pause between each action. To activate single-step... |
| 19432 | 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 OLE DB and ODBC-compliant... |
| 19433 | Microsoft Access 2000 and Microsoft Jet database engine version 4.0 use the DISTINCTROW predicate differently than did earlier versions of Microsoft Access. This article discusses the differences in queries that use DISTINCTROW. |
| 19434 | 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. |
| 19435 | 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 or report. This article discusses the different sources of information... |
| 19436 | The Microsoft Jet database engine runs in several different modes depending on whether it is called from Microsoft Access, Data Access Objects, the Microsoft OLE DB Provider for Microsoft Jet, or the Microsoft Access ODBC driver. It can be run in... |
| 19437 | 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 Access stops responding... |
| 19438 | 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. |
| 19439 | The Microsoft Access 2000 Readme file, Acread9.txtTXT, contains late-breaking information about issues related to setup, conversion, and use of the application. This file is installed by default to the C:\Program Files\Microsoft Office\Office folder... |
| 19440 | This article applies only to a Microsoft Access database (.mdb). Novice: Requires knowledge of the user interface on single-user computers. For a Microsoft Access 2002 version of this article, see 296449. This article demonstrates how you can create a report that ranks a specific number |
| 19441 | Moderate: Requires basic macro, coding, and interoperability skills. 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: Run-time error '2455': You entered an expression that has an |
| 19442 | Advanced: Requires expert coding, interoperability, and multiuser skills. You can change the printer for a report or form in two ways: You can change the Windows default printer.You can set the PrtDevNames and PrtDevMode properties. The information in this article supplements the |
| 19443 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). This article describes how you can disable the PAGE UP and PAGE DOWN keys in a form by using the KeyPreview property |
| 19444 | Moderate: Requires basic macro, coding, and interoperability skills. 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. |
| 19445 | Moderate: Requires basic macro, coding, and interoperability skills. When you run a procedure that contains the OpenReport method of the DoCmd object, and you use the wherecondition argument to pass a string that contains more than 2000 characters, the report may not open. You may also |
| 19446 | This article applies only to a Microsoft Access database (.mdb). Moderate: Requires basic macro, coding, and interoperability skills. The Microsoft Office 2000 Developer (MOD) Package and Deployment Wizard does not allow you to include custom registry entries in order to set Access |
| 19447 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 2002 version of this article, see 288194. When you use the w Weekday option to calculate |
| 19448 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you try to import or link a Microsoft Excel spreadsheet, if you click Show Named Ranges in the Import |
| 19449 | You can delete objects programmatically by using either the Delete method or the DeleteObject method. You can also use the DeleteObject action in macros. |
| 19450 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). When you try to run macro actions that contain a WHERE clause (ApplyFilter, OpenForm, OpenReport, and FindRecord), and queries that reference the |
| 19451 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). When you print or preview a report, you may receive the following error message: You can't use a pass-through query or a non-fixed-column crosstab |
| 19452 | Novice: Requires knowledge of the user interface on single-user computers. If you use the Format() function on the result of a Month() function, Microsoft Access returns an incorrect result. Novice: Requires knowledge of the user |
| 19453 | Advanced: Requires expert coding, interoperability, and multiuser skills. If you use a dynamic data exchange (DDE) function as the ControlSource property of a list box or a combo box, the box will be empty when you view it in Form view. However, if you view the form in Datasheet view, |
| 19454 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). Form and report sections have a KeepTogether property that you can set to Yes or No. The KeepTogether property |
| 19455 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 2002 version of this article, see 287685. This article describes how to concatenate |
| 19456 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you run a DSum() function, you receive incorrect results. When you |
| 19457 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). You can display multiple fields in a combo box or a list box on a form or a report even when those fields come from a |
| 19458 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access project (.adp). In a Microsoft Access project, after you change the connection to point to a different database, you see unexpected data in combo boxes, list boxes, |
| 19459 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access project (.adp). In a Microsoft Access project, after you modify the Database properties, you notice that an object that you recently created is no longer there. This can |
| 19460 | Novice: Requires knowledge of the user interface on single-user computers. When you disable the ControlBox property of a form, you are no longer able to gain access to the View menu by pressing ALT+V. When you disable the ControlBox property |
| 19461 | Novice: Requires knowledge of the user interface on single-user computers. 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 |
| 19462 | Moderate: Requires basic macro, coding, and interoperability skills. When you print or preview a report that is based on a query, it may contain more records than the query returns. When you print or preview a report that is based on a query, |
| 19463 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you use certain Access methods that modify modules or references, all variables in the same Visual Basic |
| 19464 | This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). Advanced: Requires expert coding, interoperability, and multiuser skills. Microsoft Access does not have a feature that enables you to determine the path for a linked OLE object stored |
| 19465 | Microsoft has released Microsoft Office 2000 Service Pack 3 (SP-3). This article describes the issues that are fixed for Microsoft Access 2000. about how to download and how to install the Office XP Service Pack 2 (SP2) 326585 OFF2000: Overview of the... |
| 19466 | When you programmatically copy a file with the FileCopy statement in Visual Basic for Applications, you may receive the following error message: Run-time error '70' Permission denied |
| 19467 | Moderate: Requires basic macro, coding, and interoperability skills. For a Microsoft Access 2002 version of this article, see 286242. When you use the FindFirst method, you receive a No match or a run-time error message. This behavior occurs when you search for a value that contains |
| 19468 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access database (.mdb). When you try to open a Visual Basic for Applications class module in Design view, you see one or more of the following behaviors: Access stops |
| 19469 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). If you use transaction processing to validate a user's input in the BeforeUpdate event of a subform, and if you |
| 19470 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). After you type a Format property of **$#,##0.00 for a control in a report or a form, or for a field in Design view |
| 19471 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). When you try to print or preview expanded levels of a hierarchical table (subdatasheets), the data printed or displayed in preview is incorrect |
| 19472 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). On a computer that is running Windows 98, when you print text that includes the euro symbol from a table in |
| 19473 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). When you click the Advanced button in the Import Text Wizard, the mouse pointer changes to an hour glass, and Access appears to stop responding |
| 19474 | When you click the Exit button that runs the DoCmd.Close Microsoft Visual Basic for Applications (VBA) code, an Enter Parameter Value dialog box may appear. This occurs when you close a form window in Access that runs with the Windows XP operating... |
| 19475 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). In a Microsoft Access database or project running on Microsoft Windows 95 or Microsoft Windows 98 in which a form is |
| 19476 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access database (.mdb). When you try to save a change that you made in Design view of a table, you may receive the following error message: Illegal Operation performed on |
| 19477 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). When you close a form that has a combo box that is based on a parameterized query, you may receive the following error message. If you are running |
| 19478 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). In a Microsoft Access database that contains hundreds of forms, reports, macros, or modules, you may see one or more of the following symptoms: In the |
| 19479 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). After you convert a database from Access 2.0, you find that a macro containing the FindRecord action is not behaving as expected. |
| 19480 | This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). Novice: Requires knowledge of the user interface on single-user computers. When you try to delete a data access page that has one or more supporting files, such as an image file, you |
| 19481 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). When you search for a Null value by using the Find command on the Edit menu, the Visual Basic for Applications equivalent of the Find command, or the |
| 19482 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). If you press a numeric or an alphabetical key on the keyboard while focus is in a list box that is based on a text field which has a format |
| 19483 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access project (.adp). When you are using a parameterized stored procedure as the initial record source for a form (by setting both the RecordSource and the UniqueTable |
| 19484 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you compile a Microsoft Access 2000 database or project, all empty event procedures are removed from the |
| 19485 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). When you convert a database to Access 2000, you may receive the following error message: There were compilation errors during the conversion or |
| 19486 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you run a report that contains code which dynamically calculates width, you notice that the calculations |
| 19487 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access database (.mdb). After you use a Table object with the ADOX Catalog object in a Visual Basic for Applications procedure, you notice that the field properties of one |
| 19488 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). For a Microsoft Access 2002 version of this article, see 287432. In Access 2000, each time that you sort a query that has parameters, the query prompts |
| 19489 | When you design a view in an Access project (.adp), no column names are displayed for any table that is inserted in the view. CAUSE This behavior occurs in an Access project that is connected to a Microsoft SQL Server database with a name that includes a hyphen |
| 19490 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). If you have opened multiple instances of a report, you find that no matter which instance you try to export or |
| 19491 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). You find that you cannot open or convert one of your Access 97 databases. Either nothing happens at all (the operation fails silently), or you |
| 19492 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 2002 version of this article, see 287674. When you try to export a table by using the |
| 19493 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). When you use the DeleteObject method to programmatically delete an object that does not exist, you may receive the following error message: Run-time |
| 19494 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). When you try to edit data in a multiuser Jet database or in a database that you have open more than once on your computer, you cannot modify the |
| 19495 | This article describes how to publish a Microsoft Office document to a Web server by using the File Transfer Protocol (FTP). |
| 19496 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access project (.adp). Although the SQL Server and Microsoft Data Engine (MSDE) bit data type allows NULL values, when you create a table in a Microsoft |
| 19497 | When you print a document that was created by using the right-to-left language features in a Microsoft Office 2000 program, the document may be printed with unreadable characters, missing sections, or incorrect formatting. |
| 19498 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). In SQL view of a query, if you try to save a long SQL statement, you see one of the following behaviors. In Windows 95 or 98 You may receive the |
| 19499 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access database (.mdb). When you run a delete query, or when you open a table in Datasheet view, click Select All Records on the Edit menu, and |
| 19500 | When you use Access 2000 to link a Microsoft SQL Server table that contains a UniqueIdentifier column as the primary key, #DELETED appears for all records in the result set. |
| 19501 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access project (.adp). When you view the contents of a char, nchar, varchar, or nvarchar column in an Access project that contains a value with more |
| 19502 | Advanced: Requires expert coding, interoperability, and multiuser skills. To include a custom context-sensitive Help file in a Microsoft Access 2000 run-time solution, you cannot just add the .chm or .hlp file to the package. You must also take some other steps to make |
| 19503 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). In a Microsoft Access 2000 query, when you try to edit the query in the query design grid, you may receive the following error message: The expression |
| 19504 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). When you delete a record from a subform that was built with the Form wizard, Microsoft Access hangs (stops responding). CAUSE |
| 19505 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you insert a hyperlink that points to a Microsoft Word document, a Microsoft Excel workbook, a Microsoft |
| 19506 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). A Microsoft Access report suddenly is not formatted as expected. Upon checking the printer settings, you find that they have been reset to their default |
| 19507 | When you use any of the programs listed at the beginning of this article, you may notice any of the following problems: When you attempt to start one of the programs, the following error message may appear: This program has performed an illegal... |
| 19508 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access database (.mdb). When you use the AddNew method on a recordset object variable created from the RecordsetClone property of a form, the form incorrectly moves to a |
| 19509 | When you run or open a Microsoft Visual Basic for Applications macro with a UserForm, the following error message appears: System Error &H80004005 (-2147467259). Unspecified error. This may be followed by these error messages: Out of memory Run-time... |
| 19510 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access project (.adp). After you upsize a form that has a combo box bound to a Yes/No field in a table, the combo box no longer displays data in a Microsoft |
| 19511 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access project (.adp). After you disable your server as a publisher/distributor, you are unable to create new publications. When you try to create a new publication, |
| 19512 | This article applies only to a Microsoft Access database (.mdb). Advanced: Requires expert coding, interoperability, and multiuser skills. If you have two forms open with the same record source, and you programmatically set the recordset of one form to be equal to the recordset of the |
| 19513 | In the products listed above, when you click Open on the File menu, select a File Transfer Protocol (FTP) site, and then click Open , error messages similar to the following may appear: Cannot connect to the FTP server on the computer named... |
| 19514 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access database (.mdb). After you use the Microsoft Access Upsizing Tools to migrate your database to a Microsoft Access client/server application, |
| 19515 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). ERROR MESSAGE When you try to create or open a report in Microsoft Access, you may receive the following error message: |
| 19516 | ERROR MESSAGE When you try to print from Microsoft Access, you see the following error: The dynamic-link library Commdlg failed: error code '0xl'. The printer driver for the selected printer may be incorrectly installed. NOTE: Microsoft Office 2000 has built-in functionality |
| 19517 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). ERROR MESSAGE When you try to create or open a report in Microsoft Access, you may receive the following error message: |
| 19518 | If you attempt to delete an ActiveX object contained in a custom user form or to remove a user form from a workbook in any of the Microsoft Office 2000 programs listed in the beginning of this article, you may receive an error similar to following:... |
| 19519 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). ERROR MESSAGE When you run a procedure, you may receive the following error message: The expression you entered as the |
| 19520 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). ERROR MESSAGE When you try to convert a Microsoft Access version 2.0 database to version 2000, you may receive the |
| 19521 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access project (.adp). When you open an Access project as Read-Only, you notice that you can still make design changes to the tables. CAUSE |
| 19522 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). For a Microsoft Access 2002 version of this article, see 294755. When you try to convert a database to Access 2000, you may receive the following |
| 19523 | Moderate: Requires basic macro, coding, and interoperability skills. In the Calendar control included with Microsoft Access 2000 and Microsoft Office 2000 Developer, you can change the formatting of all the text, but you cannot change the formatting of individual dates. |
| 19524 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). This article describes how to display a label after a set number of printed lines of data on a report. For example, |
| 19525 | 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... |
| 19526 | By default, a new Microsoft Access 2000 database does not reference the Microsoft DAO 3.6 Object Library. This is a change from earlier versions of Access. If you run Visual Basic for Applications code that uses the Data Access Object (DAO) library in... |
| 19527 | Using Microsoft Jet version 4.0, sorting is different than in previous versions. For example, assume you have the following records in an Access table: FIELD1 W W- WB W-B In previous versions of the Jet database engine, issuing SELECT * FROM Table1... |
| 19528 | When you run a Microsoft Access project (.adp) form against large tables in Microsoft SQL Server 7.0 or Microsoft SQL Server 2000, the SUM function does not return the same value each time that the form is opened. Instead, a random, incorrect result... |
| 19529 | When you start one of the Office programs listed at the beginning of this article, the following error message appears: This application must be installed to run. Please run Setup from the location where you originally installed the application. Also,... |
| 19530 | In Microsoft Office, you can use a variety of special characters when creating or saving files. Microsoft Windows also allows you to use special characters for naming files or folders. However, some of these special characters hold special meaning in... |
| 19531 | This article describes what happens to Microsoft Access groups, calculations, and labels when you export a report to Microsoft Excel. |
| 19533 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 97 and earlier version of this article, see 187342. When you view the list portion of a combo |
| 19534 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). This article shows you how to create a combo box that is filtered to list only those items that are related to an item that you selected in a |
| 19535 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). This article shows you two methods that you can use to create a fixed-width text file that enables fields to be either left- or right-aligned |
| 19537 | 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... |
| 19538 | 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. |
| 19539 | 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... |
| 19540 | When you double-click any Microsoft Office file that was created in Microsoft Office version 4.3, the following error message may appear: Windows cannot find Program. This program is needed for opening files of type ProgramFileType where Program... |
| 19542 | When you view a Microsoft Office 2000 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. |
| 19543 | When you attempt to upsize a Microsoft Access 2000 database to Microsoft SQL Server 2000, you may receive the following error message: Overflow You may also receive the same error message when you try to create an Access project that connects to an... |
| 19544 | After you install Microsoft Office 2000 Premium, when you try to start your run-time application, you are asked whether you want to convert or enable your database. |
| 19545 | When you install the Microsoft Access 2000 Run-Time component on a computer, you see a screen titled Ready to Install . This screen shows the default installation location as follows: C:\Program Files\Microsoft Office\ The following behavior may... |
| 19546 | When you create a new database, Microsoft Access automatically adds the .mdb file name extension to the database name, even if you type your own extension in the File name box. This applies to all dialog boxes in Microsoft Access in which you can... |
| 19547 | When importing a text file into a Microsoft Jet database through a Microsoft SQL statement or the Microsoft Access TransferText macro command when there is no Schema.ini file present, the Jet engine can sometimes interpret a column with Text data as... |
| 19548 | The Microsoft Access Help topic for the OutputTo action states that this macro action outputs data to the Microsoft Excel 98 format. However, when you open the exported Microsoft Excel spreadsheet in Microsoft Excel 2000, you notice that the format is... |
| 19549 | This article shows you how to view and edit relationships in a Microsoft Access database. |
| 19550 | This article shows you how to edit records in related tables. It includes the following topics: |
| 19551 | This article describes the new features of Microsoft Jet 4.0, and compares some of the changes between the prior version of Microsoft Jet (version 3.5) and Jet 4.0. |
| 19552 | Microsoft Office 2000 Premium, Microsoft Office 2000 Professional, and the stand-alone version of Microsoft Access 2000 have a Calendar ActiveX control that you can use in Microsoft Office applications. However, you are not licensed to redistribute... |
| 19553 | When you try to start any of the Microsoft Access wizards, the wizard does not start. You may see either the busy mouse pointer or nothing, and then the focus returns to Access as if you had not tried to start the wizard. |
| 19554 | When you move from record to record in a main form, the main form and the nested subform are not synchronized if either of the following conditions is true: |
| 19555 | This article applies only to a Microsoft Access database (.mdb). This article provides information and examples on how to use Microsoft Access 2000 as an Automation server. With Visual Basic for Applications, you can manipulate the functionality of... |
| 19556 | SYMPTOMS When you try to run upsized make-table or append queries in a Microsoft Access project, you may receive the following error message: Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option. |
| 19557 | SYMPTOMS Even though Name AutoCorrect is enabled to track and perform changes in your database, when you open a report after changing a field name, a query name, or a table name, you are prompted for the old field name, or you receive the following |
| 19558 | After you compact and after you repair a database that includes a table that has an AutoNumber field, you notice that when you enter new data, the AutoNumber is a duplicate of an earlier AutoNumber. |
| 19559 | SYMPTOMS When you use the TransferText method to import or export a text file, you may receive the following error message: Run-time error '2511': The action or method requires a Specification Name argument. Run-time error '2511': The action or |
| 19560 | SYMPTOMS When you try to import objects from a Microsoft Access 97 secured database into a Microsoft Access 2000 database, you may receive the following error message: You don't have permissions to import, export or link to ' tablename'. You |
| 19561 | SYMPTOMS Every time that you use Help in Microsoft Access 2000 or in the Visual Basic Editor, you receive the following message: Preparing index for first use... This happens even if you have used Help before. |
| 19562 | SYMPTOMS When you open a report in a Microsoft Access project, you may receive the following error message: The recordsource recordsource specified on this form or report does not exist. The recordsource recordsource specified on this form or |
| 19563 | SUMMARY This article demonstrates how to use the Seek method with an ActiveX Data Objects (ADO) recordset. Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the |
| 19564 | SYMPTOMS When you open a table that has more than 255 columns in an Access project, you receive the following error messages, and then the table does not open: Too many columns defined in a rowset Too many columns defined in a rowset -and- |
| 19565 | SYMPTOMS When you use a property of the DataAccessPages object, you may get one of the following error messages: Run-time error '2018': The data access page name ' page name' you entered is misspelled or refers to a data access page that isn't |
| 19566 | SYMPTOMS When you expand the Subdatasheet view of a table, you may receive the following error message: The table or query name ' TableName' you entered in either the property sheet or macro is misspelled or refers to a table or query that doesn't |
| 19567 | SYMPTOMS In the Import, Export, and Link dialog boxes in Microsoft Access 2000, FoxPro is not listed as an option for file type. |
| 19568 | ACC2000: Error Message: The User-Supplied Function Named 'Function Name', the Program to Assist You in Resolving Conflicts, Could Not Be Found |
| 19569 | SYMPTOMS When you insert a module from text in the Visual Basic Editor (VBE), the module does not appear in the Microsoft Access Database window. |
| 19570 | SYMPTOMS When you export a table from a Microsoft Access database to the Microsoft Word Merge format, you may receive the following error message: The data being exported does not match the format described in the Schema.ini file. The data being |
| 19571 | SYMPTOMS When you enable or convert a database that was created in an earlier version of Microsoft Access in Access 2000, any fields with a Binary data type have the appearance of data corruption, showing extended characters throughout. |
| 19572 | SYMPTOMS When you type an invalid value in the ControlSource property of a control on a data access page, Microsoft Access returns one of the following error messages and erases the value: Invalid property value. Invalid property value. -or- |
| 19573 | SYMPTOMS When you try to convert a database that was created in an East Asian version of Access 97, such as a Japanese or a Chinese database, in the U.S. English version of Access 2000, you may receive one of the following error messages: The |
| 19574 | SYMPTOMS In a Microsoft Access project, if you place a calculation inside an aggregate (totals) function, you may see one of the following problems: When you open a form, #Error is displayed in a text box. -or- You may see the following error when |
| 19575 | After you install the latest service pack for Microsoft Jet 4.0, when you import text files or try to export an Access object to text format, you may receive the following error message: Can't update. Database or object is read-only. When importing,... |
| 19576 | SYMPTOMS When a form is open in a database, and if that form has a control on it that references a subform control, when you try to open a second instance of the database, you may receive the following error message: The database has been placed in |
| 19577 | SYMPTOMS When you try to open the Visual Basic Editor in a Microsoft Access database (by pressing ALT+F11), you may receive one or more of the following error messages: The Visual Basic for Applications project in this database is corrupt. The |
| 19578 | SYMPTOMS When you start the Form or Report Wizard in Microsoft Access 2000 to create a new form or report, and you then cancel the wizard, you may receive one of the following error messages if you try to open a second instance of the same database: |
| 19579 | SUMMARY This article demonstrates how to open the Visual Basic Editor in an Access MDE or ADE database when full menus and special keys are both disabled. |
| 19580 | SYMPTOMS When you open a data access page created with the original version of Microsoft Access 2000 that contains the Calendar control, you may see one of the following warnings: Do you want to install and run http:// server/mscal.ocx? The |
| 19581 | SYMPTOMS If you create a query based on a table that has a name beginning with the following Jet SQL reserved words ALL (for example, All YourName) DISTINCT (for example, Distinct YourName) DISTINCTROW (for example, Distinctrow YourName) TOP |
| 19582 | SYMPTOMS When you try to set the Index property of an ActiveX Data Objects (ADO) recordset that is based on a table in a Microsoft Jet database, you may receive the following error message: Run-time error '3251': Object or provider is not capable |
| 19583 | SYMPTOMS In an Access project in which you have the record source of a form or a report set to a stored procedure that selects from a local or a global temporary table, the field list is empty. You may also receive the following error message when |
| 19584 | SYMPTOMS When you try to export data from a Microsoft Access 2000 database to a text file, and if the table contains a field with a data type of Number and a field size of Decimal, you may receive the following error message Invalid argument. |
| 19585 | SUMMARY By using an append query, you can change the starting value of an AutoNumber field in a table to a number other than 1. |
| 19586 | In Microsoft Access, when you import a dBase, FoxPro, or Paradox file that does not follow the MS-DOS 8.3 file name format (that is, its name before the period exceeds eight characters, or it lacks a three-character extension following the period),... |
| 19587 | SYMPTOMS When you include a comma (,) as part of the To argument for a SendObject action in a macro or code, Microsoft Outlook and Microsoft Outlook Express display the comma as a semicolon (;) when the action runs. |
| 19588 | SYMPTOMS Novice: Requires knowledge of the user interface on single-user computers. You cannot change engine-enforced properties such as FieldSize, DefaultValue, ValidationRule, ValidationText, Required, or AllowZeroLength on linked (attached) |
| 19589 | SUMMARY Microsoft Access includes a Data Definition Language (DDL) that you can use to create and delete (drop) tables and relationships. You can also do these same operations by using Data Access Objects (DAO) in Visual Basic for Applications. This |
| 19590 | This article lists tips to optimize the performance of Open Database Connectivity (ODBC) data sources in Microsoft Access. NOTE : This article assumes that you are familiar with client/server environments and architectures. |
| 19591 | SUMMARY This article describes how to refer to controls on subforms or subreports, and describes some common behaviors you may encounter when you refer to controls on subforms or subreports. |
| 19592 | SUMMARY Microsoft Access 2000 enforces field and record validation rules defined at the table level, regardless of the data input or editing method. |
| 19593 | SYMPTOMS 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 an error similar to the following: RunTime Error'3112': Record(s) cannot be |
| 19594 | SUMMARY This article discusses whether the Visual Basic for Applications programming language is a compiled language or an interpreted language. |
| 19595 | 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... |
| 19596 | SYMPTOMS 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: The object doesn't |
| 19597 | SUMMARY To perform a mail merge with Microsoft Access data, you can export or copy your data to a word processor program, or you can use the Microsoft Word Mail Merge Wizard. However, you can also create a Microsoft Access report to generate mail-merge |
| 19598 | SYMPTOMS You may be unable to import any data from a fixed-width text file. |
| 19599 | SUMMARY Screen fonts and printer fonts can be different. When you create a new form or report, you can use the LayoutForPrint property to set whether the controls on the form or report are formatted with screen fonts or printer fonts. If you use |
| 19600 | SUMMARY You can display multiple fields in a combo box or a list box on a form or a report, even when those fields come from a table that is not bound to the form or to the report. You can also update controls, such as text boxes, with new information |
| 19601 | SUMMARY The TransferDatabase action is the macro equivalent of the Link Tables command. However, Microsoft Access does not have an action to delete a link to a linked (attached) table. To remove a linked table from the Database window, select the |
| 19602 | SYMPTOMS When you try to open an object or change permissions for an account, you may receive one of the following error messages: You can't view this object's permissions. You can't view this object's permissions. -or- No permission for |
| 19603 | SUMMARY The Database object provided by a Microsoft Data Access Object (DAO) has a Name property. However, this property returns the full path and the file name of the database. To retrieve either the path or the file name separately, you must parse |
| 19604 | SUMMARY This article describes how to use the OpenDatabase method to open a Microsoft Access database that has a database password. Note that this is different from opening a database that is secured with the Microsoft Access user-level security |
| 19605 | SYMPTOMS When you use the Import Text Wizard to import certain text files, you may see one of the following symptoms: The records in the imported file are combined into one continuous record. The Import Text Wizard stops responding (hangs), or |
| 19606 | SUMMARY This article shows you two methods that you can use to create queries that list only the top n items per group. By using either one of these methods, you can create a query that displays only the top five salespeople for each region. |
| 19607 | SYMPTOMS When you attempt to display a form in Microsoft Access, you may receive one of the following error messages: The expression event you entered as the event property setting produced the following error: Microsoft Access doesn't support the |
| 19608 | SYMPTOMS After you run ActiveX Extensibility Objects (ADOX) code referring to a Table object in a Microsoft Access database, you notice that the field properties in one or more queries in the database are missing. |
| 19609 | SYMPTOMS When you try to export a report that contains a form in Datasheet view as a subreport to another file format such as Text (*.txt), Microsoft Excel (*.xls), or Rich Text Format (*.rtf), you may receive the following message: The Save As |
| 19610 | SYMPTOMS After you convert a database that you created with the Database Wizard in an earlier version of Microsoft Access, you may receive the following error message when you click the Change Switchboard Items button on the Main Switchboard form: |
| 19611 | SYMPTOMS After you create Lookup fields in tables, the Lookup data is ignored when you export the table to Hypertext Markup Language (HTML), Internet Database Connector (IDC), or Active Server Pages (ASP) format. Data from the bound column for the |
| 19612 | SYMPTOMS If you open a database that was created in an earlier version of Microsoft Access, and you try to run or to compile code that uses Data Access Objects (DAO), you may receive a compile error. |
| 19613 | When you save your file, the Create New Folder button in the Save As dialog box is not available. |
| 19614 | When you programmatically activate a commandbar drop-down list, you may receive one of the following error messages: If you are running Microsoft Windows 95 or Microsoft Windows 98: You see the following Microsoft Visual C++ Runtime Library error |
| 19615 | In a query, you may want to sort a field based on all permutations of each group of digits. For instance, all of the following records would appear together in the sort: 5678, 6785, 7856, 8567, 7568, 8756 These records would appear together |
| 19616 | When you open a form or a report in Design view, you don't see the toolbox. This is true even though the Toolbox command is checked on the Toolbars submenu on the View menu. |
| 19617 | This article shows you how use Data Access Objects (DAO) to control transactions in a form that is based on a table (a bound form) in a Microsoft Access (Jet) database. |
| 19618 | On a form, you can use the NotInList event of a combo box to add records to an underlying table. This article describes how to use the HTML dropdown list control to simulate this functionality on a data access page. This article uses the |
| 19619 | To reduce data entry, you may want to copy data from an existing record to a new record. This article provides two methods to accomplish this on a data access page. |
| 19620 | In a form, if a control has an input mask, you can enter data into any position in the control (left, right, middle), even if you first click in the control. There is no option that you can use to turn this feature off. This article shows you how to |
| 19621 | This article shows you how to calculate daily hours worked, regardless of the number of times an employee clocks in or out. |
| 19622 | When you use aggregate functions, such as Sum, Count, Min, and Max, you may receive a #Error error when the form is based on an ActiveX Data Object (ADO) recordset. |
| 19623 | 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. |
| 19624 | This article shows you how to create the ConvertMDBs function that you can use to convert all the databases in a specific folder to Access 2000 format. It also shows you how to create the ProcessTree function that you can use to convert all Access |
| 19625 | SYMPTOMS When you use Microsoft FrontPage Help and then you open and use Help in another Office application, you may receive one of the following errors. In Windows 95/98: This program has performed an illegal operation and will be shut down. If the |
| 19626 | When you create server-based objects such as tables and views in a Microsoft Access project, it's a good idea to document the schema of each object so that you can re-create it in the future. If you own Microsoft SQL Server 7.0, you can use the |
| 19627 | This article describes how to create and use a form that contains Start/Stop and Reset command buttons that use the Timer event of a form to display elapsed hours, minutes, and seconds in a text box control. NOTE: This article explains a technique |
| 19628 | 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 as flat |
| 19629 | This article shows you how to programmatically create a list of Access error messages and to save the results to an Access table, complete with the associated error number. |
| 19630 | If you invoke the Undo method of a form outside the form module, such as in a global procedure, a global function, or from the Immediate window, you may receive an error similar to one of the following: Dr. Watson for Microsoft Windows NT An |
| 19631 | This article shows you how to create an HTML page that sorts a data access page by three different fields. This HTML page is a frameset made up of two data access pages. The first page provides the controls to sort the second page. |
| 19632 | Form and report class objects in Microsoft Access define a set of events that makes it possible to use event procedures to automate tasks. By using the WithEvents keyword, Visual Basic for Applications allows you to track the events occurring in a |
| 19633 | When you delete records in a form in a Microsoft Access project (.adp), the order of events is different than when you delete records in a form in a Microsoft Access database (.mdb). In a Microsoft Access project, the order of events when you delete |
| 19634 | This article demonstrates how to create script that filters a data access page by setting the ServerFilter property. You can use this script even when the page is not stored on a Web server. |
| 19635 | You cannot create a system DSN by using the RegisterDatabase method. To create a system DSN, use the ODBC API call for SQLConfigDataSource. Microsoft provides programming examples for illustration only, without warranty either expressed or implied, |
| 19636 | When you try to assign an ActiveX Data Objects (ADO) Recordset object to a form, you may receive the following error message: The object you entered is not a valid Recordset property. The object you entered is not a valid Recordset property. |
| 19637 | When you create a chart by using the Microsoft Access Chart Wizard, you do not have the option to place data labels on the chart. You can, however, add data labels to the chart manually by using Microsoft Graph, or you can add them programmatically by |
| 19638 | This article demonstrates a technique that you can use to synchronize two drop-down lists on a data access page. You can also apply this same technique to group filter controls or a combination of both control types. Although the end result of this |
| 19639 | When you run certain stored procedures from a Microsoft Access project, the output of the procedure is truncated in Datasheet view. If you run the same procedure from one of the SQL Server Client Tools, all rows are returned as expected. |
| 19640 | This article describes a method that you can use to collate and print two reports. This method alternates two reports between the DoCmd.SelectObject and DoCmd.PrintOut Visual Basic methods. NOTE: This article explains a technique demonstrated in |
| 19641 | When you try to edit data in a form based on an ActiveX Data Objects (ADO) recordset, the form is read-only. This occurs even if you can successfully edit the recordset directly with ADO. |
| 19642 | 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. |
| 19643 | When you attempt to use any of the Web features in the Microsoft Office 2000 programs listed at the beginning of this article, and Microsoft Internet Explorer is installed, you may receive an error message similar to one of the following Program name... |
| 19644 | In an Office 2000 program, when you use the Open dialog box to select an Office document and then click the Tools list, the Find command is not displayed. |
| 19646 | When you run ActiveX Data Objects (ADO) code that references properties or methods of an object, you receive either unexpected results or the following error message: Run-time error '3265': ADO could not find the object in the collection |
| 19647 | Running code in a module may cause the module to disappear. |
| 19648 | This article demonstrates how to programmatically determine if a user successfully deleted one or more records in a bound form in a Microsoft Access project (ADP). |
| 19649 | If you use the Requery method of the Recordset object to requery a form, you no longer see all the records in the form. If you are using a Microsoft Access database, you find that the first record is the only record appearing in the form. If you are |
| 19650 | If you use the CommitTrans or RollbackTrans methods directly with the CurrentProject.Connection object, you may receive one of the following errors: You tried to commit or rollback a transaction without first beginning a transaction. You tried |
| 19651 | This article shows you how to use explicit and implicit parameters with ActiveX Data Objects (ADO) and Microsoft Jet. |
| 19652 | When you make changes to a module and then close the Visual Basic Editor, or you close the Module window but leave the Visual Basic Editor open, you are not prompted to save the changes. |
| 19653 | In Microsoft Data Access Objects (DAO), if you set the Bookmark property to LastModified, you may receive the following error message: No Current Record. No Current Record. |
| 19654 | When you use one of the new Visual Basic for Applications functions as an expression, you may receive the #Name? error value. For example, if you set the ControlSource property of a text box to the expression =WeekdayName(6) , the text box returns... |
| 19655 | Even though you can programmatically create a Microsoft Jet 4.0 QueryDef (stored procedure), you may not be able to access it by using the adCmdStoredProc constant with the CommandText property in ActiveX Data Objects (ADO). |
| 19656 | When you are using ActiveX Data Objects (ADO), if you use the AddNew or Delete method of the Recordset object, and you open the recordset with an unspecified lock type, you may receive one of the following error messages: Run-time error '3251': |
| 19657 | This article shows you how to upsize a Microsoft Access database to the Microsoft SQL Server or to the Microsoft Data Engine (MSDE) by using the Access 2000 Upsizing Wizard. This article covers an introduction to the Upsizing Wizard, what to check... |
| 19658 | 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... |
| 19659 | The Microsoft Access 2000 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... |
| 19660 | When you drag a table from the field list to a data access page and choose to place the fields as individual controls in the Layout Wizard dialog box, you may receive the following message: You tried to drop an OLE or Long Binary column onto your data... |
| 19661 | When you use the Combo Box Wizard to create a combo box on a form that is not based on any table or query, you see all three of the normal options. However, the following option does not work: Find a record on my form based on the value I selected in... |
| 19662 | This article describes the concept of lightweight objects and provides a technique to create a lightweight switchboard form that uses the Hyperlink properties of form controls to open other objects in the database. |
| 19663 | When you call a class module method directly from a query, form, report, or macro, you receive an error message. |
| 19664 | In Help in the Visual Basic Editor, you see methods, properties, events, and statements that apply only to the |
| 19665 | You can use the tab control to display linked subforms. A form contains linked subforms when the second subform displays only the records related to the record that you select in the first subform. The Customer Orders form in the sample dat |
| 19666 | In Microsoft Access, when you try to run the Microsoft Office Chart Wizard on a data access page, you may receive the following error message: Run-time error '424': Object required |
| 19667 | 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 type no data for that control, you do not receive an error message. Any changes that you |
| 19668 | When you concatenate variables or controls in a function or OpenRecordset method, you may receive one of the following error messages. Run-time error '3070': The Microsoft Jet database engine does not recognize '' as a valid field name or |
| 19669 | 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 application, you |
| 19670 | This article demonstrates a sample user-defined procedure that you can use to create a toggle button on a form that enables you to cycle through the form's controls and set such properties as Locked and Enabled, without having to refer to each |
| 19671 | This article shows you how to create two user-defined functions that you can use to convert any letter in a phone number to its corresponding digit on a telephone keypad or rotary dial. For example, you can convert the number 425-ACC-ESS9 to its |
| 19672 | The OpenDatabase method in Visual Basic for Applications enables you to open an external database file and to work with Data Access Objects (DAO) in that database. The OpenDatabase method supports Microsoft Access databases and a number of |
| 19674 | Although you cannot use the Seek method directly on a linked (attached) Microsoft Access table, by using Visual Basic for Applications, you can create a workaround. This article demonstrates a sample user-defined Sub procedure that you can use to |
| 19675 | This article shows you how to create a table of contents or an index for a report. NOTE: This article explains a technique demonstrated in the sample file, RptSmp00.mdb. For information about how to obtain this sample file, please see the following |
| 19676 | This article explains how Microsoft Access stores the Date/Time data type, and why you may receive unexpected results when you calculate or compare dates and times. This article addresses the following topics: Storing Date/Time Data Formatting a |
| 19677 | You can use the PrtDevMode property to set or return printing device mode information specified for a form or report in the Print dialog box. When you use the PrtDevMode property, you need to keep certain printer driver characteristics in mind. |
| 19678 | This article shows you how to create two user-defined functions for copying records from a Microsoft Access recordset to a Microsoft Excel spreadsheet and printing the updated spreadsheet. The functions use OLE Automation to transfer the data to |
| 19679 | 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 application. The |
| 19680 | This article describes how to create a form that uses the TransferDatabase command to attach tables from an Open Database Connectivity (ODBC) data source. Creating this form provides more control over the tables than the Link dialog box and is |
| 19681 | A form whose ControlBox, MinMaxButtons, and CloseButton properties are set to No still displays the Restore and Close buttons when you maximize the form. Microsoft provides programming examples for illustration only, without warranty either |
| 19682 | This articles demonstrates a method that you can use to change the background color of the active control on a form. This method will change the background color of any active control that supports the BackColor property. Microsoft provides |
| 19683 | Microsoft Access doesn't have properties to determine if a form or a report is maximized or minimized. This article shows you how to create custom form properties that determine if a form is maximized or minimized. This method uses Windows application |
| 19684 | You can use the SysCmd() function to perform several functions. One of these functions is the acSysCmdAccessDir(), which returns the name (\\) of the folder where Msaccess.exe is located. It does not return the name of the executable file, |
| 19685 | When you define a field as an AutoNumber field, Microsoft Access automatically increments the value of the field whenever a new record is added to the table. You have no control over this value. If you want to control the value of the number assigned |
| 19686 | When you use the SendKeys statement to send keystrokes to the user interface in Microsoft Access, and you use the CTRL key designation (^) in combination with uppercase characters, the action is unsuccessful, although you receive no beep to indicate |
| 19687 | Advanced: Requires expert coding, interoperability, and multiuser skills. 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/98) |
| 19688 | 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 made in the list. |
| 19689 | 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 so as to be available to other objects |
| 19690 | In Microsoft Access 2000, a user can insert a carriage return/line feed into a bound text box by pressing CTRL+ENTER. This key combination is a Windows shortcut recognized by all Microsoft Office products, including Access. However, in certain |
| 19691 | Versions of Access earlier than Access 2000 do not have a command that you can use to retrieve information from the Clipboard. In earlier version, to retrieve information from the Clipboard, you have to define a Visual Basic for Applications function |
| 19692 | 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 Microsoft Windows API functions. This article shows |
| 19693 | The Microsoft Win32 application programming interface (API) can be used to connect and disconnect from network drives and printers by using Visual Basic for Applications. |
| 19694 | To make a network connection with the Windows application programming interface (API), you can use an unused logical drive letter or a Universal Naming Convention (UNC) name, such as \\Servername\Sharename. You can call the Windows API function, |
| 19695 | This article shows you how to create a custom function to strip invalid characters or characters that you do not want from a string. You can use this function in queries and in text input boxes. Microsoft provides programming examples for |
| 19696 | The With statement enables you to perform a series of references to a specified object without having to repeat the name of the object. For example, if you have a number of different properties to change on a single object, it is more convenient to |
| 19697 | This shows you how to create a report that marks (or flags) any missing items from a given a list of sequential integers or dates. For example, on your bank statement, you may notice that all checks that have not cleared are flagged with an asterisk |
| 19698 | When you are creating new records by using a form, you may want to speed the data entry process by having fields in the new record fill automatically with values from the previous record. This article shows you how to create a sample Visual Basic for |
| 19699 | This article shows you how you can use a single, bound control for both finding records and for typing data in a form. You can use this technique to find whether the value typed in a field already exists in another record. If the value does exist in |
| 19700 | This article shows you how to use the Circle method to create a filled-in pie slice on a report. |
| 19701 | In order for a procedure to accept an array as an argument, the procedure must declare the array argument with opening and closing parentheses after the argument name. Additionally, when passing the array to the procedure, you must include parentheses |
| 19702 | When you import a Microsoft Excel spreadsheet into Microsoft Access, the carriage return character () appears as a small square. For example, if you import a Microsoft Excel spreadsheet mailing list with complete addresses stored in single cells |
| 19703 | This article shows you how to create a sample user-defined function that you can use to validate a string to make sure that every character in the string is a letter of the English alphabet. This article assumes that you are familiar with Visual |
| 19704 | This article shows you how to shade every other detail line on a Microsoft Access report. NOTE: This article explains a technique demonstrated in the sample file, RptSmp00.mdb. For information about how to obtain this sample file, please see the |
| 19705 | When you create an SQL pass-through query in a Visual Basic for Applications procedure, you may receive the following error message when you try to set the LogMessages property of the QueryDef object. Compile error: Method or data member not |
| 19706 | This article shows you how to create user-defined functions that return the name and path of the current database. |
| 19707 | This article contains a sample user-defined function named IsTableQuery() that you can use to determine whether a table or a query exists in a database. The sample function uses the TableDefs and QueryDefs Data Access Objects (DAO) collections. |
| 19708 | This article shows you how to use Data Access Objects (DAO) to add an AutoNumber field to an existing table. |
| 19709 | In some situations, you may want to delete multiple tables quickly, rather than 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 error tables to |
| 19710 | When you edit the module of an unopened form or report in the Visual Basic Editor, Microsoft Access automatically opens the form or report in Design view. |
| 19711 | This article shows you how to create a sample user-defined Visual Basic for Applications function that you can use to fill a combo box or list box with the names of all the tables in the current database. |
| 19712 | As your use of Microsoft Access increases, you may find it necessary or convenient to run some of your Access processes at night or at some other time when you are not present. This article shows you how to run Access processes at specified times |
| 19713 | When you try to log on to Microsoft SQL Server through ODBC by using Visual Basic for Applications, the code that is typically used to trap run-time errors does not trap ODBC logon errors. Instead, you encounter the actual ODBC connection failure |
| 19714 | In a report, a text box can expand vertically if you set its CanGrow and CanShrink properties to Yes. Rectangles and lines, however, do not have these properties and cannot expand. To create a rectangle around a control that can grow or shrink, use |
| 19715 | This article contains several sample user-defined functions that you can use to do the following: Return a list of users in the current system database. Return a list of groups in the current system database. Return a list of users in a specified |
| 19716 | 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. |
| 19717 | This article shows you how to create a sample user-defined function to compute a running sum on a form. |
| 19718 | This article shows you how to substitute your own custom message for the generic error message that occurs when you violate an input mask on a form. The generic error message for input mask violation is: The value you entered isn't appropriate for |
| 19719 | 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 group... |
| 19720 | This article shows you how to create a sample user-defined Visual Basic for Applications function that you can use to create lists of fields with dot leaders between the items. For example, given the items John and Doe, the function creates the |
| 19721 | This article shows you how to create a sample procedure to link a Microsoft Outlook folder as a table in a Microsoft Access database. |
| 19722 | This article shows you how to create appointments in a Microsoft Access database and how to use Automation to add the appointments to a Microsoft Outlook calendar. |
| 19723 | This article describes how to conceptualize and implement stand-alone class modules in Microsoft Access 2000. Class modules were introduced in Microsoft Access 7.0, where class modules behind forms and reports allow you to create procedures that |
| 19724 | This article describes a technique that you can use to start compacting one or more databases automatically at a scheduled time. You create a small database with a table, a form, and a macro. The table stores the names of the databases that you want |
| 19725 | This article shows you how to use Visual Basic for Applications to hide duplicate information in successive group headers in a report. |
| 19726 | This article shows you how to write a procedure that creates a Schema.ini file based on an existing table in your database. |
| 19727 | This article shows you how to use Visual Basic for Applications to change the column headings in a crosstab query. NOTE: You can see a demonstration of the technique that is used in this article in the sample file Qrysmp00.exe. For information about |
| 19728 | This article shows you how to format a fax number in Microsoft Access 2000 so that you can merge it with a Microsoft Word document that uses Microsoft Exchange Server to print to a fax modem. |
| 19729 | This article demonstrates how you can press the TAB key or ENTER key to move from the last control on the last record of a subform to a specified control on the main form. NOTE: This article explains a technique demonstrated in the sample file, |
| 19730 | This article shows you how to return the Universal Naming Convention (UNC) path for a mapped drive letter. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the |
| 19731 | This article demonstrates how to export all modules in a database to text files. |
| 19732 | Microsoft Access has two built-in security features for protecting your database: User/Group accounts and permissions, and database passwords. This article shows you how you can also set individual passwords for each form and report in your database. |
| 19733 | This article shows you how to create a sample Visual Basic for Applications function that you can use to recover a table deleted from a Microsoft Access database under the following conditions: The database has not been closed since the table was |
| 19734 | This article shows you how to create a form that has two list boxes that imitate the multiple-selection capability used in Microsoft Access wizards. |
| 19735 | 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 you |
| 19736 | This article shows you how to turn off the Break on All Errors option in Visual Basic for Applications code to prevent users from interrupting your error handling routines. |
| 19737 | This article shows you how to use the Callback property of a Balloon object to determine which check boxes a user selected, or which label or button a user clicked, and then to respond to that selection. NOTE: This article explains a technique |
| 19738 | This article first explains recursive procedures and how you can use them in Microsoft Access, and then demonstrates how to use a recursive procedure to fill branches of a TreeView control with data. The TreeView control is available with |
| 19739 | 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 may receive an error. For example, when you use the StrConv() function in the Update To cell of an |
| 19740 | 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 2000. |
| 19741 | 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 |
| 19742 | The Data Outline control is not included with the Microsoft Office 2000 Developer (MOD) as it was in the Microsoft Access Developer's Toolkit versions 2.0 and 7.0. Instead, you can use the TreeView control to display a hierarchical list of items in |
| 19743 | This article shows you how to create a sample user-defined function to retrieve the handle to the Microsoft Access window. It also shows you how to create functions to determine and change the Microsoft Access window state (maximized, minimized, |
| 19744 | This article shows you how to create a sample user-defined Visual Basic for Applications function that you can use to check the file version information stored in most files. |
| 19745 | When you maximize a form, all other forms that are open are also maximized. You cannot maximize one form independent of the other open forms. |
| 19746 | When you use the CreateControl() function to programmatically create an OLE control, only an empty container is created. |
| 19747 | 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() ignore |
| 19748 | When you open other applications, such as other Microsoft Office 2000 programs, through Automation code, the applications that you open may not always close when your code finishes running. |
| 19749 | This article shows you how to create a sample Visual Basic for Applications function that populates (or fills) controls on a report based on a table or query when you preview or print the report. The sample function fills a newly-created text box on a |
| 19750 | 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 for the past |
| 19751 | 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 demonstrates how to |
| 19752 | This article shows you tips that can help you debug your Visual Basic for Applications code, particularly when your code compiles correctly, but does not perform as you expect. Debugging is the process that you use to find and resolve errors, or |
| 19753 | This article shows you how to create a sample user-defined Visual Basic for Applications routine that you can use to count the occurrence of a specific field value in a record or recordset. Microsoft provides programming examples for illustration |
| 19754 | This article shows you how to use Data Access Objects (DAO) in Microsoft Access 2000 to create an Access 2.0 database, and how to copy entire tables from an Access 2000 database to the newly created Access 2.0 database. This technique allows you to |
| 19755 | This article describes how to create a Visual Basic for Applications module that uses the 32-bit versions of the GetWindowsDirectory() and GetSystemDirectory() Windows API functions to return the Windows and Windows System directory (folder) paths. |
| 19756 | This article provides a technique to concatenate information from multiple records based on the many side of a relationship, and to format the results into a single line separated by commas in a report. |
| 19757 | By using the Import dialog box, you can import data from other systems that you may be using, such as dBASE or Paradox. By using the Import dialog box, however, you can import only one table at a time. Most of the time, this functionality is enough. |
| 19758 | This article shows you how to create a sample user-defined function called Wait(), which you can use to delay program execution for a specified period of time. You can call this function from any form or report event procedure or from a RunCode macro |
| 19759 | Moderate: Requires basic macro, coding, and interoperability skills. This article shows you how to create a sample user-defined Visual Basic for Applications function to concatenate portions of text fields. The function is useful for displaying names |
| 19760 | This article shows you how to use Visual Basic for Applications to synchronize a form to the current record on the subform of another form. The method described in this article synchronizes the form's bookmark with the bookmark of the form's recordset |
| 19761 | This article shows you how to create a sample user-defined Visual Basic for Applications function to retrieve the path and file name of the originating database for a linked Microsoft Access table. The function uses the linked table's Connect |
| 19762 | When you use Visual Basic for Applications to concatenate dates into an SQL string, you must use a standard U.S. date format, regardless of the region that you have set in the Regional Settings tool in Control Panel. This article shows you how to |
| 19763 | This article describes 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 Text ISAM |
| 19764 | This article shows you how to display slides from Microsoft PowerPoint on a form in Microsoft Access. This technique uses Automation in Access to open a PowerPoint presentation and to link to the first slide. Viewing other slides is accomplished by |
| 19765 | To position Microsoft Access on the screen, you need to call the SetWindowPos() Windows API function. This article demonstrates how to call this function to position and size Microsoft Access on the screen. |
| 19766 | In Microsoft Windows NT or Microsoft Windows 2000, you can use the Win32 application programming interface (API) to retrieve network information about the currently running computer, such as the user name, workgroup, domain, and computer name. In |
| 19767 | This article shows you how to use Visual Basic for Applications code to maximize, minimize, and restore Access. You can use the RunCommand action to maximize, minimize, and restore Access. For example, you can use the following: DoCmd.RunCommand |
| 19768 | This article shows you how to use a combination of Microsoft Windows application programming interface (API) calls and Visual Basic for Applications code to create floating pop-up menus. |
| 19769 | This article describes how to use the Windows 32-bit application programming interface (API) ShellExecute() function to start an application associated with a given file extension without having to know the name of the associated application. For |
| 19770 | Sometimes it is not practical to store images in a Microsoft Access table. If you have a large number of images, or if each of your image files is large, the size of the Microsoft Access database file can rapidly increase. This article demonstrates |
| 19771 | This article shows you how to create a custom function to strip extra characters from a string. This function is useful in a situation where the value in a field contains too many spaces between names or has other formatting problems. Microsoft |
| 19772 | This article shows you how to create a sample user-defined Visual Basic for Applications function to determine the current screen resolution. You can use this function to determine if you are running in standard VGA mode (640 x 480) or Super VGA mode |
| 19773 | You can use Microsoft Windows API functions to capture screen shots of any object on the Windows desktop. You can capture screen shots of the Access user interface, Access objects, other Windows applications, or the entire desktop. Microsoft provides |
| 19774 | Because the architecture of Windows 95 and later and Windows NT is 32-bit, there are several differences in the application programming interface (API) from the 16-bit API of Windows 3.x. This article shows you how to convert code that contains 16-bit |
| 19775 | 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... |
| 19776 | 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... |
| 19777 | You receive one of the following error messages when you try to connect to either the Microsoft Data Engine (MSDE) or SQL Server 7 Desktop Edition on a computer running either Microsoft Windows 95 or Microsoft Windows 98: Test Connection Failed |
| 19778 | When you use the TransferText macro action to export an HTML or text file using a specification table, you may receive the following error message: The data being exported does not match the format described in the Schema.ini file. The data |
| 19779 | When you try to export a report with the Publish It with MS Word OfficeLinks command, you may receive the following message: The Save As command can't process any subforms contained in your report. Do you want to proceed anyway? The Save As |
| 19780 | In a Microsoft Access query, if you use the LIKE operator with a wildcard to search for dates, you may see unexpected results. |
| 19781 | When you use the AutoCorrect feature in Microsoft Access to correct typing errors automatically, the Change event of a control on a form is triggered each time that AutoCorrect is invoked. This can cause undesirable results, such as error messages or |
| 19782 | When you use Filter By Selection or Filter By Form commands on a form that has its DataEntry property set to Yes, Microsoft Access changes the property setting to No so that it can display the filtered records. This behavior is the same |
| 19783 | When you use the InputBox() function in a query, you may receive the following error message: Function isn't available in expressions Function isn't available in expressions |
| 19784 | When you open a form or right-click on the form to see the shortcut menu, you may receive the following message: Microsoft Access can't find the macro '' Microsoft Access can't find the macro '' |
| 19785 | When you rename the shortcut (or link) for a data access page, the name of the HTML file does not change. |
| 19786 | When you use a data source that contains a parameter in the Pivot Table Wizard, 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 Table Wizard. |
| 19787 | When you try to create a Microsoft Access form in Microsoft Excel by using the Access Links 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 |
| 19788 | If you export a Microsoft Access table that contains line separators to Microsoft Excel format, the line separators will not appear as expected in Microsoft Excel. Instead, you see two vertical characters where the line separators should be. |
| 19789 | When you compare a recordset's bookmark with a Variant or String variable, you may receive the following error message: Run-time error '13:' Type Mismatch Run-time error '13:' Type Mismatch This error message can |
| 19790 | When you change the SpecialEffect property for a text box or label to Shadowed, the editable area in the control is decreased. |
| 19791 | If you use the Filter By Form feature, and you are searching for words that start with is , you must use quotation marks around the string. If you type is* , the filter returns the following message: You can use the Is operator only in an |
| 19792 | 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 |
| 19793 | The sequence of the Deactivate and Close events for a Microsoft Access form are the reverse of the Close and Deactivate events in a Microsoft Access report. |
| 19794 | If an object's method within a subroutine or a function uses the optional arguments allowed by the subroutine or the function, and one or more of the optional arguments are excluded at the time that the subroutine or the function is called, one of the |
| 19795 | If a macro contains the ShowToolbar action with the Toolbar Name argument set to the name of a custom toolbar, and if that toolbar is already visible, running the macro hides the toolbar instead of showing it. This behavior also occurs when you run a |
| 19796 | When you use the IsDate() function with a date in Long Date format, the function returns a value of False. For example, the following expression returns a value of False: IsDate(Friday, January 1, 1999) However, the following |
| 19797 | When you use the AutoFormat feature on a form that contains a hyperlink, the default color for the hyperlink text is changed. |
| 19798 | The Microsoft Access 2000 Help Topic Example Dynamic Data Exchange (DDE) Example, which can be displayed by clicking Example on the following topics, DDEExecute Statement DDEInitiate Function DDEPoke |
| 19799 | When you are entering data in a form, you may receive the following error message: Microsoft Access can't find the macro '.' Microsoft Access can't find the macro '.' |
| 19800 | 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, |
| 19801 | If you create a GoToRecord macro that points to a subform and run that macro from the main form, you may receive the following error message: Object '' isn't open Object '' isn't open |
| 19802 | If you create a crosstab query that uses an implicit parameter [XXX] or a form reference in a WHERE clause (criteria), you may receive the following error message: The Microsoft Jet database engine does not recognize '[XXX]' as a valid field name |
| 19803 | Under certain circumstances, DoEvents and SendKeys are not supported when called by user-defined (custom) functions in Visual Basic for Applications. |
| 19804 | If your server supports the creation of SQL views, you can achieve a compromise between pass-through and Access queries by creating a view on the server and then linking it. The Microsoft Jet database engine treats a linked view exactly like a linked |
| 19805 | This article discusses how you can optimize query performance in Microsoft Access 2000. The topics include the Microsoft Jet database engine's query Optimizer, query timing, analyzing performance, and design tips for improving query performance. |
| 19806 | You can refer to a particular column of a combo box in a text box on a form by using the Column property as follows: =Forms![Formname]![ControlName].Column(x). However, if the combo box is on a subform, the text box returns |
| 19807 | In Microsoft Access, you cannot export a Paradox or dBASE table over the top of an existing, corrupted Paradox or dBASE database file. If you try, you receive the following error message: Disk or network error Disk or network error This error |
| 19808 | When you disable the Control Box for a form, the Control Box submenu is disabled also. If you maximize and then restore a form that has its Control Box disabled, the Control Box submenu will reappear on the restored form if you press the ALT key and |
| 19809 | When you use the BuildCriteria method to programmatically set the Filter property on a form and the Field argument of the BuildCriteria method references a field name that contains a space, you may receive the following error message: |
| 19810 | You may want to display scroll bars in a subform only as needed. The following function turns the scroll bars on or off according to a preset number. The scroll bars do not appear unless the number of records in the subform is greater than the preset |
| 19811 | 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. In Microsoft Money 4.0 In Microsoft Money 4.0 |
| 19812 | When you use the Report Wizard in Microsoft Access 2000 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 stop |
| 19813 | If you use the Paste Special command using the Paste Link option and click to select the Display As Icon check box when pasting a Microsoft Access object into either Microsoft Excel or Microsoft Word, the pasted image has the following |
| 19814 | 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: |
| 19815 | 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... |
| 19816 | When you convert a database from an earlier version of Microsoft Access, you may receive the following error message: |
| 19817 | Session Summary In this session, we will discuss common combo box usage in a Microsoft Access database. This session will cover what combo boxes are, how they are created, and the distinct properties of a combo box. It will also introduce various... |
| 19818 | When you attempt to type some data into a Microsoft Office program, the following error message appears: Program name can't use AutoCorrect lists. Program name cannot install the necessary files due to Windows installer error 87. The parameter is... |
| 19819 | The Qbf2k.exe file contains an Access 2000 database created by Ken Getz. It demonstrates how to create a custom Filter-by-Form that you can use in any application, including an Access run-time application. |
| 19820 | If you programmatically open a form in Filter-by-Form view in a Microsoft Access 2000 run-time application, you may receive the following error message: Execution of this application has stopped due to a run-time error. The application can't |
| 19821 | If you are not a member of the db_owner role and you try to apply a filter (by using a filter by selection, a filter by form, or a server filter) to a datasheet or to a form in an Access project, the filter is not applied, and you may receive the |
| 19822 | When you work with Microsoft SQL Server data from within Microsoft Access 2000, you now have two ways to establish a connection: You can use the traditional method of linking the tables through the Microsoft SQL Server ODBC driver. |
| 19823 | This article shows you how to recover data from a nonmember of a replica set. It then shows you how to synchronize the data back into a replica set. The nonmember can be a database that has an invalid replica ID, or it can be a database that is not |
| 19824 | When you look in the About Microsoft program name box in one of the Microsoft Office 2000 programs listed at the beginning of this article, you may see the following: Microsoft program name ; 2000 Service Release 1 where program name is the name of... |
| 19825 | When you run a stored procedure that contains COMPUTE / COMPUTE BY, in a Microsoft Access project, the results are truncated. |
| 19826 | If you choose a unique field when you link a dBASE table, the index contains only records that are unique with respect to the specified index expression. For example, a .dbf file may contain n records, while the unique index may contain m entries, |
| 19827 | This article describes two methods you can use to retrieve the field description stored with a field in a table definition. One method shows how to do this with ActiveX Data Objects (ADO) and the other shows how to do this with Data Access Objects |
| 19828 | You can use ActiveX Data Objects (ADO) and Data Definition Language (DDL) in Visual Basic for Applications code to change the data type of a field in an Access database (.mdb) or an Access project (.adp). This article shows you how to create a |
| 19829 | This article shows you how to create and use a procedure to display the current line or row number in a subform. NOTE : This article explains a technique demonstrated in the sample file, FrmSmp00.mdb. For information about how to obtain |
| 19830 | When you try to preview or print a report in Microsoft Access, you may receive the following error message: Microsoft Access couldn't print your object. Make sure that the specified printer is available. Microsoft Access couldn't print your |
| 19831 | You are unable to set the permissions for individual modules using the Security tools provided by Microsoft Access 2000. Permissions set to individual modules that were created in earlier versions of Access are ignored by Access 2000. |
| 19832 | When you export a table that contains a date earlier than 01/01/1900 to Microsoft Excel, you may encounter one of the following problems: In a Microsoft Access project (.adp), one of the following occurs: You see the following |
| 19833 | When you try to preview or print a report in Microsoft Access, you may see the following error message: Microsoft Access is having difficulty communicating with the printer. You may receive this error for one of the following reasons: Before beginning... |
| 19834 | After you add a group filter control to a data access page, the page displays only one record at a time. This happens even though you have set the DataPageSize property to a value greater than 1. |
| 19835 | When you save several objects at the same time (monolithic save), you may see the same name listed more than once in the Save dialog box. |
| 19836 | When you export a Microsoft Access 2000 table with a primary key field to any of the dBASE or Microsoft FoxPro formats, an index is created. However, exporting to a Paradox format does not create an index in any version of Microsoft Access. |
| 19837 | In a Microsoft Access crosstab query, you can specify only one field or calculation as the value. Often, you may want to show more than one value in the query. For example, the following example shows two columns of information per |
| 19838 | When you print or preview a form, the detail section of the form is blank, even though controls are visible in the detail section when you view the form in Form view. Other sections, such as the form header and form footer, appear correctly when you |
| 19839 | This article has three examples that show you how to rank records within a query. The first example ranks records from a table. The second example ranks the results of a totals query. The third example demonstrates an alternative method of handling |
| 19840 | 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. |
| 19841 | 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 error |
| 19842 | This article discusses the reasons why Microsoft Access does not use record numbers, as some other database products do. |
| 19843 | 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 |
| 19844 | When you view the location of references with the References dialog box on the Tools menu, 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 |
| 19845 | In Microsoft Access, if you use Data Access Objects (DAO) to open a recordset and you do not explicitly close the recordset, DAO may hold onto the memory that it used for its previous compile until the next recordset is opened. |
| 19846 | When you try to create a new object in an existing Access database, the New buttons may be unavailable and you therefore cannot create the object. The Save button may also be unavailable, preventing you from saving any design changes. |
| 19847 | When you try to close a form that has an embedded Microsoft Graph 2000 Chart object, you may receive the following error message even though you did not make any changes to the object: The object is locked, so any changes you make will be |
| 19848 | When you try to open an Access 97 database in Access 2000, you may receive the following error message: Cannot open a database created with a previous version of your application. Cannot open a database created with a previous version of your |
| 19849 | This article demonstrates how you can use a form to programmatically change the paths to linked OLE objects. Paths to linked OLE objects are not exposed in any properties in Microsoft Access. To programmatically change a linked OLE object path, you |
| 19850 | When you try to open an Access 2000 database that does not use ActiveX controls, you may receive one of the following error messages: ActiveX error: There is no license for this control ActiveX error: There is no license for this control |
| 19851 | When you try to add the values of two fields in a database, and one of the fields contains null values in a few records, the result of the calculation for those records appears blank (null). |
| 19852 | When you attempt to open a table, a view, a stored procedure, or a database diagram in Design view of an Access project (.adp), you may receive the following error message: OLE Server isn't registered. OLE Server isn't registered. |
| 19853 | After you open an ADP file that appears to connect successfully, the ADP file disconnects after you open a table or a view. Additionally, you may receive one of the following error messages. When you create a new table You do not |
| 19854 | When you try to add a product to a new order in the Orders form in the Order Entry sample database, you may receive an error message similar to the following: You cannot add or change a record because a related record is required in table |
| 19855 | When you start one of the Office programs listed at the beginning of this article, you may receive the following error message: Required registry information is missing and this application cannot run. Please run setup to correct this problem. When... |
| 19856 | When you try to import or link a text file, you receive one of the following error messages: Run-time error '3027': Cannot update. Database or object is read-only. Run-time error '3027': Cannot update. -or- Cannot |
| 19857 | When you try to export a Microsoft Access 2000 table to a Sybase database, you receive the following error message: ODBC--call failed. [Intersolve][ODBC SQL Server Driver](#102) The same process worked fine in Microsoft Access 97. |
| 19858 | This article discusses common errors that you may see when you use Replication in Microsoft Access. The first section gives general troubleshooting steps that you can try. The second section gives an error message and then steps that Microsoft uses to... |
| 19859 | 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 |
| 19860 | When you try to open the Visual Basic Environment (VBE) from an object that contains a semicolon in its name, Access may stop responding and then shut down unexpectedly without error. After restarting Access you may find that: You can |
| 19861 | 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 Use the Object Browser Microsoft Press and Third-Party... |
| 19862 | When you click the AutoReport: Columnar wizard in the New Report dialog box to create a report that is based on a query, you receive the following error message: Subscript Out Of Range Error Subscript Out Of Range Error |
| 19863 | This article describes two methods that allow you to import a text file that has an extension that Access does not recognize, without having to change the extension manually. |
| 19864 | This article describes how to copy an Access 2000 database (.mdb) file from a floppy disk or a Zip disk to the My Documents folder on the hard disk. |
| 19865 | When you try to open a table, a query, a form, a report, or a data access page in a multiuser Access 2000 database that is stored on a network, you may receive the following error message: Record is deleted. Record is deleted. If the object |
| 19866 | In a Microsoft Access project (ADP), you can use a parameterized stored procedure as the row source of a combo box on a form. This article gives you an example of how to pass a parameter to the stored procedure that you are using as the row source. |
| 19867 | The RefreshDatabaseWindow method in an Access project does not work. |
| 19868 | 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. |
| 19869 | 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 |
| 19870 | With Microsoft Jet version 4.0, you can change the database password by running a data-definition query. Because you can do this, it is relatively easy to set the database password through ActiveX Data Objects (ADO). This article shows you how |
| 19871 | When you click Open , Save , or Save As on the File menu in any of the Microsoft Office 2000 programs listed at the beginning of this article, you may experience one of the following symptoms: When the current folder has subfolders, all subfolders... |
| 19872 | Microsoft Office 2000 saves in one location all of the new custom template files that you create in any Microsoft Office applications. This article explains the location of templates in Office 2000, how the New dialog box (on the File menu, click New... |
| 19873 | When you make a design change to a table and then try to save the table, you may get an error message that starts with the following sentence: |
| 19874 | You may not be able to save your logon ID and password locally when you link a table from an Open Database Connectivity (ODBC) data source because the |
| 19875 | Microsoft Access addresses linked data differently than it does its own native data. This article discusses how Access retrieves linked ODBC data. |
| 19876 | When you use the Export Text Wizard to import, export, or link a text file, you may receive the following error message: |
| 19877 | Microsoft Access can record all SQL statements sent to an Open Database Connectivity (ODBC) data source in a file called Sqlout.txt. You can create this log file by setting the |
| 19878 | This article shows you how to use the |
| 19879 | When you print a column report, it is sometimes necessary to display a label for each row of detail being printed within the column. However, when the report is a multicolumn report, each new column in the multicolumn report redisplays thes |
| 19880 | When you use indirect synchronization to synchronize your replica set on either Microsoft Windows NT 4.0 or Microsoft Windows 2000 Server, the synchronizer leaks file search handles. As a result, Error 2009 is logged in the Event Log for the server.... |
| 19881 | When you run a make-table query against a DB2 database, you may receive the following error message: |
| 19882 | This article shows you how to use Automation to add a task or a reminder to Microsoft Outlook. |
| 19883 | This article shows you how to create a form that used Windows Sound Recorder to play and to record sounds. The technique uses Visual Basic for Applications code to open Sound Recorder and to control its functionality from Microsoft Access. |
| 19884 | This article shows you how to use Automation from a Microsoft Access form to start Microsoft Outlook and to display a new contact screen for input. You can change just one line of code to make this example apply to a new Microsoft Outlook a |
| 19885 | This article shows you how to create a procedure in Visual Basic for Applications that will keep an audit trail of the changes that are made to a record in a form. |
| 19886 | When you use ActiveX Data Objects (ADO) to create objects in a database, the size of the database increases substantially during the operation. After compacting, the size of the database is much smaller. |
| 19887 | When you move to the next record on a form or close a form, Microsoft Access automatically saves any changes that you have made to the current record. This article shows you how to use a BeforeUpdate event procedure to prompt you to verify |
| 19888 | This article shows you two methods of using the NotInList event to add a new record to a combo box on a form. |
| 19889 | When you open a Microsoft Access form that has the |
| 19890 | When you open a Microsoft Access form that has the |
| 19891 | When you open an existing Office 2000 document and resave the document, the file-level permissions change. |
| 19892 | In Access 2000, when you query a linked SQL Server 2000 table that contains a field defined with a data type of BigInt, returned data is incorrectly mapped to Binary instead of to TEXT, which can appear in the form of indecipherable symbols within the... |
| 19893 | While opening Microsoft Access and a form through Automation and setting focus to the the form custom menu bar, the following Microsoft Visual Basic error message occurs: |
| 19894 | This article provides an overview and sample code for creating Microsoft Outlook contacts from information stored in a Microsoft Access database. The sample code in the More Information section of this article should be run from a Microsoft |
| 19895 | In the |
| 19896 | To refer to a control's current value during a Change event, you can use the control's |
| 19897 | When you start Microsoft Access in a secured database environment, you are prompted by the |
| 19898 | If you set the |
| 19899 | When you run an update query with more than 127 fields selected, you may receive the error message: |
| 19900 | In the Office 2000 programs listed at the beginning of this article, when you click Open on the File menu, you can browse to restricted drives, even though drive access is restricted via Group Policy. |
| 19901 | When you insert an Enhanced Metafile (EMF) image, such as a Barcode Control, into your document, the characters in the EMF or barcode are displayed upside down. This issue occurs only on computers running Microsoft Windows NT 4.0 or Microsoft Windows... |
| 19902 | When you import data from a text file, or export data to a text file by using the Text ISAM, you receive the following error message: |
| 19903 | When automating Microsoft Access 2000 and issuing the |
| 19904 | The Microsoft Knowledge Base contains a wealth of information about all Microsoft products and technologies. This article introduces you, the Access 2000 user, to the Microsoft Knowledge Base and gives you tips to find the information and t |
| 19905 | This article explains the role and relationship of the workgroup information file (MDW) in Microsoft Access security. |
| 19906 | 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 |
| 19907 | 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 querie |
| 19908 | 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. |
| 19909 | 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 Outlook, Microsoft Fax, and a fax modem installed and that they are functioning. |
| 19910 | By carrying out the |
| 19911 | 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. |
| 19912 | This article describes the |
| 19913 | You can use the |
| 19914 | This article shows you how to use an SQL pass-through query for a form's record source. It assumes that you know how to build and use SQL pass-through queries. |
| 19915 | : Requires basic macro, coding, and interoperability skills. |
| 19916 | The Orders and Developer Solutions sample databases that are included with earlier versions of Microsoft Access are not included with Access 2000. |
| 19917 | This article describes two techniques that you can use to automatically run code when a form's Edit mode changes. You can use these techniques when you want to have different controls available on a form when a record is being edited and wh |
| 19918 | You can use the |
| 19919 | This article shows you how to get the fiscal year or fiscal month of a particular date by using an expression or a user-defined function. |
| 19920 | This article shows you how to ensure that the |
| 19921 | This article shows you how to create a procedure that will run if your Access application does not detect any user input for a specified period of time. It involves creating a hidden form containing code that keeps count of idle time. |
| 19922 | This article shows how to use Automation to print a Microsoft Word document that you are working with in a Microsoft Access function or in an Access form's object frame. |
| 19923 | This article describes a method that you can use to transfer the ownership of a newly created table to a specific owner. For example, if the functionality within a secured database enables the current user to import a table, that user will |
| 19924 | This article shows you two examples of how to create and use procedures with optional arguments. |
| 19925 | This article shows you how to create sample functions that you can use to format the |
| 19926 | This article shows you how to create and use a form module procedure called AfterUndo. The AfterUndo procedure runs when edits made to the current record are undone. |
| 19927 | When you try to start Microsoft Access by using the |
| 19928 | This article explains how to transfer your spreadsheet files from Microsoft Works into a Microsoft Access database (.mdb). |
| 19929 | When you run the |
| 19930 | This article shows you how to use Automation to create and send a Microsoft Outlook message in Microsoft Access 2000. |
| 19931 | This article shows two methods that you can use to work with Microsoft Graph objects. One method demonstrates how to use Automation to change the chart type of a Microsoft Graph object. The second method shows how to determine the graph typ |
| 19932 | This article shows you how to use Automation to add, remove, and set trend lines on a Microsoft Graph object. |
| 19933 | Although Microsoft Access can use a custom paper size, you must first create the custom paper size. In Microsoft Windows NT 4.0, you do this by creating a custom form in the Printers window under |
| 19934 | Certain types of reports require that each record be printed a specific number of times. These reports include labels that are used for picking, shipping, and invoicing, or tear-off forms that are meant for multiple recipients. |
| 19935 | You cannot edit the information in a Hyperlink field in a table by clicking the link because that activates the link. This article describes the different parts of a Hyperlink data type, and shows you several methods that you can use to edi |
| 19936 | This article describes how you can create two types of shortcuts on the Windows 95 or later desktop, both of which start an Access database and open to a form of your choosing. You can create such a shortcut either by dragging the form from |
| 19937 | This article describes three methods that you can use to change the caption of a control on a data access page. These three methods are: |
| 19938 | Microsoft Office 2000 provides program information and support through the Office Assistant, which is a feature that is shared by all Microsoft Office programs. The Office Assistant is an interactive Help utility that allows you to ask ques |
| 19939 | When you run the Microsoft Access 2000 Setup program in Maintenance Mode, and you use the |
| 19940 | This article describes a method that you can use to print records that are randomly selected. |
| 19941 | 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 that contains dates along the x-axis, and if m |
| 19942 | You can use a query to return records that have duplicate values within a field or whose values, between records within that field, are less than a specified amount. For example, you may want to return a list of all the orders that were pla |
| 19943 | At times, you may want to animate the movements of the Office Assistant in response to actions performed in your application. For example, you may want to have the Assistant appear when you open a particular form. Or you may want the Assist |
| 19944 | This article shows you how to use Automation to call Microsoft Excel functions from within Microsoft Access. |
| 19945 | This article describes how to import a Works database file into a Microsoft Access 2000 database. This is a two-step process. First you must save the Works database file in a format compatible with Microsoft Access. Then you can import the |
| 19946 | If your regional settings are configured to use a comma as the decimal separator (for example, in the German regional settings), filtering by selection on a Decimal field may generate the following error message when you link to an Open Database... |
| 19947 | When you double-click a shortcut that points to a Microsoft Access 2000 database object, the Windows Installer starts, and then you receive the following error message: |
| 19948 | The Microsoft Jet replication update, Jet40Repl.exe, is a Setup program that updates certain files that are used by Access and by Microsoft Replication Manager 4.0. These files were updated with the release of Microsoft Jet 4.0 Service Pack 7 (SP7).... |
| 19949 | When you update linked ODBC tables in a Microsoft Access database, an access violation occurs with the following message: The instruction at '0x1b01a333' referenced memory at '0x0000000c'. The memory could not be 'read'. This error message occurs when... |
| 19950 | When you use Access 2000 Service Release 1 (SR-1) with Microsoft Jet 4.0 Service Pack 5 (SP5) to query tables linked from two separate databases on the same server, you may find that Jet does not pass the WHERE clause parameters to the ODBC data... |
| 19951 | This article describes how to determine the current Microsoft Jet 4.0 database engine service pack level. This article permits you to download the latest Service Pack to the Jet 4.0 database engine, provides you setup instructions, lists the files... |
| 19952 | If you have an Access project (*.adp) that was created with Microsoft Access 2000 with no service releases applied, and the project is based on a Microsoft SQL Server 2000 database, you may notice several incompatibility issues, the most ob |
| 19953 | 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. |
| 19954 | When you create a form based on a table with a Yes/No field, you may prefer to create two check boxes on the form: one to display the Yes selection, and another to display the No selection. This article demonstrates how to create such a form. |
| 19955 | When you try to convert a Microsoft Access 2000 database to a Microsoft Access 97 database format, you may receive the following error message: |
| 19956 | After you install Office 2000 or Office XP, the Activation Wizard appears each time that you start an Office program. |
| 19957 | SQL Server 2000 was released more than a year after Access 2000 and Visual Studio 6.0. As a result, the original versions of those products do not support some of the new features of SQL Server. When you attempt to design SQL Server 2000 da |
| 19958 | When you attempt to link an Informix table to a Microsoft Access database, you may receive the following error message: Error 3701 Invalid scale for decimal datatype. Error 3701 Invalid scale for decimal datatype. |
| 19959 | When you try to start the Data Access Objects Help file in Microsoft Access, you may receive the following error message: Microsoft Visual Basic Microsoft Access can't display help. An error occurred and this feature is no longer |
| 19960 | 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... |
| 19961 | Microsoft Office applications can act as ActiveX Servers. They provide client applications design-time access to an Object library, or type library, that enables client applications to view an Office application's objects, properties, methods, and... |
| 19962 | This article includes sample code that illustrates how you can programmatically determine the installation path for a Microsoft Office application given the ProgID for that application. |
| 19963 | 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. |
| 19964 | 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 |
| 19965 | When you run a query that includes a Memo, an OLE, or a Hyperlink field on a computer that is running Microsoft Jet 4.0 Service Pack 5 (SP5), you receive the following error message: Run-time error '3114': Cannot include Memo, OLE or Hyperlink Object... |
| 19966 | When you print a data access page, only the current record is printed, instead of all records. |
| 19967 | When you delete the navigation section of a data access page by selecting the section and then manually deleting it, the DataPageSize property of the associated section is automatically changed from its original setting to All . On a grouped |
| 19968 | When you import a text file that contains time values into a Microsoft Access database, if you filter the table on specific time values, the filter may not return any records. |
| 19969 | On a Hyperlink field in a Filter By Form, if you use the Like operator with an asterisk (*) as the last character of the lookup value, more records than expected may be returned. |
| 19970 | When you drag a field onto a data access page, Microsoft Access, by default, creates a text box control for all field types, except for those fields with a data type of Yes/No or Bit. |
| 19971 | You cannot add bound controls to either a caption or a navigation section of a data access page. You may receive the following error message when you move a bound control to either of these sections, or when you set the ControlSource property of |
| 19972 | When you select a Group Filter control on a data access page, the Promote button on the toolbar is unavailable (is dimmed). If you manually move the Group Filter control from one section of the page to another, you may receive the following error |
| 19973 | If you base a data access page on an AutoLookup query, the recordset will not be updateable. |
| 19974 | 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. |
| 19975 | When you try to open a database or an object in a database (such as a table or a form), or when you try to compact a database, you may receive one of the following error messages: Selected collating sequence not supported by the operating system. |
| 19976 | This article shows you how to use automation to create and format a chart in Microsoft Excel. |
| 19977 | When you try to open a database that is located on a Novell NetWare server, you may receive the following error message: Couldn't use ; file already in use. Couldn't use ; file already in use. |
| 19978 | When you have an unbound object frame that has a linked object on a report, changes in the data or content to the source object are not displayed in the report. |
| 19979 | At times, you may need to transpose the data in a table or query so that the field names are listed vertically down the left column and the data extends across the page horizontally. For example, you may need to transpose the data for a report or |
| 19980 | When you compile or run code, you may receive the following error message: Compile Error: User-defined type not defined. Compile Error: User-defined type not defined. |
| 19981 | If you refresh a parameter query in a Microsoft Access database, you are not prompted again for the parameter. However, if you refresh a parameter query in a Microsoft Access project, you do receive another prompt for the parameter. |
| 19982 | When you point to Toolbars on the View menu and click Customize , the list of commands that appears on the Commands tab does not contain all of the available menu commands. |
| 19983 | 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 |
| 19984 | When you import a data access page from a Microsoft Access database or a Microsoft Access project (.mdb or .adp) into your current Access database or project, the ConnectionString property of the page still references the original source. |
| 19985 | This article describes how to create application-specific add-ins for Access. In Access, there are two different types of add-ins: application-specific add-ins and Component Object Model (COM) add-ins. An application-specific add-in works in only one |
| 19986 | You may notice one or more of the following behaviors with the name of a data access page: The name of a page in the Database window may be different from what you typed in the Save As dialog box. -or- The name of the page in |
| 19987 | The new SQL grammar exposed by Microsoft Jet database engine version 4.0 allows users to specify business rules that can span more than one table. These are called check constraints and allow users to exceed a single validation rule per table. In this... |
| 19988 | The Name AutoCorrect Log table may not track all changes even if you have selected all of the check boxes in the Name AutoCorrect area. |
| 19989 | When you use the Count function in a query, view, or stored procedure, Null values are ignored. |
| 19990 | You are not able to add a new record, or to edit or delete an existing record on a data access page. |
| 19991 | When you try to check a Jet database that has queries or stored procedures created through the native OLEDB provider for Microsoft Jet into Microsoft Visual SourceSafe, the objects are not visible in the SourceSafe dialog box and cannot be checked |
| 19992 | If a report or a form has its RecordSource property defined as a table that contains no records, #Error is displayed when you preview the report or view the form in Form view if a bound control on the report or form is defined by using the |
| 19993 | The default ODBC Login timeout setting for Microsoft Jet databases is 20 and is stored, depending on the version, in the following registry key: HKEY_LOCAL_MACHINE\SOFTWAREMicrosoft\Jet\4.0\Engines\ODBC\LoginTimeout You can change this value |
| 19994 | This article shows you how to programmatically create an MDE file from an existing database. |
| 19995 | 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 |
| 19996 | 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. |
| 19997 | By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 95/98 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 taskbar. |
| 19998 | 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. |
| 19999 | This article lists the ActiveX control (formerly called OLE Custom Control) interfaces that Microsoft Access 2000 requires, as well as those categories of interfaces that it does and does not support. This information will help you to create custom |
| 20000 | In Microsoft Visual Basic for Applications, you can reference another VBA project (MDB, MDA, or ADP) in the References dialog box. By using the Project Explorer in the Visual Basic Editor, you can also see the code in referenced projects, or you |
| 20001 | This article shows you how to create a stored procedure in the Visual Basic Environment and, if needed, how to add a parameter to the existing stored procedure. NOTE : Native stored procedures are new in Microsoft Access 2000. You cannot |
| 20002 | When you copy, export, import, or transfer tables into a new table or database, the IDENTITY property seed and increment values are both set to the default of 1. |
| 20003 | In Microsoft Access 2000, you can change the seed and increment value of an AutoNumber field, otherwise known as an Identity column, from the default value of one. However, there are no options available in the user interface (UI) for you to make this |
| 20004 | When you open an Access project, you are prompted to enter a user name and password, even though a default user name has been set and the Blank Password check box has been selected. When you return to the Data Link Properties dialog box, you |
| 20005 | If you use Access 2000 Client-Server to create a table that violates SQL Server naming conventions, you will be unable to delete, rename or edit the table in SQL Server 6.5 Enterprise Manager. If you try to do so, you receive the following error |
| 20006 | You can copy and paste Office Charts and Office PivotTables from one data access page to another. However, the data in the Chart or the PivotTable is not copied from one page to the other. |
| 20007 | When you build a query in the query by example (QBE) grid and use an alias for a column name, the name that you specified in the alias is not displayed when you run the query. Instead, an unexpected field name is returned in Datasheet view. |
| 20008 | When you bind a form to an ActiveX Data Objects (ADO) recordset in Microsoft Access, data errors that occur on the form are not available within the ADO connection's Errors collection. |
| 20009 | You are making changes to a data access page, and even though you have deleted all of the previously added controls from the data access page, you still see the New Relationship dialog box when you try to add a new field to the page. |
| 20010 | On a grouped data access page, if you delete the child section of the page, the associated expand control in the parent section is not automatically deleted. Because the expand control is no longer associated with a section of the page, it has no |
| 20011 | When you create an option group on a data access page, a label, which is associated with the control, is also created. By default, this label is placed on the upper-left portion of the option group control. If you delete this associated label, no |
| 20012 | When you pause the mouse pointer over a partially covered button on the record navigation control of a data access page, that button becomes completely visible and the control that was covering the button is partially hidden. |
| 20013 | When you try to drag the last field out of a grouping section on a data access page, you receive the following error message: This field can not be deleted because it is last field in a grouping section. Delete the grouping section instead. |
| 20014 | The TotalType property of a control on a data access page allows you to work with the value in either a bound or a calculated control by applying the following functions: None Sum Avg Min Max Count |
| 20015 | When you create or open a data access page that is based on an existing HTM or HTML page that contains an IFRAME or a frameset, you may receive the following error message: You cannot edit this page because it contains frames. The data access page |
| 20016 | When you scroll through records on a data access page, the execScript method calls the expression twice. |
| 20017 | If you have a stand-alone data access page open in Microsoft Access without a database file being open, and you then open an Access database (*.mdb) file from the Documents list on the Start menu, the data access page will be closed before the |
| 20018 | When you demote the parent field of a grouped data access page, the child field that is used for grouping the data displays #Name? |
| 20019 | When you use script in a data access page to change the appearance of a mouse pointer, the mouse pointer does not change its appearance until you physically move the mouse. |
| 20020 | When you delete the 2-D, or grid section, of a data access page, you can no longer bind the page to a data source. Additionally, after you have removed the 2-D section, you cannot replace it on the page. |
| 20021 | 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. |
| 20022 | When you change the RecordSource property of a data access page that has bound controls, the controls on that page are unbound. If you then reset the RecordSource property of that same page to the original value, the controls are not |
| 20023 | When you type an expression in the ControlSource property on a data access page and then switch to Page view, you may receive the following error message: The CALC expression ( expression ) is invalid. The CALC expression ( expression ) |
| 20024 | When you print preview or print your mailing label report, the last row(s) of labels on each page is not used. |
| 20025 | When you use a combo box or list box control to perform a Filter By Form, you may receive the following error message Type mismatch in JOIN expression Type mismatch in JOIN expression followed by: Microsoft Access didn't apply the |
| 20026 | When you write script for the Current event of the MSODSC control of a grouped data access page, the script runs when the section of the page is expanded, but the script does not run when the section of the page is collapsed. |
| 20027 | 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. Can't open any more tables. When you click OK , you receive the message: Out of memory. Out of |
| 20028 | This article describes methods that you can use to programmatically enable or disable all menu items or specific menu items on a custom command bar. |
| 20029 | When you press the SHIFT+F1 keys to display help for an object in the toolbox, all undocked toolbars are hidden until you close the Help topic. Also, if you click the Start button while a toolbar is undocked, the undocked toolbar |
| 20030 | After converting a Microsoft Access 2000 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. There is no object in |
| 20031 | This article demonstrates how to create a query that returns all the records in which the value of a Date field falls within the previous month. |
| 20032 | In Microsoft Access 2000, 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 Run-time error '13': Type mismatch |
| 20033 | When you look at a group filter control and a dropdown list control on a data access page, you cannot tell which control type is which by simply looking at the control. To determine whether a control is a group filter control or a dropdown list |
| 20034 | A movie control plays the video file while you are in Design view of a data access page. |
| 20035 | A Group Filter control is a special type of drop-down list box. A Group Filter control allows you to filter the records returned on a data access page, or in a section of a data access page, based on your selection. Each section of a data access page |
| 20036 | Even though a database stores only a link to a data access page and not the data access page itself, you still cannot create a new data access page in a database that you have open in Read-Only mode. You can also not save changes to an existing data |
| 20037 | When you mix ActiveX Data Objects (ADO) transaction methods with Microsoft Jet 4.0 Data Definition Language (DDL) transaction statements, Microsoft Access and/or the Visual Basic Editor may stop responding (hang). |
| 20038 | When you add a drop-down list box or a list box to a data access page, you see only one column of data. If you are using the Control Wizard, you can enter two columns, but you can only see one of those columns. If you are using the Control |
| 20039 | When you convert to Microsoft Access 2000 a Microsoft Access 2.0, 95, or 97 database that contains characters specific to a foreign language, unexpected characters appear in the converted database. |
| 20040 | The caption section of a data access page serves much like a section header in a report. Information that applies to the entire group can be displayed here to avoid duplication of information in every record. The primary difference between a caption |
| 20041 | By using the security tools provided by Microsoft Access 2000, you cannot prevent individual users from creating data access pages in a database. |
| 20042 | This article shows you how to use the CreateDataAccessPage method to programmatically create data access pages. This method allows you to specify the name and path of a new data access page, as well as allowing you the flexibility of linking to |
| 20043 | When you try to customize toolbars or open a Microsoft Access form, report, macro, or module in Design view, you receive the following message: You do not have exclusive access to the database at this time. If you proceed to make changes, you may |
| 20044 | When you switch from the Microsoft Script Editor (MSE) to Microsoft Access, the tree structure in the field list for the data access page may collapse. |
| 20045 | When a grouped data access page does not specify a group header for the outermost group, the page will not display any records for either the parent or child groups. This is the case even when the ExpandedByDefault property for that group record |
| 20046 | If you convert to Microsoft Access 2000 an Access database created in an earlier version that has a linked Microsoft FoxPro table, the icon of the table appears dimmed. Also, if you try to open the table, you receive the following error message: |
| 20047 | To edit the text displayed in the following controls on a data access page Bound HTML Bound Hyperlink Command Button Hyperlink Label (including labels attached to:) Check Box Dropdown List Box |
| 20048 | If you upsize a table that has a field with a data type of Text, the Upsizing Wizard will map the type to the Microsoft SQL Server 7.0 nVarChar data type instead of the VarChar data type. This happens even though the Upsizing Wizard report indicates |
| 20049 | You cannot select more than one control at a time in Design view of a data access page. |
| 20050 | To see whether you are running Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0, you can check the Sqlstp.log file located in your Windows or Winnt folder. |
| 20051 | This article contains sample Visual Basic for Applications code that you can use to select an incremented number of records from an existing table or query and to create a dynamic counter value for those records in a new table. You can use this sample |
| 20052 | This article demonstrates how to find records in a Microsoft Jet database using ActiveX Data Objects (ADO) and OLE DB. |
| 20053 | If you use a converted Microsoft Access 97 add-in in Access 2000, the add-in appears on the Add-Ins menu of an Access database (.MDB ), but not in an Access project (.ADP). |
| 20054 | If you open a form in Form view and have two or more calculated controls, you may receive an #Error? error in all of the calculated controls on the form, even if the expression for an individual control is valid. |
| 20055 | You may receive the following error message when you try to open a data access page: The HTML file that corresponds to the selected data access page has been moved, renamed, or deleted from: . Press locate to specify a new path, or press |
| 20056 | When you create a new database object while you have a data access page open in Design view, the field list and the source property lists (for such properties as the RecordSource property and the RowSource property) may not display the new |
| 20057 | If you type two quotation marks () in a control on a data access page, Access will store the quotation marks rather than a zero-length string in the underlying table. |
| 20058 | When you use the alignment tools on the Alignment and Sizing toolbar, the control you are aligning may lose focus. |
| 20059 | The section of a data access page is visible, even though you have set the Visibility property of that section to Hidden . |
| 20060 | Although data access pages and reports have many grouping and sorting properties in common, there are some new properties that have been added to the Sorting and Grouping dialog box for data access pages. These new properties change the behavior |
| 20061 | In the programs listed at the beginning of this article, the steps for creating a new toolbar may differ from steps that you use in earlier versions of these programs. This article lists the steps to use when you want to add a command to a new toolbar. |
| 20062 | 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 |
| 20063 | 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 |
| 20064 | When you try to export a Microsoft Access table or query that has a file name longer than 60 characters to a text file, the export fails, and you receive the following error message: Export Text Wizard Export Text Wizard The object |
| 20065 | The Display Form/Page list in the Startup dialog box may contain the same name twice. |
| 20066 | The default ODBC Login timeout setting for Microsoft Jet databases is 20 and is stored, depending on the version, in the following registry keys: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC\LoginTimeout You can change this value |
| 20067 | When you import objects from another database, the entire import process may abort and you see the following error message: Microsoft Access is unable to open the data access page. The file does not exist, or you do not have read access to |
| 20068 | If you have a Microsoft Access project (.adp) on a computer that has a different code page setting than the server to which you are linking, and you use characters particular to the client's code page in the name of an object, you may experience the |
| 20069 | You may not get the records you expect when you use Filter by Selection on a data access page. |
| 20070 | The Microsoft Windows operating system provides two routines that can be called by Microsoft Office 2000 programs to get the \Windows and the \Windows\System folders. |
| 20071 | The Office PivotTable becomes disconnected from its data source immediately after you demote a section of a data access page that includes the PivotTable control. |
| 20072 | This article shows you how you can align and resize multiple controls on a data access page. |
| 20073 | When you browse to an .ade, .adp, .mda, .mdb, or .mde file in the Add References dialog box and set a reference to one of these databases, the name that appears in the References dialog box differs from the actual file name that you selected |
| 20074 | If you delete the associated HTML file for a data access page, the Database window does not refresh when you open the database or press the Database window refresh key (F5). When you try to open a page, and if someone has deleted the underlying |
| 20075 | This article shows you two procedures that use the EnumPrinters API function to retrieve a list of printers available locally and also those printers on a network that may be connected to your computer. The procedures demonstrate |
| 20076 | 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: Run-time error '2289' Microsoft Access can't output the module in the requested |
| 20077 | When you run code that contains the RunCommand method with the acCmdSaveModuleAsText constant, you may receive the following error message: The command or action 'SaveModuleAsText' isn't available now. The command or action |
| 20078 | At times, you may want to reset or change a user's password without using the user interface. This article demonstrates several sample functions that you can use to accomplish this task. |
| 20079 | If you place a control bound to a Hyperlink field on a data access page, you can see the address, but it does not function as a hyperlink. |
| 20080 | When you click either Microsoft Access or Data Files , in the Files of type list, for the following dialog boxes you cannot see the entire list of extensions for Microsoft Access or Data Files: Open Export object name Import Link |
| 20081 | This article shows you how to create and use a Group Filter control on a data access page. The example in this article uses the sample database Northwind.mdb. |
| 20082 | The macro or function attached to the BeforeUpdate or AfterUpdate property of a bound control does not run when expected. |
| 20083 | When you export a table that contains a Number or a Currency field to a fixed-width text file, the numbers in the table become left-aligned. |
| 20084 | When multiple users use a Microsoft Access database, changes they make to a custom toolbar (not a built-in toolbar) may not be saved when the database is closed. If you are one of the multiple users in a database, and you begin editing a custom |
| 20085 | While choosing an ODBC datasource to link to, import from, or export to, you may see your computer's A, B, and CD-ROM drives read repeatedly. |
| 20086 | In Microsoft Access 97, Modules.Count returns the number of currently open Visual Basic for Applications modules; however, in Microsoft Access 2000, Modules.Count returns the number of modules last opened in the Visual Basic Editor, even if |
| 20087 | When you upsize a Microsoft Access database that has constraints, the constraints are not upsized. |
| 20088 | Microsoft Access 2000 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 2000. The upgrade version sells at a reduced price, and |
| 20089 | This article demonstrates how to trap Microsoft Jet database engine errors using ActiveX Data Objects (ADO) and the OLE DB provider for Microsoft Jet. |
| 20090 | Support for the definition of stored procedures has been added to Microsoft Jet 4.0. This article provides Visual Basic for Applications (VBA) code examples that demonstrate how to create and run a parameterized Microsoft Jet stored procedure. NOTE :... |
| 20091 | If you manually change the string DataCodePage in the Registry key HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Xbase to anything other than OEM or ANSI and try to export using the dBASE 5 ISAM driver, you receive the |
| 20092 | In Microsoft Graph 9.0, Microsoft Graph for the first time supports early binding. Early binding was not possible in earlier versions of Graph. |
| 20093 | This article shows you how to create sample Visual Basic for Applications code that creates Internet shortcuts from a Microsoft Access table that has a Hyperlink field with one or many records. The shortcuts are then placed in a folder on your hard |
| 20094 | Microsoft Access places new data access pages in the folder specified in the Default database folder setting on the General tab in the Options dialog box. Unless you change this setting, the folder is C:\My Documents. Microsoft Access also |
| 20095 | When a control on a data access page is bound to a field in a table that has a valid input mask, the data access page ignores the input mask. In the data access page, you can enter and save values that do not conform to the input mask that is |
| 20096 | 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. |
| 20097 | 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 |
| 20098 | To protect the data in a control on a form from accidentally being changed, you can use a message box to prompt for verification when you try to enter data into that control. Clicking Yes in the message box unlocks the control, and allows you to |
| 20099 | This article shows you how to use Automation to create a Microsoft Graph object on a Microsoft PowerPoint slide from Microsoft Access by using a Microsoft Access table. |
| 20100 | When you output a report to HTML format, each page of the report is exported as a separate HTML file that may contain a long file name. |
| 20101 | The Load Statement and Unload Statement Help topics included in the Microsoft Access Help system do not apply to procedures that you create in Microsoft Access. You can use these statements with UserForms in other Microsoft Office applications and |
| 20102 | When you use Data Access Objects (DAO) to retrieve properties for linked TableDef objects, the process is much slower than when you use DAO to retrieve the properties for local TableDef objects. |
| 20103 | 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. |
| 20104 | Moderate: Requires basic macro, coding, and interoperability skills. When you refer to properties and methods belonging to objects created with the CurrentDb function, you may receive the following error message: Object invalid or |
| 20105 | This article shows you how to use Visual Basic for Applications to set properties for default controls on forms and reports. |
| 20106 | When you modify a tab control in Microsoft Access, either manually or with Visual Basic for Applications code, if you delete the last page of the tab control, the control itself is also removed from the form. |
| 20107 | If you open a data access page from within Microsoft Access and then click a hyperlink on the page, the browser opens a Web page, as expected. However, you cannot click the Back button in the browser to return to the page in Microsoft Access. |
| 20108 | The Microsoft Access Help Topic What Name AutoCorrect fixes and doesn't fix in an Access database states the following: You can save changes to an object if you have permissions to modify the design of the object, you have write access to the |
| 20109 | If a database has the Name AutoCorrect feature enabled, users may experience a delay when they try to open database objects. |
| 20110 | When you insert an object from one program (for example, a Microsoft Excel worksheet object) into another program (for example, Microsoft Word), and you deactivate and reactivate the inserted object, the Undo command may behave differently in each... |
| 20111 | This article describes how to fill a list box on a form with the names of files that are in a folder, and how to enable printing of one file or several of the files from the form. |
| 20112 | When a subform control is less than 4 inches wide (as measured by the Form Design ruler) and the subform control uses the record navigation buttons and the horizontal scroll bar, the horizontal scroll bar is not displayed, even when i |
| 20113 | When you add a new record or edit an existing record on a data access page, the position of that record within the recordset may change. |
| 20114 | In a data access page, if you call a function that is not available outside of Microsoft Access, you receive the following message when you open the page in Microsoft Internet Explorer: |
| 20115 | 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 Catego |
| 20116 | The Microsoft Jet database engine does not provide column-level security, as does Microsoft SQL Server, where you can assign permissions at the column level to a user or group account. For example, you may want some users/groups to have rea |
| 20117 | When you try to add a record to a datasheet that is produced by a query, Access will either stop responding (hang) briefly and eventually quit without a warning or error, or Access may generate one of the following error messages and then quit:... |
| 20118 | When you export to the dBASE file format, an empty .dbf file is created or Microsoft Access stops responding (hangs). |
| 20119 | This article shows you how to format and print a table from the Microsoft Access user interface. |
| 20120 | When you try to update a linked Microsoft FoxPro 6.0 table in Access 2000, you may receive one or both of the following error messages: |
| 20121 | This article lists words and symbols that you should not use in field, object, and variable names because they are "reserved words." Reserved words have a specific meaning to Microsoft Access or to the Microsoft Jet database engine. If you |
| 20122 | 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.... |
| 20123 | The Auto2000.exe file contains the Microsoft Office 2000 Automation Help file created by Microsoft Technical Support. This Help file contains Automation theory and has multiple examples that show you how to automate the Office 2000 products (Microsoft... |
| 20124 | Microsoft Office products may change from one release to the next. Typically, the type library for an Office product will have the same functions that were present in the earlier product version, but some functions may have additions to the number of... |
| 20125 | When you run an Office 2000 program on Microsoft Terminal Server, the Microsoft Script Editor does not start when you click the Microsoft Script Editor command on the Tools menu. |
| 20126 | 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: The Object Browser Microsoft Press and Third-Party Reference and Learning... |
| 20127 | The Places COM Add-in was developed for Microsoft Office 2000 applications that use Microsoft Visual Basic 6.0. |
| 20128 | When you convert a macro to Visual Basic for Applications (VBA) and the macro contains a form reference that requires brackets, you may receive a syntax error when you run or compile the converted code. |
| 20129 | You can add new data to or you can modify existing data within a view even though the view implements WITH CHECK OPTION . Although you may receive the following Microsoft Access error when you save the new or modified record, the record is still |
| 20130 | If you create an event procedure for a Microsoft Access form in Form view, the event procedure will work as long as the form remains in Form view. However, when you switch the form to Design view and then back to Form view, the event procedure no |
| 20131 | This article describes how to merge a Word document with a Microsoft Access database by using a parameter query. |
| 20132 | After you use the Microsoft Access Add-in Manager to install a custom menu add-in in Microsoft Access 2000, the custom menu add-in is not listed as an installed menu add-in. However, you are able to use the menu add-in successfully. |
| 20133 | The Microsoft Access 2000 Form and report specifications Help Topic contains the following specification: Number of levels of nested forms or reports 3 The Help Topic Subforms: What they are and how they work contains |
| 20134 | Microsoft Access has two options that force Date fields and controls to display four-digit years. One option ( This database ) forces the display of four-digit years at the database-level in a particular database or project. The other option ( All |
| 20135 | When you try to run the Visual Basic for Applications method SysCmd with acSysCmdGetWorkgroupFile as the action, you may receive the following error message, and then Access quits: In Microsoft Windows 95 or Microsoft Windows 98: |
| 20136 | This article demonstrates how to create a custom Visual Basic for Applications function in Microsoft Access that you can use to copy an existing Microsoft Data Engine (MSDE) or a Microsoft SQL Server database. |
| 20137 | When you run a Visual Basic macro that adds or manipulates toolbar buttons or menu commands for the CommandBars object, the controls may be added to a different CommandBar, or an error message similar to the following may appear: Run-time error '5':... |
| 20138 | When you have multiple documents open in any of the programs listed, only one icon for the program appears in the taskbar even though the Windows in Taskbar option in the Options dialog box is selected. |
| 20139 | When you use Microsoft Access 2000 to open or convert an MDE file created with Microsoft Access 97, you may receive the following error message: You can't convert or enable an MDE file. |
| 20140 | If you use the Upsizing Wizard to upsize tables in a Microsoft Access database in which any table or query name contains an apostrophe ('), none of the tables are upsized. |
| 20141 | This article shows you how to can create a running total for each page of a report. |
| 20142 | This article shows you how to switch the view of a subform from Datasheet view to Form view while the main form is open in Form view. |
| 20143 | This article lists all of the arguments that you can use with the GetOption and SetOption methods. |
| 20144 | In certain situations, the BuildCriteria method does not work as expected, or it returns values that cannot be used by other methods or SQL statements. This article addresses the following topics: Searching for a string containing |
| 20145 | In a RichTextBox control, the default behavior of the TAB key is to move the focus to the next control in the tab order of a form. This article shows you how you can use the TAB key to insert a tab character into a RichTextBox control. |
| 20146 | When you supply a GUID value as a criteria in a query field that is based on an AutoNumber field that is set to a Replication ID, no fields are returned. You might see this if you reference a form field that contains the Replication ID in the |
| 20147 | 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. |
| 20148 | When you switch a form from Form view to Design view, 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. This program has |
| 20149 | This article demonstrates a method that you can use to fill a table with random records from another table. The sample procedure in this article uses Data Access Objects (DAO) to fill a table with a user-specified number of records from an existing |
| 20150 | When you import a Microsoft Excel spreadsheet into Microsoft Access, currency is not displayed correctly in the Import Spreadsheet Wizard. There may be extra zeros to the right of the decimal place in the sample data. However, when you open the |
| 20151 | If you create a shortcut in Microsoft Windows that points to a password-protected Visual Basic Editor project, you may receive the follow incorrect error message when you double-click the shortcut: Microsoft Access can't find the procedure '.' |
| 20152 | When you try to drag a module from an .mde or .ade file to the desktop in order to create a shortcut, you may receive the following error message: Requested type library or wizard is not a VBA project Requested type library or wizard is not a |
| 20153 | In a Microsoft Access project, if you create a field in a table and set the field's data type to Bit , you cannot click to select the AllowNulls property check box. |
| 20154 | When you try to resize the grid pane or SQL pane in a view in a Microsoft Access project, you may receive the following error message: In Microsoft Windows 95 or Microsoft Windows 98: In Microsoft Windows |
| 20155 | In a Microsoft Access project, if you are logged on with a logon name that is not the database owner, but with a name that is a member of the built-in role db_owner, a table created by that user is owned by that user. The table is not owned by the dbo |
| 20156 | You cannot see the contents of an embedded Microsoft Rich TextBox ActiveX Control when you Print Preview a report. |
| 20157 | A subreport that contains snaking columns does not snake to multiple columns when you preview the main report. The subreport does snake, however, if you preview the subreport as a stand-alone report (instead of within the main report). |
| 20158 | When you open a report in a Microsoft Access project that uses both grouping and client-side filtering (the Filter property), the report returns no data, or you may receive the following error messages The bookmark was invalid. The bookmark |
| 20159 | When you use a File DSN to import or link a FoxPro ODBC data source, you may receive the following error: Reserved error (-7778); there is no message for this error. Reserved error (-7778); there is no message for this error. |
| 20160 | A table that was replicated continues to have a replication field even after you have set the Replicable property of the table to No . |
| 20161 | The Deploying Data Access Pages on the Internet or Your Intranet white paper is available in the MSDN Online Library. To view this white paper, visit the following Microsoft Web site: |
| 20162 | When you upsize an Access table that contains Replication ID fields, you may receive the following error message: Microsoft Access was unable to append all the data to the table. The contents of fields in x record(s) were deleted, and 0 |
| 20163 | This article provides an overview and sample code for importing Outlook contact information into an Access table. The sample code in the More Information section of this article should be run from an Access global module. The code provides a |
| 20164 | When you create or rename a folder or file, the following error message may appear: You may not have access privileges to create a new folder in this location. |
| 20165 | 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... |
| 20166 | When you install Microsoft Office 2000 on a computer that has 3d Studio Max installed, 3d Studio Max Material Library files are no longer associated with 3d Studio Max. This may cause the Material Editor Browse r dialog box either not to display |
| 20167 | Office 2000 includes a new clipboard called the Office Clipboard. You can use this clipboard to collect and paste multiple items. For example, you can copy a drawing object in Microsoft Excel, switch to Microsoft PowerPoint and copy a bulleted list,... |
| 20168 | When you try to assign the value of a control to some other object in a Microsoft Access project, you may receive the following error message: Invalid use of Null Invalid use of Null |
| 20169 | When you start one of the Office programs, the following error message appears: There was a problem starting the Office Assistant. Would you like to try reinstalling it? There was a problem starting the Office Assistant. When you click Yes |
| 20170 | When you open a linked SQL Server table that has a field of type UniqueIdentifier, you see #Deleted in the fields of all records. |
| 20171 | When you copy an item in any of the Office 2000 programs, you may receive the following error message This item was not copied because the Office Clipboard is full. To free space on the Clipboard, paste the items where you want them, and then click... |
| 20172 | When you try to drop a non-existent table using DAO 3.5, you receive the following error message: 3376 Table doesn't exist. 3376 Table doesn't exist. When you try to drop a non-existent table using DAO 3.6, you receive a different error |
| 20173 | When you export from Microsoft Access to a Lotus 1-2-3 format of *.WK1, *.WK3, or *.WJ2, an associated INI file with the same file name is also created. For example, if you export Table1 to the WK3 Lotus 1-2-3 format, an INI file with the name |
| 20174 | This article provides examples for using a built-in function called StrConv that you can use to capitalize the first character of a word or a set of words. This function is not affected by leading spaces, but it does have the following limitations |
| 20175 | When you access Help in any of the Microsoft Office 2000 programs, you may receive the following error message: The feature that you are trying to use is on a network resource that is unavailable. Click OK to try again, or enter an alternate path in... |
| 20176 | If you convert an Access database created in an earlier version of Access that is also not the same language version, you may see unexpected characters, including extended characters, in the converted database. |
| 20177 | After you copy an OLE Object field or Image field object to the Clipboard, you are unable to paste the object into another OLE Object field by using the Clipboard toolbar. |
| 20178 | Using Access Client/Server, if you try to change the Data Link property for Connection Timeout, the connection is dropped and re-opened; this forces edited objects to be saved and automatically commits uncommited records. |
| 20179 | The Link dialog box incorrectly shows the extension for Microsoft Access projects. |
| 20180 | 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 |
| 20181 | The last bulleted item in the Microsoft Access Help topic Considerations when sorting records in a table, query, form, or report states the following: You can't sort a field whose data type is Memo, Hyperlink, or OLE Object. This is |
| 20182 | In Microsoft Access 2000, you can sort on Memo fields in a query. However, if you select a Memo field in a datasheet or on a form, you will not be able to sort by this field. |
| 20183 | 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. |
| 20184 | When you start Microsoft Access, you may receive one of the following error messages: System Error. System Error. -or- Not enough memory to start Microsoft Access. Not enough memory to start Microsoft Access. |
| 20185 | When you run the Microsoft Script Editor in any of the Microsoft Office 2000 programs, the menus and toolbars are not visible. |
| 20186 | When you export a report that contains totals to Microsoft Excel, the total fields are missing in Excel. |
| 20187 | When you type characters in a list box, the list box selects the first item in the list that corresponds to the last keystroke that you type. For instance, if you type f, the list box selects the first item in the list that begins with f. |
| 20188 | You cannot install the Microsoft Data Engine (MSDE) through the Office 2000 Setup program. There is a separate Setup program that you use to install the MSDE. |
| 20189 | When you try to save your database's Visual Basic for Applications project in Microsoft Access 2000 running on Windows NT 4.0, you may receive the following error message: The Save Operation Failed. The Save Operation Failed. This may be |
| 20190 | When you use the Combo Box Wizard or List Box Wizard to create a combo box or a list box based on a query, you may receive the following error: No value given for one or more required parameters. No value given for one or more required |
| 20191 | A Microsoft Access form has a CloseButton property, which you can use to prevent a user from closing the form with either the Close Button icon or by clicking Close on the File menu. However, the user can still close the form by |
| 20192 | A user-defined function may return one of the following error messages: Run-time error '94': Invalid use of Null Run-time error '94': Invalid use of Null -or- #Error #Error |
| 20193 | This article shows you how to use the SysCmd() function in Microsoft Access to create a progress meter on the status bar that gives a visual representation of the progress of an operation that has a known duration or number of steps. |
| 20194 | When you use the Korean Global Input Method Editor (IME) in Microsoft Access 2000, Korean characters are repeated after you input them into Access tables or fields. |
| 20195 | When you quit Microsoft Excel over a dynamic data exchange (DDE) channel in Microsoft Access, you receive the following error message: Run-time error '291': The other application in the DDE conversation quit unexpectedly. Run-time error |
| 20196 | You can store large data objects (such as sound, video, or graphics 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 that |
| 20197 | This article shows you how to create a sample Visual Basic for Applications function called FindEOM() that accepts a date as an argument and returns the last day of the month. |
| 20198 | Reports have a RunningSum property; forms do not. This article shows you how to create a running sum on a form. NOTE : This article explains a technique demonstrated in the sample file, FrmSmp00.mdb. For information about how to |
| 20199 | This article describes a function that you can use to find the date of the Monday prior to the current day. |
| 20200 | With the Microsoft Access Popup property, you can create forms that float (that is, they stay on top of other forms) in Microsoft Access. However, if you set focus to a program other than Microsoft Access, the Microsoft Access popup forms are |
| 20201 | This article describes two methods that you can use to obtain values from the previous or the next record for use in calculations. The first method uses the DLookup() function in an expression; the second method uses two user-defined functions. |
| 20202 | This article shows you a routine to keep a given number of records together on a page with their group header. The article also tells you how to avoid an abandoned group header at the bottom of a page, and how not to print the group header beyond a |
| 20203 | This article describes how you can call Visual Basic for Applications functions or user-defined functions when the function name is stored in a string variable. This method provides a functionality similar to that of pointers to functions in other |
| 20204 | In Microsoft Access reports, page numbering always starts with the number 1. However, you may want your report to have page numbering that starts with some number other than 1. This article describes two methods for defining custom starting-page |
| 20205 | This article shows you how to create two functions to calculate the age of a person or thing based on a specified date. NOTE : You can see a demonstration of the technique that is used in this article in the sample file Qrysmp00.exe. For |
| 20206 | If a form calls a Visual Basic for Applications function that is halted because a run-time error occurred, you will not be able to access the form. |
| 20207 | This article demonstrates two methods that you can use to pass multiple values to a query by using a parameter prompt. The first method uses the Instr() function to parse the parameter values entered when the query is run. The second method |
| 20208 | If you type a credit card expiration date (month/year) in a Date/Time field on a form, Microsoft Access 2000 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 |
| 20209 | This article shows you how to create a sample user-defined function named RemoveAlphas() that removes alpha, or nonnumeric, characters from an alphanumeric string. All nonnumeric characters will be removed. A common use for the RemoveAlphas() |
| 20210 | IsNull ([AutoNumber Fieldname]) no longer returns True while entering a new record. |
| 20211 | This article demonstrates how to create an SQL pass-through (SPT) query in Microsoft Visual Basic for Applications with Data Access Objects (DAOs). You can use SPT queries to pass SQL statements directly to an ODBC data source, avoiding the need to |
| 20212 | To add a user to an existing group with code, you must use the CreateUser method twice: once to create the new user for that Microsoft Access session, and again to create the user for the group. |
| 20213 | This article shows you how to create a sample user-defined function, GetRGB(), that returns the red, green, or blue component from an RGB color value. Note that this behavior is the opposite of the Visual Basic for Applications function RGB() . |
| 20214 | When you calculate by using floating-point numbers, the result is not always what you expect. |
| 20215 | This article discusses the ColumnWidth property, which applies to fields or columns in Datasheet view. This property is documented in the Microsoft Access Help index. |
| 20216 | 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. This |
| 20217 | This article shows you how to create a sample Visual Basic for Applications function that uses the InputBox() function to open a form to a particular record. |
| 20218 | Microsoft Access 2000 includes a new function, StrReverse() , that returns a string with the characters reversed from the original argument string. For example, if you were to pass the string ABCD to the function, the function would return the |
| 20219 | This article shows you two Visual Basic for Applications methods to fill an array. The first method fills an array when you know the number of elements in the array. The second method fills an array when you do not know the number of elements in the |
| 20220 | Data in Memo or OLE fields in a snapshot changes if the data in the underlying table for the snapshot changes. |
| 20221 | This article shows you how to use the Seek method when your table's primary key or index includes more than one field. Note that when you use the Seek method on multiple fields, the Seek fields must be in the same order as the fields in the |
| 20222 | This article shows you two methods for returning the total number of days in the current month. The first method uses a query, and the second method uses a user-defined function. |
| 20223 | This article illustrates how to write the contents of a text data file to a control on a form. |
| 20224 | Microsoft Access ships in and can use several languages. This article shows you how to create a sample function that you can use to determine which language version of Access is installed, which language version the user interface is using, and which |
| 20225 | When you use the Avg() function in a report to average a set of values, the function uses records that have zero values in the calculation. Sometimes, you do not want to include records with zero values in a calculation. This article has |
| 20226 | When you use the OpenForm method or macro action to open a form as a dialog form, fields on the form do not display the values that you assign to them. |
| 20227 | This article shows you how to replace one string with another string. |
| 20228 | Microsoft Access does not have a built-in mechanism for returning a random record from a set of records. This article describes a sample user-defined function that you can use to return a random record. |
| 20229 | Because Microsoft Access stores dimension/location properties as twips, in certain cases you may have to convert twips to pixels, such as when you call a Windows API function. This article shows you how to do this. |
| 20230 | It is possible to quit Microsoft Windows from within a Microsoft Access application by using a Windows application programming interface (API) function. To do this, you must create a module that declares the API function and a procedure to call the |
| 20231 | This article shows you how to create a sample function that generates a random file name that can be used for a temporary file. |
| 20232 | In the Windows environment, various display resolutions may cause screens to appear out of proportion. As a developer, you can get the width and height of various elements of the window display by using the Windows application programming interface |
| 20233 | Because a Date/Time value is stored as a double-precision number, you may receive incorrect formatting results when you try to manipulate Date/Time values in an expression. This article demonstrates how to create expressions and custom functions for |
| 20234 | Through the use of a Windows application programming interface (API) function, Microsoft Access can determine if another program is already running. There may be times when you want only one instance of an application to run in Microsoft Windows. For |
| 20235 | Some local objects in a replicated database appear as replicable objects. That is, they are displayed with the Replicable icon even though they are not replicable objects. |
| 20236 | This article shows you how to display the current user name in a control on a form or in the title bar of the Microsoft Access window. |
| 20237 | In a multiuser environment, you cannot use the OpenDatabase method to find out if the current database was opened exclusively. If you try to open the current database with the OpenDatabase method in Visual Basic for Applications and the |
| 20238 | 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 |
| 20239 | This article discusses the Microsoft Access functions CreateControl() and CreateReportControl() . If you want to write your own form wizards or report wizards, you can use these functions to create controls on a form or report that is open in |
| 20240 | This article shows you how to use the DeleteControl and DeleteReportControl statements and the CreateGroupLevel() function. If you intend to write your own form wizard or report wizard, you can use these statements to delete controls on a |
| 20241 | This article shows you how to create a Visual Basic for Application procedure to determine if a form exists in a database. If the form is in the database, the function opens it; otherwise, you get a message box stating that the form does not exist in |
| 20242 | This article shows you how to create a sample user-defined function to check whether an object exists in the current database. This can be useful before you create a new object (such as a table, a form, or a report) in the database. |
| 20243 | If a report has OLE objects that are Empty or Null , you can set up a report so that Empty or Null OLE objects do not appear. NOTE : This article explains a technique demonstrated in the sample file, RptSmp00.mdb. For |
| 20244 | You can hide and display 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 display the Quarterly Orders |
| 20245 | You are not prompted to enter a parameter value when you output a form to text if the form is bound to a query that contains an invalid form control reference in its Criteria row. However, the text file that is created does not contain any data. |
| 20246 | You are unable to type data into a text box or combo box on a tab control that contains a Microsoft TreeView or ListView ActiveX control on another page. This behavior occurs when all of the following conditions are true: |
| 20247 | On the right side of the Microsoft Access status bar, there are eight 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 |
| 20248 | Unexpected characters, specifically characters Chr(10) and Chr(236), appear approximately every 65th character within a Memo field of an imported dBASE IV or Paradox database. |
| 20249 | In Visual Basic for Applications, to find a record in an indexed field, the Seek method may be faster than the Find method, especially in a large table. |
| 20250 | 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 Number |
| 20251 | A custom function called from a query runs as follows: One time per query if the expression does not reference a field. One time per record if the expression does reference a field. Two times per record if there are criteria |
| 20252 | This article shows you how to sort titles in text fields without including the leading articles the, a, or an. |
| 20253 | This article shows you how to calculate the number of working days between two dates. |
| 20254 | The Format property of a control can round a Number or Currency field to the number of decimal places that you want. However, this does not change the underlying data, which may contain additional digits that the control does not display. If you |
| 20255 | This article describes some of the conversions between Visual Basic for Applications and C arguments. |
| 20256 | This article shows you how to create a Visual Basic for Applications function that creates a snapshot that determines the frequency of occurrences for all numbers in a table. The most frequently occurring number in a data set is called the |
| 20257 | There are situations in which calling functions from external dynamic-link libraries (dlls) returns a 2-byte unsigned integer. Visual Basic for Applications does not support this data type. So that Access can correctly evaluate this data type, you |
| 20258 | An imported file may contain field values that have a combination of numeric and alphabetical characters. These fields are not sorted in the proper order if they contain variable numbers of characters. This article describes sample functions that you |
| 20259 | This article demonstrates how to implement a dBASE-style REPORT FORM command in Visual Basic for Applications. |
| 20260 | Some states are adding new telephone area codes based on a phone number's prefix. This article shows you how to change a phone number's area code in a table based on the prefix. You do this by creating a table with the prefix that you want to find and |
| 20261 | 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 measurement of a data set, like the mean |
| 20262 | 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. |
| 20263 | This article shows you how to create a sample, user-defined function named ConvertCurrencyToEnglish() to convert a numeric value to an English word representation. For example, the function will return the following words for the number 1234.56: One... |
| 20264 | This article provides two methods that you can use to parse comma-separated text in a Text field and to display the text in multiple Text fields. You can use the first method for a Text field that contains two words separated by a |
| 20265 | Before you print a form or a report, you can save space by conditionally reducing the size of the controls on the form or report. For example, you might want to reduce the size of text boxes that contain varied-length text, or reduce the size of text |
| 20266 | After you add ANSI-92 syntax to a query in a database that is also in ANSI-92 mode, the query still appears when you open the database in Access 2000. The query may or may not run correctly. |
| 20267 | 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... |
| 20268 | 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. |
| 20269 | When you insert a new record into a linked ODBC table that has a fixed-length text field (CHAR) as the primary key, #DELETED appears in all of the fields in the new record. NOTE : If you then close and reopen the linked table, the newly |
| 20270 | This article demonstrates how to use the Windows Installer to find the installation path of Microsoft Office or an Office XP or an Office 2003 applications. |
| 20271 | Automation clients written for Microsoft Access 97 that use either early binding (VB, ATL with #import) or dispid binding (MFC) might unexpectedly fail when trying to automate Microsoft Access 2000 or 2002. Among the possible errors you might receive... |
| 20272 | When you use the |
| 20273 | Microsoft has made available a downloadable Help file that contains automation theory and multiple examples showing how to automate the Microsoft Office XP programs listed at the beginning of this article. |
| 20274 | 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 for Applications and with creating Microsoft Access applications |
| 20275 | This article describes how to use Automation to create and manipulate a Microsoft Excel Worksheet. |
| 20276 | This article shows you how to use Visual Basic for Applications to import an entire worksheet from a Microsoft Excel workbook without specifying a range. |
| 20277 | When you create a query in Microsoft Query based on a Microsoft Access parameter query, you may receive the following error message: Too few parameters. Expected n . Too few parameters. If you click Help in the error message box, the |
| 20278 | This article describes how to close Microsoft Access from a different program using Automation and the Quit method. |
| 20279 | 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 |
| 20280 | This article describes how to import data from a Microsoft Word mail merge data file into a table in a Microsoft Access database. |
| 20281 | In the Microsoft Office programs listed at the beginning of this article, the How to obtain the Microsoft Office 2000 Resource Kit Help topic states that you can download the Microsoft Office 2000 Resource Kit from Microsoft on the Web. This is |
| 20282 | When you look at your version number for a Microsoft Office 2000 program that is listed in the Applies To section of this article, the version number may be different from the version that is included with Microsoft Office 2000, which is version... |
| 20283 | When you start the Visual Basic Editor in one of the Microsoft Office 2000 programs listed at the beginning of this article and then press F1 to start online Help, the Visual Basic Editor (VBE) window may be resized to make room for the Help window. |
| 20284 | In the Microsoft Office 2000 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. |
| 20285 | When you try to create a new Microsoft Access project file (ADP) or when you try to upsize a Microsoft Access database file (MDB), Access appears to stop responding (hangs), or you receive the following error message: |
| 20286 | This article shows you how to programmatically change the data type of a field at run time. |
| 20287 | When you use = Null instead of Is Null as the criteria for a query, the query may not return the expected results. For example, a query may return no records if you use = Null as the criteria in a field that has records that have no data.... |
| 20288 | The Jet compact utility, JETCOMP.exe, is a stand-alone utility that compacts databases created with Microsoft Jet database engine 3.x and 4.x. This utility may be run in conjunction with Microsoft Jet database engine 3.x and 4.x for recover |
| 20289 | Microsoft provides a custom installation wizard that you can use to modify the Setup process of Microsoft Office or Microsoft Access 2000. This article give you an overview of the Custom Installation Wizard and provides sample steps for cre |
| 20290 | A replica that you have deleted or moved still appears in the |
| 20291 | The Setup programs for the products listed at the beginning of this article do not create a menu shortcut for the Workgroup Administrator program. |
| 20292 | When you try to convert a large Microsoft Access 2.0, 95, or 97 database (typically 4 megabytes (MB) and larger) to Microsoft Access 2000, the status bar displays the word "Converting," and then switches to the word "Ready." After a short t |
| 20293 | When you show the Microsoft Office Assistant by clicking Show the Office Assistant on the Help menu, the Microsoft Office program stops responding, or the following message appears: This program has performed an illegal operation and will be shut... |
| 20294 | In any Office program, the version number displayed in About Microsoft program may be different than the version number displayed for that program in either Microsoft System Information (MSInfo), or from a Microsoft Visual Basic macro. For example,... |
| 20295 | When you ask the Office Assistant a question about Microsoft Visual Basic for Applications, you receive one of the following responses: The Office Assistant cannot currently answer your questions. Run Setup again to make sure all the necessary Help... |
| 20296 | In any of the Microsoft Office 2000 programs, when you ask the Office Assistant for help, clicking any of the topics presented does not start Help. |
| 20297 | When you start a non-English (U.S.) version of any of the Microsoft Office 2000 programs, one of the following symptoms may occur. Microsoft Access 2000 You receive the following error message: Can't find language dll Microsoft Excel 2000 No error... |
| 20298 | When you start one of the Microsoft Office programs listed at the beginning of this article after you install Microsoft Project 2000 or Microsoft Visio 2000, the program quits immediately after it starts. |
| 20299 | When you click any of the shortcuts to start an Office program, you receive an error message similar to the following: Windows cannot find Excel.exe This program is needed for opening files of type 'Application'. Location of Excel.exe: You are... |
| 20300 | When you assign Microsoft Visual Basic code to run for a command button that is displayed in the Visual Basic Editor (not its corresponding Microsoft Office program) by using the OnAction property, the code does not run as expected when you click the... |
| 20301 | The Readme.doc file that is located on the root of the Office 2000 CD contains incorrect information about the Office readme file. For late breaking or other information relevant to all the Microsoft Office 2000 products, see the Ofread.txt |
| 20302 | When you use hyperlinks to switch multiple times between your Web browser and Microsoft Office programs, your system slows down and begins to run low on available memory. If you press CTRL+ALT+DELETE to display the Close Programs dialog box in... |
| 20303 | When you click the Office Assistant in any of the Office 2000 programs listed at the beginning of this article, you may receive the following error message in the Office Assistant balloon: The Office Assistant cannot currently answer your |
| 20304 | This article contains information about the Microsoft Office 2000 FYRO Macedonian Update. The following text explains why an update was necessary, how to download it, and how to install it. |
| 20305 | When you look at the version information for a Microsoft Office 2000 program in the About Microsoft program name box (on the Help menu), the version information may differ from program to program. |
| 20306 | The following error message may appear when your macro evaluates a statement that uses the euro symbol: Run-time error '13': Type mismatch |
| 20307 | When you click System Information on the Help menu in any Office program, system information is not displayed, or you receive the following error in Microsoft Outlook: Can't find the system information. |
| 20308 | In Microsoft Windows Explorer, when you click a shortcut representing a Microsoft Office 2000 program, Windows Installer unexpectedly starts to install the program. |
| 20310 | This article describes how to clear the Most Recently Used list (MRU) for the Microsoft Office programs listed at the beginning of this article. To clear the MRU, follow the steps for the program that you are using. Microsoft Access, Excel, PhotoDraw,... |
| 20311 | To help you deploy the Microsoft Office 2000 HTML Data Security Update within your organization, Microsoft is providing an update for Office 2000 administrative installations. This update is contained in a self-extracting file that is avail |
| 20312 | If a table has more than 16,384 rows, and you click the |
| 20313 | Using Microsoft Visual Basic for Applications in Microsoft Access, you can prevent users from logging on to a Jet database. If users are already in the database, they will remain logged on; however, no other users will be able to open the d |
| 20314 | When you work with one of the Microsoft Office 2000 programs listed at the beginning of this article, one of the following symptoms occurs: When you attempt to open or save a Microsoft Word document, you receive the following error message: Word has... |
| 20315 | 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 |
| 20316 | This article describes how to use a secured Microsoft Access database in a Microsoft Word for Windows mail merge. This article assumes you have already created or have access to a secured Access database. |
| 20317 | This article explains how you can examine the registry at run time to determine the installation path and version of an Office application. |
| 20318 | This article shows you how to merge the current record in a Microsoft Access object into a Microsoft Word document, to print it, and then to close Microsoft Word. |
| 20319 | This article describes how to use Automation in Microsoft Access 2000 to open a Microsoft Word 2000 document, and how to move to a specific location in the document. |
| 20320 | This article shows you how to use Visual Basic for Applications to run a Microsoft Word mail merge in Microsoft Access. |
| 20321 | This article shows how to use Automation to move to a specific location in a Microsoft Word 2000 document. |
| 20322 | This article shows you how to use Automation to run a Microsoft Word 2000 macro from Microsoft Access. |
| 20323 | Each time you start an Office program, a dialog box for Windows Installer appears with the following message: Preparing to install... This is followed by another dialog box, with the following message: Please wait while Windows configures Office... |
| 20324 | When you click Print on the File menu in any of the Microsoft Office programs listed at the beginning of this article, you may receive a blank Print dialog box, and your document may not be printed. NOTE : You can print your document by using the... |
| 20325 | When you click Open or Save As on the File menu, the Back button is available even though the Hide the common dialog back button group policy has been enforced on your computer. |
| 20326 | When you click one of the Office program shortcuts on the Programs menu, you may receive the following error message: The installation source for this product is not available. Verify that the source exists and that you can access it. The |
| 20327 | Microsoft has released an update that eliminates a security vulnerability in Microsoft Office 2000 and all of the programs listed at the beginning of this article. The vulnerability could allow a malicious Web site operator or e-mail author to take... |
| 20328 | In any of the Microsoft Office 2000 programs or Microsoft Project 2000, if you ask the Office Assistant for help and click any of the Help topics, the following error message appears: Help requires Microsoft Internet Explorer 3.0 or greater. You can... |
| 20329 | In any of the Office 2000 programs or Project 2000, if you ask the Office Assistant for help and click any of the Help topics, the following error message appears: Help requires Microsoft Internet Explorer 3.0 or greater. You can install the latest... |
| 20330 | When you restart your computer or you try to start one of the Office programs, you may receive the following error message: This application must be installed to run. Please run Setup from the location where you originally installed the |
| 20331 | When you attempt to use any program within Microsoft Office 2000 SR-1, you may be prompted to register from the Office Registration Wizard before you can use the program. |
| 20332 | When you start any of the Office programs or when you start the Office Assistant, the following error message may appear: The Office Assistant could not be started. Please repair the Assistant by running Office 2000 setup and selecting Repair Office... |
| 20333 | When you start an Office program, you may receive the following error: Required registry information is missing and this application cannot run. Please rerun setup to correct this problem. Required registry information is missing and this |
| 20334 | When you run Office Setup, you may receive an error message similar to one of the following: Ie5wzd caused an exception in module Msjava.dll Ie5wzd caused an exception in module Msjava.dll -or- Ie5wzd caused an exception |
| 20335 | When you start one of the Office programs, the following may occur: The program starts, but after a few seconds, the following error message appears: Required registry information is missing and this application cannot run. Please run setup to correct... |
| 20336 | When you type certain words or characters in a Microsoft Office program (such as Microsoft Word, Microsoft Excel, or Microsoft PowerPoint), they may be replaced with Xs. For example, if you type an inappropriate four-letter word, each letter of the... |
| 20337 | When you start one of the Microsoft Office programs listed at the beginning of this article after you apply the Microsoft Office SR-1/SR-1a Update, the program quits immediately after it starts. |
| 20338 | When you attempt to start an Office program, the following error message appears: This application requires the Windows Installer to run. This application requires the Windows Installer to run. |
| 20339 | When the Microsoft Find Fast Indexer program runs, the following error message appears: For the Find Fast program to continue indexing, you must repair the damaged document, or move the document to a drive or folder that you are not indexing with Find... |
| 20340 | When you attempt to start the Visual Basic Editor in Microsoft Excel 2000, the following error message appears: An error occurred initializing the VBA libraries (1004). When you attempt to start the Visual Basic Editor in Microsoft Word 2000, the... |
| 20341 | When you first start a Microsoft Office program, the menus and toolbars display basic commands and buttons. As you work with an Office program, the commands and buttons that you use most often are stored as personalized settings and displayed on menus... |
| 20342 | Microsoft Office 2000 includes a program that you can use to create digital certificates for signing Microsoft Visual Basic for Applications (VBA) projects. The program is called SelfCert.exe. You can use it to create test certificates that you can... |
| 20343 | When you start any of the Microsoft Office 2000 programs listed at the beginning of this article, you may receive the following error message: There was a problem starting the Office Assistant. Would you like to try reinstalling it? If you click Yes ,... |
| 20344 | If you click About program name on the Help menu in any of the Office programs, the version number may not show SR-1, even though you successfully installed the SR-1 update. NOTE : program name is the name of the Office program that you are using. |
| 20345 | The following symptom occurs with Microsoft Visual Basic for Applications code that relies on the Dir function to return an empty string as the termination condition of a file-processing loop: The code runs endlessly if the files are modified while... |
| 20346 | When you click None of the above, look for more help on the Web in a Microsoft Office Assistant balloon, a Help window is opened. When you click Send and go to the Web , Microsoft Internet Explorer is started even though it is not set as your default... |
| 20347 | When you install one of the products listed above and then install a second product listed above (CD1 or CD2 in the case of Microsoft Office), the default installation location of the second product is not the location where you installed the previous |
| 20348 | When you attempt to import tables from an Access 2000 or 2002 database to Outlook 2000 or 2002, the following error message may appear: An ODBC error has occurred in the Microsoft Access translator while opening a file to build a field map.... |
| 20349 | When you use any of the Microsoft Office XP or Microsoft Office 2000 programs, you may notice one or more of the following behaviors: Publisher document icons are displayed as generic icons. Microsoft Publisher is no longer displayed under Programs on... |
| 20350 | By default, a chart sorts the X-axis fields in alphabetical or numeric order. This article describes two methods that you can use to sort the X-axis fields in a different order. |
| 20351 | If you modify a Print Setup setting while you are previewing a report, Microsoft Access 2000 does not ask you to confirm the changes; the changes are automatically saved. This behavior differs from that of Microsoft Access 2.0, which prompts you |
| 20352 | 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 Edit Relationships dialog box. |
| 20353 | You can use the IIf() function to group values under a small number of headings in a crosstab query. This article demonstrates how to group records by country and to count the number of orders placed for each customer. NOTE : You |
| 20354 | The Table Analyzer Wizard can help you create a relational database from a set of data. When you use the Table Analyzer Wizard, you do not have to know relational database design principles. This article explains how the Table Analyzer Wizard |
| 20355 | 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 |
| 20356 | You may receive the following error message when you try to print or preview a Microsoft Access report that has been converted from Access version 2.0: Some data may not be displayed. There is not enough horizontal space on the page for the number |
| 20357 | This article shows you how to add blank lines between the printed lines on a report. You can use this method to add a blank line after a set number of lines. For example, you could use this method to add a blank line after every five lines of data in |
| 20358 | If you select 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. |
| 20359 | If you use the Error() or Error$() functions to get the textual description of an error message, you may receive the following error message: Application-defined or object-defined error Application-defined or |
| 20360 | This article demonstrates how to include a blank row at the top of a combo box list. This enables you to set the combo box's LimitToList property to Yes , and still be able to delete the contents of the combo box without triggering the |
| 20361 | When you export tables, queries, or forms that contain OrderBy and Filter properties to ASP or IDC format, and then browse to the exported files in a Web browser, you notice that the recordset is not sorted, and that it outputs all records. |
| 20362 | This article demonstrates two methods that you can use to create a running totals query. A running totals query is a query in which the total for each record is a summation of that record and any previous records. This type of query is useful for |
| 20363 | If you try to create a command bar with an existing name by using Visual Basic for Applications, you may receive the following error message: Run-time error '5': Invalid procedure call or argument Run-time error '5': |
| 20364 | If you reference a subreport control from a main report when the subreport does not return any matching records, you may receive the following message #ERROR #ERROR for the referenced subreport control. NOTE : This |
| 20365 | The most recently used (MRU) file list is the list of the last database files that were opened in Microsoft Access. This list appears in the Microsoft Access startup dialog box (9 files) and at the bottom of the Microsoft Access File menu (4 |
| 20366 | When you try to open a Microsoft Access readme.txt file, you receive the following error message: Windows cannot find deskedit.exe This program is needed for opening files of type 'Text File'. Location of deskedit.exe: C:\ |
| 20367 | Microsoft Access 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. |
| 20368 | When you try to create a new report, you may receive one of the following error messages. You may receive the following error message if you use the wizard to create a new report: You must install a printer before you can create a report. |
| 20369 | This article describes how to group rows of data using a value range rather than having a single row per value. |
| 20370 | When you set the height of a form or report's Detail section in the Page Setup dialog box under Item Size on the Columns tab, the Detail section's height does not change. The Page Setup Height setting is ignored, and the section |
| 20371 | 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: To make changes to this field, first save the |
| 20372 | A form with its DefaultView property set to Datasheet and its Modal and PopUp properties set to Yes does cannot be opened with all three properties applied. The form opens in Datasheet view, but the Modal and PopUp property |
| 20373 | When you use the Filter By Form feature, a combo box or list box contains more values than the number that you specified in the Don't display list where more than this number of records read box on the Edit/Find tab of the Options command |
| 20374 | Code written in Access Basic that uses -1 or 0 (with the quotation marks) to compare a Yes/No field in a table or recordset does not work properly when you convert the Access Basic code to Visual Basic for Applications code. In Access version 2.0, |
| 20375 | When you append data from a delimited text file to an existing table by using a TransferText macro action or a TransferText method in Visual Basic for Applications, you may receive an error message similar to the following: Run-time |
| 20376 | In Microsoft Access 2000 you can control the user's ability to add records to a table when using a data entry form. The AllowAdditions property can prevent users from adding new records while still allowing them to view and modify the existing |
| 20377 | When you import a fixed-width file with two Date fields that have different formats, individually you can import them, but if you try to import them together, you may receive the following error message: Type Conversion Error Type Conversion |
| 20378 | This article demonstrates how Microsoft Access handles Currency, Date/Time, and Number formats when you change the regional settings in Control Panel in Windows 95/98 or Windows NT 4.0. NOTE : This article assumes that you are using |
| 20379 | If you change the source of a linked object on a form by using the Links dialog box, the SourceDoc and SourceItem properties for that object are not updated although the object itself is updated correctly. |
| 20380 | 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. |
| 20381 | A Btrieve ISAM is no longer available in Microsoft Access 2000. |
| 20382 | When you open or make a reference to a linked table in Microsoft Access, you may receive the following error message: Couldn't find input table or query '' Couldn't find input table or query '' -or- Couldn't find file '\' |
| 20383 | This article describes how you can reference the parameters of a report's RecordSource query or view. You can use this method to display the parameters in a text box in the report. NOTE: This article explains a technique |
| 20384 | When you create a chart in Microsoft Access, Microsoft Graph automatically adjusts the scale of the value axis for each record. This means that the displayed range of values may vary from record to record. This article demonstrates how you can |
| 20385 | This article shows you how to use the drag-and-drop method to copy data from a Microsoft Excel worksheet to a table in a Microsoft Access database. |
| 20386 | When you convert a Microsoft Access version 1. x or 2.0 database to a Microsoft Access 2000 database, the conversion process may display a warning message or stop altogether because of an incompatibility with new features and enhancements. This |
| 20387 | The Auto List Members feature in Microsoft Access helps you type Visual Basic for Applications code by displaying a list of an object's properties and methods as you type. However, when you type the name of a report control in the class module |
| 20388 | The .ldb file plays an important role in the multiuser scheme of the Microsoft Jet database engine version 4.0. The .ldb file is used to determine which records are locked in a shared database and by whom. |
| 20389 | In Microsoft Access, 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 procedures that |
| 20390 | When you convert the Microsoft Access 2.0 sample database, NWIND.MDB, to Microsoft Access 2000, you may receive the following error message: There were compilation errors during the conversion or enabling of this database. There were |
| 20391 | This article demonstrates how to use the tab control on a form in Microsoft Access. |
| 20392 | This article shows you how to use the DLookup () function and includes examples and tips. The following topics are addressed in this article: The DLookup () function syntax and usage. The following DLookup () |
| 20393 | The Database Documenter does not enable you to view a report on a per user basis nor to have a report that is grouped by users and groups display the permissions for the objects in your database. However, you can create your own custom reports that |
| 20394 | When you use the Microsoft Office 2000 Developer (MOD) Setup Wizard to create disk images for a custom application, the file compression ratio is less than some third-party compression utility programs. For example, the MOD Setup Wizard may compress a |
| 20395 | This article gives you examples of how to programmatically create, search, replace, and modify Visual Basic for Applications code within Access. One of the most common uses for code that itself writes code is a wizard. Wizards can be used to |
| 20396 | 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 |
| 20397 | 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 : |
| 20398 | When you add a record to an SQL table 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 field, the new record appears deleted until you reopen the SQL table. If you try to |
| 20399 | When you open a database created with an earlier version of Microsoft Access without converting the database (enabling it), you are unable to link or to import data. |
| 20400 | If you use the CreateWorkspace method without specifying the DBEngine object, you may receive the following error message when you use the optional password argument: Run-time error '3028': Can't start your application. The |
| 20401 | When you select the Find a record on my form based on the value I selected in my combo box option in the Combo Box Wizard dialog box, the Combo Box Wizard does not give you the option to select a table or query as your data source. |
| 20402 | When you place a tab control on any page of another tab control, and then view the form in Form view, the embedded tab control is visible from any page of the main tab control. |
| 20403 | 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: Invalid bracketing of name |
| 20404 | When you search for file extensions by using the FileType property of the FileSearch object, certain file extensions may return a files found = 0 message, even though the information does exist. For example, this behavior occurs if |
| 20405 | This article shows you how to use watermarks in a form. |
| 20406 | When you purchase Microsoft Office 2000 Developer (MOD), your license agreement permits you to redistribute run-time versions of applications that you create to users who do not have Microsoft Access. When recipients of your application run your Setup |
| 20407 | You can use the RepeatSection property to specify whether a group header is repeated on the next page or column when a group spans more than one page or column. NOTE: This article explains a technique demonstrated in the sample |
| 20408 | The About MDE files Help Topic contains the following paragraph: If your database contains Microsoft Visual Basic code, saving your Microsoft Access database as an MDE compiles all modules, removes all editable source code, and compacts the |
| 20409 | Microsoft Access 2000 has 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 types of controls you can morph. For example, you cannot morph an image |
| 20410 | The Setup program for Microsoft Access 2000 and Microsoft Office 2000, 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 Server version 6.5. |
| 20411 | When you convert a Microsoft Access version 2.0 database to Microsoft Access 2000, you may receive one of the following error messages if your database contains an OLE control: The OLE server isn't registered. To register the OLE server, |
| 20412 | When you compile a database in Microsoft Access, you may receive the following error message: A module is not a valid type. A module is not a valid type. |
| 20413 | When you click on a tab control in Design view of a form, you do not see the control handles (boxes around the control) that enable you to change the size of the control or to delete the control. This article demonstrates how to select pages |
| 20414 | When you try to convert a Microsoft Access 2.0 database to Microsoft Access 2000, the conversion process stops, and you may receive the following error message: Name conflicts with existing module, project, or object library. Name conflicts |
| 20415 | 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. |
| 20416 | If you create a custom command bar that contains commands from the Built-in Menus category, any changes you make to the custom command bar are reflected in the built-in menus, and vice versa. Also, if you move your database to another |
| 20417 | 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. |
| 20418 | When the Enabled property of a page on a tab control is set to False , you can still click the tab and see its controls and the data that they contain. However, you cannot change any of the data. |
| 20419 | When you start Microsoft Access on a network workstation, you may receive the following error messages: The file or folder 'MSACCESS.EXE' that this shortcut refers to cannot be found. The file or folder 'MSACCESS.EXE' that this shortcut refers |
| 20420 | When you use Microsoft Access 2000 to open a database that was created in an earlier version of Microsoft Access, in most cases, the database is converted without difficulty. However, there are circumstances when objects and code in the older database |
| 20421 | This article summarizes many of the new features in Microsoft Access 2000. It contains the following sections: What's New About Data Access Pages What's New in a Microsoft Access Project What's New About Working on the Internet |
| 20422 | Database replication is a feature of Microsoft Jet database engine 3.0 and later. Microsoft Access 2000 uses the Jet 4.0 database engine. Replication enables you to make copies of the databases (called replicas) so that users can work on their |
| 20423 | Titles often begin with the articles A, An, and The. When you sort such title fields, you may not get the intended result of having the titles sorted in alphabetical order by their most meaningful words. For example, movie titles, such as The |
| 20424 | 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, |
| 20425 | 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. |
| 20426 | If you try to open a recordset on a linked table by using the dbOpenTable constant, you may receive the following error message: Run-time error '3219': Run-time error '3219': Invalid Operation. Invalid Operation. |
| 20427 | 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 one of the following error messages: Field 'F1' doesn't |
| 20428 | 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. |
| 20429 | Microsoft Access does not prompt you for the second parameter in a query, even though it does prompt you for the first parameter. |
| 20430 | This article demonstrates how to set the QueryTimeout property for queries run against ODBC data sources. |
| 20431 | 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. |
| 20432 | This article describes how to sort the values on a form based on field names that you select from a combo box. |
| 20433 | Microsoft Access allows a Null value in a field that is the foreign key in a relationship even if referential integrity is enforced. |
| 20434 | This article shows you how to convert a replicated database back to a regular database. |
| 20435 | This article describes two methods that you can use to export Null fields with delimiters. |
| 20436 | When you pass optional arguments that are of a data type other than Variant to a Visual Basic for Applications function, the IsMissing() function returns a value of False for those optional arguments. This is perceived as a |
| 20437 | When you import or link a fixed-width text file with fields that contain an embedded carriage return (CR) and line-feed (LF) control characters (ASCII decimal values 13 and 10 respectively), Microsoft Access interprets this character set as being the |
| 20438 | 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. |
| 20439 | This article demonstrates how you can create a report that displays the first and last record on a report page in the page footer for that page. This is useful if you want to create a phone book-like index on each page of a report. This |
| 20440 | When you link to a Microsoft Excel spreadsheet from a Microsoft Access 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. |
| 20441 | 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 by the query before you applied the additional filters. |
| 20442 | The following table lists the ActiveX controls that have been tested and verified for use with Microsoft Access 2000. The ActiveX controls listed in this article are the only ActiveX controls supported for use with Microsoft Access 2000. |
| 20443 | This article explains why a Microsoft Access database may change in size when you convert the database from an earlier version to Microsoft Access 2000. |
| 20444 | When you try to convert or open a Microsoft Access 2.0 database, you may receive the following error message The process failed because there is no printer installed. The process failed because there is no printer installed. This may be |
| 20445 | Migration from earlier versions of Microsoft Access to Microsoft Access 2000 is straightforward. When you initially open your database in Access 2000, you have two choices: to convert the database to version 2000, or to open it in version 2000. The |
| 20446 | 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 ODBC tables in your programs, or refresh existing ODBC tables. |
| 20447 | This article describes how to set, or change, the screen position where a form will open. |
| 20448 | After you export data to create Dynamic HTX/IDC or Dynamic Active Server Pages (ASP) files on your Web server, you may receive the following message when you try to view those files with your Web browser: The page cannot be displayed The page |
| 20449 | This article lists the wizard files included with Microsoft Access, and lists the wizards and builders that each file contains. |
| 20450 | This article lists the hardware and software requirements to install Microsoft Access 2000. |
| 20451 | When you import a delimited text file that has a field that contains values in a Medium Date format (DDMMMYY), the data for that field is not imported and an import errors table is created. |
| 20452 | You can use Microsoft Graph to embed a graph object in a Microsoft Access form or report. However, if you export the form or report to an Excel worksheet, the graph does not appear in the worksheet. This article describes how to export a Microsoft... |
| 20453 | When you use the PrtMip property example in Help, you may receive the following error message: Compile Error: Method or data member not found Compile Error: Method or data member not found |
| 20454 | This article describes how to create a graph that is bound to two combo boxes. You can control the data that is displayed in the graph by making selections from the combo boxes. |
| 20455 | 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. |
| 20456 | When you set the BackStyle property of a form control to Transparent, the control's background color is visible when the control has the focus. |
| 20457 | 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: No unique index found for referenced field of primary table. No unique |
| 20458 | 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. |
| 20459 | When you switch the focus away from a maximized form in a Microsoft Access database, the Resize event of the form that is losing focus fires unexpectedly. |
| 20460 | When you create a main report that has a subreport with snaking (multiple) columns, the report is printed with only one column of data for the subreport. This behavior occurs when items on the subreport extend to two columns. |
| 20461 | When you use quotation marks () around the values in a pass-through update query, or you send a string that contains an apostrophe (') to Microsoft SQL Server, you may receive the following ODBC error: ODBC--call failed. [Microsoft][ODBC |
| 20462 | This article discusses the causes of invalid page faults in Microsoft Access 2000 and provides troubleshooting steps for solving invalid page fault errors. |
| 20463 | 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 only the labels in the first column and only the text boxes in |
| 20464 | 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 not numeric |
| 20465 | You can select multiple records in a form using the record selector at the left side of the form. You can also use the SelTop and SelHeight form properties to specify or determine the number of selected records in a continuous or Datasheet |
| 20466 | When you use an index on a table without a primary index, the table does not sort according to the order of the fields in the index. |
| 20467 | Setting the Filter property of a form does not apply the filter. |
| 20468 | When you try to invoke the Input Mask Wizard, you may receive the following error message: The Input Mask Wizard only works with Text or Date fields. The Input Mask Wizard only works with Text or Date fields. |
| 20469 | 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 that you move from one record to another in the main form. In addition, a macro attached to |
| 20470 | 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 behavior occurs with the TransferSpreadsheet macro and the Import |
| 20471 | The Microsoft Access Chart Wizard enables you to format a label for each axis of a chart or graph. You can modify the label formats in Microsoft Graph, and then save those changes for later use. When it is not possible to simply reformat the data in |
| 20472 | When you open a form that has the AllowAdditions property set to No, the form allows you to add records. |
| 20473 | 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 are cleared if the list box is requeried. This behavior |
| 20474 | This article shows you how to create a report that you can filter dynamically in Print Preview by selecting filter criteria from a pop-up form. NOTE : This article explains a technique demonstrated in the sample file, RptSmp00.mdb. For |
| 20475 | This article shows you how to create a pop-up form for setting the sort order of data in a report. NOTE : This article explains a technique demonstrated in the sample file, RptSmp00.mdb. For information about how to obtain this sample |
| 20476 | 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 |
| 20477 | 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 and |
| 20478 | When you try to omit fields from the export specification in the Export Text Wizard, you may receive the following error message: The number of fields in your export specification does not match the number in the table you have chosen to export. |
| 20479 | This article describes how to create a command button on a filtered form that, when clicked, opens a report and applies the filter that is on the form to the report. NOTE : This article explains a technique demonstrated in the sample |
| 20480 | A stand-alone option button that has been pasted into an option group has an OptionValue property of -1. |
| 20481 | When you link a Microsoft Access 2.0 table to a Microsoft Access 2000 database, you may receive the following error message: Cannot open a database created with a previous version of your application. Cannot open a database created with a |
| 20482 | 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. |
| 20483 | 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 allows you to select only one field for a primary key. |
| 20484 | 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: Data type mismatch in criteria expression. Data type mismatch in criteria expression. |
| 20485 | A text box whose Format property is set to Currency on a form or on a report displays data with an extra space at the right end of the value. |
| 20486 | Vertical line controls do not increase in height when you place them in a report section even if you set the CanGrow property for the section to Yes . |
| 20487 | If you change the size of a form in Design view, and then save and close the form, when you open the form from the Database window, the size of the form will not reflect the changes that you made. |
| 20488 | When you try to modify a linked table that is located on a read-only drive, a write-protected disk, or a CD-ROM in Microsoft Access, you may receive the following error message: The Microsoft Jet database engine cannot open the file |
| 20489 | When you use the OutputTo method or OutputTo action to save a report to a text file (.txt), blank lines are randomly added to the text file. NOTE : This behavior can also occur when you use the Export command to save a report to a |
| 20490 | You cannot use the Find command to find fields containing the number sign (#) character. |
| 20491 | When you view and switch between maximized forms, all forms may suddenly become un-maximized (restored). |
| 20492 | If you try to use the CommandBars object model in Visual Basic for Applications to reference the Shortcut Menus toolbar, you may receive the following error message: Run-time error '5': Invalid procedure call or argument |
| 20493 | When you try to export a query in dBASE (any version) file format, you receive the following error message: Couldn't find object queryname.dbf. Couldn't find object queryname.dbf. When you try to save the underlying table to dBASE format, |
| 20494 | Microsoft has expanded its online services to a non-proprietary platform with the addition of no-charge Microsoft-sponsored NNTP newsgroups on the Internet. Previously, Microsoft-sponsored electronic service forums were limited to users of CompuServe |
| 20495 | 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. |
| 20496 | When you attempt to create a watermark by setting the Picture property of a mailing label report to a graphic image, the watermark appears only once on each sheet of labels instead of on each label. |
| 20497 | Forms always open to a maximized state after any other Microsoft Access window has been maximized (excluding the Microsoft Access Database window). However, when a Microsoft Access window is maximized, forms may briefly be displayed in a restored |
| 20498 | If you move a database file from one computer to another, and then try to open the database on the second computer, you receive the following message: |
| 20500 | When you open one of the Microsoft Office programs listed at the beginning of this article, the program may open slowly. |
| 20501 | This step-by-step article describes how to call Office macros from a Visual C# .NET Automation client. You can use Microsoft Office Automation to open a document or create a new document that contains a Visual Basic for Applications (VBA) macro and... |
| 20502 | Sometimes, you may not want to store images in a Microsoft Access table. You may not want to do this if you have many images, or if each of your image files is large. Image files can increase the size of an Access database quickly. |
| 20503 | 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. |
| 20504 | If you dimension an object as a Recordset and then set that object to databaseobject.OpenRecordset(source), you may get the following error message: |
| 20505 | 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... |
| 20506 | When you try to install one of the programs listed at the beginning of this article, on a computer that is running Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows Millennium (Me) you may receive the following error message: Error... |
| 20507 | 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... |
| 20508 | 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 |
| 20509 | 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. |
| 20510 | 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... |
| 20511 | 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. |
| 20512 | If you want to troubleshoot a problem with your printer driver, try printing with a different printer driver. If you determine that the problem does not occur when you use a different driver, you may need to update or reinstall the original printer... |
| 20513 | You can provide context-sensitive Help for a |
| 20514 | This article demonstrates how to use drag-and-drop functionality in the Microsoft TreeView control, version 6.0. |
| 20515 | After the Microsoft Data Engine (MSDE) Setup program copies files to your computer, it stops responding during the "Connecting To Server" phase. |
| 20516 | This article contains troubleshooting steps that you can use if error messages appear when you run the Setup program or any Microsoft Office 2000 program, under Microsoft Windows NT 4.0. |
| 20517 | When you uninstall Microsoft Access or Microsoft Office, the System.mdw file and the sample databases are removed, even if you have made changes to these files. |
| 20518 | When you start one of the Office programs, the following symptoms may occur: |
| 20519 | When you start one of the Microsoft Office 2000 programs on a computer that is running Microsoft Windows XP, Microsoft Windows NT, or Microsoft Windows 2000, you may experience one of the following symptoms: |
| 20520 | Microsoft has created new Paradox and dBASE ISAM drivers for Microsoft Jet 4.0 that do not require the installation of the Borland Database Engine (BDE) to provide full read/write access to Paradox and dBASE files. The current Jet 4.0-based Paradox... |
| 20521 | This article lists the updates for Microsoft Office 2000 that are currently released by Microsoft. |
| 20522 | When you start an Office 2000 program, the Office Registration Wizard (ORW) appears, and the bold text in the middle of the dialog box states: |
| 20523 | When you install any of the Office products listed at the beginning of this article, you may receive an error message similar to the following: Internal Error 2889: Please contact product support for assistance. |
| 20524 | 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. |
| 20525 | This article contains a list of Microsoft Office Developer samples and tools that are available in the Microsoft Download Center. |
| 20526 | Microsoft has created the Windows Installer CleanUp Utility, which allows you to safely remove Windows Installer-related registry settings from your computer in the event of a problem. |
| 20527 | The following two white papers that discuss replication in Microsoft Jet Database Engine version 4.0 are available in the MSDN Online Library: |
| 20528 | 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 |
| 20529 | This article shows you how to dim or disable items on a menu bar, toolbar, or shortcut menu in Microsoft Access. |
| 20530 | This article shows you how to use Automation code to manipulate a Microsoft Project (*.mpp) file from Microsoft Access. |
| 20531 | 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... |
| 20532 | To ensure the proper operation of your Microsoft Data Engine (MSDE) or SQL Server computer, run the INSTCAT.SQL script with the Query Analyzer, ISQL, or OSQL utility. If INSTCAT.SQL has not been properly implemented on MSDE or a SQL Server, |
| 20533 | This article contains a discussion of ASCII to EBCDIC conversion issues, translation tables, and code to translate from ASCII to EBCDIC and vice- versa. |
| 20534 | This step-by-step article discusses how to use the object models for Office applications to avoid dialog boxes during Automation. It also provides an example of how to simulate user input to programmatically dismiss a dialog box that cannot be avoided... |
| 20535 | This article describes the limitations of graphics import filters that are provided with Microsoft Office 2000. This information is also available in Help in each program. (On the Help menu, click Microsoft application Help . In the Answer Wizard or... |
| 20536 | This article contains a listing of all the Open Database Connectivity (ODBC) drivers installed by Microsoft Access 2000, Microsoft Office 2000, and Microsoft Data Access Components (MDAC). |
| 20537 | An unhandled exception may occur under the following circumstances: |
| 20538 | When you attempt to use a Microsoft Office 2000 program on a Microsoft Windows XP-based computer, you may receive an error message similar to one of the following: Program name executable for Windows has encountered a problem and needs to close. We... |
| 20539 | When you attempt to start Help in Microsoft Outlook 2000, you may receive an error message similar to the following: Microsoft Outlook cannot display Office Assistant Help. Microsoft Outlook cannot install the necessary files due to Windows Installer... |
| 20540 | This article shows how to format words on a control in a report. The article uses an example from the Northwind database, a text box composed of concatenated first and last name fields from the Employees table. |
| 20541 | 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. |
| 20542 | When you click a hyperlink in a Microsoft Office document in an Office program, you may receive an error message similar to the following: This operation has been canceled due to restrictions on this computer. Please contact your system administrator. |
| 20543 | When you try to view the code for a module, try to compile a database, try to create an MDE file, or try to execute code in a Microsoft Access 2000 database, you may receive the following error message: |
| 20544 | When you try to import data, copy a table, or run an append query, you may receive the following error message: |
| 20545 | In Access and other Microsoft Office applications, you can use the |
| 20546 | When you use Microsoft Office 2000, if you click a button on the Microsoft Office Shortcut Bar (OSB), the program that you select may not start. WordPad may start instead. You receive the following error message: File is too big to open in WordPad,... |
| 20547 | When you use any database wizard in Microsoft Access, you may receive the following error message: |
| 20548 | When you are running an append query, you receive the following error message: |
| 20549 | When you try to link or embed a Word document, you may receive one of the following error messages: |
| 20550 | This article describes how you can 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 corrupt |
| 20551 | You are unable to import Microsoft Excel Spreadsheets and HTML files. When you use the Import Wizard to import a Microsoft Excel spreadsheet or a Hypertext Markup Language (HTML) file, you see a message in the status bar that says "Import S |
| 20552 | You can remove Microsoft Office 2000 Suite editions and stand-alone Office programs remotely with Microsoft Systems Management Server or by other means. To remove a program or suite remotely, you need the product's globally unique identifier (GUID).... |
| 20553 | This article explains how users with different versions of Microsoft Access can share the same data. |
| 20554 | When you try to link to a Microsoft SQL Server 7.0 database from Microsoft Access using the ODBC |
| 20555 | This article explains how to download and install the Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) Update from the Microsoft Tools on the Web site. NOTE : For information about obtaining the latest Office 2000 Service Pack, please see the... |
| 20556 | This article describes how to repair a damaged Microsoft Access database when the database cannot be recovered using the methods described in the following article |
| 20557 | This step-by-step article describes how to reset a menu in a Microsoft Office program back to its default first-run condition. In addition, this article describes the following: What the Personalized Menus and Toolbars feature is. Two methods for... |
| 20559 | When you try to save design changes to a new object, or when you compact a database, you receive the following error message: |
| 20560 | When you use Microsoft Access, you receive the following error message: |
| 20561 | When you want to open a database read-only with the ActiveX Data Object (ADO) and the Jet 4.0 provider, the |
| 20562 | This article shows you how to programmatically link or embed an object in an unbound object frame on a form by using the object frame properties in Microsoft Access. |
| 20563 | When you output a report to Microsoft Excel, any Memo field is truncated to 255 characters. You may also see this behavior when you click the |
| 20564 | When you use the Chart Wizard to insert a chart in a form or a report, you receive the following error messages: |