Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access+course+training - errors including undefined expre

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+course+training - Errors including 'Undefined Expression Left' and Compile Errors

access+course+training - Errors including 'Undefined Expression Left' and Compile Errors

ResolvedVersion Standard

Craig has attended:
Access Introduction course
Access Intermediate course

Errors including 'Undefined Expression Left' and Compile Errors

The above link to an issue I am having when trying to run Access reports through my Smartstream software.
They link to a MISSING: utility.mda message that appears in the references list of the mdb's module.
What is the reason for this occurring, and is there a way, other than manually adding the mda in the references list, that I can stop these errors appearing?

Thanks
Craig.

RE: Errors including 'Undefined Expression Left' and Compile Err

Hello Craig,

Hope you enjoyed your Microsoft Access courses with BEST Training.

Thank you for your question regarding the Errors you are recieving, and appologies for the delay in answering your foum post.

For my reference, what is Smartstream software?

I would recommend making a backup of your database before trying any of the suggestions below.

Here are some options to address your question:

1. REPAIRING
Utility.MDA is an office add in. Try repairing your access installation

2. DIFFERENT VERSIONS OF ACCESS
If it is referencing utility.mda, it may be converted from an earlier version of Access and it might not need the reference.
Try removing the reference to utility.mda and see if the db works.

If you have not already found a solution, I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.