|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 25th, 2004, 03:27 PM
|
|||
|
|||
"invalid bracketing of name" when referencing Query Parameter
In Access2003 I have a query that uses the start and stop date that it gets
from a form. In the query I have entered the fields in the Query Preference. Form - "frmSelector" start date field - [forms]![frmSelector]![txtStartDate] stop date field - [forms]![frmSelector]![txtStopDate] when I run the query I get a messagea message "invalid bracketing of name "[forms!frm_Selector!txtStartDate]"". But what I entered into Queries-Parameters was forms!frm_Selector!txtStartDate. When you save the query it adds the brackets. If I enter [forms]![frm_Selector]![txtStartDate]...I get "[[forms]![frm_Selector]![txtStartDate]]" Any suggestions? 
|
|
#2
October 25th, 2004, 03:34 PM
|
|||
|
|||
|
Fix it, save it, and hope it doesn't happen again. I'm not sure why it
happens but it is a bug. -- Duane Hookom MS Access MVP -- "GreggLund" wrote in message ... In Access2003 I have a query that uses the start and stop date that it gets from a form. In the query I have entered the fields in the Query Preference. Form - "frmSelector" start date field - [forms]![frmSelector]![txtStartDate] stop date field - [forms]![frmSelector]![txtStopDate] when I run the query I get a messagea message "invalid bracketing of name "[forms!frm_Selector!txtStartDate]"". But what I entered into Queries-Parameters was forms!frm_Selector!txtStartDate. When you save the query it adds the brackets. If I enter [forms]![frm_Selector]![txtStartDate]...I get "[[forms]![frm_Selector]![txtStartDate]]" Any suggestions?
|
|
#3
October 25th, 2004, 03:43 PM
|
|||
|
|||
|
Any suggestions for work around? I get this same problem not matter what I
put into the Query-Parameter Dialog. gregg "Duane Hookom" wrote: Fix it, save it, and hope it doesn't happen again. I'm not sure why it happens but it is a bug. -- Duane Hookom MS Access MVP -- "GreggLund" wrote in message ... In Access2003 I have a query that uses the start and stop date that it gets from a form. In the query I have entered the fields in the Query Preference. Form - "frmSelector" start date field - [forms]![frmSelector]![txtStartDate] stop date field - [forms]![frmSelector]![txtStopDate] when I run the query I get a messagea message "invalid bracketing of name "[forms!frm_Selector!txtStartDate]"". But what I entered into Queries-Parameters was forms!frm_Selector!txtStartDate. When you save the query it adds the brackets. If I enter [forms]![frm_Selector]![txtStartDate]...I get "[[forms]![frm_Selector]![txtStartDate]]" Any suggestions?
|
|
#4
October 25th, 2004, 05:38 PM
|
|||
|
|||
|
Did you view the SQL view and change it there?
-- Duane Hookom MS Access MVP -- "gregglund" wrote in message ... Any suggestions for work around? I get this same problem not matter what I put into the Query-Parameter Dialog. gregg "Duane Hookom" wrote: Fix it, save it, and hope it doesn't happen again. I'm not sure why it happens but it is a bug. -- Duane Hookom MS Access MVP -- "GreggLund" wrote in message ... In Access2003 I have a query that uses the start and stop date that it gets from a form. In the query I have entered the fields in the Query Preference. Form - "frmSelector" start date field - [forms]![frmSelector]![txtStartDate] stop date field - [forms]![frmSelector]![txtStopDate] when I run the query I get a messagea message "invalid bracketing of name "[forms!frm_Selector!txtStartDate]"". But what I entered into Queries-Parameters was forms!frm_Selector!txtStartDate. When you save the query it adds the brackets. If I enter [forms]![frm_Selector]![txtStartDate]...I get "[[forms]![frm_Selector]![txtStartDate]]" Any suggestions?
|
|
#5
October 25th, 2004, 06:05 PM
|
|||
|
|||
|
I saw an aswer you put for another questions and then went into SQL view and
edited it there...and it works. THANKS gregg "Duane Hookom" wrote: Did you view the SQL view and change it there? -- Duane Hookom MS Access MVP -- "gregglund" wrote in message ... Any suggestions for work around? I get this same problem not matter what I put into the Query-Parameter Dialog. gregg "Duane Hookom" wrote: Fix it, save it, and hope it doesn't happen again. I'm not sure why it happens but it is a bug. -- Duane Hookom MS Access MVP -- "GreggLund" wrote in message ... In Access2003 I have a query that uses the start and stop date that it gets from a form. In the query I have entered the fields in the Query Preference. Form - "frmSelector" start date field - [forms]![frmSelector]![txtStartDate] stop date field - [forms]![frmSelector]![txtStopDate] when I run the query I get a messagea message "invalid bracketing of name "[forms!frm_Selector!txtStartDate]"". But what I entered into Queries-Parameters was forms!frm_Selector!txtStartDate. When you save the query it adds the brackets. If I enter [forms]![frm_Selector]![txtStartDate]...I get "[[forms]![frm_Selector]![txtStartDate]]" Any suggestions?
|
|
#6
November 30th, 2006, 10:38 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"invalid bracketing of name" when referencing Query Parameter
Thank you! It worked for me too!!
"Duane Hookom" wrote: Did you view the SQL view and change it there? -- Duane Hookom MS Access MVP -- "gregglund" wrote in message ... Any suggestions for work around? I get this same problem not matter what I put into the Query-Parameter Dialog. gregg "Duane Hookom" wrote: Fix it, save it, and hope it doesn't happen again. I'm not sure why it happens but it is a bug. -- Duane Hookom MS Access MVP -- "GreggLund" wrote in message ... In Access2003 I have a query that uses the start and stop date that it gets from a form. In the query I have entered the fields in the Query Preference. Form - "frmSelector" start date field - [forms]![frmSelector]![txtStartDate] stop date field - [forms]![frmSelector]![txtStopDate] when I run the query I get a messagea message "invalid bracketing of name "[forms!frm_Selector!txtStartDate]"". But what I entered into Queries-Parameters was forms!frm_Selector!txtStartDate. When you save the query it adds the brackets. If I enter [forms]![frm_Selector]![txtStartDate]...I get "[[forms]![frm_Selector]![txtStartDate]]" Any suggestions?
|
|
#7
August 23rd, 2007, 11:12 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"invalid bracketing of name" when referencing Query Parameter
I have looked at my SQL and changed the bracketing but now it says there is a syntax error in the parameter clause: PARAMETERS =[forms]![reports form]![DateFrom] And =[forms]![reports form]![DateTo] DateTime; "Duane Hookom" wrote: Did you view the SQL view and change it there? -- Duane Hookom MS Access MVP -- "gregglund" wrote in message ... Any suggestions for work around? I get this same problem not matter what I put into the Query-Parameter Dialog. gregg "Duane Hookom" wrote: Fix it, save it, and hope it doesn't happen again. I'm not sure why it happens but it is a bug. -- Duane Hookom MS Access MVP -- "GreggLund" wrote in message ... In Access2003 I have a query that uses the start and stop date that it gets from a form. In the query I have entered the fields in the Query Preference. Form - "frmSelector" start date field - [forms]![frmSelector]![txtStartDate] stop date field - [forms]![frmSelector]![txtStopDate] when I run the query I get a messagea message "invalid bracketing of name "[forms!frm_Selector!txtStartDate]"". But what I entered into Queries-Parameters was forms!frm_Selector!txtStartDate. When you save the query it adds the brackets. If I enter [forms]![frm_Selector]![txtStartDate]...I get "[[forms]![frm_Selector]![txtStartDate]]" Any suggestions?
|
|
#8
August 23rd, 2007, 12:35 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"invalid bracketing of name" when referencing Query Parameter
why post twice?
-- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "scubadiver" wrote in message ... I have looked at my SQL and changed the bracketing but now it says there is a syntax error in the parameter clause: PARAMETERS =[forms]![reports form]![DateFrom] And =[forms]![reports form]![DateTo] DateTime; "Duane Hookom" wrote: Did you view the SQL view and change it there? -- Duane Hookom MS Access MVP -- "gregglund" wrote in message ... Any suggestions for work around? I get this same problem not matter what I put into the Query-Parameter Dialog. gregg "Duane Hookom" wrote: Fix it, save it, and hope it doesn't happen again. I'm not sure why it happens but it is a bug. -- Duane Hookom MS Access MVP -- "GreggLund" wrote in message ... In Access2003 I have a query that uses the start and stop date that it gets from a form. In the query I have entered the fields in the Query Preference. Form - "frmSelector" start date field - [forms]![frmSelector]![txtStartDate] stop date field - [forms]![frmSelector]![txtStopDate] when I run the query I get a messagea message "invalid bracketing of name "[forms!frm_Selector!txtStartDate]"". But what I entered into Queries-Parameters was forms!frm_Selector!txtStartDate. When you save the query it adds the brackets. If I enter [forms]![frm_Selector]![txtStartDate]...I get "[[forms]![frm_Selector]![txtStartDate]]" Any suggestions?
|
|
#9
August 23rd, 2007, 12:42 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"invalid bracketing of name" when referencing Query Parameter
I asked myself the same thing. -- The 11th day of every month: http://truthaction.org/forum/index.php "Jeff Boyce" wrote: why post twice? -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "scubadiver" wrote in message ... I have looked at my SQL and changed the bracketing but now it says there is a syntax error in the parameter clause: PARAMETERS =[forms]![reports form]![DateFrom] And =[forms]![reports form]![DateTo] DateTime; "Duane Hookom" wrote: Did you view the SQL view and change it there? -- Duane Hookom MS Access MVP -- "gregglund" wrote in message ... Any suggestions for work around? I get this same problem not matter what I put into the Query-Parameter Dialog. gregg "Duane Hookom" wrote: Fix it, save it, and hope it doesn't happen again. I'm not sure why it happens but it is a bug. -- Duane Hookom MS Access MVP -- "GreggLund" wrote in message ... In Access2003 I have a query that uses the start and stop date that it gets from a form. In the query I have entered the fields in the Query Preference. Form - "frmSelector" start date field - [forms]![frmSelector]![txtStartDate] stop date field - [forms]![frmSelector]![txtStopDate] when I run the query I get a messagea message "invalid bracketing of name "[forms!frm_Selector!txtStartDate]"". But what I entered into Queries-Parameters was forms!frm_Selector!txtStartDate. When you save the query it adds the brackets. If I enter [forms]![frm_Selector]![txtStartDate]...I get "[[forms]![frm_Selector]![txtStartDate]]" Any suggestions?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Error Message: Invalid Bracketing when trying to set Parameters | tpope999 | Running & Setting Up Queries | 3 | October 14th, 2004 07:02 PM |
| Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
| Using a query with a replaceable parameter as the source of a control | Hoo | Using Forms | 2 | May 30th, 2004 09:43 AM |
Linear Mode
