Parameter Query

[John Bixtis]

Hi,

It may seem trivial to most of you but I can't make it work.

I have an Access 2003 project looking data on SQL Server 2000.

I want to create something like a parameter query in Access, so that I can
enter data and the Server will bring back the relevant records. I don't see
any way to make this work.

Can somebody help me please?

Many Thanks,
John

 

[Vadim Rapp]

Hello John,
You wrote in conference microsoft.public.access.adp.sqlserver on Mon, 4 Jul
2005 15:44:42 +0100:

JB> I have an Access 2003 project looking data on SQL Server 2000.

JB> I want to create something like a parameter query in Access, so that I
JB> can enter data and the Server will bring back the relevant records. I
JB> don't see any way to make this work.

Create a stored procedure with parameters.

Vadim Rapp

 

[aaron.kempf]

more importantly

that fucking POS company won't document this as thoroughly as is
needed.

you make a sproc with parameters; and pretend you have a parameter
named @PLU

you then have a control named PLU on your form and report.. and ADP
will automagically fill the @PLU parameter with the value of the
textbox named PLU.

where this is really helpful is to bind a textbox to a vba function

-aaron