I have an existing ms access table.
I want to use VBA to append a new field (column) with the DataType as short text. I want to assign the value of the field in the format of "YYYYMMDDhhss" where YYYY is the year which is determined by a date in another column, MM is the month determined by the month in another column, DD is the date determined by a date in another column. The date format for that column is DD/MM/YYYY.
The hh is the hours, the ss is the seconds. these can be assigned values of 01 and 01 respectively.
Kindly assist with the appropriate VBA Code.