Run-time error for Invalid brackeing....

[var]

Hi,

i have a crosstab query and a Form, when I run the query through the
Form it populating

Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'

where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error

pls anybody suggest me the right way of declaring this.....

thnaks in advance

Var

 

[Guest]

[Forms]![frmMainForm]![Date]

 

[var]

Hi Klatuu

It works fine only for a few dates, when i gave some other
dates.....nothig is happening the Form just staying opened....no
results displayed...no response

Do i need to declare any Default Value...to accepts the other dates in
the text fields of the Form

any suggestions...

Var

[Forms]![frmMainForm]![Date]

Hi,

i have a crosstab query and a Form, when I run the query through the
Form it populating

Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'

where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error

pls anybody suggest me the right way of declaring this.....

thnaks in advance

Var

 

[Guest]

If the table field is a date/time data type, you need
"#" & [Forms]![frmMainForm]![Date] & "#"

One thing to keep in mind, If you are using Now() to populate the field, you
may not get all your matches, because Now() includes the time where Date()
does not.

Hi Klatuu

It works fine only for a few dates, when i gave some other
dates.....nothig is happening the Form just staying opened....no
results displayed...no response

Do i need to declare any Default Value...to accepts the other dates in
the text fields of the Form

any suggestions...

Var

[Forms]![frmMainForm]![Date]

Hi,

i have a crosstab query and a Form, when I run the query through the
Form it populating

Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'

where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error

pls anybody suggest me the right way of declaring this.....

thnaks in advance

Var

 

[var]

Hi Klatuu

Yest you are right the table field is a Date/time data type,

I tried the "#" &...................& "#", but it didn't work tried
something else with it but no use.......still the invalid brackeing
error pop ups

do i need to declare this in Query Parameters or Form text field
property......is that both make a difference right

any ideas

Var

If the table field is a date/time data type, you need
"#" & [Forms]![frmMainForm]![Date] & "#"

One thing to keep in mind, If you are using Now() to populate the field, you
may not get all your matches, because Now() includes the time where Date()
does not.

Hi Klatuu

It works fine only for a few dates, when i gave some other
dates.....nothig is happening the Form just staying opened....no
results displayed...no response

Do i need to declare any Default Value...to accepts the other dates in
the text fields of the Form

any suggestions...

Var

[Forms]![frmMainForm]![Date]

:

Hi,

i have a crosstab query and a Form, when I run the query through the
Form it populating

Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'

where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error

pls anybody suggest me the right way of declaring this.....

thnaks in advance

Var

 

[Guest]

I don't see the problem. What you sent originally was missing an !
[Forms][frmMainForm]![Date]
I put it in where it belongs
[Forms]![frmMainForm]![Date]
I can't determine the problem. One thing to note, Date is an Access
reserved work and really should not be used as a field name or any other name
for that matter, but the brackets should protect against that.

How is it the bracketing error is back. Your last post said it worked for a
few dates.

Hi Klatuu

Yest you are right the table field is a Date/time data type,

I tried the "#" &...................& "#", but it didn't work tried
something else with it but no use.......still the invalid brackeing
error pop ups

do i need to declare this in Query Parameters or Form text field
property......is that both make a difference right

any ideas

Var

If the table field is a date/time data type, you need
"#" & [Forms]![frmMainForm]![Date] & "#"

One thing to keep in mind, If you are using Now() to populate the field, you
may not get all your matches, because Now() includes the time where Date()
does not.

Hi Klatuu

It works fine only for a few dates, when i gave some other
dates.....nothig is happening the Form just staying opened....no
results displayed...no response

Do i need to declare any Default Value...to accepts the other dates in
the text fields of the Form

any suggestions...

Var


Klatuu wrote:
[Forms]![frmMainForm]![Date]

:

Hi,

i have a crosstab query and a Form, when I run the query through the
Form it populating

Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'

where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error

pls anybody suggest me the right way of declaring this.....

