Need to display references 1

[burgerman]

I am having trouble with Access displaying NAME#? In any field that has date() as it’s control source. I have isolated the problem to be an issue when I distribute the .mde file to other users who may have some of the references missing on their system. My question is how can I have a list of the references appear in a support form that I can create so I can tell what file the host machine is missing?

 

[scking]

You could use a Window Script file to search the registry for the proper controls and display a message box to advise you.
-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[MichaelRed]

Hmmmmmmmmmmmmm,

perhaps this reveals a bit more about StuuuuuuFFFFfff than I need to know. With a bit of tweaking (to place into a more formal procedure, the following snippet (done ENTIRELY in the immediate (a.k.a. DEBUG window) revealed all that I needed to know:

? Application.References.Count
 12 
For xx = 1 to 12: Debug.Print Application.References(xx).Name: Next xx
VBA
Access
stdole
DAO
Office
ADODB
JRO
Scripting
Excel
PowerPoint
Outlook
ADOR
[code]

 MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over