A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old May 4th, 2010, 12:10 AM posted to microsoft.public.access.queries
[email protected]
external usenet poster
 
Posts: 4
Default Function is not availalbe in expressions in query expression error message (0/1)

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
  #2  
Old May 4th, 2010, 12:36 AM posted to microsoft.public.access.queries
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Function is not availalbe in expressions in query expression error message (0/1)

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

wrote in message
...
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

  #3  
Old May 4th, 2010, 03:33 PM posted to microsoft.public.access.queries
[email protected]
external usenet poster
 
Posts: 4
Default Function is not availalbe in expressions in query expression error message (0/1)

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


On Mon, 3 May 2010 19:36:10 -0400, "Gina Whipp"
wrote:

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

  #4  
Old May 5th, 2010, 12:56 AM posted to microsoft.public.access.queries
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Function is not availalbe in expressions in query expression error message (0/1)

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

wrote in message
...
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


On Mon, 3 May 2010 19:36:10 -0400, "Gina Whipp"
wrote:

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


  #5  
Old May 5th, 2010, 02:40 AM posted to microsoft.public.access.queries
Bob Barrows
external usenet poster
 
Posts: 475
Default Function is not availalbe in expressions in query expression error message (0/1)

wrote:
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/...ad.php?t=92526

There are more to be found via this google search:
http://www.google.com/search?rlz=1C1...ing+references

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


  #6  
Old May 5th, 2010, 07:42 PM posted to microsoft.public.access.queries
Repent34[_2_]
external usenet poster
 
Posts: 7
Default Function is not availalbe in expressions in query expression error message (0/1)

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







On Tue, 4 May 2010 21:40:48 -0400, "Bob Barrows"
wrote:

wrote:
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/...ad.php?t=92526

There are more to be found via this google search:
http://www.google.com/search?rlz=1C1...ing+references

  #7  
Old May 5th, 2010, 08:27 PM posted to microsoft.public.access.queries
Repent34[_2_]
external usenet poster
 
Posts: 7
Default Function is not availalbe in expressions in query expression error message (0/1)

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 a

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




On Tue, 4 May 2010 19:56:51 -0400, "Gina Whipp"
wrote:

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!

  #8  
Old May 5th, 2010, 09:11 PM posted to microsoft.public.access.queries
Repent34[_2_]
external usenet poster
 
Posts: 7
Default Function is not availalbe in expressions in query expression error message (0/1)

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



On Mon, 3 May 2010 19:36:10 -0400, "Gina Whipp"
wrote:

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

  #9  
Old May 5th, 2010, 10:23 PM posted to microsoft.public.access.queries
Repent34[_2_]
external usenet poster
 
Posts: 7
Default Function is not availalbe in expressions in query expression error message (0/1)

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






On Wed, 05 May 2010 13:11:59 -0700, Repent34 wrote:

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



On Mon, 3 May 2010 19:36:10 -0400, "Gina Whipp"
wrote:

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

  #10  
Old May 6th, 2010, 03:39 AM posted to microsoft.public.access.queries
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Function is not availalbe in expressions in query expression error message (0/1)

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

"Repent34" wrote 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






On Wed, 05 May 2010 13:11:59 -0700, Repent34 wrote:

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



On Mon, 3 May 2010 19:36:10 -0400, "Gina Whipp"
wrote:

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.