1756) 9/25/2007 Q208529 ACC2000: How to Filter a Report from a Pop-Up Form (Q208529)
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 1757) 9/25/2007 Q208532 ACC2000: How to Sort a Report from a Pop-Up Form (Q208532)
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 1758) 10/1/2007 Q208536 ACC2000: Microsoft Access Report Is Not Visible in Word or Excel (Q208536)
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 1759) 9/23/2007 Q208541 ACC2000: Keeping Subreport or Text Box Data Together on a Page (Q208541)
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 1760) 9/23/2007 Q208544 ACC2000: Can't Export Part of a Table to a Text File (Q208544)
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. 1761) 9/23/2007 Q208548 ACC2000: How to Filter a Report Using a Form's Filter (Q208548)
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 1762) 9/23/2007 Q208416 ACC2000: Buttons Pasted into Option Groups Have Option Value of -1 (Q208416)
A stand-alone option button that has been pasted into an option group has an OptionValue property of -1. 1763) 9/27/2007 Q208419 ACC2000: Error Message When You Link Access 2.0 Tables (Q208419)
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 1764) 9/23/2007 Q208420 ACC2000: Two Tables Automatically Joined in Query (Q208420)
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. 1765) 9/23/2007 Q208422 ACC2000: Text Import Wizard Allows Only One Field for Primary Key (Q208422)
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. 1766) 9/23/2007 Q208425 ACC2000: Type Mismatch Error Specifying Criteria with Count in a Query (Q208425)
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. 1767) 9/30/2007 Q208428 ACC2000: Text Box Formatted as Currency Has a Space on the Right (Q208428)
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. 1768) 9/29/2007 Q208429 ACC2000: Vertical Lines in Report Do Not Grow with Section (Q208429)
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 . 1769) 9/23/2007 Q208430 ACC2000: Form Size Changes Not Retained (Q208430)
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. 1770) 9/22/2007 Q208431 ACC2000: Link Tables on a CD-ROM or Write-Protected Media (Q208431)
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
1
2
.... .... 114
115
116
117
[ 118 ]
119
120
121
122
.... 124
Previous Page
Page 118 of 124
Next Page
|