Search results

I finally got this to work in my form - but on the text box is unbound, and I would really like to send the DateAdd result to my table...(I know, calculation not always the best info to sent to the table), but it is relevant. How do do that if my text box is unbound?

To Pat - the one year calculated date is from a variable date...which is why I want it - it's for document retention policy monitoring. Plog - 1. I've put the query in the form. 2. HCInternalRequset is the table 3. =DateAdd('yyyy',1,[HDRneed]) HDRneed being the date the data is needed...

Still need help...that did not work. It's telling me it can't recognize the field name in the validation expression (?). Not sure where I'm going wrong here...

Thank you!!

I'm putting a very basic table (form on the front end) together to collect data, and I want the date field to be populated with the date the data is entered, and I don't want it to change - will =date() or =now() do that? Also, I want to calculate a DateAdd on a date field that is manually...

Hi - I'm in the Chicago area, and I'm a paralegal...I've done some database work, some SQL, some Crystal Reports....but it's been a long time! I'm not new to Access but I'm not a programmer...so I'm looking for help here and there :)