Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 27th, 2007, 06:31 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default Invalid bracketing of name

Help

Can someone please tell me why I'm getting this error?
Why am I getting this error message?

Invalid bracketing of name

This is what I have:

Site_ID: IIf([BILL_CODES]="*LAM*","symanlam",IIf([MESSAGE_NOTES]="*LAM*","symanlam",([qry_Symantec_email_Circ_A2_3.Site_ID])))


Thanks
Corey

 
Old February 27th, 2007, 06:50 PM
Registered User
 
Join Date: Oct 2006
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Corey

I suggest that you write the string as below. This will work

Site_ID: IIf([BILL_CODES]="*LAM*","symanlam",IIf([MESSAGE_NOTES]="*LAM*","symanlam",([qry_Symantec_email_Circ_A2_3]![Site_ID])))

In this case it prefers to have the name of the query and field name separated by square brackets (Highlighted in red) with an exclamation point in between to identify the difference of the name and field

HTH

Martin



 
Old February 28th, 2007, 10:08 AM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default

Martin,

That didn’t seem to work with, I didn’t get any error, but when I try to run it, it gives me the “Enter Parameter Value” box asking for “qry_Symantec_email_Circ_A2_3!Site_ID”
I also tried
Site_ID: If([BILL_CODES]="*LAM*","symanlam",IIf([MESSAGE_NOTES]="*LAM*","symanlam",([qry_Symantec_email_Circ_A2_3].[Site_ID])))

That didn’t work either.

Any ideas?

Corey


 
Old February 28th, 2007, 07:39 PM
Registered User
 
Join Date: Oct 2006
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Corey

I know this sounds a silly question, but I presume you have the query [qry_Symantec_email_Circ_A2_3] within the query you are trying to write here and that you have joined it to the respective field in the table.

The reason I ask is, that the problem you are getting is a normal response when Access cannot find the field in the table/query.

Let me know and we will take it from there

Martin






Similar Threads
Thread Thread Starter Forum Replies Last Post
invalid syntax near ")" charleshuff2002 ADO.NET 1 March 8th, 2007 03:21 PM
Help with Invalid bracketing of name Corey Access VBA 1 February 18th, 2006 06:13 AM
Invalid parameter name: {0} gozfidan Crystal Reports 0 December 7th, 2005 05:58 PM
Invalid object name Syed Naveed Khursheed BOOK: Beginning ASP 3.0 8 November 20th, 2004 01:42 AM
Invalid bracketing sasidhar79 SQL Language 1 July 13th, 2004 07:31 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.