 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Can'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 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 >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 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 > Tony, > If you always want the ShipDate field to show the current date and time, you [quoted text clipped - 14 lines] > > > > Thanks for the help > 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.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Should that be in the table or the Form? Thanks Rick > > 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 (), [quoted text clipped - 4 lines] > =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. 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 > Should that be in the table or the Form? > [quoted text clipped - 10 lines] >> in the ControlSource. That is where you should have the name of your >> field. Thanks for the help, I put it in the table and everything works great. Thanks for the help. Tony > 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 [quoted text clipped - 16 lines] > >> in the ControlSource. That is where you should have the name of your > >> field. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.