Need some help to get the results I need.  The formula I started with is this:
DateDiff: DateDiff([Interval],[LastDateDue],[CurrentDate])
This what I want, but my formula does not return this:
If interval yyyy, then June 1, 2004 to May 1, 2006 = 1 (this equal to 1 year

Using VBA and the advice received from a previous posting, I put the
following information into a table
For Each fld In tdf.Fields
               .AddNew

Can I perform the menu operation of compact & repair database using VBA code??
Thanks,
Gary

I have default printer with default paper is letter. I have database with
some reports layout for letter and some other reports layout for A4. I would
like to schedule to print the report at given time. I need to change
printer's paper to my report's paper for each time it ...

i export a table from access to a txt file. now i want to rename the file
with vba code. is that possible??
other solution would be to export the file with the correct name, but i dont
know how to specify the name from a macro

I have an .mdb file with about 30 tables and each table has a dozen or more
fields.  One table has 254 fields.  I need to create a new table that
contains two columns: one column will show table names, and another will show
field names within that table.   The new table will be ...

Please someone help me with this.

This is not an access function but a vba question nevertheless; I have a
routine that I wrote which automates the process of downloading a file from
an FTP site, using the Windows APIs. Are there any API functions, however,
that can be used to download files from and http site ...

We're running Access 2003, SP2. I have a database with the following code:
Private Sub cmdSaveClose_Click()
   Dim response As Integer
   On Error GoTo SaveErr

I want to have some code written that will zip down a file, then copy the
file from one directory to another.  I already have code for copying the
file, but no clue on how to zip a file down.  Any ideas?
Thanks in advance for any thoughts!

1. I have a macro that calls several queries
2. I run the macro against either 13 buildings or a single building
3. Running the macro for 13 building requires 895,000 records to be
processed in the macro

I have the folowing problem, I have table with a column that holds email
addresses. The problem is that all email adress have double @ signs.
So all email address have this format: Name@@organization.com.
I would like to be able to create a string function that updates all email

I have got a strange occurance going on with a piece of code.
It functions as it should with no problems apart from it goes into the debug
window and execution stops on a certain line of code.
It is a recently added piece of code and I would of placed a breakpoint on

I create a table in VBA. I can see this table after pressing F5 table screen
of Access.
What I actualy try to do is create a table in VBA then setting a record set
to this newly created table and to write to the table.

Hi, using Access version 97. Which means APIs...
I want to be able to allow users to select from a list of available printers:
1. a specific printer.
2. print tray for first page and print tray for second (and subsequent) pages.