Is there an easy way to determine how many diiferent values appear in a query
or table. I am not interested in how many time a particular value appears
just in counting the number of different values that appear.
Thanks in advance

I have inserted ole objects into a table.  Am I able to send them via e-mail
using VBA?  SendObject does not seem to work.  Any help would be appreciated.
Thanks!
deurbroucq

I need to be able to download a .txt file directly into my clients Access
database.  The file will always be in the same directory with the same name.
Is this possible?  Can someone point me in the right direction or throw some
code this way?

I'm transferring Excel spreadsheet to Access table. I have multiple tables.
How ever when I transfer data to existing table, earlier records stays also
in table. How can I delete the record from table before writing? I can't
delete whole table and then create it again, because ...

I have an excel spreadsheet that calculates a multitiude of data from one
worksheet with named ranges to another  worksheet.  I have a nifty Access DB
that imports a 'raw data' file and through a series of query's builds a
finished table named "My new data" that I can import to ...

I have a database DB1 that creates a form in another
database MyDB (like a wizard).
I use the following code
   Dim AppAcc As New Access.Application

I have been working on being able to double click a listbox that returns
records from a search and have the double click open a form with that record
on it.. i have 4 different search options using checkboxes which only one can
be selected at a time here is the code i am using ...

How do I record log in activites? When a user makes a change i want to be
able to see the original document and the changed document, How long they
were using the program.

I am getting this error message on the line below reading:"For each oRvs..."
with the word "revisions" highlighted.  WHY?  I have references set.  I have
included some of the surrounding code - please HELP!  THANKS!
           Set oDoc = oApp.Documents.Item(1)

I'm using the following code (from the help file VBAXL10.chm) within Access
to determine whether Excel was running when I first opened the workbook in
VBA:
   ExcelRunning = IsExcelRunning()

How can I make a copy of the current database, from the current database,
using VBA Code.
Thank you
Ross

Please provide more professional controls in Access BUT keep them easy to use
like they currently are.  A simple treeview would be nice.  The ability to
lock / dock and add popup menus would be nice.

We have a database (sql 2000) which we are going to start to pull information
from using MS access 2003. I am having trouble figuring out what to do with
this here…
A web-based form where coordinators enter times for attendants that take

In a function I've declaired a variable as Public
strVendor as string
In this function strVendor is set to a value.
Within this function I open a report and in it's format

I have huge access database that has reached to the limit of using moduls on
it.
Now i would like to split my application for many mdb/mde.
As i heared i need referances for this. How can i use them and what is the