thnaks in advance

Var

 

[var]

HI

even i am not sure, where i went wrong....but one thing i can say

when i am preparing the reprot, i used certain dates to populate the
query selection box to choose the field heading and text boxes

may be that aspect will effect the entire Query in selecting the dates
from Form.....is there any connections that work like this

i am using a Crosstab Query, is there any simple method where i can
generate the Report much more easier than this

Var

I don't see the problem. What you sent originally was missing an !
[Forms][frmMainForm]![Date]
I put it in where it belongs
[Forms]![frmMainForm]![Date]
I can't determine the problem. One thing to note, Date is an Access
reserved work and really should not be used as a field name or any other name
for that matter, but the brackets should protect against that.

How is it the bracketing error is back. Your last post said it worked for a
few dates.

Hi Klatuu

Yest you are right the table field is a Date/time data type,

I tried the "#" &...................& "#", but it didn't work tried
something else with it but no use.......still the invalid brackeing
error pop ups

do i need to declare this in Query Parameters or Form text field
property......is that both make a difference right

any ideas

Var

If the table field is a date/time data type, you need
"#" & [Forms]![frmMainForm]![Date] & "#"

One thing to keep in mind, If you are using Now() to populate the field, you
may not get all your matches, because Now() includes the time where Date()
does not.

:

Hi Klatuu

It works fine only for a few dates, when i gave some other
dates.....nothig is happening the Form just staying opened....no
results displayed...no response

Do i need to declare any Default Value...to accepts the other dates in
the text fields of the Form

any suggestions...

Var


Klatuu wrote:
[Forms]![frmMainForm]![Date]

:

Hi,

i have a crosstab query and a Form, when I run the query through the
Form it populating

Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'

where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error

pls anybody suggest me the right way of declaring this.....

thnaks in advance

Var

 

[Guest]

Not that I know of.
How about trying putting a date in the criteria by hand to see what happens.
Use the # to surround the the date
#9/20/2006#

HI

even i am not sure, where i went wrong....but one thing i can say

when i am preparing the reprot, i used certain dates to populate the
query selection box to choose the field heading and text boxes

may be that aspect will effect the entire Query in selecting the dates
from Form.....is there any connections that work like this

i am using a Crosstab Query, is there any simple method where i can
generate the Report much more easier than this

Var

I don't see the problem. What you sent originally was missing an !
[Forms][frmMainForm]![Date]
I put it in where it belongs
[Forms]![frmMainForm]![Date]
I can't determine the problem. One thing to note, Date is an Access
reserved work and really should not be used as a field name or any other name
for that matter, but the brackets should protect against that.

How is it the bracketing error is back. Your last post said it worked for a
few dates.

Hi Klatuu

Yest you are right the table field is a Date/time data type,

I tried the "#" &...................& "#", but it didn't work tried
something else with it but no use.......still the invalid brackeing
error pop ups

do i need to declare this in Query Parameters or Form text field
property......is that both make a difference right

any ideas

Var



Klatuu wrote:
If the table field is a date/time data type, you need
"#" & [Forms]![frmMainForm]![Date] & "#"

One thing to keep in mind, If you are using Now() to populate the field, you
may not get all your matches, because Now() includes the time where Date()
does not.

:

Hi Klatuu

It works fine only for a few dates, when i gave some other
dates.....nothig is happening the Form just staying opened....no
results displayed...no response

Do i need to declare any Default Value...to accepts the other dates in
the text fields of the Form

any suggestions...

Var


Klatuu wrote:
[Forms]![frmMainForm]![Date]

:

Hi,

i have a crosstab query and a Form, when I run the query through the
Form it populating

Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'

where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error

pls anybody suggest me the right way of declaring this.....

thnaks in advance

Var

 

[var]

Hi

I will give a trial to that and let you know if anything comes up

var

Not that I know of.
How about trying putting a date in the criteria by hand to see what happens.
Use the # to surround the the date
#9/20/2006#

