Date Created

[dinadvani via AccessMonster.com]

Hi All,

I have 5 forms in which have put field date created and date modified. I have
put formula as Date() and set the enabled property to NO and Locked property
to YES. But the problem is now when I opened the forms they all had the
current date.

Please help me to resolve this issue.

I need these fields to build a Query on date created and modified, so as to
know the new fields added on a particular day.

Also I need your help for building the query, as the data in the forms are
formula it does not gets stored in Tables, so how do I go about it so as to
build a query wherein a user types a particular date and all the entries on
that date pops up.

Thanks a lot

Regards,
DA

 

[dinadvani via AccessMonster.com]

Please Help......

Hi All,

I have 5 forms in which have put field date created and date modified. I have
put formula as Date() and set the enabled property to NO and Locked property
to YES. But the problem is now when I opened the forms they all had the
current date.

Please help me to resolve this issue.

I need these fields to build a Query on date created and modified, so as to
know the new fields added on a particular day.

Also I need your help for building the query, as the data in the forms are
formula it does not gets stored in Tables, so how do I go about it so as to
build a query wherein a user types a particular date and all the entries on
that date pops up.

Thanks a lot

Regards,
DA

 

[Rick Brandt]

Hi All,

I have 5 forms in which have put field date created and date
modified. I have put formula as Date() and set the enabled property
to NO and Locked property to YES. But the problem is now when I
opened the forms they all had the current date.

Please help me to resolve this issue.

I need these fields to build a Query on date created and modified, so
as to know the new fields added on a particular day.

Also I need your help for building the query, as the data in the
forms are formula it does not gets stored in Tables, so how do I go
about it so as to build a query wherein a user types a particular
date and all the entries on that date pops up.

On your form you need =Date() as the DefaultValue property for [date created],
not as the ControlSource property. The ControlSource (for both TextBoxes)
should be the name of the field where you want the value saved.

For [date modified] you have to use VBA code. That TextBox should have no
DefaultValue property and in the BeforeUpdate event of the form you run code...

Me![date modified] = Date

 

[dinadvani via AccessMonster.com]

Thanks a lot Rick

Hi All,

[quoted text clipped - 12 lines]

about it so as to build a query wherein a user types a particular
date and all the entries on that date pops up.

On your form you need =Date() as the DefaultValue property for [date created],
not as the ControlSource property. The ControlSource (for both TextBoxes)
should be the name of the field where you want the value saved.

For [date modified] you have to use VBA code. That TextBox should have no
DefaultValue property and in the BeforeUpdate event of the form you run code...

Me![date modified] = Date