ASP and MS Access forms

[Waks]

hi people,

i am creating a website for a cricket club that is connected to a database for retrival of information. i can retrive infor from the database but only through tables.. is there any way in which i can get the information but via the forms. i have created the forms in access but cannot get to view the whole form in web page. i am using ASP as the programming method.

any ideas on how to achieve this are most welcome.

thanks in advance
wakar

[JahShuWah]

from what i understand about Access.....forms are used only for the submittal of information. use reports to view results.

[zollodav]

are you just using asp with an access database or are you using MS ACCESS directly with the assistance of ASP........for instance are you making the forms in MS ACCESS and then converting them to be used for the web.......?

[Waks]

i have created the web pages with the extensions.asp and the page coding has asp coding within it. i have a small database that has forms and tables in it. some of the webpages link directly to the database so that information can be retrieved.

i have designed the forms in access and would like them to be displayed on the web page when the page is loaded.

hope this helps
waks

[JahShuWah]

waks:

sounds like you and i are trying to accomplish the same thing.

www.onlinecommentbox.com

i haven't figured it out just yet either. you'll need to make sure your server supports ASP pages.

[HackinCowboy]

You can do that much easier if you lose the forms. Just create text areas on your web page and then when a user submits the information store it to the database. Something like this:

If request("submit") <> "" Then
RS.addnew
RS("Date") = Now()
RS.update
Response.Redirect("myPage.asp")
End If

RS is your recordset. Date is the name of a field in the table.
Is this what you're trying to do basically?

[Waks]

the forms are not used for text input but for output... there is an example of the form that i have created and would like to display on the web page.

cheers waks.

PS hope that helps as i really like to have that page viewable on the web page

[MDB]

Get yourself a good HTML editor and use it in combination with the ASP. Converting the Access forms to web pages is a lot more trouble than its worth. You could quickly build a page very similar to the one you have linked in a short amount of time.

Getting the data straight from the tables using ASP is exactly what you want to be doing. Access wasn't written to be an HTML editor. As a database it should be ok for a few club members to use via the web.