asp and access forms

[edgarv]

Is there a way to go a specific record in a ms access form?
how would I go about doing that?

By this I mean: If I have a web form generated from access 2000 and I have about 1200 records. Could I put a link on another page for example put a link "375" and when you click on it it would go to the web form generated from access and show me record 375?


any help is greately appreciated
thank you

 

[edgarv]

Did I post my question in the wrong place?

 

[Sheco]

Maybe. What do you mean you "have a web form generated from access 2000" ???

Did you write a ASP script that reads an access database and builds HTML that displayes the data one record at a time?

Or is this some kind of wizard thing inside Access that lets you auto-magically make a web page?

 

[edgarv]

It is a wizzard kind of thing, (you can also do it in desing view) thisis to build webpages from your tables

 

[Sheco]

Did it make a file with a .ASP extension?

 

[edgarv]

no, it made a file with htm extension

 

[Sheco]

Since it is .htm then the wizard gave you a static HTML page with a copy of the data.

However, you can make your own dynamic pages using ASP, PHP, Perl, or other server side scripting technologies.

ASP will be the easiest technology to master if you already know how to program in VB/VBA/VBScript and your target web server is Microsoft IIS.

 

[edgarv]

ok I got it.

I am not too familiar with any of those languages, still learing asp though.
Following your advice,
I created an asp document that shows me all the data I need to see. everything looks good. I created it with Dream Weaver.
The problem now is that I can only see the first record.

Is there a way to see the rest? or do I have to create a page for each one?

 

[Sheco]

I'm not sure about the code generated by Dream Weaver but I assume it uses ADO to connect to and display values from the database.

Some questions:
* How many records are in this table?
* Will new records be added to the table?
* Do you want to display only 1 record per page or have pages more like a search engine where it shows 10 or 20 and then has links at the bottom to navigate through all the records?
* How are you sorting the records?

 

[edgarv]

Let me show you the form. you can see it at

http://daviesmolding.com/aqpc/daviesaqpc.htm

this the html version, that access made. My ASP version has the same fields and the same layout.

I really appreciate the help

 

[edgarv]

Oh sorry forgot to answer the rest of the questions
yes, there will be more recorda added,
It would be ideal to display just one record at the time and a link to the next record.
the records are stored in an access db

the link that I sent is for the form the view is exactly as the form, it only shows the records