If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find Record Command Box
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 -- KarenLouise |
#2
|
|||
|
|||
"=?Utf-8?B?S2FyZW5Mb3Vpc2U=?="
wrote in : 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 |
#3
|
|||
|
|||
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=?=" wrote in : 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 |
#4
|
|||
|
|||
"=?Utf-8?B?S2FyZW5Mb3Vpc2U=?="
wrote in : 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
copy value of field to find a record in another form | Caroline | Using Forms | 8 | March 2nd, 2005 02:03 AM |
Find Record | Ben | Using Forms | 1 | November 1st, 2004 12:41 AM |
Best way to find corrupted record? | Bill Mitchell | Using Forms | 4 | August 9th, 2004 09:51 PM |
Find Record in Subform | Katherine R | General Discussion | 7 | June 26th, 2004 03:22 PM |