Re: Parameter Query

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 01/04/05


Date: Tue, 04 Jan 2005 21:50:25 +0100

On Tue, 4 Jan 2005 06:47:03 -0800, pjscott wrote:

>I'm using sql 2000 and Access 2002. I need to create a parameter query that
>would ask the following statement: "Enter the work order number".
>
>How would I do this in sql?

Hi Paul,

You can't, at least not in MS SQL Server. SQL Server is completely
non-interactive. You just submit a query and you get the results back.

I believe that you can do it in Access 2002, but you'd have to ask in an
Access group.

Best, Hugo

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)


Relevant Pages

  • Re: Run an Access macro__
    ... Yep, I don't think it is particularly good idea, and an Access group ... threads, using the command line and object automation, so maybe you ... DTS - http://www.sqldts.com ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: MS GRAPH, PASSING PARAMETERS, ACCESS PROJECT
    ... You probably will have a better chance to get a good answer if posting to an Access group. ... a SQL Server group.) ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Why sql Server automatically change my input value.
    ... this to Access group to see if there is something wrong with the client app. ... wrong with the trigger codes. ... interact with sql server. ... It only store the first 100 something characters right. ...
    (microsoft.public.sqlserver.programming)
  • Re: Moving data from Access to SQL Server
    ... How does this involve DTS? ... You may want to try posting to a VB And/Or Access group instead ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Replicate SQL Server to Access using JRO
    ... it is related to SQL Server too...and access group is just as helpful ... >> Private Sub replicate(ByVal SQLConnection As String, ByVal JetConnection ...
    (microsoft.public.access.replication)

Loading