Maixzkqxmgiqu
New Member
Long time Lurker... Short story long: I'm building some on-the-fly spreadsheets with asp classic and MS SQL. I'll simplfy this to the basics since my issue isn't in creating the spreadsheets or building the forms. The issue is what happens AFTER the spreadsheets are created.User specifies the variables, order by vars, display type (radio buttons, check boxes, text areas, drop downs, javascript form checking, and all that jazz) .Submission goes to an assembly asp classic page, grabs stuff out of the database, then EITHER displays to screen OR uses AddHeader (both using various include files/SQL views) to bodge it all into an excel spreadsheet and ship the file off to the user.ISSUE: When the spreadsheet option is specified, the user experience is to have the form (with all of their choices) remain in the browser. After opening (or saving) the spreadsheet file - the user returns to their browser to find the form as exactly they left it.NOT A PROBLEM for me... but the client??? Loves how everything works EXCEPT they want the form reset to the starting position.I have looked at (and tried over the past 10 hours) just about everything (from javascript pop-under windows to response.redirects) and I am STUCK on where to intervene in this process. The client does NOT want the html reports to open in a new window and doesn't want a separate form-set for screen viewing vs spreadsheets. So I am kind of limited in approach.So somehow I need to find a way to determine that the spreadsheet has completed or the form has been submitted in spreadsheet mode and then refresh the page the form is on.... sigh.Ideas????? Clues???