navigate through database 1

[dashusa]

i have a database that contains the img paths to 13742 images and i made a page that uses the navigation control to navigate through the records and i have an input box that lets me add data about each image...the problem is that i need to be able to jump to a specific record instead of clicking the next button 6000 times
ANY IDEAS??

 

[Remou]

Do you want to jump a number of records, such as with
DoCmd.GoToRecord
Or do you wish to search for a record, as with the RecordSetClone?

 

[dashusa]

i suppose i could do both.... 1st prize would be an input box that collects a number from a user and then displays the image of that number .
Can i add DoCmd.GoToRecord to my record navigaion menu that i alredy have?

 

[Remou]

Sure, no problem. Just add something like:

intRec = InputBox "Enter record to go to:"
If intRec > 0 Then
  DoCmd.GoToRecord , , acGoTo, intRec
End If[code]
to a command button.
As for the search, you can create a pretty good goto with the ComboBox wizard by choosing 'find a record on my form'.
You can also use a recordset and findfirst.

 

[dashusa]

Thanks
i have a very limited knowledge of vb so let me explain what ive got so far ...
i have exported my page into html format so that remote users can log onto it and make changes so should i put the code that you made into my html?

 

[Remou]

Ok. This is something different altogether. I do not even know where to begin. I have a small database that is published to the web but I have used ASP and VBScript for searches and changes. Other people might recommend Data Access Pages. In fact you might get half a dozen different suggestions if you search for 'publish to the net / web' in the Access fora.
The notes I have made above all refer to an Access database and VBA, not to things that can be done with HTML.