Function is not availalbe in expressions in query expression error message (0/1)

[repent34]

I recently received this error message when opening the source DB in
Access 2007.

I have attached two jpg pics.

Does this error message give enough details for someone to point me in
the right direction for a fix?

The last time I developed and worked in this DB everything worked
fine.

I get this error when clicking on a control that runs a query macro
against a backend DB consisting of about 15 tables.

I should mention the error comes into play when trying to run the
frontend on a client W/S. I don't see the error while on my W/S which
is my developer W/S and has Access 2007. The clients running the
front end have the MS Access Runtime installed.

thanks for any and all help

 

[Gina Whipp]

Check the References on your Client's machine. Sounds like ther might be
one missing.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I recently received this error message when opening the source DB in
Access 2007.

I have attached two jpg pics.

Does this error message give enough details for someone to point me in
the right direction for a fix?

The last time I developed and worked in this DB everything worked
fine.

I get this error when clicking on a control that runs a query macro
against a backend DB consisting of about 15 tables.

I should mention the error comes into play when trying to run the
frontend on a client W/S. I don't see the error while on my W/S which
is my developer W/S and has Access 2007. The clients running the
front end have the MS Access Runtime installed.

thanks for any and all help

 

[repent34]

Can I do that if they only have the Access Runtime installed? I didn't
have to check anyrthing when I set them up, I only installed the
Runtime and supplied them with the Access front end on their desktop
and it all ran fine. Not sure where or why it broke. Can you advise
me fiurther please?

chris

 

[Gina Whipp]

Oh dear... missed that last line, no you can't but it surely sounds like a
Reference issue. Okay, when you open the database on your machine what
References are set?

As a side note, stop using your real eMail address as the Spammers will
harvest!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Can I do that if they only have the Access Runtime installed? I didn't
have to check anyrthing when I set them up, I only installed the
Runtime and supplied them with the Access front end on their desktop
and it all ran fine. Not sure where or why it broke. Can you advise
me fiurther please?

chris

 

[Bob Barrows]

I recently received this error message when opening the source DB in
Access 2007.

I have attached two jpg pics.

Does this error message give enough details for someone to point me in
the right direction for a fix?

The last time I developed and worked in this DB everything worked
fine.

I get this error when clicking on a control that runs a query macro
against a backend DB consisting of about 15 tables.

I should mention the error comes into play when trying to run the
frontend on a client W/S. I don't see the error while on my W/S which
is my developer W/S and has Access 2007. The clients running the
front end have the MS Access Runtime installed.

thanks for any and all help

You will need to use one of the subroutines available on the web to identify
and perhaps fix the missing References on that machine. I know a couple of
MVPs have versions of that sub on their websites. Here's one:
http://www.access-programmers.co.uk/forums/showthread.php?t=92526

There are more to be found via this google search:
http://www.google.com/search?rlz=1C...rome&ie=UTF-8&q=access+vba+missing+references

 

[Repent34]

can you tell me where in my DB I need to place that code?

 

[Repent34]

Gina;

on my laptop, I have MS Access 2007 installed. I have also installed
the "developers extensions" as well as the "Save as PDF or XPF"
add-ins.

The client workstations only have the Access Runtime installed.

The references I have installed on my W/S, by looking in the MS Visual
Basic Editor/Tools/References are:

Visual Basic for Applications
Microsoft Access 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Access database engine Object Library
Microsoft Outlook 12.0 Object Library

chris

 

[Repent34]

I've done quite alot of testing on this issue. what I've found out,
is that if I remove a sendmail macro action from a button on a form,
as well as removing the VBS code under the editor, save everything,
create another accde file and publish to my client, I now don't
receive this error, and everything seems to be back to normal, except
of course when the user clicks on the button, to drive the macro that
does a send mail funtion, nothing happens. I just need to fix that
part. I'll try to do this and post back my results.

the T/S I did consisted of removing various parts of my forms, code,
controls, etc until I removed the above referenced control for
sendmail that resolved the issue.

Do this sound familiar to anyone?

chris

 

[Repent34]

Looks like my issue is finally resolved. I ended up having to remove
the macro for the sendobject, in this case, email. I then recreated
it from scratch and everything is back working.

If there is an easier way to discover the problem, I sure wish someone
would share it with me. I may run into this issue again.

BTW, I had tried creating a new blank DB, then importing over all
forms, controls, queries, etc. Still had the same error. Only after
deleting the macro and underlying code and recreating it did I get a
solution.

chris

 

[Gina Whipp]

Not sure what happened with SendObject... and that is not a Reference
issue. Unfortunately, tracking down errors is sometimes tedious (and
annoying). Did you change anything in the macro that would indicate what
part thru up the error?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

in message
Looks like my issue is finally resolved. I ended up having to remove
the macro for the sendobject, in this case, email. I then recreated
it from scratch and everything is back working.

If there is an easier way to discover the problem, I sure wish someone
would share it with me. I may run into this issue again.

BTW, I had tried creating a new blank DB, then importing over all
forms, controls, queries, etc. Still had the same error. Only after
deleting the macro and underlying code and recreating it did I get a
solution.

chris