Here is my problem. I use Access 2000. The data base is simple : one table
(Customers : with Id, Name, etc and e-mail address). Whay I want to realise

solution : 1) create a report for each customer, 2) sending ...

http://msdn.microsoft.com/msdnmag/issues/05/04/RegFreeCOM/default.aspx
Simplify App Deployment with ClickOnce and Registration-Free COM
When you
   set app = createobject("Access.application.11")

I have a form with a combo box on it.  When you select a value (a PO#) from
the combo box, the bound field is the indexID of the selected PO.  On the
same form, I have a text box that I'd like to feed from a query I've built.
The query does some math and comes up with a number (qty ...

Folks,
I would imagine that many of you also visit the Yahoo Groups.  There
you can upload files for others to use and view.  Is that possible with
this group?  If not, how do get files to other users?

I have a database that creates invoices for customers in MS Word.   Is
there a way I can automatically trigger a mailing of each invoice in
the mail merge document to its specific email address?

I have two tables with transactional data.  Table 1 has a Cost Centre,
Account, Fund Code and a YTD0-6 figure for each Account Number. Table 2
has Cost Centre, Account, Fund Code, Period 7, Period 8, Period 9,
Period 10, Period 11, Period 12 data.

I have an unbound form that adds and updates records to one table.  I
use an INSERT sql statment to add a new record and a UPDATE statement
to update a record.  I created a function named C2F to check each field
for null.  If the field is null I need to write the value null to the

I'm trying to embed the value of a combo box into my email body text
string. Any clues as to how I can adjust my syntax as this gives
compile error:
Private Sub Email_Click()

I've got a list box that has two columns.    I would like to get the
value of the first column of the user selected row.  How would I do
that?  It is not a multiselect listbox.
PS  Whats the difference between a "field list" and a "value list" in a

I currently use the following to send emails to users. I have a need to
modify it so that it opens GroupWise instead of sending the email in
the background but don't know what the code is to do that, what do I
need to change the 'oMessage.Send' to, I tried .Display and .Open

I have a listbox on a form that is selecting using named FinalQuery:
SELECT [FinalQuery].[Job No#], [FinalQuery].[Date Ordered],
[FinalQuery].[Misc#]
FROM FinalQuery;

I am writing a parts inventory database for my workplace.  I have it
mostly working, but the reordering report isn't quite right.  I want
the report to show me parts that need to be ordered.  The query I'm
using in the report to generate this number is:

I have created a database to track employee time. Within that,  I have
also created a report off the following query:
SELECT ALLTasksFilter.ProjectName,
Sum([qryDateFilterTaskHours-Daily].NumberOfCompletions) AS

Bob, your version works perfectly.
I have changed SELECT * to SELECT customer, outdate, outwardtime, indate,
inwardtime, iif([input the date] = indate, 1, 2) AS sortkey
The customer going 'outdate' have a 'outwardtime'.

I've written several SubRoutines for sending reports via embedded A97
VBA to OUtlook, but was wondering if there's a way to send from
Access/Outlook 2000 a daily email letting certain users know that my
backups of their databases ran. I'd like to do this from the push of a