HI

even i am not sure, where i went wrong....but one thing i can say

when i am preparing the reprot, i used certain dates to populate the
query selection box to choose the field heading and text boxes

may be that aspect will effect the entire Query in selecting the dates
from Form.....is there any connections that work like this

i am using a Crosstab Query, is there any simple method where i can
generate the Report much more easier than this

Var

I don't see the problem. What you sent originally was missing an !
[Forms][frmMainForm]![Date]
I put it in where it belongs
[Forms]![frmMainForm]![Date]
I can't determine the problem. One thing to note, Date is an Access
reserved work and really should not be used as a field name or any other name
for that matter, but the brackets should protect against that.

How is it the bracketing error is back. Your last post said it worked for a
few dates.

:

Hi Klatuu

Yest you are right the table field is a Date/time data type,

I tried the "#" &...................& "#", but it didn't work tried
something else with it but no use.......still the invalid brackeing
error pop ups

do i need to declare this in Query Parameters or Form text field
property......is that both make a difference right

any ideas

Var



Klatuu wrote:
If the table field is a date/time data type, you need
"#" & [Forms]![frmMainForm]![Date] & "#"

One thing to keep in mind, If you are using Now() to populate the field, you
may not get all your matches, because Now() includes the time where Date()
does not.

:

Hi Klatuu

It works fine only for a few dates, when i gave some other
dates.....nothig is happening the Form just staying opened....no
results displayed...no response

Do i need to declare any Default Value...to accepts the other dates in
the text fields of the Form

any suggestions...

Var


Klatuu wrote:
[Forms]![frmMainForm]![Date]

:

Hi,

i have a crosstab query and a Form, when I run the query through the
Form it populating

Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'

where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error

pls anybody suggest me the right way of declaring this.....

thnaks in advance

Var

 

[var]

Hi,

No, its not working out!!!???

any other help

var

Hi

I will give a trial to that and let you know if anything comes up

var

Not that I know of.
How about trying putting a date in the criteria by hand to see what happens.
Use the # to surround the the date
#9/20/2006#

HI

even i am not sure, where i went wrong....but one thing i can say

when i am preparing the reprot, i used certain dates to populate the
query selection box to choose the field heading and text boxes

may be that aspect will effect the entire Query in selecting the dates
from Form.....is there any connections that work like this

i am using a Crosstab Query, is there any simple method where i can
generate the Report much more easier than this

Var


Klatuu wrote:
I don't see the problem. What you sent originally was missing an !
[Forms][frmMainForm]![Date]
I put it in where it belongs
[Forms]![frmMainForm]![Date]
I can't determine the problem. One thing to note, Date is an Access
reserved work and really should not be used as a field name or any other name
for that matter, but the brackets should protect against that.

How is it the bracketing error is back. Your last post said it worked for a
few dates.

:

Hi Klatuu

Yest you are right the table field is a Date/time data type,

I tried the "#" &...................& "#", but it didn't work tried
something else with it but no use.......still the invalid brackeing
error pop ups

do i need to declare this in Query Parameters or Form text field
property......is that both make a difference right

any ideas

Var



Klatuu wrote:
If the table field is a date/time data type, you need
"#" & [Forms]![frmMainForm]![Date] & "#"

One thing to keep in mind, If you are using Now() to populate the field, you
may not get all your matches, because Now() includes the time where Date()
does not.

:

Hi Klatuu

It works fine only for a few dates, when i gave some other
dates.....nothig is happening the Form just staying opened....no
results displayed...no response

Do i need to declare any Default Value...to accepts the other dates in
the text fields of the Form

any suggestions...

Var


Klatuu wrote:
[Forms]![frmMainForm]![Date]

:

Hi,

i have a crosstab query and a Form, when I run the query through the
Form it populating

Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'

where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error

pls anybody suggest me the right way of declaring this.....

thnaks in advance

Var