Button Click Text Box Table Populate

[NeonSky via AccessMonster.com]

Hello Everyone,

Ok, I have a text box where a user inputs a date. On button click I would
like that date to populate all fields in a "date" column in my table.

Simple enough i am sure though I am new to front end design.

Thanks so much!

 

[Guest]

Need to know more about what you are trying to accomplish. The date needs to
be filled in when each records is created otherwise you have to use an update
query.

 

[NeonSky via AccessMonster.com]

Hello Anne,

Thanks for the response.

How do I create an update query to add a "date" column to an existing table.
This column will reflect the present date. This is for the purpose of having
a "stamp" for when we recieve the records. So if someone was to say hey I
need all the records we recieved last wednesday I have a means of going to
our history table and filtering out the dates needed.

Hope this helps, happy to elaborate!!

Thanks!

Need to know more about what you are trying to accomplish. The date needs to
be filled in when each records is created otherwise you have to use an update
query.

Hello Everyone,

[quoted text clipped - 4 lines]

Thanks so much!

 

[Guest]

Sorry, been busy reconfiguring my computer.
Add the date field to your original table, be sure to include that field in
any query.
On your form add the date field (make sure you don't name it date, use
EntryDate or something like that. Add that field to your form and use as
default value of that field =Date().
No update query needed, everytime a new record is entered the date is filled
in automatically. I that what you needed?

Hello Anne,

Thanks for the response.

How do I create an update query to add a "date" column to an existing table.
This column will reflect the present date. This is for the purpose of having
a "stamp" for when we recieve the records. So if someone was to say hey I
need all the records we recieved last wednesday I have a means of going to
our history table and filtering out the dates needed.

Hope this helps, happy to elaborate!!

Thanks!

Need to know more about what you are trying to accomplish. The date needs to
be filled in when each records is created otherwise you have to use an update
query.

Hello Everyone,

[quoted text clipped - 4 lines]

Thanks so much!

 

[NeonSky via AccessMonster.com]

Anne,

Thank you, works great!

I really appreciate the input!

- Anthony

Sorry, been busy reconfiguring my computer.
Add the date field to your original table, be sure to include that field in
any query.
On your form add the date field (make sure you don't name it date, use
EntryDate or something like that. Add that field to your form and use as
default value of that field =Date().
No update query needed, everytime a new record is entered the date is filled
in automatically. I that what you needed?

Hello Anne,

[quoted text clipped - 19 lines]