#name? error

[nq]

I have a database that appears to work correctly for a group of people.

The database has several queries/reports that require pop-up forms to enter search criteria before calling the query. On several of these forms, a value is required for a year. Normally this defaults to the current year but may be changed to any previous year. I have an unbound control with a default value of: DatePart("yyyy",Date())

This fills the control with 2006 (current year) and is passed as a parameter to the query. This works perfectly.

I have sent the database to someone that tells me that the pop-up forms do not display the current year, instead they display: #name?

This usually indicates that a value cannot be referenced for some reason. In this instance I cannot understand what is not being referenced or not being returned. Any ideas would be appreciated.

Nigel.

 

[Remou]

As far as I remember this is a Reference problem. You need to check that a references has not been lost and that the necessary files are present, that is, the VB files.

 

[ssatech]

I have sent the database to someone that tells me that the pop-up forms do not display the current year, instead they display: #name?"

Could it be his Regional Options on his Windows Setting is formatted different?

 

[nq]

I have checked all the regional and date settings. I don't think that is the problem.
The problem may be a reference problem. I do remember trying to implement a rather complex email system, only to be thwarted by Microsoft's vain attempts at fixing a security flaw by sending one email at a time with an unbearable wait between consecutive emails. I had removed all the code for that and the reference to the Outlook library but perhaps for some strange reason it still requires a reference to the Outlook library.

 

[PHV]

Does the DB compiles properly ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nq]

Compile seems to work perfectly. I always compile after any change.

 

[PHV]

I have sent the database to someone
Does the DB compiles properly on someone's computer ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nq]

Hmm....
Yes - on computers that don't have this problem. I will arrange to test on a machine that does.
My experience is with C and Fortran - once compiled, that's it. Does that mean that compilation in Access is not true compilation, rather a means of checking for errors before interpretation by individual machines?