My VBA knowledge is quite limited
I have a function:
-----
Function Update2ndYrDate(txtcustid As String, dteDue As Date)

I have this code in access which transfers 4 tables into an excel
spreadsheet.  I have a macro in excel that does the formatting.
Is there a way to trigger the excel formatting macro from the access code,
instead of me manually having to open the spreadsheet and using the menu to

Can this be done with code?

I need to email a report to each customer (with email address) in my database.
What is the best way to send a customised report for each client, and have
the report appear in the body of the email (not as attachment)?
If it must be attached I would prefer to send it as a PDF file.

I have an MS Access database that has a linked table to a Windows Sharepoint
Services list.
I have a crystal report that uses that linked table as a data sourced. The
report runs on my windows XP workstation where I have MS Office 2003

I have a form that contains a subform that is based on a simble query that
keeps a running count and sum of records entered.  I want to be able to
refresh this subform after I delete a record.  I have the warnings set off
so.  I have and event in my afterDelConfirm, and is shows ...

have been trying to figure out this frusterating detail for the last week,
and still have not gotten it to work correctly:
I have a form, connected to a table, which displays a list of products and
corresponding details.  The purpost of this form is that it will be used by a

Due to customer limitations and compatibility issues, I am using Access 2000.
For an internal report, I am trying to program a report to print to a file
for creation of a pdf.  I've seen many remarks here about changing the
printer from code and from the report in Access 2002 ...

i am trying to update a dabase in the field from a program.
now i have created a new table and wish to add a refernces to the new table
to a table that i have add a field to..
the following code has a "syntax error in the CONSTRAINT claues." Error

Why do I need all the six commas in this MS access VBA code to parse
data
from one text box form to another text box form?
Main Form:

Is it possible to programmatically open an URL then copy the text within the
page. I would have several (hundreds) pages from Statistics Canada to get
data from and dont want to cut and paste by hand. All pages have the same URL
except that the end of the string is a number that ...

I have imported a file that has no field names.  The file is going to be
imported every month so I want to automate it so that the field names will be
changed with a rename function or something else that may work where they
won't have to be changed manually.

I'm having some trouble with a Select query I wrote; I'm getting "Error 3027 -
Cannot update. Database or Object is read-only."  I think it's a problem with
my SQL statement, which is executed from VBA.  All of my other
queries/recordsets work, so it's not the database or ...

How does one refer to foreign characters in VBA?  I am aware of
www.lookuptables.com and can see the characters in their various forms, but
how do I reference an extended ascii code in vba, with the intent to replace
it with an english character?

How do I create an MDE File Programmatically?