How do I code Access Style Nav bar in ASP?

[chdavisjr]

I have searched, and read the FAQs and am not sure which is the proper forum for this question.
I can write Web pages in ASP/VBScrip that open Access databases in datasheet view and page, edit, add, delete, etc.

However, the users on our Intranet want us to design our Publications page so that it looks like a form in Access 2000. (Using Access Page option isn't a choice.)

I need to write the form so that it opens the first record, and has buttons for First, Last, Next, Previous, New, Delete.

Can some one point me to a tutorial page or any other site that has examples on how to do this?

Most sincerely,
Chalmers

 

[adroit]

Hi ,

You can do all this using ASP/VB Script. You just to have all these options on a one very well designed HTML form.
All the buttons you will be having there submit the page to a common process page where you can select the user action type using the SELECT CASE for the Submit Button.
For Record Navigation you have to use pagging with the recordset pagesize 1 .

 

[onpnt]

I would say about the only way you are going to take the looks of a access form is the use of style sheets.

something like

http://www.microsoft.com/mind/0299/forms/forms.asp

_________________________________________________________
_{$str = "sleep is good for you. sleep gives you the energy you need to function";
$Nstr = ereg_replace("sleep","coffee",$str); echo $Nstr;}

http://www.onpntwebdesigns.com

[/sub]

 

[chdavisjr]

Thank you, adroit and onpnt, but as I said I do know ASP and VBScript, but am having trouble showing the database 1 record at a time. I can make a form look like access without style sheets .. that is not the problem!

I can do all the editing and deleting, sorting, etc, etc when I have all the records on the screen like a datatable and have populated the table rows with a loop thru the recordsets.

I saw over a year ago, an example on some Access related web site exactly how to do this.

The ASP/VBScript (or maybe it was javascript?) code would open up the records one recordset at a time, in an ASP Form built similar in looks to an Access form, and then you had the buttons below to go to first, last, next, previous records,and a button to add a new record or to delete the current record, etc.

The code when you clicked the buttons had the movenext, movefirst, movelast recordset commands, etc.

If you were on the first record, the previous button was disabled.

If you were on the last record, the next button was disabled.

I am just having trouble putting it all together!

I hope this helps explain what I am looking for!

 

[onpnt]

alrighty, that's much easier then the style sheet
all you need to do is set a paging script to one pagecount and manipulate the way the rs populates the screen so they appear in the form correctly. search for paging pagecount etc.. ASP

some links to look at
faq333-3229

http://www.stardeveloper.com/articles/thread.html?tid=423

http://www.devasp.com/search/default.asp?c_id=52

http://www.4guysfromrolla.com/webtech/062899-1.shtml

http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_20247512.html

still think making it look like the form is harder


_________________________________________________________
_{$str = "sleep is good for you. sleep gives you the energy you need to function";
$Nstr = ereg_replace("sleep","coffee",$str); echo $Nstr;}

http://www.onpntwebdesigns.com

[/sub]