I have one main form linked with many sub form, my problem if I want to
delete one record, it delete only form the main form table so when you open
another table you will find same record still there in another tables so what
I will do to delete the records from all tables in the ...

Does anyone know how to set a macro to change a record from snapshot to
dynaset? I want to set the macro to a command button on my form to change it
without going into design view.  I know how to apply it once it is set and
have worked with macros, but I cannot figure this one out.

First off, I do not write code so I need a macro solution. I have a
complex form with a number of imbedded subforms. I enter the form
using a macro, and immediately need to refresh some data on a subform
with a macro. If I put the Open Form and Refresh commands in the same

Simple i should think:  i have a listbox control [List94] on a form named
[Batch Status Page].  I'd like to set the event procedure to allow me to
double click on any of the records listed in the listbox (there are four
columns. the first column holds the batch number, which is ...

This should be fairly simple, but never for me.  All I want to do is have my
MsgBox macro to pop up and say "No data for this report".  My macro works
fine, but I cannot figure out the code for where I need it to pop up.  
The basis is a simple form with text dates beginning and ...

I'm working with a database used for military record keeping.  Right now
there is a columb for someone's numeric MOS designation and then the worded
title of it.  The numeric designation will always have an exact match to the
worded column, so I am assuming there has to be a way ...

I tried to use import an Excel spreadsheet into an existing table, using a
TransferSpreadsheet macro, and it seems to append the data on to the bottom
of the existing table, rather than overwrite the data in the table.  I tried
to delete the table, using a DeleteObject macro, and ...

I created a macro that runs  OutpuTo a txt file.
On the exported file, can I automatically rename the file with this naming
convention:  "mmddyy or (now)" & "query name".txt  = 040808Sales.txt
Thank you.

I've created a macro that takes the contents of a table, and dumps the data
into an excel spreadsheet. What I would like to do is somehow format that
data as it arrives in the excel spreadsheet so that I can tell at a glance
which data is new.

I used to use two types of macros in Access 2003, both of which were very
helpful.  I can't seem to find them in Access 2007.  Thay were DeleteObject
and TransferSpreadsheet.  Did MS do away with these two macros in Access
2007?  Please tell me where to find them if they are in ...

I really need some help.  I have a database that I built in Access 2007 that
has some basic fields in it (i.e. name, address, email, date added to
database, etc.).  I plan on bundling the database with the Access 2007
Runtime to deploy it on my customers PC.  My customer wants ...

I have a daily file that I need to import into access that uses the date and
file name (i.e. 02252008_report.csv) and was wondering if there is a way to
set up a macro that will use the current date and report name to import the
file into access?

I need to create a button on a form that will copy the text from a particular
field in a selected record and place the text in the same field for a newly
created record.
In other words...say I have a table with the following fields: 1.

I have created a form where data is entered and added to a table.  In order
to edit the data I created an edit form.  On the 1st form where the data is
entered there is one field that has a drop down list to choose from.
How can I also have a drop down on the edit form and insert ...

I have a macro that runs CopyObject command
to copy one table from the database into another access table.
I want to add a current date to the name of the table in the
new database when the macro runs. Is there a way to add a date