Re: Find Record Command Box

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" wrote:

> "=?Utf-8?B?S2FyZW5Mb3Vpc2U=?=" <KarenLouise@xxxxxxxxxxxxxxxxxxxxxxxxx>
> wrote in news:C6710D16-01D9-462C-92D2-F5D2F0F9DDF5@xxxxxxxxxxxxx:
>
> > 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
>
>
.