"invalid bracketing of name" when referencing Query Parameter

[Guest]

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?

 

[Duane Hookom]

Fix it, save it, and hope it doesn't happen again. I'm not sure why it
happens but it is a bug.

 

[Guest]

Any suggestions for work around? I get this same problem not matter what I
put into the Query->Parameter Dialog.

gregg

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
--

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?

 

[Duane Hookom]

Did you view the SQL view and change it there?

--
Duane Hookom
MS Access MVP
--

Any suggestions for work around? I get this same problem not matter what I
put into the Query->Parameter Dialog.

gregg

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
--

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?

 

[Guest]

I saw an aswer you put for another questions and then went into SQL view and
edited it there...and it works. THANKS

gregg

Did you view the SQL view and change it there?

--
Duane Hookom
MS Access MVP
--

Any suggestions for work around? I get this same problem not matter what I
put into the Query->Parameter Dialog.

gregg

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
--

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?

 

[Guest]

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;

Did you view the SQL view and change it there?

--
Duane Hookom
MS Access MVP
--

Any suggestions for work around? I get this same problem not matter what I
put into the Query->Parameter Dialog.

gregg

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
--

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?

 

[Jeff Boyce]

why post twice?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

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;

Did you view the SQL view and change it there?

--
Duane Hookom
MS Access MVP
--

Any suggestions for work around? I get this same problem not matter what I
put into the Query->Parameter Dialog.

gregg

:

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
--

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?

 

[Guest]

I asked myself the same thing.

--

The 11th day of every month:

http://truthaction.org/forum/index.php

why post twice?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

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;

Did you view the SQL view and change it there?

--
Duane Hookom
MS Access MVP
--

Any suggestions for work around? I get this same problem not matter what I
put into the Query->Parameter Dialog.

gregg

:

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
--

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?