How can I run a query

L

los7883

New Member
I am setting up a website to use at work and i am trying to figure out a way to set up a form on the website that once a value is entered on the web form and a button is pressed or the tab button hit, it will run a query on an access database and return the value for that object. For instance...

the access database has area codes as well as the different servers the area code is homed off of, on the website i want to be able to enter the area code and hit GO and it return the name of the server it is homed off of. I have something set up in Excel (VBA) that does this for me but i wanted to move it to HTML or something...any advise?
 
html is not going to give you that functionality, your going to need to run something like asp, php, perl cgi, and so.
Your running an access database so the web server is running windows? or is there a dedicated db server?
 
what would be the easiest to pick up? I did a search on ASP and it had a sample code to put on your computer to see if your system would be compatible with asp or something like that (HTML goodies had a tutorial on asp that walked you through setting it up) and mine was not able to open up any file with the .asp extension...what exactly is php and how hard is it to learn?
 
You must log in or register to reply here.
Back
Top