Ms access Save Data to xl depends upon 1 table pick & Depends 2 Upon fiterDate vba

manilara

New member
Joined
Nov 5, 2011
Messages
10
Reaction score
0
Points
0
Location
sydney
Excel Version(s)
2019
Ms access Save Data to xl depends upon 1 table pick & Depends 2 Upon fiterDate vba

Dear Experts


I need vba help on Msaccess form Cmd button retrive data from Start & End date depends upon of Tabular column


I have set of 3 Table column named Dispatch,Closed,Cancel & One Form


condition is
If Select Dispatchcalls Filter Date col is = "Order Relase Date". Col No 26
If Select ClosedCalls Fitler Date Col is = "ClosedDate". Col No 48
If Select Cancelcalls Filter Date Col is = "ClosedDate". Col No 38


Save
1.If DispatchCalls select in table List and Filter Date in Start&End ..Retrive Data from Table DispatchCalls depends upon OrderrelaseDatecol... Savefile as Dispatch
2.If ClosedCalls select in table List and Filter Date in Start&End ..Retrive Data from Table ClosedCalls depends upon ClosedDatecol... Savefile as Closed 3.If CancelCalls select in table List and Filter Date in Start&End ..Retrive Data from Table CancelCalls depends upon ClosedDatecol...savefile as Cancel


Find the attachment
 

Attachments

  • OnsiteDCC.zip
    170.6 KB · Views: 26
Back
Top