You can use JavaScript to pass from one form to another
See
http://irt.org/script/692.htm
--
| Ok, cool, I will review these pages.
|
| I am aware of that Excel is used for single users. Fortunately this database
| is only accessed for viewing.
|
| Is there a way to link the textbox in the 2 forms so that the end users only
| have to enter the value once?
|
|
| Thanks for your response
|
| "Stefan B Rusynko" wrote:
|
| > You will need to hand code the ASP code and not rely on the DBRW to do what you want
| > (and yes ASP can be coded to write to a .csv)
| >
| > FYI
| > Excel is for single users, and running it as a DB can cause locking problems w/ multiple users
| > And writing to a csv give you less flexibility for using the data
| > (ASP can generate a csv extract from Access)
| >
| > Why not just create an Access DB (file import the Excel worksheet in a Access DB) for the source query and also write to it in a
| > different table for your register
| > (if you are going to rely on the DBR or DBIW you will need 2 forms - 1 query, one update)
| >
| > For some simple examples of hand codes ASP see
http://www.asp101.com/samples/
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | The ASP code is generated by the Frontpage 2003 Database Result Wizard. It
| > | automatically generates a submit button and textbox which retrieves data from
| > | an excelsheet.
| > |
| > | After that I added another submit button which has to submit the same value
| > | that was entered to a csv file.
| > |
| > | I don't know if your able to open the following image... but here is a
| > | screenshot of our internal website:
| > |
http://forums.aspfree.com/attachment.php?attachmentid=2706
| > | featuring the tool im working on.
| > |
| > | Now, I've come to the point that I realized that ASP cannot send values to a
| > | csv file. Is that true?
| > |
| > |
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Both links have working samples
| > | >
| > | > What did you do in your asp code and form?
| > | >
| > | > Did you use 2 submit buttons and set different values for each,
| > | > then check for those values on your ASP processing page to decide which DB to open?
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > | Could you please give me a working sample? Because the sites you provided me
| > | > | did not gave the answers I needed to.
| > | > |
| > | > | It would be much appreciated!
| > | > |
| > | > | The sites you posted
| > | > |
| > | > | "Stefan B Rusynko" wrote:
| > | > |
| > | > | > For deciding which button was pressed w/ ASP see
| > | > | >
http://www.aspfaq.com/show.asp?id=2242
| > | > | > For understanding multiple submit buttons examples see
| > | > | >
http://ppewww.ph.gla.ac.uk/~flavell/www/trysub.html
| > | > | > (check for the value passed from the button value in the ASP processing code to decide which DB to write to
| > | > | > --
| > | > | >
| > | > | > _____________________________________________
| > | > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > | > To find the best Newsgroup for FrontPage support see:
| > | > | >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > | > _____________________________________________
| > | > | >
| > | > | >
| > | > | > | I'm using frontpage 2003 by the way..
| > | > | > |
| > | > | > | "DirkG" wrote:
| > | > | > |
| > | > | > | > Hi,
| > | > | > | >
| > | > | > | > I have an issue. I used the Frontpage Database Results Wizard to generate a
| > | > | > | > lookup tool in ASP with an Excel Database attached.
| > | > | > | >
| > | > | > | > People fill in a textbox and press submit. Results are shown. Now, I want to
| > | > | > | > have the following: Next to the Submit button is a Register button which
| > | > | > | > submits the value of the textbox to a different Database.
| > | > | > | >
| > | > | > | > I'm having trouble with writing the value to a database in ASP.
| > | > | > | > Does anyone know how this is done?
| > | > | > | >
| > | > | > | > Many thanks,
| > | > | > | > Dirk
| > | > | >
| > | > | >
| > | > | >
| > | >
| > | >
| > | >
| >
| >
| >
