Search results

I receive a syntax error when trying to re-write old 2007 code used to export excel data to a word document the error is in the following line of code... DoCmd.TransferSpreadsheet([TransferType As AcDataTransfer Type = acExport],[SpreadsheetType As AcSpreadSheetType =...

Good afternoon, I am new to Microsoft 2016 and am trying to write a VBA code to duplicate a record and only specific fields to a new record with a new primary key number. The primary key is a field called ProjID. Currently, I know the VBA is incorrect because under my general modules, this is...