problem with "on the fly" fields in access 2007

[Greg]

Hello,

Everything was working properly under access 2003, and I have a problem in
access 2007 :

I have fields without datas or source for those datas :
Access 2003 had a pop up window saying , for example, " shipping fees ?"
I answered, and the answer was used for calculations and prinitng of the
document.

Under access 2007, it's not working with text : #Error.

And in calculations, I have incoherent numbers.

Do you know how to solve this problem ??

Thank's


Greg

 

[John Vinson]

Hello,

Everything was working properly under access 2003, and I have a problem in
access 2007 :

I have fields without datas or source for those datas :
Access 2003 had a pop up window saying , for example, " shipping fees ?"
I answered, and the answer was used for calculations and prinitng of the
document.

Under access 2007, it's not working with text : #Error.

And in calculations, I have incoherent numbers.

Do you know how to solve this problem ??

One thing worth trying is to put these parameters into the query's
Parameters dialog. Right mouseclick the background of the tables or
use the View menu option and select Parameters (at least this is how
it works in 2003, I'm dragging my heels on installing 2007!). Add the
parameter and its data type.

John W. Vinson[MVP]

 

[Greg]

Tks for your help !

I've added an "expression" (whithout "source") to the request giving datas
to this report : it works.

(unfortunately, this request is alos the one for various functions in my
db...i'll have to make several ones to fit each purpose : It was much more
practical under access 2003.)

Ths .

Regards.

Greg