Re: Using Parameter Query to restrict data
From: d (anonymous_at_discussions.microsoft.com)
Date: 04/01/04
- Previous message: James: "Drop Down Lists"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Apr 2004 01:11:13 -0800
----- Sylvain Lafontaine wrote: -----
Parameters are to be used with Stored Procedures (SP). For tables, you must
use Server filters:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_customfilteringandsearching.asp
S. L.
"Calum_Polwart-nospam@bigfoot.com" <calum_polwart@bigfoot.com> wrote in
message news:5f14eec1.0403271229.6145f387@posting.google.com...
> Am realatively new to DAP's but have some limitted expereience of
> Access.
>> I want to pass some data from a login screen to a database. I've
> managed to set-up the login screen to pass the information into a
> Cookie, and then the next page is able to pick that information out of
> the cookie.
>> I am left with a variable called pUsername which i then want to use to
> query a database to ONLY show the record with the field [UserID] equal
> to pUsername from the Access Table called [Users]. I've tried to
> follow the Online Help example (where I got the suggestion of the
> cookie) but am now stuck because it shows all the data...
>> MSODSC.RecordsetDefs("Users").parametervalues.Add "[UserID]=",
> pUsername
>> I've tried it with and without the equals sign, makes no difference...
> ...I don't actually understand what the above line does!!
>> I want to only see the current user so that they can update their
> information but NOT change other people's information? Does that make
> sense...
>> Calum
- Previous message: James: "Drop Down Lists"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
