Access Report Function

%3CLINGO-SUB%20id%3D%22lingo-sub-1429453%22%20slang%3D%22en-US%22%3EAccess%20Report%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429453%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20using%20Access%20from%20my%20Office%20365%20suite%20subscription%20for%20a%20club%20register%20database%20that's%20been%20operating%20and%20changed%20fine.%20Recently%2C%20a%20number%20of%20reports%20started%20failing%20with%20%23name%2C%20%23error.%20I%20have%20not%20changed%20them%20or%20the%20database%20since%20everything%20was%20working%20fine%20about%20a%20week%20ago.%20After%20a%20fair%20bit%20of%20invetigation%2C%20It%20seems%20to%20do%20with%20the%20Trim%2C%20UCase%20functions.%20Remove%20them%20and%20the%20reports%20work%2C%20put%20them%20back%20and%20they%20fail.%20Date%20function%20also%20stopped%20working.%20Been%20back%20to%20a%20few%20backups%20that%20were%2Fare%20fine%20and%20same%20problem%20so%20seems%20to%20be%20the%20App%20rather%20than%20database.%20Any%20known%20issue%2Fchange%20from%20recent%20updates%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1429453%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1429753%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Report%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429753%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684671%22%20target%3D%22_blank%22%3E%40Dave_C1305%3C%2FA%3E%26nbsp%3BThe%20symptoms%20you%20describe%20are%20often%20(but%20not%20always)%20caused%20by%20missing%20references%20which%20causes%20VBA%20not%20to%20compile.%20Start%20there.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Missingreferences.png%22%20style%3D%22width%3A%20943px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195570iE5203248D11BE633%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Missingreferences.png%22%20alt%3D%22Missingreferences.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20that%20is%20not%20the%20problem%2C%20post%20back.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1432719%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Report%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3BHi%20George%2C%20Thank%20you%20very%20much%20for%20responding.%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20I%20do%20have%20a%20missing%20reference%20Microsoft%20OLE%20DB%20Provider%20for%20OLAP%20Services%20connection%20dialog%208.0%20in%20MSOLUI80.DLL.%3C%2FP%3E%3CP%3EI%20don't%20know%20how%20to%20fix%20that.%20I%20have%20had%20a%20missing%20.DLL%20and%20simply%20copied%20it%20into%20my%20DB%20file%20directory.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1432788%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Report%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432788%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684671%22%20target%3D%22_blank%22%3E%40Dave_C1305%3C%2FA%3E%26nbsp%3BI%20just%20removed%20the%20missing%20reference%20and%20all%20seems%20fine.%20Thank%20yo%20again%20for%20your%20help.%20It%20is%20much%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, I'm using Access from my Office 365 suite subscription for a club register database that's been operating and changed fine. Recently, a number of reports started failing with #name, #error. I have not changed them or the database since everything was working fine about a week ago. After a fair bit of invetigation, It seems to do with the Trim, UCase functions. Remove them and the reports work, put them back and they fail. Date function also stopped working. Been back to a few backups that were/are fine and same problem so seems to be the App rather than database. Any known issue/change from recent updates?

4 Replies
Highlighted

@Dave_C1305 The symptoms you describe are often (but not always) caused by missing references which causes VBA not to compile. Start there.Missingreferences.png

 

If that is not the problem, post back.

 

 

Highlighted

@George Hepworth Hi George, Thank you very much for responding. 

Yes I do have a missing reference Microsoft OLE DB Provider for OLAP Services connection dialog 8.0 in MSOLUI80.DLL.

I don't know how to fix that. I have had a missing .DLL and simply copied it into my DB file directory.

Highlighted

@Dave_C1305 I just removed the missing reference and all seems fine. Thank yo again for your help. It is much appreciated!

Highlighted

@Dave_C1305 

Congratulations on solving the problem.

 

Continued success with your project.