Date Created

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

--
Message posted via http://www.accessmonster.com

Please Help......


dinadvani wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200701/1

dinadvani via AccessMonster.com wrote:
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

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thanks a lot Rick

Rick Brandt wrote:
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


--
Message posted via http://www.accessmonster.com