ms access to html web pages

[lmRDN]

I am currently studying towards an HNC in computers, our latest assignment has asked us to create an access database and form and then link it into an already created html site. The idea is to create a dynamic web page. So far I have been unable to actually get the form to function this way - Am i doing something wrong or have I been asked to do the impossible???

[OBonio]

You need to be running a web server (IIS on windows, Apache on Linux) and use something like ASP.NET, ASP (both windows based) or PHP (windows and Linux based) to put the data into Access. If using Access, I guess you're using Windows. On Win2k and XP, you can install IIS locally and use a URL such as http://localhost/ to get ASP working.

Here's a tutorial :

http://www.webwizguide.info/asp/tutorials/default.asp

[stevie21]

Access database *and form* ? You mean that the form is on the webpage or in access? (I'm hoping its the former).

If you're happy to copy and paste and then make small amendments to existing code then it's spectacularly easy to have a webpage read info from a database.
By amending a few lines you can also have the page read info from a user (in an online form) and insert this into a database.

[OBonio]

Good point Stevie21. There are 2 types of forms we are talking about here. Access forms and HTML forms. HTML forms are used to get data into databases from websites.

[lmRDN]

The forms i am talking about are the forms compiled in access - if there are buttons created within access they don't function when opened within the website.  So how do I get the form to send the data either to the database or via email?  I just don't get it....

[OBonio]

Forms in Access won't display in a website. I'm 99% certain that they are talking about creating an HTML form.

Have a look at that tutorial above, it really is quite simple.

[stevie21]

If it wasn't part of a course that gives you a qualification I'd be tempted just to give you the answer but if you're going to get a bit of paper at the end of it you really should learn something and produce this work yourself.

To be *really* blunt (and annoyingly pragmatic), if you aren't capable of figuring this out then you don't deserve the HNC. Once you've figured it out you'll be surprised that you were ever stuck on it.

[lmRDN]

Thank you to everyone who gave me a reply - Stevie I am sorry but the course I have been studying has not taught us from day one, we all have struggled for the past two years and this is the first time i have posted a question in relation to my course - I am under pressure as the criteria was changed 1 week prior to hand in, i am studying for an exam a week after the handin date and i also work full time - so I apologise for asking for a little bit of help. And i did figure it out myself, I sat from 7.30 this morning working on it and I have mastered it - so thanks.

[stevie21]

Sorry for my earlier bluntness but especially for all things internet related there are literally thousands of tutorials online already. In fact, there are websites which give examples of code and effectively do the work for you.

I do know how difficult these things can be and am no stranger to being thrown in at the deep end and just expected to know this stuff but I when I had to learn this I was at uni from 9-5, work 6-11pm and would then do a few hours work at home until the early hours most days until I got my uni work done.
Maybe I just assumed you were being lazy minded and wanted someone to do your work for you so apologies if I was.