I want to create a form that includes a field 'Instore date'. What we would
like is that (only) if you open the form a pop up window will appear to
notify you of any records where 'Instore date' is less than two weeks away.
You would then have a choice to click yes and be taken ...

Hello, I have a series of append quieries which I would like to run with our
returning a key violation error. I have set the primary key in the table in
order to limit the number of new records. Is there a better way to do this or
can someone tell me how to FORCE the yes accept ...

I need to delete duplicate records in a table (the records are exact
duplicates in every field, I have no control over duplicates being there).
I found VBA code from:
http://www.databasejournal.com/features/msaccess/article.php/3077791

I have two sheets within a spreadsheet,
One sheet contains a list of names and the other contains/should
contain data relating to those names.
Within sheet 1 I have a column with not only the word "Name" in it as

The Access help provides this code snip for this but doesn't describe
how it is to be declared.  I'm trying to use it in a module funtion.
When I try to dim it neither scripting nor FilesystemObject are
available from the autocomplete list.  Could someone please explain to

I have this from surfing here and it not work.  What I have is column A
with headings, and what I copy into this would look something like this
for example....
( Used | to show cells)

I have created a macro that opens a pop up form with two calendar controls on
it for beginning date and ending date.  I also have a report based on a query
that uses the dates selected on these calendars as a date range.
What I want to happen is this:  The user clicks on a button ...

Good morning all:
I have a excel spreadsheet and a macro setup to TransferSpreadsheet to a
Table in my database. The issue i am having is everytime i run the macro, its
saying field F10- F... is missing in destination table. The spreadhseet

I am working with a access report and I have varios blank lines in the report
that I would like to delete.  I used a different macro to get rid of some
duplicate information.  But it just made the information invisible.  Now I
need to delete the line from the report.  Is this ...

How do i run a macro from a sub form ?
When i try to run one i get the error message that the sub-form cannot be
found, even though its live on my screen.
Please help

        Do anyone have experiance running a Acccess macro from asp.net with
C#. I tried with windows application it worked fine but i lose my thread in
asp.net application.
Ananth Ramasamy Meenachi

From a macro, is there a way to print with a specific file name derived from
the database?
e.g. C:\test\[JobName]\
Thansks for your help,

I have created an autoexec macro to run a bunch of other test macros,
and then exit the program.  It all works great except that now I can
no longer modify the tests since it starts/runs/exits.  I looked for a
way to just disable macros in the applicaton prior to opening the

I need a macro that can stop so I can fill in the blanks throughout the
report.

I have a TransferSpreadsheet macro that's supposed to overwrite an
excel file with new data each time it is run (the access table is
updated each time in a query). However, the data isn't being rewritten.
I've checked the table and file names, and the query is correct. Any