473,836 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Function not available

492 Contributor
For some reason one of my users is getting a function not available on a Access 2007 program that has been running on other computers with no problem. The computer she is using is a new 64bit machine running windows 7. The program has never been installed on this machine, I sent her the installation program (I use the developer package solutions) but now when she tries to run the program she get this function not available, the statement is a DMAX("Mid statement. I know this is a missing reference but for the life of me I can't figure out which one is missing. If anybody can point me in the correct direction I would appreciate it. Also is there any way to find which ref is missing in a compiled program?
Thanks for any help.
Jul 12 '11 #1
25 7193
8,834 Recognized Expert Expert
Expand|Select|Wrap|Line Numbers
  1. Dim ref As Reference
  3. Debug.Print "Reference", "Broken?", "Absolute PATH"
  4. Debug.Print "--------------------------------------------------------------------------------------------------"
  6. For Each ref In Application.References
  7.   Debug.Print ref.Name, IIf(ref.IsBroken, "Yes", "No"), ref.FullPath
  8. Next
  10. Debug.Print "--------------------------------------------------------------------------------------------------"
Sample OUTPUT:
Expand|Select|Wrap|Line Numbers
  1. Reference     Broken?       Absolute PATH
  2. --------------------------------------------------------------------------------------------------
  3. VBA           No            C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
  4. Access        No            C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB
  5. stdole        No            C:\WINDOWS\system32\stdole2.tlb
  6. DAO           No            C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
  7. ADODB         No            C:\Program Files\Common Files\System\ADO\msado21.tlb
  8. Outlook       No            C:\Program Files\Microsoft Office\OFFICE11\msoutl.olb
  9. Office        Yes           C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL
  10. MSComctlLib   No            C:\WINDOWS\system32\MSCOMCTL.OCX
  11. Scripting     No            C:\WINDOWS\system32\scrrun.dll
  12. Excel         No            C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE
  13. --------------------------------------------------------------------------------------------------
Jul 12 '11 #2
CD Tom
492 Contributor
Thanks for the quick reply. I've added this code to my program but when I run it I get the following message. Method 'FullPath' of object 'Reference' failed
Not sure what this means or what I'm doing wrong.
Jul 12 '11 #3
8,834 Recognized Expert Expert
Very strange Tom, let's go to Plan 'B'. Try listing the GUID instead, yoou can always reference this Value in the System Registry, then extract related information.
Expand|Select|Wrap|Line Numbers
  1. Dim ref As Reference
  3. Debug.Print "Reference", "Broken?", "GUID"
  4. Debug.Print "--------------------------------------------------------------------"
  6. For Each ref In Application.References
  7.   Debug.Print ref.Name, IIf(ref.IsBroken, "Yes", "No"), ref.Guid
  8. Next
  10. Debug.Print "--------------------------------------------------------------------"
Sample OUTPUT:
Expand|Select|Wrap|Line Numbers
  1. Reference     Broken?       GUID
  2. --------------------------------------------------------------------
  3. VBA           No            {000204EF-0000-0000-C000-000000000046}
  4. Access        No            {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}
  5. stdole        No            {00020430-0000-0000-C000-000000000046}
  6. DAO           No            {00025E01-0000-0000-C000-000000000046}
  7. ADODB         No            {00000201-0000-0010-8000-00AA006D2EA4}
  8. Outlook       No            {00062FFF-0000-0000-C000-000000000046}
  9. Office        Yes           {2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}
  10. MSComctlLib   No            {831FDD16-0C5C-11D2-A9FC-0000F8754DA1}
  11. Scripting     No            {420B2830-E718-11CF-893D-00A0C9054228}
  12. Excel         No            {00020813-0000-0000-C000-000000000046}
  13. --------------------------------------------------------------------
Jul 12 '11 #4
CD Tom
492 Contributor
Ok, that worked and I can see the results in the immediate window. How do I execute this on a compiled runtime program that is on a different machine?
Jul 12 '11 #5
CD Tom
492 Contributor
I tried running the Check Ref program on my users machine and doesn't give me any answers. Do you know what reference or .dll is used for the following function. Max(mid(warmupc omment),1,4) that's the function that shows up in the error window. The exact message is Function is not available in expressions in query expression Max(mid(warmupc omment),1,4) this works on all other machines that has the program loaded. I've looked at all the references in my machine and then using windows explorer have compared then to what's on her machine by looking in the directories for the same files. It looks like everything is there. She doesn't have Access loaded on her machine or I would send the actual program and look at it there.
Right now I'm at a loss as what to do, so any help is greatly appreciated.

I did find a couple of references that were missing on her machine and copied those over. Do I need to do something else besides just coping them?

Jul 12 '11 #6
32,584 Recognized Expert Moderator MVP
Tom, Is the capitalisation correct in the error message you posted? If it is then you appear to have problems with both the Mid and the warmupcomment references.
Jul 13 '11 #7
CD Tom
492 Contributor
I probably didn't type it exactly as should have been. However the statement works on all other systems except the one machine. I've developed the program on windows 7 on a 32bit machine, but I have a laptop that is a 64bit with windows 7 and it works fine on that machine. I can't get back on her machine until tomorrow so I will try and get the exact spelling. Although I don't think that's the problem.
Jul 13 '11 #8
759 Contributor
Just an idea: Compare references and see what references are in the computer where your program run without problems and are NOT in a computer where your program do not make the job.
Jul 13 '11 #9
CD Tom
492 Contributor
The only way I've been able to check the references is by opening the program on my machine and going to the references looking at where the reference is located and then using explorer on the other machine checking the reference location and see if it is there. Like I mentioned earlier I have found a couple that were missing and have copied them from my computer to the other machine. I guess my question, is just coping them to the other machine all I needed to do or do I need to do something else?
Jul 13 '11 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Ken VdB | last post by:
Hi everyone, Is there a reason why the Mid() function only works in one direction in VBScript? This code works in VB6 but not in VBScript? Is there a way around it? I am trying to create an ASP page which produces a fixed width text file for import into a third party legacy application which I don't have control over. --code sample-- Dim strSomeString
by: wavelet | last post by:
Hi, I am searching one time function under windows2000 with Visual C++ environment. Is there function available like gethrtime() in unix? Thx. #include <sys/time.h> main()
by: aaapaul | last post by:
Hello ! I have some values stored in a xml-file. When starting my application, I read this file and store the values in a collection object. My problem is the error-handling, if the fieldname does not exist. I dont want to use try and catch. The indexof-function to check would be better, but it is not available.
by: Yannick Warnier | last post by:
Hi there, I'd like to know since what version the md5() function is available in postgresql. I didn't find the function in the doc (I tried looking at some of the different function types in the user doc). Also, how may I find it by myself? Is there a complete list of function names and description somewhere? Thanks,
by: nishit.gupta | last post by:
Is their any single fuction available in C++ that can determine that a string contains a numeric value. The value cabn be in hex, int, float. i.e. "1256" , "123.566" , "0xffff" , It can also contain zero
by: reeteshsingh | last post by:
All, I am using ibm db2 8 release. i found out that timestampadd function is available only in version 9 not in 8. can you please suggest if there is any similar function available in version 8 or otherwise how can i handle adding hours in timestamp, so that it increases date in timestamp it total number of hours crosses 24. pls suggest thnx in advance rgds reetesh
by: Anz | last post by:
Can any one know the javascript function to auto resize the swf when resizing its pop up window. I need to auto resize the swf when i resize my popup window in which the swf is displayed. Is there any javascript function available to perform this requirement ?
by: H9XLrv5oXVNvHiUI | last post by:
Hi, I have a question about injecting friend functions within template classes. My question is specific to gcc (version 3.4.5) used in combination with mingw because this code (or at least code that gets the same result) works as expected in visualc++. I know that this is probably not the right behavior for a compiler but it's the kind of behavior I'm searching for so I was hoping there was a way to do the same thing in gcc. As you know...
by: Jock | last post by:
My purchase order system sequentially added the next number to the new order when I clicked the macro button set up with copy/paste functions and it worked well. I cannot do this now as 2007 does not offer these macro functions. My system simply looked at the last record copied the number in the field - opened a new record and pasted the number+1. I cannot use the autonumber function because if a record is raised and then not proceeded...
by: kalees waran | last post by:
is it possible function available to use multiple headers in a page
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.