Help ! Access, ASP, Excel 1

[rikmg]

I have a query if it's poss you could help ?

Iam in the process of building a small Intranet application. Iam using ASP along with access backend.

Info will be sent from an HTML form, [an inventory report] various drop down lists, text boxes, etc.

This info from the form is then added to the mdb, but an administrator needs to pull the same form back to add further info to complete the form, [cookies?] and finally it gets exported to excel format and saved on the server. Also an admin page needs setting up so "admin" can confirm when some reports are completed and when others need completing, maybe this could be the way the first part of the form could be stored and pulled back from ? Could it all be done in office applications ?

 

[rk1972]

YES, all Can be done.

First Try to Store all info into the Database.

Second, whenever someone logins as ADmin, give them option of editing the old forms, by passing some ID.

Third, Use ASP's File command to export and Save it in Excel file.

Hope it helps !

 

[rikmg]

thanx very much for this it helps alot !!


can you point me in the direction of the file cmd for ASP a tutorial of some sort ?

Cheers.

 

[Veep]

http://www.asp101.com/

http://www.w3schools.com/default.asp

http://www.4guysfromrolla.com/

http://www.aspfaq.com/default.asp

http://www.learnasp.com/learnasp/