Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / March 2006

Tip: Looking for answers? Try searching our database.

Funtion is not available in expressions in query expression

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kent - 27 Sep 2004 19:41 GMT
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?
Ken Snell [MVP] - 27 Sep 2004 19:52 GMT
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

Signature

       Ken Snell
<MS ACCESS MVP>

> I have a multi-user Access database that has been running
> well on 3 different workstations.  Only now, for some
[quoted text clipped - 24 lines]
>
> What could be missing?
- 27 Sep 2004 20:54 GMT
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.
[quoted text clipped - 57 lines]
>
>.
rafmarce - 14 Mar 2006 16:48 GMT
>If references are messed up -- you can get that Undefined Function message.
>
[quoted text clipped - 31 lines]
>>
>> What could be missing?

Great!!!!!!
I experienced the same problem with XP but thank you in a few steps (unselect
a selected reference; back out of the dialog; go back in and select the
reference just unselected) I solved it.
Greetings from Rome, Italy
Paul - 27 Sep 2004 19:56 GMT
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.

Signature

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 have a multi-user Access database that has been running
> well on 3 different workstations.  Only now, for some
[quoted text clipped - 24 lines]
>
> What could be missing?
- 27 Sep 2004 20:53 GMT
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.
[quoted text clipped - 31 lines]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.