If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can't get date to save in table..........
I created a Ship Date field in a Table, created form using the ship date
field, wanted the field to display current date using date (), but the date does not save back to the table. Thanks for the help |
#2
|
|||
|
|||
Can't get date to save in table..........
Tony,
If you always want the ShipDate field to show the current date and time, you can set this in the table as the default for that field. A good idea, as if you ever append any records, access will put in the current date and time for you. Usually if you set the default value of a date/time text box for a form, that data is saved back to the table. How are you setting the default value in the form? Jeanette Cunningham "Tony" wrote in message ... I created a Ship Date field in a Table, created form using the ship date field, wanted the field to display current date using date (), but the date does not save back to the table. Thanks for the help |
#3
|
|||
|
|||
Can't get date to save in table..........
Tony wrote:
I created a Ship Date field in a Table, created form using the ship date field, wanted the field to display current date using date (), but the date does not save back to the table. Thanks for the help =Date() needs to be in teh DefaultValue property. Sound slike you used it in the ControlSource. That is where you should have the name of your field. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#4
|
|||
|
|||
Can't get date to save in table..........
In the table the Data Type is Date/Time
The format of the Text Box is General Date........ I can get todays date to show up in the Form when I click on it but it does not want to save the date field to the table. This is got to be easy but I am missing something. Thanks for your help and patience "Jeanette Cunningham" wrote: Tony, If you always want the ShipDate field to show the current date and time, you can set this in the table as the default for that field. A good idea, as if you ever append any records, access will put in the current date and time for you. Usually if you set the default value of a date/time text box for a form, that data is saved back to the table. How are you setting the default value in the form? Jeanette Cunningham "Tony" wrote in message ... I created a Ship Date field in a Table, created form using the ship date field, wanted the field to display current date using date (), but the date does not save back to the table. Thanks for the help |
#5
|
|||
|
|||
Can't get date to save in table..........
Should that be in the table or the Form?
Thanks Rick "Rick Brandt" wrote: Tony wrote: I created a Ship Date field in a Table, created form using the ship date field, wanted the field to display current date using date (), but the date does not save back to the table. Thanks for the help =Date() needs to be in teh DefaultValue property. Sound slike you used it in the ControlSource. That is where you should have the name of your field. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#6
|
|||
|
|||
Can't get date to save in table..........
It would be the same for either the table or form.
As mentioned before, if you do it in the table, you don't have to worry about doing it in any forms that are based on that table. Jeanette Cunningham "Tony" wrote in message ... Should that be in the table or the Form? Thanks Rick "Rick Brandt" wrote: Tony wrote: I created a Ship Date field in a Table, created form using the ship date field, wanted the field to display current date using date (), but the date does not save back to the table. Thanks for the help =Date() needs to be in teh DefaultValue property. Sound slike you used it in the ControlSource. That is where you should have the name of your field. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#7
|
|||
|
|||
Can't get date to save in table..........
Thanks for the help, I put it in the table and everything works great.
Thanks for the help. Tony "Jeanette Cunningham" wrote: It would be the same for either the table or form. As mentioned before, if you do it in the table, you don't have to worry about doing it in any forms that are based on that table. Jeanette Cunningham "Tony" wrote in message ... Should that be in the table or the Form? Thanks Rick "Rick Brandt" wrote: Tony wrote: I created a Ship Date field in a Table, created form using the ship date field, wanted the field to display current date using date (), but the date does not save back to the table. Thanks for the help =Date() needs to be in teh DefaultValue property. Sound slike you used it in the ControlSource. That is where you should have the name of your field. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|