Problems with VBA Code after changing to Office365

[surfbinu]

Hi guys,

I am not an expert at all in Access . I took over a file with deadlines from a colleague. He used Access2010, I use now Access from Office365.

When I open the Access file, the system says it looks for the reference file OFFOWC.DLL. Afterwords when I want to open a Report, it tells me that there is an error in the VBA Code.
Can anyone help me? The file is attached.

Thank you very much in advance:
Albin

[ranman256]

whenever you do an upgrade this will happen and you must fix the broken references,

Enter VBE (Alt-F11)
menu: tools , references,
look for the checked item marked MISSING
uncheck it,
find the new version in the list and check it.

the code should work now.

[surfbinu]

that comment really helped me, thanks a lot!

whenever you do an upgrade this will happen and you must fix the broken references,

Enter VBE (Alt-F11)
menu: tools , references,
look for the checked item marked MISSING
uncheck it,
find the new version in the list and check it.

the code should work now.

[ssanfu]

Welcome to the forum......

I see several things that should be fixed.

You have a standard module named "Date". "Date" is a reserved work and shouldn't be used as object names.
You also have a field name of "Nummer" (Number). "Number" is also a reserved word.
Here is a list of reserved words that shouldn't be used as object names.

You have a couple of Macros where the name begins with a number. Never begin names with a number.

The top two lines in any module should be

Option Compare Database   'Use database order for string comparisons
Option Explicit

Good luck with your project.....