All,
   I have a procedure which checks the users Outlook Inbox for the
existance of an email from a specific address. If one is found, a question
is asked to the user asking if they wish to allow the database to save the

I have a list of files that the path of that files are stored in a list
box, but now want to compress all these files stored in the list box
and send it by email from outlook.(I am using Ms ACCESS)
any one help me.

I have some VB6 code that calls a SELECT query in Microsoft Access.
When I run the query from access, the results appear in not particular
order.  However, when I call the query from VB6, via ADO, the rows are
returned in order by one particular column/field.  There is no ORDER BY

I want to reset the default value of a combo box everytime someone
selects something from its list.
I have in the after update event combo.defaultvalue = combo.value.
Anyhow this works, as long as I don't close the form. Once I close it

Every thread I start goes out on a tangent simply because some of you
people are not reading my posts carefully:
Here is the phrase I am proposing for inclusion in the FAQ:
"to existing members of the group: please understand that for every

I have a form based on a totals query, with one of the fields as the
sum of the quantity of an article of the grouped records. I get an
#error# in a control on the form where I want to display the sum of
this sum. TxtExample =sum(SumOfQuantity).

I'm having a bit of difficulty getting the results I need from our database.
In a nutshell I'm trying to work out trends in what people buy next. So, for
example,  I'm trying to run a query that extracts all orders containing
product1 and then trying to run another query that gives ...

Kurzversion: erstellt Access eine volle Kopie der Tabelle, wenn mit
Currentdb.OpenRecordset("Tabelle") eine Tabelle zum Direktzugriff
geöffnet wird?
Hintergrund: Tabelle 1.25GB, minimaler Code (s.u.) führt zur

Hi i am trying to open an excel file from access using a button
the problem is the path and could change so i need to build the path to
the file
i am using textboxes to hold the information as it builds

I've been searching for awhile now on how to remove duplicates from a
table within an Access db and have found plenty of articles on finding
or deleting duplicates.  All I want to do is remove them from within an
SQL query - leaving one of the records behind of course.

Thanks for reading this post and wasting your time.  I was thinking
about writing about the PCDatasheet vs The Pussyfarts war.  The
pussyfarts, as near as I can tell, have little to offer this group but
pussyfart noise.  But I realize if you are going waste your time...the

On a form, when field A is changed, I update field B automatically by
Setfocus to field B, and then assign it with another value. This is
handled in the field A AfterUpdate method. After updating field B, I
want the form to continue normally. For example, setting the focus to

I just wonder whether it is possible to create Tab Control in runtime?
The reason I want that is as follows:
I wanna show a table that contains several categories of information of
clients, e.g., personal address/contacts, company address/contacts,

Is it possible in Access to do the following.
I filtered my table to have the folowing values
ProdID    Color
------------------------

Hello all, I have a membership dB in which I have a form that updates
data in 4 tables.  One of the tables is bounded to a subform within the
Main membership form.  I am trying to link all four tables, such that
when I input data on the Main form it automatically populates data on