Have code compiled on A2013 that won't compile on A2016

[GraeagleBill]

I have an app, "SDMA-V1.0-Source.accdb", that I am wanting to install on a system with A2016. The first error was the "Right" function isn't found, and also "Mid" function not found. The HELP for the condition is basically Project or Reference not found. I believe I have all the A2016 reference libraries referenced, so I'm at a loss as how to resolve. If someone has A2016 on their system and can tell me how to post the accdb, I will be most grateful. (There's actually 3 dbs, one front end and two BEs.)

These three db's are stored on my Google Drive

Here's the Front End: https://drive.google.com/open?id=1eS...0&usp=drive_fs


BE#1https://drive.google.com/open?id=1eq...I&usp=drive_fs
BE#2https://drive.google.com/open?id=1EF...P&usp=drive_fs

[madpiet]

One of the libraries is missing. Open a code module (doesn't matter which one, and then Tools>References... look for any that are marked as MISSING. Check those and recompile.

[GraeagleBill]

Maybe I missed one??? But yes, the compiler help mentioned that possibility and so I looked in the References but didn't see one marked 'MISSING', so not sure until I have access to the client machine at the moment. Maybe someone with A2016 can download the db and flush out the problem.

[madpiet]

I would go into a code window and try to compile it. If there's an error somewhere, it will fail. Then it should show you where it failed.

[GraeagleBill]

I already wrote in the OP that the functions Right and Mid could not be found

[GraeagleBill]

It wasn't until I opened a general module in design view that a couple of references were MISSING. Both were in reference to Acrobat, which makes me think that there's still a snake in the grass, as why fail the compile because the compiler can't find the "Right" and "Mid" functions, they are not related to Acrobat.

[madpiet]

I'd dig around on maybe stackoverflow or another bigger website.

https://stackoverflow.com/questions/...-compile-error

Try creating a blank database and importing everything. Then recompile. One of your library references is screwed up.

[Welshgasman]

I have an app, "SDMA-V1.0-Source.accdb", that I am wanting to install on a system with A2016. The first error was the "Right" function isn't found, and also "Mid" function not found. The HELP for the condition is basically Project or Reference not found. I believe I have all the A2016 reference libraries referenced, so I'm at a loss as how to resolve. If someone has A2016 on their system and can tell me how to post the accdb, I will be most grateful. (There's actually 3 dbs, one front end and two BEs.)

These three db's are stored on my Google Drive

Here's the Front End: https://drive.google.com/open?id=1eS...0&usp=drive_fs
BE#1https://drive.google.com/open?id=1eq...I&usp=drive_fs
BE#2https://drive.google.com/open?id=1EF...P&usp=drive_fs

BEs have Access denied?

FE gives me as Missing
Acrobat Scan 1.0 Type Library
Adobe Acrobat 10.0 Type Library


so how are we meant to compile this?

[Welshgasman]

It wasn't until I opened a general module in design view that a couple of references were MISSING. Both were in reference to Acrobat, which makes me think that there's still a snake in the grass, as why fail the compile because the compiler can't find the "Right" and "Mid" functions, they are not related to Acrobat.

Have a read of this thread
https://www.tek-tips.com/threads/lef...ht-right.6094/

[June7]

I have encountered this. A missing library causes intrinsic functions to not work even when the library seems to have nothing to do with the functions. I opened your db in Access 2021 and see only Acrobat Scan library is missing.

I removed the reference then functions work and code compiles.

Compact & Repair reduces file size by 6mb. Should always do that before posting.

[GraeagleBill]

Problem went away as soon as I removed the app's dependency on Acrobat to do PDF file combining function for the app. To bad OutputToReport doesn't have an Append option, as that would have made things simple. Same app now has a new problem. New post "Access seems to forget what acFormatPDF" means?"

[GraeagleBill]

Well, Ha Ha, Access didn't forget anything.