Using Public Variables in Visual Basic for MS Access

[Guest]

I just reciently installed MS Office 2003 and attempted to prepare a report
using MS Access with a Public Variable declared in Visual Basic for MS
Access. When I attempt to run the report the declared variable in VB returns
a #NAME? instead of the value. I run the same procedure on a 2002 version
and the correct value is returned.

I have re-installed MS Office with repair and the results are the same. I
have worked with MS Access for a number of years, using every version of MS
Office and not having this problem before.

Is this a bug in MS Access or does MS Access 2003 have differant
requirements???

 

[Marshall Barton]

I just reciently installed MS Office 2003 and attempted to prepare a report
using MS Access with a Public Variable declared in Visual Basic for MS
Access. When I attempt to run the report the declared variable in VB returns
a #NAME? instead of the value. I run the same procedure on a 2002 version
and the correct value is returned.

I have re-installed MS Office with repair and the results are the same. I
have worked with MS Access for a number of years, using every version of MS
Office and not having this problem before.

Is this a bug in MS Access or does MS Access 2003 have differant
requirements???

Please don't post the same question multiple times. Someone
already answered this question in another newsgroup.