PDA

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



manilara
2014-05-30, 12:44 PM
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

AntonyPope1966
2015-08-16, 08:18 PM
How did you solved this problem?