Reply from LenRobichaud on May 21 at 10:15 AM It sounds like you are entering data directly into your table and not using a form.
This is commonly referred to as, "Committing Spreadsheet with a Database" and is almost Always a bad idea. Your users should never have direct access to the tables.
The proper way to do this is to base a query on your table and the create a form based on the query.
If you need the calculated field, "ProdYear" actually stored in your table you can control that through a control on the form so it writes the value into your table.
Good Luck
Len Robichaud
| | | ---------------Original Message---------------
From: Dharm_Singh
Sent: Friday, May 18, 2012 12:51 PM
Subject: Automatic Filling of One Field from Another Field in Same Record of Access Table
In an Access 2003 table, when a date field "C Ack" is filled up in a record, say "16-05-2012", I want that another field "ProdYear" of this same record may automatically be filled with "2012-13". In case the date field is filled with "20-02-2012", the another field of that record "ProdYear" should automatically be filled with "2011-12".
For the date field "C Ack" of the table, I have made a Simple Query for the above purpose with following code :-
ProdYear: IIF(DatePart("m",[C Ack])<4,DatePart("yyyy",[C Ack])-1 & "-" & Right(Year([C Ack]),2),DatePart("yyyy",[C Ack]) & "-" & Right(Year([C Ack])+1,2))
I want to eliminate the query and direct filling of ProdYear in the table is desired.
Thanks!
D.S.Pundir |
| Reply to this email to post your response. __.____._ |    _.____.__ |
No comments:
Post a Comment