We use MS Access with a large number of Macros that are very large.  The
contain selection criteria to generate individual reports (some of them up to
300).  There is no Find and Replace edit capability in Macros, like there is
in other MS Office products.  Find and Replace ...

Hi
I have completed an application in ACCESS 2003 ,the input data is inform of
an excel spreadsheet.I had gotten my desired output.However i have to do the
same procedure on 12 more spreadsheets.Each spreadsheet is unique and the

I have a Report & 3 sub-reports all based on the same Query.  Every Month I
run this report, going into Design & changing the criteria "Between
#3/1/2007# And #3/31/2007#".
I have used "Between [BeginningDate] And [EndingDate]" for other reports

The action arguments Page From and Page To for the PrintOut action make it
seem as if I can specify a certain print range.  I want to print only the
first page of one report and pages 1-5 of another.  The PrintOut Action still
prints all pages of each report despite the fact that ...

I need some help.  I'm wanting to email management reports automatically on
monday of every week, without the need to manually run the reports.  I have a
couple of functions that do this just fine and it works great.  However, I
have some reports that I pass criteria information ...

I have a db that holds thousands of records.  I have a query that pulls the
top 10 records using a begin date and end date as criteria.  I want to export
the data to excel via a macro activated by the switchboard.  I have created
the macro, and all works well, except I have one, ...

I have a database I open daily. In it, I include info about the birthday &
anniversary dates of folks I know. I'd like to create a macro (or code???)
that will do signal me when someone's birthday or anniversary is to take
place within the next 2 weeks.

I am creating a database for a college program.  To be as fully automated as
possible.  In the program, students often get certifcicates for seminars they
have attended.
I want to create a macros to print one such certificate.

Ok...I know this may be kind of vague but anyone have any ideas as to why all
of a sudden a database would not add records anymore?

I would like the selection on one drop down list to limit the list of other
drop down lists on a form using a macro. Is this possible?

Is it possible to set a macro to automatically run every 30 days without
using visual basic?

So I have an unrelated form with a set of buttons to define what reports to
bring up.  Now, when you click on the button, it opens the related report,
and then closes.  What I can't figure out is how to give the report focus.  I
want to give the report the focus because you can ...

The DeleteRecord command returns an error if there is on record in the
underlying table. Therefore I would like to include a condition to stop the
macro.

I have written some VBA that (among other things) writes the SQL statements
associated with all queries in an Access database to a text file. The SQL is
retrieved in this way:
   For Each aQueDef In CurrentDb.QueryDefs