If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help!
I am a new Access user and I'm having the following
problem: I added three fields to an existing database which are to include three dates for vaccination of each employee in the database. However, each time I add a date to any employee's record, it adds it to EVERY record. Any ideas on how to fix this? |
#2
|
|||
|
|||
help!
"Jennie" wrote in message
I am a new Access user and I'm having the following problem: I added three fields to an existing database which are to include three dates for vaccination of each employee in the database. However, each time I add a date to any employee's record, it adds it to EVERY record. Any ideas on how to fix this? I'm guessing that you add these vaccination-date fields (text boxes) to the form, not to the table on which the form is based. Thus they would be "unbound" controls, not bound to any record, and so when you display the form all records show the same value in that control. But the value isn't actually being stored anywhere; it's just being displayed. If I'm right about what's going on, here's what you should do. Press F11 (if necessary) to display the database window, go to the Tables tab, open the table the form is based on in Design View, add your vaccination-date fields (field type Date/Time) to the table, then close and save the table. Now go to the Forms tab, open your form in Design View, remove the unbound text boxes you added, then click the "Field List" button on the toolbar to display the field list of the form's record source. If the fields you added to the table aren't there in the list, your form's Record Source is probably a query or SQL statement, and you'll have to modify that before you can get the fields onto your form. To do that, close the field list for now and click the "Properties" button to bring up the property sheet for the form. Go to the Data tab of the property sheet and you should see the Record Source property. Click on that line, then click on the "build" button (caption "...") that will appear at the end of the line. Modify the query to include the fields you added to the table, then close it and let your changes be saved. Now click the "Field List" toolbar button again, and the new fields should be displayed. (If they aren't, close and save the form, then open it again in Design View). From the field list, drag the new fields down to the body of your form and drop them where you want them. Make any formatting changes you want, flipping into Form View if you'd like to see what the form looks like, then save your changes and close the form. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|