|
 |
 |
 |
 |
Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms
of Use |
Trademarks
Article ID: 207766 - Last Review: June 24, 2004 - Revision: 2.0 ACC2000: The Time Cards Subform Is Not Filtered with New RecordsThis article was previously published under Q207766 Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
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 displaying a new, blank record,
the Time Cards subform displays time card information from another record.
This behavior occurs each time that you open the form and add a new record
by using the navigation button. The behavior does not occur if you click
Data Entry on the Records menu.
Edit the Time Card form to add the TimeCardID field. You can set the
Visible property of this field to No if you do not want to see it. To do so, follow these steps:
- Start Microsoft Access, and then open the database you created using the Time and Billing Wizard.
- In the Database window, click Forms under Objects, and then click Time Cards.
- Open the Time Cards form in Design view.
- If the Field List is not already open, on the View menu, click Field List.
- Drag the TimeCardID field from the Field List to an empty space on the Time Cards form.
- If the property sheet is not already open, on the View menu, click Properties.
- Set the Visible property of the TimeCardID text box to No.
- Save the form and close it.
When you click Enter/View Time Cards on the Main Switchboard, and then attempt to type new data, the data from other records is not displayed because the subform is now properly filtered.
Steps to Reproduce Behavior- Start Microsoft Access, and then click the Access database wizards, pages, and projects option in the opening dialog box. Click OK.
- In the New dialog box, click the Databases tab, and then select the Time and Billing template. Click OK.
- In the File New Database dialog box, select a folder in the Save in box, type a file name for the new database in the File name box, and then click Create.
- Click Finish on the first screen of the Database Wizard.
- When you are prompted to type your company information, click OK, and then type Acme Supply in the Company Name box. Close the My Company Information dialog box.
- On the Main Switchboard form, click Enter/View Clients.
- On the Clients form, type Frank in the First Name box and Johnson in the Last Name box. Then click the Projects button and type Shelving in the Project Name box. Close the Projects form, and then close the Clients form.
- On the Main Switchboard form, click Enter/View Other Information, and then click Enter/View Employees.
- Create the following new records by typing the data below in the appropriate fields:
First Name Last Name
-------------------------------
John James
Sara South
Close the Employees form. - On the Forms Switchboard form, click Return to Main Switchboard, and then click Enter/View Time Cards.
- On the first record, select John James in the Employee box. Press TAB twice to move the cursor to the Date Worked field. Type 01/02/00, and then press TAB. Select Shelving in the Project list. Close the Time Cards form.
- On the Main Switchboard form, again click Enter/View Time Cards.
- Click the New Record navigation button, and then in the Employee window select Sara South. Notice that the date and project name entered for John James under Time Worked appears on the form.NOTE: The information is displayed erroneously, but it is not saved with the new record. Only new information that you add to the Time Worked box is actually saved with the new record.
For more information about subforms, click Microsoft Access Help on the
Help menu, type subforms: what they are and how they work in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
APPLIES TO- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
 |
 |
 |
 |
 |
 |
 |
| |