Hi,
I'm still on my quest to enter a file name for a file I will later output to my computer. This is my current test code (whithout the inputbox segment) -
Function CopyQuearytoSdriveFolder()
Dim MyValue As String
MyValue = "mm_dd_yyyyQTMsQuery.xls"
DoCmd.OutputTo "acOutputQuery", "Qualified TMs", "Microsoft Excel 97-2003 (*.xls)", "S:\Compensation\Urban Tax Credit\Access DB Data\From Access\XXX.xls", True
End Function
When I step through this though I get the Runtime Error '13': Type mismatch after running the DoCmd step.
I've made sure that the data in my query are all formatted as text, so I'm not sure where the mismatch is occurring. any help would be appreciated! thanks,
Paul G
I'm still on my quest to enter a file name for a file I will later output to my computer. This is my current test code (whithout the inputbox segment) -
Function CopyQuearytoSdriveFolder()
Dim MyValue As String
MyValue = "mm_dd_yyyyQTMsQuery.xls"
DoCmd.OutputTo "acOutputQuery", "Qualified TMs", "Microsoft Excel 97-2003 (*.xls)", "S:\Compensation\Urban Tax Credit\Access DB Data\From Access\XXX.xls", True
End Function
When I step through this though I get the Runtime Error '13': Type mismatch after running the DoCmd step.
I've made sure that the data in my query are all formatted as text, so I'm not sure where the mismatch is occurring. any help would be appreciated! thanks,
Paul G