Sorry, I haven't explained myself very well.
I have a frames page with the frame on the left hand side of page listing hyperlinks to various reports listing staff names and details. When one of these links is clicked on, the appropriate report is generated using data from an Access database and displayed as an asp page on the right hand side of the frames page. On this asp page, above the list of names, there is a link that allows the user to download the names to an Excel file. This link runs an asp page, listed below:
<%@ Language=VBScript %
<% Response.Buffer = true
'open recordset to get staff names
set rs= server.CreateObject ("adodb.recordset")
rssql="SELECT * tblStaff WHERE tblbranch.branchid= " & request.querystring("param")
rscon=Application("staffconnect_connectionstring")
rs.Open rssql, rscon
'code to download
response.clear
Response.ContentType = "application/octet-stream"
Response.AddHeader "content-disposition", "attachment;filename=Staff_List.csv"
'print staff details
while not rs.eof
Response.Write Rs.Fields(0)
response.write " "
response.write rs.fields(1)
response.write (",")
response.write (chr(13)&chr(10))
rs.movenext
wend
rs.close
set rs=nothing
response.end
%>
When this has runs the excel file has been created and is ok, but now when i select a link from the left hand frame, the new report does not appear in the right hand frame. The links do work provided i don't download, the downloading seems to mess things up. I think the reports are being generated - there is network activity and there is a delay before the "Done" message appears in the status bar - but the report doesn't appear in the right hand frame! I hope this explains things a bit more - sorry if I haven't got all the technical terms correct!!
karen
