Updating date field
Mail merge is a useful tool to create a set of documents that are essentially the same but where each documents contain unique elements.
However, when we merge some mails, we should pay more attention to the format of date, currency and number.
Or, perhaps you want to insert a date in Excel that will update automatically and always display the current date and time?
Or, maybe you want to auto fill weekdays or input random dates in your worksheet?
You may be familiar to view multiple webpages in Firefox/Chrome/IE, and switch between them by clicking corresponding tabs easily.
Here, Office Tab supports similar processing, which allow you to browse multiple Word documents or Excel workbooks in one Word window or Excel window, and easily switch between them by clicking their tabs.
Function Update Transaction Date() As Boolean Dim db As Database Dim LUpdate As String Dim LMsg As String Dim LTransaction Dt As Date On Error Go To Err_Execute 'Query user for Date of R LMsg = "Enter the Date of R Form __/__/____" LMsg = LMsg & Chr(10) & Chr(10) & "Format date as: mm/dd/yyyy" LTransaction Dt = Input Box(LMsg) Set db = Current Db() 'Re-Assign Date to Transaction Date LUpdate = "update [Chapter Form Bulk Input Table]" LUpdate = LUpdate & " set [Transaction Date] = #" & Format(LTransaction Dt, "mm/dd/yyyy") & "#" db.
Would you like to answer one of these unanswered questions instead?
In Microsoft Access 2003/XP/2000/97, I have a database which contains a date field called Transaction Date.
If you omit the WHERE clause, all records in the table will be updated!
The WHERE clause specifies which record(s) that should be updated.