I am trying to copy a table, appending the date to the destination table name in VB code.
However I get a Type Mismatch error.
Here's the troublesome code:
Dim MyDay, MyMonth, MyYear, MyDate, MyNewTable As String
MyDay = Format(Date, "dd")
MyMonth = Format(Date, "mm")
MyYear =...