473,326 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Playing around with Access references

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
3 1660
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********************@twister.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
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********************@twister.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 #3
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********************@twister.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

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

Similar topics

2
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...
11
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...
0
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...
3
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...
3
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. ...
5
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...
3
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...
1
prn
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...
3
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.