General MS Access Help

[Growler]

Hello,

I've been asked to build a database that takes user-inputted data off of a Space Request webform and stores it in the database I've built. Do you know how I can automate this process? Do I need to embed some sort of VB macro in the form? How do I even start?

For example,
The user will enter data in fields for name, administrative unit, reason for request, check a checkbox... and all this data needs to be automatically stored in a database when the user clicks submit.

I'm assuming I:
1st) build a database in MS Access to include all possible fields
2nd) build the webform
3rd) Link the database to the webform (which I have no idea how to do)

Any help would be amazing.

Thanks

 

[pbaldy]

Unless you're using the new 2010 version of Access with Sharepoint, your question is more of a web programming question than an Access question. You would need to be using ASP, PHP, etc to push the data into Access. I've done it with ASP, but I know there are other ways.