Recent content by tlgallen

Thank you The_Doc_Man. I also appreciate your three time certification. This code is a mess. Quite simply, the full code is below and it is supposed to: 1. Execute a specific query and export the data to an Excel spreadsheet called "WDExcel; 2. The data then is supposed to go to a WordMerge...

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 =...

Thank you for the valued guidance. UK access programmers are the BEST. You have both provided me several workable options to resolve the duplicate record issue in my public function

Thank You June7, I did find the following original general module which works as a public function, but it duplicates all fields instead of specific fields. It does currently work, I just need to copy the fields EmployeeNo, ProjType, ProjDesc, Time, DueDate, Prog, Mod, Improve, WorkPlan...

Thank you Vlad and June 7. Executing the SQL statement from the VBA sounds like the solution. Why do you think a General Module for Duping a Project Record was possibly created? I noticed throughout our database, on several forms, there is VBA code which calls up the Public Function Dupe...

Thank you Vlad for the quick reply. How would I create a query in VBA? The form is called PreProj, the table is called "Project". The fields to copy to a new record are "Employeeno", "Projtype", etc". The form currently has the VBA I previously posted which sounds like I should delete all the...

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...