Can I create a macro with a command button to duplicate a record but remove
one or more fields in the process.  can not duplicate a record because it
would create of a primary field dulpication.  I want to be able to click the
button, remove the primary key field than duplicate ...

I am working with delete macro in a subform. It works well in deleteing  the
information but if I decide not to follow through and hit cancel a window
show us stating action failed and in order to close window I have to hit the
halt button. What must i change in the macro for it ...

I've been using sendobject to send excel reports out automatically. Some of
these reports can be consolodated into one report on multiple tabs. I used
transferspreadsheet to get the queries to post onto seperate tabs on a
spreadsheet but now cannot figure out how to get Access to ...

I'm new at designing access databases.  I created a command button to execute
a macro to create an export file and print a report.  The first time I
clicked the button, the report printed but I couldn't find the export file.  
Now when I click the button, it gives me the following ...

Please be gentle as I am new to all this!
I have written a macro in Access 2007 that finds a record in a query (AVG of a number of figures) and I need to be able to somehow COPY this figure and then paste it into a record in a table. I have built all the elements of the macro and ...

I am trying to creat an append query from a table [Prospective Gains] to
table [DIVO Form] I have set up an append query from the Gains table to the
Divo table with a delete query and set the close procedure to the following:
 Private Sub Form_Close()

I'm trying to send an report automatically through a macro and there's a
message box that says "this program is trying to automatically send an
e-mail. . . Do you wish to send . . . " and there's a yes or no option.  Does
anyone know the program to download so that I have a check ...

I'm needing alittle help on my project. I am creating a retail shop
database with ACCESS where I have 12 tables, 11 forms, 14 queries and
6 Reports. Currently, I am having a problem with putting more than 8
items on the switchboard manager and pages becuase the max it is

I am just learning to develop apps with Access.  I have a bit of experience
developing Excel apps, using VBA.
I need to design a Produce purchasing and distribution application.  It will
need to handle incoming and outgoing product, invoice tracking, pricing,

In my table, I want to have a field that says "Updated By" and another that
says "Update Date".  Anytime changes are made to the record, I would like the
current user's name and the date to get put into those fields.  Does anyone
know how to do this or at least point me in the ...

I have a macro which opens up an Email. BUT I have to input the eMail address
before sending the email. Is there any way I can 'grabe' the email address
from the database itself?. All users in the DB have their email address
(Access 97)

I have like 30 reports to print every month. I will build a macro for it.
Quite simple i guess. Most of those reports have a query. Most of them, query
and reports have a filter and a criteria, but the real question is : I'd like
to "ask" from wich date to wich date to them all ...

Is there a way (what is best way) to view the field values of each record as
you process through a recordset while in debug mode? The results I am
expecting are not happening, and before I post up my code for help, I will
try to debug myself. I need to see which record I am ...

i have declared one global varibale named VAR1 in form module and
another defined in sub proecdure with the same name (VAR1) in the same
form module . if i use VAR1 then local variable will be
accessed .......but if i wanna use the global variable explicitely in

i wish to create a macro to check the integrity of database, like that
if max(TableA.ID) <> max(TableB.ID) then
msgbox("ID not matched")
How can i make it in macro look?