[AccessD] OT-AVAYA Auto-Attendent

..or..

strSQL = "SELECT PayNo " & _
"FROM OurPersonnelTable " & 
WHERE  PayNo = '" & $KEY & "';"

I have put two single quotes within the string to delimit $Key.  Either this
or Stuart's posting should work

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: 30 June 2009 09:20
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OT-AVAYA Auto-Attendent

It;s looking for a PayNo which consists of the string "$Key"

build your string as:

strSQL = "SELECT PayNo " & _
"FROM OurPersonnelTable " & 
WHERE  PayNo = " & $KEY & ";"

-- 
Stuart

On 30 Jun 2009 at 7:56, Paul Hartland wrote:

> To all,
> 
> Sorry for the OT, but didn't know where to post this.  We have AVAYA
> telephone systems, and an auto-attendent manager (think it's called
> VoiceMail Pro Client).  Where we can setup a number, then the user gets
the
> pre-recorded messages, with options etc, bit like most auto-mated call
> centres.
> 
> I have a number, which when dialled will ask me for a payrol number, it
then
> repeats the payroll number.  I then open a coonection to our employees
> database, and have a simple select query like below :
> 
> SELECT PayNo
> FROM OurPersonnelTable
> WHERE  (PayNo = "$KEY") ;
> 
> The payroll number I am entering is a dummy one, which has a record setup
> for my details (PayNo 999999),  But the select for some reason is always
> failing.
> 
> Anyone had any experience of this, and could point me to reference
> sites/manuals etc
> 
> Thanks in advance for any help.
> 
> 
> 
> 
> -- 
> Paul Hartland
> paul.hartland at googlemail.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com