Beginner, trying to load external data between two dates specified via userform

Hi all, i am new to this site and have heard great things.

i feel i might have been thrown in the deep end of visual basic and would appreciate any help or just to know weather i am in the right direction.

I have an external database file which i created a macro to access which offers me a box to enter two dates, >= date x and <=date z. I need to replace these dates with inputted dates via input boxes on a userform which loads on excel open. Difficult?

What ive got.

--------------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

I have tried replacing the two current dates with things like TBStartDates.value and TBEndDates.value??

or heading along the lines of

Criteria1:=">=" & Format(Me.TBStartDates.Value, "mm/dd/yy"), Operator:=xlAnd, _
Criteria2:="<" & Format(Me.TBEndDates.Value, "mm/dd/yy")

but i am clueless and close to giving up.

thanks

Rob

Thanks David much appreciated, Still not quite there i have hit a run time error 438 meaning i haven't defined something? Which strikes me as weird being the macro worked before i added the input boxes which i believed i defined.

Thanks Chippy

Did you mean replace the CommandText array with the SQL String? like so..

Please Login or Register  to view this content.

I still haven't got the dates to load correctly, a table is created in excel but just say "getting external data" but never loads. i am also coming across problems with the .Refresh BackgroundQuery:=False code can you shed any light on this?