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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
#6
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|