Funtion is not available in expressions in query expression

  • Thread starter Thread starter Kent
  • Start date Start date
K

Kent

I have a multi-user Access database that has been running
well on 3 different workstations. Only now, for some
reason, I have a user that does not run a form correctly
any more. I've found the problem to be that the query
that is defined as the records source for a control cannot
perform a simple MID statement. The error I'm getting is
the following:

Run-Time error '3075':

Funtion is not available in expressions in query expression
'Mid([FieldName],7,5)'.

Other machines are running this same form with no
problems. The user having this problem, does not display
when the control populates. It just simply does not
populate the control with any values. I openned the
problem control and attempted to run the record source
query directly in a query window. This is when the error
was displayed.

All machines are running Windows XP. The only difference
I know of is that the problem station was upgraded with
the Service Pack 2. I hesitate mentioning that, because I
don't really see how that could be the problem ... but it
is the only difference I know of.

What could be missing?
 
If references are messed up -- you can get that Undefined Function message.

Try following these steps (from a post by Douglas Steele, MVP):

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://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--

Ken Snell
<MS ACCESS MVP>


Kent said:
I have a multi-user Access database that has been running
well on 3 different workstations. Only now, for some
reason, I have a user that does not run a form correctly
any more. I've found the problem to be that the query
that is defined as the records source for a control cannot
perform a simple MID statement. The error I'm getting is
the following:

Run-Time error '3075':

Funtion is not available in expressions in query expression
'Mid([FieldName],7,5)'.

Other machines are running this same form with no
problems. The user having this problem, does not display
when the control populates. It just simply does not
populate the control with any values. I openned the
problem control and attempted to run the record source
query directly in a query window. This is when the error
was displayed.

All machines are running Windows XP. The only difference
I know of is that the problem station was upgraded with
the Service Pack 2. I hesitate mentioning that, because I
don't really see how that could be the problem ... but it
is the only difference I know of.

What could be missing?
Click to expand...
 
It is very likely that you have a missing reference on the PC in question.
Open any code module and select Tools|References. If any are missing,
you'll need to correct that condition.

--
Michael Badnarik for President '04
Libertarian...the freedom party
www.lp.org
www.badnarik.org

"If you are in prison and your chances are 50% for execution by electric
chair, 45% for execution by lethal injection, and 5% for escape, are you
just going to vote for the chair because it is the likeliest outcome?" Vote
Libertarian and live to be free.
 
I appreciate that. However, that was the 1st thing I
looked for and none are missing.
-----Original Message-----
It is very likely that you have a missing reference on the PC in question.
Open any code module and select Tools|References. If any are missing,
you'll need to correct that condition.

--
Michael Badnarik for President '04
Libertarian...the freedom party
www.lp.org
www.badnarik.org

"If you are in prison and your chances are 50% for execution by electric
chair, 45% for execution by lethal injection, and 5% for escape, are you
just going to vote for the chair because it is the likeliest outcome?" Vote
Libertarian and live to be free.

Kent said:
I have a multi-user Access database that has been running
well on 3 different workstations. Only now, for some
reason, I have a user that does not run a form correctly
any more. I've found the problem to be that the query
that is defined as the records source for a control cannot
perform a simple MID statement. The error I'm getting is
the following:

Run-Time error '3075':

Funtion is not available in expressions in query expression
'Mid([FieldName],7,5)'.

Other machines are running this same form with no
problems. The user having this problem, does not display
when the control populates. It just simply does not
populate the control with any values. I openned the
problem control and attempted to run the record source
query directly in a query window. This is when the error
was displayed.

All machines are running Windows XP. The only difference
I know of is that the problem station was upgraded with
the Service Pack 2. I hesitate mentioning that, because I
don't really see how that could be the problem ... but it
is the only difference I know of.

What could be missing?
Click to expand...


.
Click to expand...
 
Thank your Mr. Snell. I'll give that a shot. I
appreciate the response.
-----Original Message-----
If references are messed up -- you can get that Undefined Function message.

Try following these steps (from a post by Douglas Steele, MVP):

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://members.rogers.com/douglas.j.steele/AccessReference Errors.html

--

Ken Snell
<MS ACCESS MVP>


Kent said:
I have a multi-user Access database that has been running
well on 3 different workstations. Only now, for some
reason, I have a user that does not run a form correctly
any more. I've found the problem to be that the query
that is defined as the records source for a control cannot
perform a simple MID statement. The error I'm getting is
the following:

Run-Time error '3075':

Funtion is not available in expressions in query expression
'Mid([FieldName],7,5)'.

Other machines are running this same form with no
problems. The user having this problem, does not display
when the control populates. It just simply does not
populate the control with any values. I openned the
problem control and attempted to run the record source
query directly in a query window. This is when the error
was displayed.

All machines are running Windows XP. The only difference
I know of is that the problem station was upgraded with
the Service Pack 2. I hesitate mentioning that, because I
don't really see how that could be the problem ... but it
is the only difference I know of.

What could be missing?
Click to expand...


.
Click to expand...
 
Back
Top