C
CharlesBanks
I am attempting to use the Source Property to connect to text files that are
contained in dated subfolders. Currently I have a ActiveX control that places
a date in a table. I would like to take that date and add it to the FROM
clause in my related Qry.
For Example - Date = 11/16/2004
Select EMP.FirstName
FROM EMP IN '\\ServerName\Data\20041116' [dBASE IV;]
When the user selects a different date (11/17/2004)
I would like my Qry updated to be:
Select EMP.FirstName
FROM EMP IN '\\ServerName\Data\20041117' [dBASE IV;]
Any suggestions would be greatly appreciated.
contained in dated subfolders. Currently I have a ActiveX control that places
a date in a table. I would like to take that date and add it to the FROM
clause in my related Qry.
For Example - Date = 11/16/2004
Select EMP.FirstName
FROM EMP IN '\\ServerName\Data\20041116' [dBASE IV;]
When the user selects a different date (11/17/2004)
I would like my Qry updated to be:
Select EMP.FirstName
FROM EMP IN '\\ServerName\Data\20041117' [dBASE IV;]
Any suggestions would be greatly appreciated.