update table

[Guest]

Hi,

In my form there is today's date and time, =date() & =time(), and other
components. When I "submit record" to compile my records in a designated
table, all the data get transferred except for Date and Time.

However, if I entered the date and time manually in my form, it will get
transferred as all the other components.

How do I have today's date & time transferred and compile in my table? This
form is used by about 30 agents a day, It would be important for them not to
have to enter the date & time for every customer.

Thanks for your assistance
Karine

 

[Joan Wild]

Hi,

In my form there is today's date and time, =date() & =time(), and other
components. When I "submit record" to compile my records in a designated
table, all the data get transferred except for Date and Time.

However, if I entered the date and time manually in my form, it will get
transferred as all the other components.

You just need a single field in your table to store the date/time. Set it's
default value to =Now() and that will capture both the date and time. You
don't need to have anything on your form, but if you want you can add a
textbox control bound to this field, and users will see it when they create
a new record.

 

[Guest]

Where are you putting the date and time? It sounds like you have a bound
form, but the controls where you have the data and time are not bound to your
table. If you have the Default Value property for the controls bound to your
table set to date and time, then there should not be a problem. If this does
not help, post back with more detail so we can help.

 

[Guest]

Thanks a lot! I think it worked.

You just need a single field in your table to store the date/time. Set it's
default value to =Now() and that will capture both the date and time. You
don't need to have anything on your form, but if you want you can add a
textbox control bound to this field, and users will see it when they create
a new record.