Playing around with Access references - Microsoft Access / VBA

Scott Simonson

When in the code editor I select TOOLS | REFERENCES I get a list of
references. Mainly DLLs that are accessible. Well I assume that they are all
accessible. Besides the ones I have to use or might use, what about the
others? While scrolling through the list I saw something with AIM, AOL
Instant Messaging. Is there something in there to use in an Access app? How
do I know. How could I expose the objects contained in it? Are there other
useful objects elsewhere to play with?

Scott

Nov 13 '05 #1

Subscribe Reply

1702

Allen Browne

Hi Scott.

You can have fun fooling with several of the (hundreds? of) controls you may
see exposed there. The most commonly used ones are probably calendar,
treeview (ms common controls), and richtext. There are many general ones
that do little more than you can already do in Access, and other specialist
ones that are useful if you have a special need.

In practice, though, you want to keep the extra references to a minimum. If
you copy an mdb file onto another computer that does not have a specialist
library installed, it breaks the application. If the other computer has a
different version of the library, it breaks the application. If some other
software installs another version of a library onto your computer, it breaks
the application. If you update to a different version of Access, a simple
thing like the calendar control can break the application. In short, any
extra libraries you include means are you are increasing the support issues
for your application, so if you are developing something to use on other
people's machines, you really don't want to introduce DLL-hell issues.

So, most of the apps I write use just 3 libraries (Access, VBA, and DAO),
and I have to be convinced there is a genuine need before I will introduce
any more.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Scott Simonson" <sc***********@ wi.rr.com> wrote in message
news:KF******** ************@tw ister.rdc-kc.rr.com...

When in the code editor I select TOOLS | REFERENCES I get a list of
references. Mainly DLLs that are accessible. Well I assume that they are
all accessible. Besides the ones I have to use or might use, what about
the others? While scrolling through the list I saw something with AIM, AOL
Instant Messaging. Is there something in there to use in an Access app?
How do I know. How could I expose the objects contained in it? Are there
other useful objects elsewhere to play with?

Scott

Nov 13 '05 #2

Allen Browne

When in the code editor I select TOOLS | REFERENCES I get a list of
references. Mainly DLLs that are accessible. Well I assume that they are
all accessible. Besides the ones I have to use or might use, what about
the others? While scrolling through the list I saw something with AIM, AOL
Instant Messaging. Is there something in there to use in an Access app?
How do I know. How could I expose the objects contained in it? Are there
other useful objects elsewhere to play with?

Scott

Nov 13 '05 #3

Scott Simonson

Thanks Allen,

I understand not using references, or at least too many, is not preferred.

I do want to look into it so if I would find something that I'd like to add
to my project I can add it. Does anyone have suggestions on some objects
that you have used and how to use them? I am simply exploring the
possibilities.

Thanks,

Scott

"Scott Simonson" wrote in message
news:KF******** ************@tw ister.rdc-kc.rr.com...

When in the code editor I select TOOLS | REFERENCES I get a list of
references. Mainly DLLs that are accessible. Well I assume that they are
all accessible. Besides the ones I have to use or might use, what about
the others? While scrolling through the list I saw something with AIM, AOL
Instant Messaging. Is there something in there to use in an Access app?
How do I know. How could I expose the objects contained in it? Are there
other useful objects elsewhere to play with?

Scott

Nov 13 '05 #4

Similar topics

2109

Conversion from Access 97 - 2000

by: Peter Mather | last post by:

Hi, I have struck problems when trying to convert an Access97 database to Access 2000. I get a compile Error when I start the database in Access 2000.. The message is Can't find project or library. In the procedures it highlights the Error$ statement and in functions it highlights Left$ and Mid$

Microsoft Access / VBA

1867

understading references in MS Access

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.

Microsoft Access / VBA

244

Playing around with Access references

by: Scott Simonson | last post by:

When in the code editor I select TOOLS | REFERENCES I get a list of references. Mainly DLLs that are accessible. Well I assume that they are all accessible. Besides the ones I have to use or might use, what about the others? While scrolling through the list I saw something with AIM, AOL Instant Messaging. Is there something in there to use in an Access app? How do I know. How could I expose the objects contained in it? Are there other...

Microsoft Access / VBA

5895

MS Access DLLs, OCXs, References

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

Microsoft Access / VBA

1669

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

by: Lauren Wilson | last post by:

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...

Microsoft Access / VBA

3790

Playing Sound Clip

by: Johnny M | last post by:

I use the following code to play WAV files from Access. Is there a method to play MP3 files from an Access event or control.: '***************************************************** Option Compare Database Option Explicit Declare Function sndplaysound Lib "WINMM.DLL" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long Dim soundName As String Dim WFlags As Integer

Microsoft Access / VBA

2377

Programming "Now Playing" for MSN Messenger

by: Tommy DN | last post by:

I've made a program that displays the track that's playing on a (internet)radiostation. The name of the "now playing" track comes from the radiostation's website ( from the statusbar using the Internet Explorer object model ). Now, I want the name of the track in the person's nickname from MSN Messenger ( the "now playing" info that actually comes from the Windows Media Player Music Plugin ). Does anybody know how to do that ( in VB.Net...

Visual Basic .NET

11548

Access 2007 acwzmain acwztool

by: prn | last post by:

Hi folks, I'm relatively new to Access, but I seem to have drawn the short straw, so I have the assignment for my workplace of looking for problems/inconsistencies in migrating applications to Access 2007 from previous versions. We don't have a lot of Access applications, but even a dozen or so can be an interesting challenge. I have loaded a few that were created in Access 2003 into Access 2007 and all of the ones I have tried have come up...

Microsoft Access / VBA

7776

Access Crashes When Rt Click Build in Query Design View

by: mnjkahn via AccessMonster.com | last post by:

I'm running Access 2003, modifying a query that has over 45 fields. When I right click on the field name in Query Design View, and then click Build, Access crashes before the Build window appears. It doesn't happen every time, and using the Zoom window works fine. It appears that it only happens when I want to modify an existing expression. This continues to happen even after the database is repaired and reopened. Anyone have any...

Microsoft Access / VBA

9706

What is ONU?

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...

General

10569

Problem With Comparison Operator <=> in G++

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...

C / C++

10325

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

10315

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

10075

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

6847

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5519

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5651

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2990

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General