473,883 Members | 1,523 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
25 7201
CD Tom
492 Contributor
I just did something that may help. I have a 64bit machine that I installed the program on. When I run the runtime version (.accdr) of the program I get the Function not available error, but when I run the non runtime version (.accdb) I don't get any error and the program runs fine. Do you think that there is a problem with the run time version of the program not working on a 64bit machine. Is there a 64bit version of Access runtime? I'm going to check on that.
Still looking for help.
Jul 18 '11 #21
32,584 Recognized Expert Moderator MVP
CD Tom:
Still looking for help.
Tell us that again when you've reported on how you handled my last post (#20). If there's anything there you don't understand, you need to say so.
Jul 18 '11 #22
CD Tom
492 Contributor
Ok, I don't understand how to print that to a file.
Jul 18 '11 #23
32,584 Recognized Expert Moderator MVP
My system just crashed on me so I can't look anything up or give details, but essentially the Debug.Print facility is similar syntax to writing to a file. The file needs to be assigned an integer value to pass to the Open # command which opens the file (Open it for Append). Close it when finished, but each display changes from :
Expand|Select|Wrap|Line Numbers
  1. Debug.Print {values}
to :
Expand|Select|Wrap|Line Numbers
  1. Print #3 {values}
(assuming 3 is the integer value of the file in your code.

Let me know if this is not enough. I'll probably be on again tomorrow with the ability to look it up for you in more detail.
Jul 19 '11 #24
CD Tom
492 Contributor
I was finally able to find out what reference was missing. Using my 64bit machine and installing the run time .accdr of the my program I was able to test more. The problem ended up being the Microsoft ActiveX Data Objects library was missing. I don't know why but once I put that back in everything worked fine.
Thanks for all the help you guys are a great source for any help. Thanks again
Jul 20 '11 #25
32,584 Recognized Expert Moderator MVP
8-) Sorry I couldn't be more specific earlier.

I can put in some example code that may help with this, but there are so many options it would be irresponsible for me to make a specific suggestion. I often use a specific Binary mode that gives me full control of everything that is written out, but that is actually quite a complicated approach and is used very rarely. I'll shove some example commands in but with the proviso to check the details in Help before using.

Expand|Select|Wrap|Line Numbers
  1. Dim intFileNo As Integer
  2. intFileNo = FreeFile()
  3. Open strName For Binary Access Read Write Lock Write As #intFileNo
FreeFile() determines for you (in the code) a valid, free, file number to use.

Open# is where all the options and complications come in. A mode of Output, Random, or even Append may suit your purpose of logging the details.

PS. I add this now in case any one coming after you might find it helpful. I appreciate you have already resolved your issue. Well done for that. Such remote problems can be very tricky to handle.
Jul 20 '11 #26

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: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
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: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
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: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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 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.