Can't find project or library

[N1755L]

Hello everyone,

What is wrong with my Access? The Str() function is a basic, how can this function be missing? I had a problem not so long ago with not being able to change background colors via VBA 'cause, I'm almost certain, the same error message.

Any ideas welcome. Somehow my Access installation is broken, or my HD is dying? Haven't noticed any other errors with my system though.

I've included a screenshot. Any ideas/suggestions welcome.

 

[MarkK]

Sometimes you can fix that just by changing the priority of a reference. Open the references viewer, select an optional reference, like ACE or DAO, and move it up or down the list.

 

[N1755L]

Life used to be simple, easy, things used to be "findable", before ^$#%$@%* MS went and messed up the lovely, accessible, workable, infinitely useful menu bar, and replaced it with idiotic ribbons, which have some merit in some places, but NOT to the exclusion of the menu bar.

In the days of yore, I remember going to the menu bar to find the references section you mention, but as usual, MS has now made it cumbersome and time-consuming to find anything you're not intimately familiar with.

May I ask how you would get to the references in this crippled version of Access?

Many thanks.

 

[MarkK]

Open a code window (which has no ribbon), go to Tools, first item is References, there is a window with a list. Highlight a reference other than VBA, OLE, or Access, and click the up or down button to change priority. Click OK. See if that helps,

 

[N1755L]

Open a code window (which has no ribbon), go to Tools, first item is References, there is a window with a list. Highlight a reference other than VBA, OLE, or Access, and click the up or down button to change priority. Click OK. See if that helps,

Thanks Mark,

That did the trick!