Error message on first time Button is pressed

[Tom d]

From the Main Menu the first time the add a authors name button is pressed, I receive an error message. After the first time there is no error message.

 

[theDBguy]

Hi. I opened your file but didn't get an error.

 

[Tom d]

From the Main Menu the first time the add a authors name button is pressed, I receive an error message. After the first time there is no error message.

What version are you running

 

[Gasman]

I receive an error message.

And you could not possible tell us what that error message was?

 

[theDBguy]

What version are you running

Assuming you were asking me, I'm using 2016.

 

[Tom d]

The error message is Your Microsoft Access Database or project contains a missing or broken reference to the file 'Argisversion.dll' version 1.0

 

[NauticalGent]

I also do not get the error, however I did look at your references and noticed this:

I unchecked it, debug/compiled it, and everything worked fine like before.

 

[Gasman]

I get the same error

 

[Tom d]

And you could not possible tell us what that error message was?

The error message is Your Microsoft Access Database or project contains a missing or broken reference to the file 'Argisversion.dll' version 1.0

 

[Gasman]

I would start looking here?

arcgsiversion - Google Search

Why do you need that reference BTW?

 

[NauticalGent]

Why do you need that reference BTW?

I would say no...

 

[Gasman]

I removed the reference and it still appears to work?

 

[Pat Hartman]

The code will work without the reference as long as no procedure from the library is called. It won't compile though.

 

[Tom d]

I also do not get the error, however I did look at your references and noticed this:

View attachment 116701
I unchecked it, debug/compiled it, and everything worked fine like before.

I am new to access. How did you get to this screen, what do you mean debug/compiled it

 

[Gasman]

The code will work without the reference as long as no procedure from the library is called. It won't compile though.

Compiled for me?

 

[Pat Hartman]

OK. Please read my entire reply. If it compiled for you, then, the code of the library is never referenced.

 

[NauticalGent]

I am new to access. How did you get to this screen, what do you mean debug/compiled it

I am currently away on and errand. @Gasman or @Pat Hartman can you assist?

 

[Pat Hartman]

If you are asking how to get to the References screen:
1. Open the VBE to any code module
2. Click on Tools
3. Click on References
4. Uncheck the library that is marked as missing

If you actually need to use this library, then unchecking it will simply move the error to a different part of the application. If you need to use the code, you need the reference. If you need the referenced library, you MUST install it on all PC's where your application needs to run.

 

[Gasman]

Press Alt and F11 keys together. That will give you the VBA window (where all the code is located).
Then when there click Tools/References from the menu bar.
That will show you all the references used. Yours will show missing. Untick that one and press OK.

Now you will be back at the VBA window.
Now click Debug/Compile <YourDBname>

Hopefully that should not produce any errors as was the case with me.

If it does show an error(s), then report back as to what they are.
If it does not, then try the DB as it is.

 

[Tom d]

If you are asking how to get to the References screen:
1. Open the VBE to any code module
2. Click on Tools
3. Click on References
4. Uncheck the library that is marked as missing

If you actually need to use this library, then unchecking it will simply move the error to a different part of the application. If you need to use the code, you need the reference. If you need the referenced library, you MUST install it on all PC's where your application needs to run.

Figured it out and it worked. Thank You