I have a Access table( "tblSchedule) with 3 fields named "Route" , "Planned Start" and "Planned End".
Data in the table like as:
Route Planned Start Planned End
A 12:00 14:00
B 13:00 16:00
C 16:00 18:00
I want to assign Planned Start to an excel worksheet.
I created a hidden form with the record source tblSchedule.
To assign the value of Route A to C to the excel worksheet write the VBA code as below:
wb_Target.Cells(2, 2) = Forms("Form1").Planned_Start(1)
wb_Target.Cells(3, 2) = Forms("Form1").Planned_Start(2)
wb_Target.Cells(4, 2) = Forms("Form1").Planned_Start(3)
I am getting "run time error 451.Property let procedure not defined and property get procedure did not return an object."
Would you please advise how to fix it or if other easy way to do. please provide example code.
Thanks in advance for your prompt response.