Doug Steele Object Documentor error

[Guest]

I installed the addin on Jeff's sugestions and I really like it, but in one
of my DBs I am getting the following error when I try and run it

Unexpected Error
The following error has occoured:
Error Number: 3085
Error Description: Undefined function 'Left$' in expression

And so I can't produce the report. Any thoughts?

Jeff

 

[Jeff Conrad]

Hi Jeff,

It is a References problem. The arch-nemesis of Access is missing references.

To fix the References problem follow these steps on that computer:
- Open any module in Design view.
- On the Tools menu, click References.
- At least one Reference should say "Missing". WRITE down the one(s) missing.
- Click to clear the check box for the type library or object library marked as "Missing:."
- Close the References Window box.
- Open the References Window back up. Hopefully, nothing should say Missing this time.
- Now go find that library/project(s) in the list that was missing.
- If more than one were missing, find the others and check them as well.
- Close the References box again.
- Now re-compile again. Debug--Compile.
- Hopefully you should not see any more compile errors.

If you'd like to read more about References, here's more info than you could possibly ever want to
know:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

http://members.iinet.net.au/~allenbrowne/ser-38.html

http://www.trigeminal.com/usenet/usenet026.asp

http://www.papwalker.com/dllhell/index-page2.html

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/?id=248941

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/?id=310803

ACC2002: References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/?id=283115

ACC97: References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/?id=175484

ACC: VBA Functions Break in Database with Missing References
http://support.microsoft.com/?id=160870

 

[Guest]

Hi Jeff,

Okay, this sounds like the way to go, but what if I have no modules in the
DB? There are Tables, Queries, Forms, Reports and Macros.

Jeff

 

[Jeff Conrad]

Not a problem. Tech support is here to help.

1. Open any form in Design View
2. Go up to the main menu bar and select View | Code
3. This will bring up the code window for this form
4. Now you will see Tools | References on the menu bar
5. Follow the instructions below

 

[Guest]

Thanks again Jeff, that did it. If you have the time and the inclination, I
am going to post another error not related to the Documenter in a new thread.
Seeing how you have known the answer to all my other problems, you will
probly know this one too.

Jeff

 

[Jeff Conrad]

Thanks again Jeff, that did it.

You're welcome, glad to help.

If you have the time and the inclination, I am going to post another error not
related to the Documenter in a new thread. Seeing how you have known the
answer to all my other problems, you will probably know this one too.

Oh sure, put the pressure on me now!
I'll see what I can do later on.

 

[Guest]

Jeff,

Thanks for the info! I had a similar problem with my code. I'd managed to
make my way to the References window. But I initially couldn't find the
missing module because I was expecting it to be one of the unchecked items.
So thanks a bunch for your help!

Have a great day!

Carolyn

 

[Jeff Conrad]

Hi Carolyn,

Thanks for the info! I had a similar problem with my code. I'd managed to
make my way to the References window. But I initially couldn't find the
missing module because I was expecting it to be one of the unchecked items.
So thanks a bunch for your help!

No problem, glad to help.

Have a great day!

Thanks, you too.
Hope you find the Add-In useful.

 

[Guest]

I had a different error, which is corrected by changing the installation
notes to read:
2. Now open any Access database (other than the mda database)
--Michelle K. Gross