Excel Workbook created from Access VBA
I need some help. I have created a form in Access that queries on a persons last name and sends all the info on the last name to an Excel spreadsheet. I want to send multiple people's data to the worksheet---but when i try to do this, I only get 1 person's data at a time in the worksheet. The data of the person before gets over-written. Here is what I have:
glb_Strsql = "SELECT * from DR_SEARCH_TABLE_Mar WHERE last_name= '" & DrName & "' AND FIRST='" & lstFirst.Value & "' and st = '" & lstState.Value & "' and kenwood_territory = '" & lstTerritory.Value & "' "
Set qdf = CurrentDb.QueryDefs("glb_Strsql")
qdf.SQL = glb_Strsql
Filename:="C:\Documents and Settings\My Documents\My_Search.xls"
HasFieldNames = Yes
Any help would be greatly appreciated. Thanks!