Find Record Command Box

[KarenLouise]

I am new to data page design for the web. I want to have the user put in an
id number and the attached database will find their record. I have been
trying to use the toolbox command wizard but it doesn't seem to have a
function for find a record. Is there an easy way to do this? I tried to
follow help, but the command properties does not have an onclick property and
when I go into code, I can't get the sample code given in help to work

 

[Tim Ferguson]

I am new to data page design for the web. I want to have the user put
in an id number and the attached database will find their record.

This newsgroup is meant to be about tables and database design. I am not
clear what technology you are using to construct your web pages (asp, cold
fusion, frontpage, etc etc) but you would do better to ask your question in
a group dedicated to it instead.

The most general answer would be to use the button click event to construct
a SELECT query using the required ID Number, and reposting the page using
the data from the returned recordset. The details, however, are up to you.

Best wishes


Tim F

 

[KarenLouise]

I am using Access and in particular, am trying to design a page to be
published to the web. I posted from the Access database design window. I
don't find a listing for pages so don't understand why this is not the
correct forum to post from.

I have created a control button on the design page and am using the script
editor to enter the following script:

<SCRIPT language=vbscript event=onclick for=btnFind>
<!--

Dim rs
Set rs = MSODSC.DataPages(0).Recordset.Clone
Rs.find([CNO]=(InputBox("Please enter C Number to find", "Find")))
MSODSC.DataPages(0).Recordset.Bookmark = rs.Bookmark
-->
</SCRIPT>


CNO is the field name in my table where I want to locate the users C number.
It is a text field.

I have named the control btnFind and believe I have entered the code into
the proper location.

It returns an error message "Arguments are of wrong type, are out of
acceptable range or are in conflict with one another".

I am trying to adapt the code from the help site Microsoft Office
Assistance:Adding custom filtering and search to a page in Access. I have
simplifed the code as much as possible till I get it to run, then I can add
the error handling back in.

Can you help me fix the code or is there a better way to perhaps use a pop
up window much like other web sites use to enter userid to enter a
controlled site backed by a data base.

KarenLouise

 

[Tim Ferguson]

Can you help me fix the code

Not really: I've never used data access pages (which is what I presume
this is) and the overall impression I've recieved from these groups is
that it's a pretty useless technology. There's another group called
microsoft.public.access.dataacess.pages which would probably suit your
purposes better.

or is there a better way

If I were going to distribute a database over the www or even an intranet
web, then I'd use a normal webserver/html setup. Microsoft IIS (free with
windows) uses ASP, most generic webservers will allow perl or php, etc
etc. None of it is going to be straight out of the box, though: you have
a significant amount of learning to do.

Hope that helps

Tim F