AccessXP runtime Date field don't work

[Lorenzo]

Hello,

Access XP runtime (*.mde) on XPsp2, all date field
don't work, in the form field the output is ?name

Such as in the form control field, the default value is =Date()
or =Year(date())

The runtime database works fine su many workstation,
only one have the problem.

What can i find now ?

Thanks
Lorenzo

 

[Douglas J. Steele]

You've likely got a References problem. Unfortunately, they're a little hard
to fix with MDEs.

On the workstation where the application was developed, open up the MDB that
was used to create the MDE. Run the following code to determine all of the
required references:

Sub ListReferences()
Dim refCurr As Reference

For Each refCurr In Application.References
Debug.Print refCurr.Name & ": " & refCurr.FullPath
Next

End Sub

Find each of the files listed above and determine the version of each.

Next, on the workstation(s) where the MDE isn't working, check to see that
the exact same version of each of those files is located in exactly the same
location.

 

[Lorenzo]

Yes, i found it !
Now it's working.
Thanks.
L.

You've likely got a References problem. Unfortunately, they're a little
hard
to fix with MDEs.

On the workstation where the application was developed, open up the MDB
that
was used to create the MDE. Run the following code to determine all of the
required references:

Sub ListReferences()
Dim refCurr As Reference

For Each refCurr In Application.References
Debug.Print refCurr.Name & ": " & refCurr.FullPath
Next

End Sub

Find each of the files listed above and determine the version of each.

Next, on the workstation(s) where the MDE isn't working, check to see that
the exact same version of each of those files is located in exactly the
same
location.

 

[Tom Wickerath]

Hi Doug,

The issue of missing references in .MDE files, and your answer shown below, would be a nice
addition to your Dealing with Access Reference Problems document. Any chance you can add it?


Thanks,

Tom Wickerath
_____________________________________________

You've likely got a References problem. Unfortunately, they're a little hard
to fix with MDEs.

On the workstation where the application was developed, open up the MDB that
was used to create the MDE. Run the following code to determine all of the
required references:

Sub ListReferences()
Dim refCurr As Reference

For Each refCurr In Application.References
Debug.Print refCurr.Name & ": " & refCurr.FullPath
Next

End Sub

Find each of the files listed above and determine the version of each.

Next, on the workstation(s) where the MDE isn't working, check to see that
the exact same version of each of those files is located in exactly the same
location.

 

[Douglas J. Steele]

Yeah, I keep meaning to update that article, and never get around to it.
Hopefully your note will spur me on...