473,796 Members | 2,460 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need advice on how to confirm Access 2K Library References on atartup

Hello good folks!

It is WAY past time for me to figure out how to check for the
existence of all referenced libraries on application startup and
provide feedback to the user if they are not.

Do any of fine folks have a link to some sample VBA code that will do
this? The big issue, I believe, is how to make such a procedure
sensitive the various storage locations for the referenced DLLs on
various versions of Access -- 2000, 2002 and 2003

All responses appreciated.

Cheers,

-- LW
Nov 13 '05 #1
3 1666
Lauren Wilson wrote:
Hello good folks!

It is WAY past time for me to figure out how to check for the
existence of all referenced libraries on application startup and
provide feedback to the user if they are not.

Do any of fine folks have a link to some sample VBA code that will do
this? The big issue, I believe, is how to make such a procedure
sensitive the various storage locations for the referenced DLLs on
various versions of Access -- 2000, 2002 and 2003

All responses appreciated.

Cheers,

-- LW


Here's some links to info on References in Access:

Doug Steele:
http://members.rogers.com/douglas.j....nceErrors.html

MichKa:
http://www.trigeminal.com/usenet/usenet026.asp?1033

This is from the July 1999 issue of SmartAccess.
http://www.smartaccessnewsletter.com...2568AF00149FA4

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/support.../Q248/9/41.ASP

ACC2000: How to Loop Through References to View Their Properties
http://support.microsoft.com/support.../Q209/8/49.ASP

ACC97: How Access 97 Resolves Visual Basic for Applications References
http://support.microsoft.com/support.../Q280/4/65.ASP

ACC97: References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/support.../Q175/4/84.ASP

ACC: References Not Imported with Objects from Another Database
http://support.microsoft.com/support.../Q181/6/75.ASP

Not sure if all of these links are still valid but the top 2 are
definitely what you are looking for.
--
'---------------
'John Mishefske
'---------------
Nov 13 '05 #2
On Thu, 21 Apr 2005 22:27:07 -0500, John Mishefske
<mi************ @JUNKtds.net> wrote:

The Doug Steele link should be:
http://www.accessmvp.com/djsteele/Ac...nceErrors.html

-Tom.

Lauren Wilson wrote:
Hello good folks!

It is WAY past time for me to figure out how to check for the
existence of all referenced libraries on application startup and
provide feedback to the user if they are not.

Do any of fine folks have a link to some sample VBA code that will do
this? The big issue, I believe, is how to make such a procedure
sensitive the various storage locations for the referenced DLLs on
various versions of Access -- 2000, 2002 and 2003

All responses appreciated.

Cheers,

-- LW


Here's some links to info on References in Access:

Doug Steele:
http://members.rogers.com/douglas.j....nceErrors.html

MichKa:
http://www.trigeminal.com/usenet/usenet026.asp?1033

This is from the July 1999 issue of SmartAccess.
http://www.smartaccessnewsletter.com...2568AF00149FA4

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/support.../Q248/9/41.ASP

ACC2000: How to Loop Through References to View Their Properties
http://support.microsoft.com/support.../Q209/8/49.ASP

ACC97: How Access 97 Resolves Visual Basic for Applications References
http://support.microsoft.com/support.../Q280/4/65.ASP

ACC97: References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/support.../Q175/4/84.ASP

ACC: References Not Imported with Objects from Another Database
http://support.microsoft.com/support.../Q181/6/75.ASP

Not sure if all of these links are still valid but the top 2 are
definitely what you are looking for.


Nov 13 '05 #3
Tom van Stiphout wrote:
On Thu, 21 Apr 2005 22:27:07 -0500, John Mishefske
<mi************ @JUNKtds.net> wrote:

The Doug Steele link should be:
http://www.accessmvp.com/djsteele/Ac...nceErrors.html

-Tom.


Thanks Tom - I'll update my list.

--
'---------------
'John Mishefske
'---------------
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
8759
by: Jim | last post by:
Hi, I keep getting form results emailed to me that would indicate a form from my web site is getting submitted with all fields blank or empty, but my code should preventing users from proceeding if they left any field blank. My guess is that someone is trying to hack the site using the form to gain entry or run commands -- I don't really know since I'm not a hacker. I just know that forms are often susceptible to these kinds of...
9
4207
by: Marty McDonald | last post by:
If I invoke a web service, and it throws an exception, I can see the exception if the client app is a .Net app. However, if the client app is not a .Net app, I only receive the HTTP 500 error. I believe this is due mostly to the fact that the non-.Net apps are using POST instead of SOAP. If the non-.Net apps were using SOAP, they too would in fact "see" the exception. Is this true? Thanks!
3
1026
by: Helene Day | last post by:
I am trying to access the Word Objects from a .NET project. I have some sample from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/WordObject.asp and I have MS Office 2003. However I don't know which file I need to reference for the MS Word 11.0 Object Library. Or what else do I need to install/download from MS to be able to create MS Office 2003 Projects.
3
2067
by: James P. | last post by:
Hello there, I'd like to have my minutes convert to hours and minutes in Access report in this format: hh:mm. For examples: 150 minutes converts to 2:30. I have this formula below used to work with my machine using Access 2002 SP3. =\60 & Format( Mod 60,"\:00") However, if I run it on someone else's machine who has a newer
11
1866
by: WindAndWaves | last post by:
Hi Gurus I have recently discovered references in the VB section of MS Access, however, when choosing references, I noticed that there are more than who knows how many options. How and/or where do you i get more information on all the references available? Are there any that I should be using / should be avoiding (I know about the DAO stuff)? Keen to hear any suggestions.
3
5894
by: SAM | last post by:
Hi everyone, I consider myself a very competent programmer when it comes to actual programming and analyzing the business that I'm modelling. I am now crossing into what I would consider Access admin/config territory, an area where I generally suck at. Here is my problem. I do all my programming on my laptop before giving
5
1419
by: Natan | last post by:
I want to create an n-tier app and I would like an advice of you that know more than me about this. I want my app to support multiple databases in the way that when a client wants to use Oracle and not SQL server, I can easily port the data layer without touching the rest of the code. So, I have 2 ideas. 1: Take the way MS Pet Shop did (I read a LOT in many sites how this
5
1379
by: Ekempd | last post by:
Hi I need some advice about this situation an how I'm current handling it I hava a ASP.NET solution that in some point start multiples lenghty verification agains diferent databases, my big challenge is that the user click in a button "start process" and close the explorer windows... and in the backgroud all the required query are executed, when the user is back, maybe two hours late the process is finish .. I currently hadlle this...
1
1764
by: larpup | last post by:
I have a A2000 mdb and it is missing Microsoft Outlook 9.0 library.... I see that it is not listed. How can I get this into my references? Lar
0
10231
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10176
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,...
0
9054
agi2029
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...
1
7550
isladogs
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...
0
6792
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();...
0
5443
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...
0
5576
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4119
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
3
2927
bsmnconsultancy
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.