public variable does not recognize

[iccsi]

I have an application which has a public varaiable like following:

dim MyDateTime as Datetime

it does not recorgnize in one machine in the query.

The criteria is

[forms]![MyForm].[MyDateTime]

Above query works in all users machine except one read always zero..

It seems one machine has different setup?
Any option and property to set read public variable?

Your information is great appreciated,

 

[ruralguy via AccessMonster.com]

Not as far as I know.

I have an application which has a public varaiable like following:

dim MyDateTime as Datetime

it does not recorgnize in one machine in the query.

The criteria is

[forms]![MyForm].[MyDateTime]

Above query works in all users machine except one read always zero..

It seems one machine has different setup?
Any option and property to set read public variable?

Your information is great appreciated,

 

[ruralguy via AccessMonster.com]

Any MISSING references on that one machine?
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

I have an application which has a public varaiable like following:

dim MyDateTime as Datetime

it does not recorgnize in one machine in the query.

The criteria is

[forms]![MyForm].[MyDateTime]

Above query works in all users machine except one read always zero..

It seems one machine has different setup?
Any option and property to set read public variable?

Your information is great appreciated,

 

[AccessVandal via AccessMonster.com]

DateTime is a reserved name and word in Access.

It’s very unlikely to be a referance library or an ActiveX.

Do you have a Class module with that name? You should be using it as

Dim MyDateTime as Date

If you called it as Datetime, you may need to rename it to something else
more appropriate.

Look for Allen Browne’s site on reserve names here.
http://www.allenbrowne.com/AppIssueBadWord.html

I have an application which has a public varaiable like following:

dim MyDateTime as Datetime

it does not recorgnize in one machine in the query.

The criteria is

[forms]![MyForm].[MyDateTime]

Above query works in all users machine except one read always zero..

It seems one machine has different setup?
Any option and property to set read public variable?

Your information is great appreciated,

 

[ruralguy via AccessMonster.com]

Good catch! Sharp eye.

DateTime is a reserved name and word in Access.

It’s very unlikely to be a referance library or an ActiveX.

Do you have a Class module with that name? You should be using it as

Dim MyDateTime as Date

If you called it as Datetime, you may need to rename it to something else
more appropriate.

Look for Allen Browne’s site on reserve names here.
http://www.allenbrowne.com/AppIssueBadWord.html

I have an application which has a public varaiable like following:

[quoted text clipped - 12 lines]

Your information is great appreciated,

 

[David W. Fenton]

m:

I have an application which has a public varaiable like following:

dim MyDateTime as Datetime

That's not a public variable.

 

[inungh]

That's not a public variable.

Thanks for the message.
My cod is as following:

Public CoachDateTime As Date

Thanks again,