IS THAT VERSION PROBLEM?

[Guest]

I made a msaccess database in 2002 version in my laptop at home. But I
copied it to my office. That version is 2003. The calculation not working.
The database was as follows :
I made table A: SERIAL NO, NAME
B: SERIAL NO, EXPENSE
SERIAL NO to SERIAL NO connected

A is main form
B is sub form. In main form I created field named : Total
I put this Total field in sub form footer. From main form footer I made
another field for Total and connected to sub form Total field. Wow! this is
working in my lap top. I copied the same in my desktop. Not working in
Desktop. Msaccess in laptop is 2002. In Desktop version is 2003. Is this
the reason? Pls reply.

 

[John Vinson]

I made a msaccess database in 2002 version in my laptop at home. But I
copied it to my office. That version is 2003. The calculation not working.
The database was as follows :
I made table A: SERIAL NO, NAME
B: SERIAL NO, EXPENSE
SERIAL NO to SERIAL NO connected

A is main form
B is sub form. In main form I created field named : Total
I put this Total field in sub form footer. From main form footer I made
another field for Total and connected to sub form Total field. Wow! this is
working in my lap top. I copied the same in my desktop. Not working in
Desktop. Msaccess in laptop is 2002. In Desktop version is 2003. Is this
the reason? Pls reply.

The Access version shouldn't make any difference. By guess would be
that there is some difference between the two databases. In what way
is it "not working" - no data? #Error!#? #Name!#? What are the Control
Source properties of the two textboxes?

John W. Vinson[MVP]

 

[Guest]

Control Source Properties in sub form footer:

=Sum([EXPENSE])
Field name : Total Expense

Control Source Properties in main form footer :
=[Table2subform]!Text4

 

[Guest]

No #Error!#? #Name!#? showing. Field in main form Total is empty