Is there a way to delete a specific record (from a table) via a macro.  I
want the user to be able to delete a specific record from a table based on
entry of a primary key value.  I have figured out how to delete the record
with a delete query but I can't figure out how to run ...

I'm trying to transfer a query in a macro to a text file.  I would like the
file name to include the current date (i.e. File_Name_mmddyyyy).  How can I
do this in my macro?

I have a tblLastCost which is to store ProductID, LastCost, LastDate.
This is put onto our FrmCreditors  via a subform FrmLastCostSUB.
The fields of FrmLastCostSUB are filled by a macro using the "SetValue"
property and this is triggered by the OnExit property of the relevant

I am adding modules into an existing database that is
maintained by someone who doesn't know (and has no
interest in knowing) VB. I am setting up a new form that
will allow them to easily add additional items and it

Any idea on how to do this? I tried using the timer to schedule a sendkey
to the keyboard but that does not work.

British Telecom use hhhh:mm:ss as time format in downloaded bills, which
Excel 97 does not recognise. It can be converted to Excel by deleting two
leading "h"s. I've tried to make a macro but, if (eg) I convert 10 times and
then run the macro for the next ten, I just get the ...

I have a database in Access 2003.  I have a table with a field set to
HYPERLINK which I want to use to point to files.  I need a macro which will
prompt the user with the option to browse for a file ... when they select the
file it will then prompt them for a date and will make a ...

Can I run a n Access macro triggerred by an action outside Access?  For
example, trigger the macro by a new file in folder or based on the time of
day?

I have a subform (detail) that contains due dates and completed dates for a
series of tasks.  The detail record has the following fields: detailkey (not
an autokey), due_date, completed_date, and reviewer.
I want to write a macro or SQL command that will do the following:

I have an app that needs to be archived pretty often.  We are currently have
to go in, open the form,  and click on the button which calls a module, that
runs the function slf_monthend().  Can someone tell me if I can simply set up
a macro which opens the module, and runs the ...

I have a macro (non Code) which calls 5 different queries - all of which use
the same parameter.
Now bearing in mind other people use this macro and therefore it cannot be
converted to VB how can I declare the variable once and not 5 times??

I have a table Statistics with a new added field called RecNum. I have sorted
the table by date ascending so the oldest date is in the first row of the
table. I want to update the RecNum field starting with the number 1 in the
first row. The outcome would be that the oldest date ...

In setting up code for faxing invoices in Northwind (using Article 145787)I
have been having problems with the me macro.  It states to go into the report
and add the line "me.filter = strinvoicewhere" but when I run the code as
written in the article, it errors out with a run ...

I have database, which requires to filter by month.
A form has been created with the necesarry fields,
including one called 'date'.
Option group with 13 buttons has been created...1 for each

I have a application written in Acccess 2000 that does incident tracking for
a technical help desk.  One of the issues I have with the database is the
need to search for particular incidents by date, subject, submitter, etc.  I
think the way to do this is to create a query for ...