manilara
New member
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
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