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

[johnexcel]

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

[ranman256]

Have a cbo box on the form that has your selections:
Dispatchcalls,ClosedCalls,Cancelcalls

This combo list is pulled from a config table with 2 columns, 1 the item in the pick list, and 2 the query to run.
[pick] , [qry]
Cancelcalls, qsCancelCalls
ClosedCalls, qsClosed
etc..

the cbo box value =col 2 (the query)
when the user picks the item in the combo, it runs the query (in fld 2)

[rpeare]

OnsiteDCC.zip

Note the slight change to the table list1

[johnexcel]

Sir Pick the date in textbox0 & textbox2 value not retrieve exact dates. like
I
i pick the date 01-may-2014 & 02-may-2014 but it not extract data but if reverse date format like 05-Jan-2014 it works..