MS ACCESS 2010 Return Table Created Date to Form Test Box
Posted on 2013-06-26
Looking to get the Microsoft Access 2010 table created date/time to show up on a form in a textbox or label (don't which is best).
Display the Created Date for a table, "tmp_New_Items", on a form, "frm_New_Items", in a Textbox or Label.
1. Wrote the following function that works, now I need to get the results pushed to my form.
Public Function GetTableCreateDate(CreatedDate)
CreateDate = CurrentDb.TableDefs("tmp_New_ITEMS").Properties("DateCreated")
2. Added Text Box to form and updated the Control Source to “GetTableCreateDate(CreatedDate)”
3. The Msgbox works… heee (We will remark that once working)
4. Do I need to setup and run a Macro? (I’m not familiar with how)
When New Products are Ready to be imported we conduct a Make Table Query that creates the tmp_New_Items table with no problems.