Need help with Query/Form.

[Guest]

What I would like to do is reference a text box controll that is on a form in
a querry. What I have done is gone to the querry by example grid and right
clicked on the field and choose the "build" option so I could click and point
to the field on the form which returned......Expr1:
[Forms]![frmDailyProduction]![txtSetupDollarsPerKgApplesProduced]. When I
run the query all I get as results for this field (Expr1) is four small
squares.

Can anyone tell me what I have done wrong? Any help would be greatly
appreciated.

Thanks,
FatMan

 

[OfficeDev18 via AccessMonster.com]

Hi,

Right-click on the Expr1 field, and select 'Properties.' Maybe there's a
format that's incompatible with the data, such as date for string data, etc.

Sam

What I would like to do is reference a text box controll that is on a form in
a querry. What I have done is gone to the querry by example grid and right
clicked on the field and choose the "build" option so I could click and point
to the field on the form which returned......Expr1:
[Forms]![frmDailyProduction]![txtSetupDollarsPerKgApplesProduced]. When I
run the query all I get as results for this field (Expr1) is four small
squares.

Can anyone tell me what I have done wrong? Any help would be greatly
appreciated.

Thanks,
FatMan

 

[Guest]

Sam:
Thanks for the suggestion. I already tried that. Oddly enough the format
on the format is currency. Yet when you run the querry and then try to
format the field by clicking on the down list (in properties) there are NO
formats you can choose from. If you try to set the format prior to running
the querry (just after you added the field) you can choose currency. This
will result in the querry returning no values for this field.

Anyother ideas?

Thanks,
FatMan

Hi,

Right-click on the Expr1 field, and select 'Properties.' Maybe there's a
format that's incompatible with the data, such as date for string data, etc.

Sam

What I would like to do is reference a text box controll that is on a form in
a querry. What I have done is gone to the querry by example grid and right
clicked on the field and choose the "build" option so I could click and point
to the field on the form which returned......Expr1:
[Forms]![frmDailyProduction]![txtSetupDollarsPerKgApplesProduced]. When I
run the query all I get as results for this field (Expr1) is four small
squares.

Can anyone tell me what I have done wrong? Any help would be greatly
appreciated.

Thanks,
FatMan

 

[OfficeDev18 via AccessMonster.com]

When all else fails..... Please copy and paste the entire SQL here. This will
give us a more complete picture.

Sam

Sam:
Thanks for the suggestion. I already tried that. Oddly enough the format
on the format is currency. Yet when you run the querry and then try to
format the field by clicking on the down list (in properties) there are NO
formats you can choose from. If you try to set the format prior to running
the querry (just after you added the field) you can choose currency. This
will result in the querry returning no values for this field.

Anyother ideas?

Thanks,
FatMan

Hi,

[quoted text clipped - 16 lines]

 

[Guest]

Sam:
Thanks for all the help but I stumbled onto the solution through good old
fashion trial and error.....with just the right amount of fraustration.

Thanks,
FatMan

When all else fails..... Please copy and paste the entire SQL here. This will
give us a more complete picture.

Sam

Sam:
Thanks for the suggestion. I already tried that. Oddly enough the format
on the format is currency. Yet when you run the querry and then try to
format the field by clicking on the down list (in properties) there are NO
formats you can choose from. If you try to set the format prior to running
the querry (just after you added the field) you can choose currency. This
will result in the querry returning no values for this field.

Anyother ideas?

Thanks,
FatMan

Hi,

[quoted text clipped - 16 lines]

Thanks,
FatMan