Error Message 3075

[Len]

I have been running this standard query for two years. All of a sudden I get
this error message.

Run Time Error 3075

I am searching for the first character of a middle school name.

Left([MSLName],1)

Does anyone know why they have stopped working????

I am sure I need to insert something or download a patch? Does anyone know
what I can do?

Thank You

Len

 

[raskew via AccessMonster.com]

Len,

Post some data and some code so we can see what you're encountering.

Bob

I have been running this standard query for two years. All of a sudden I get
this error message.

Run Time Error 3075

I am searching for the first character of a middle school name.

Left([MSLName],1)

Does anyone know why they have stopped working????

I am sure I need to insert something or download a patch? Does anyone know
what I can do?

Thank You

Len

 

[Len]

Dim stDocName As String

stDocName = "PrtCntPgsAppTXA"
DoCmd.OpenQuery stDocName, acNormal, acEdit

' Code in Query is

Expr1: Left([LOCATION],1) ' Is The Field

The Field is sorted in asending Order

It is happening to every query where I use the Left Function

Thanks for getting back to me!

Len,

Post some data and some code so we can see what you're encountering.

Bob

I have been running this standard query for two years. All of a sudden I get
this error message.

Run Time Error 3075

I am searching for the first character of a middle school name.

Left([MSLName],1)

Does anyone know why they have stopped working????

I am sure I need to insert something or download a patch? Does anyone know
what I can do?

Thank You

Len

 

[John Spencer]

Len,
Have you upgraded or installed software recently? This sounds like it
could be a references issue.

To do its job, Access makes use of various external program and object
libraries. If you move a database from one machine to another, these
references may be "broken".

When this happens, you need to take steps to let Access repair the
reference(s) ON THE COMPUTER WHERE THE FAILURE IS OCCURRING.

Here are MVP Doug Steele's instructions for how to do it:

*** Quote ***

Any time functions that previously worked suddenly don't, the first
thing to suspect is a references problem.

This can be caused by differences in either the location or file version
of certain files between the machine where the application was
developed, and where it's being run (or the file missing completely from
the target machine). Such differences are common when new software is
installed.

On the machine(s) where it's not working, open any code module (or open
the Debug Window, using Ctrl-G, provided you haven't selected the "keep
debug window on top" option). Select Tools | References from the menu
bar. Examine all of the selected references.

If any of the selected references have "MISSING:" in front of them,
unselect them, and back out of the dialog. If you really need the
reference(s) you just unselected (you can tell by doing a Compile All
Modules), go back in and reselect them.

If none have "MISSING:", select an additional reference at random, back
out of the dialog, then go back in and unselect the reference you just
added. If that doesn't solve the problem, try to unselect as many of the
selected references as you can (Access may not let you unselect them
all), back out of the dialog, then go back in and reselect the
references you just unselected. (NOTE: write down what the references
are before you delete them, because they'll be in a different order when
you go back in)

For far more than you could ever want to know about this problem, check out
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Just so you know: the problem will occur even if the library that
contains the specific function that's failing doesn't have a problem.

**** End Quote ****