Run-time error for Invalid brackeing....

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

var - 20 Sep 2006 20:58 GMT

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

Reply to this Message

Klatuu - 20 Sep 2006 21:16 GMT

[Forms]![frmMainForm]![Date]

> Hi,
>
[quoted text clipped - 13 lines]
>
> Var

Reply to this Message

var - 20 Sep 2006 21:40 GMT

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]
>
[quoted text clipped - 15 lines]
> >
> > Var

Reply to this Message

Klatuu - 20 Sep 2006 21:54 GMT

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
>
[quoted text clipped - 28 lines]
> > >
> > > Var

Reply to this Message

var - 20 Sep 2006 22:12 GMT

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] & "#"
[quoted text clipped - 35 lines]
> > > >
> > > > Var

Reply to this Message

Klatuu - 20 Sep 2006 22:31 GMT

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
>
[quoted text clipped - 50 lines]
> > > > >
> > > > > Var

Reply to this Message

var - 20 Sep 2006 22:50 GMT

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]
[quoted text clipped - 61 lines]
> > > > > >
> > > > > > Var

Reply to this Message

Klatuu - 20 Sep 2006 23:00 GMT

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
>
[quoted text clipped - 76 lines]
> > > > > > >
> > > > > > > Var

Reply to this Message

var - 21 Sep 2006 01:53 GMT

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.
[quoted text clipped - 81 lines]
> > > > > > > >
> > > > > > > > Var

Reply to this Message

var - 22 Sep 2006 17:06 GMT

Hi,

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

any other help

var

> Hi
>
[quoted text clipped - 87 lines]
> > > > > > > > >
> > > > > > > > > Var

Reply to this Message