I want to import a text file, but only if the file has been updated. Can
Access 2002 read a file date?

Steve Schapel gave this advice:
 "First way would be to put a GoToRecord/Next action at  
the end of your macro, and then use another macro, with
the RunMacro action, to run your SendObject macro, with

I have a macro created from the combination of two action
queries, a delete query and an append query.  The delete
query deletes a record if a certain criteria is met, in my
case [AdminApproval]="decline".  Similarly, the append

I am using =[Forms]![Today]![PM] to populate the To
argument in a Send macro. The problem is it only uses 1
record, is it possible to have this select all records.
This form is based on a query if that helps. Thanks

I need to create a new MS Access DB file from a batch file and I think
this should be possible, since there are OS utilities to do so. Inside
of a folder you can get its context right clicking on it and select
'New -> MS Access DB', so there should be a way to do in a batch/OS

Howdy All,
  I getting update transactions from a flatfile, and want to use them to
update a table in a database.  However, I first need to check to see if the
proposed new key already exists on the table.  Obviously, there are many ways

This is driving me mad. It has to do with logics but I am
not very good at it, obviously.
I have made a macro that runs as an event of a 'Show'
button on a Dialogue form. It is designed to show

I have a document with embedded codes to send to my fax server.  The
problem is that I have to send each page separately.  In Word I can do
this as follows:
Public Sub MAIN()

is there a way to find out what tables are used by queries
so unused tables can be deleted to clean up the database
regards,
David

I have a command button that previews a report and
displays only the current record. I would like to add a
macro to send this directly to Outlook with the
attachment of the report. However, I don't know how to

I am helping a friend with an Access conversion project.  He is
converting a progrma from 2000 to 2003.  The guy who originally wrote
the program used tons of macros and very little code to do the work.
Not what I would have done, but that is me.

Please Help!  When I set up a macro to use the "sendkeys"
action, it says I require the utilities add-in.  When I
go to the add-in manager and install it, the correct add-
in appears, but as soon as the add-in manager is closed

I'm trying to use the DSOle.dll to read through all the
documents of a given directory and extract the custom
document properties from each document. When I run the
code listed below, I get a "Run-time error 432: File name

I have a macro with the TransferSpreadsheet action to
import a file to a table.
This macro sometimes runs well other times returns the
following error:

Is there a way to automatically set a field with the
current date when a user ticks yes in another yes/no
field?
It needs to be a global sort of implementation as the