I'm developing an app in Access2000.  It runs great on my PC.  My user is
100 miles away and is running a full license of Access2000 as well.  The
user receives "Run Time Error 3075 - Function not available in query
expression" on a form with a combo box referencing a query.  Any ideas why
the user would get a Run Time Error when they're actually running a full
license of Access??

Thanks in advance,
Rob Lehman

Rob,

There is most likely a missing reference on the user's machine - see
http://www.mvps.org/access/bugs/bugs0001.htm for details.

Simon Lewis

Hi Simon,
I've had the same problem  of  Rob:
("I'm developing an app in Access2000.  It runs great on my PC.  My user is
100 miles away and is running a full license of Access2000 as well.  The
user receives "Run Time Error 3075 - Function not available in query
expression" on a form with a combo box referencing a query.  Any ideas why
the user would get a Run Time Error when they're actually running a full
license of Access?? Thanks in advance, Rob Lehman")
but the solution wos not the missing referens but the different version of
JetEngine: 3.5 on my machine, 3.51 on user machine. How can I prevent this?
Thanks to everybody

Michela

Hi,
I'm developing an app in A97; it runs on my PC but not on some users' PC.
We have found the problem: different version of MJetEngine: on my pc is 3.5,
on others is 3.51.
How can I prevent this?
Thanks a lot
Miki

I had a similar problem last week!!!  I have created a simple function that
converts DB2 date stamps into a normal date format (very simple function)

I have been using the function in a SET... UPDATE sql executed against data
downloaded and then imported of an AS400  (I'm straying from the point
now..)

db.execute "UPDATE tblImportData SET sampleDate = dateDB2dattim(enddattim)"

It stopped working on a pc I was working on, making some changes to the
overall import process.  I mucked around taking the function into another
simple dummy function and debuging,  all I got was the error mentioned by
Rob & Simon - "Run Time Error 3075 - Function not available in query
expression"

I rebooted and it worked...  This has happened since and rebooting resolves
the problem.

Another problem I have noticed is that a form I have designed with two
listboxes and a couple of buttons for moving items to and thro between the
boxes works only when I do not hold the shift key down on entering the
database. (I have disabled everything in the startup dialog box for enduser
use) When not holding down the shift key the start up form frmMain does not
open, opening this manually and then opening the form in question, would
produce exactly the same results? No! Items in the listboxes don't appear
when moved. The screen does not seem to be refreshing properly!  I have
stepped through the code, and it works perfectly, (when stepping [slowly])
so I started placing DoEvents and lots of .requery & .refresh methods all
over the place but this doesn't help. I have given up as when users use the
system (without holding down the shift key) everything is OK!

Any Ideas.

Graeme.