Hi All,
I'm using the SendObject > MessageText variable to enter the body of the
email but want to write multiple lines (i.e. insert a carriage return)
Any ideas on how to achieve this would be very helpfull

I'm wanting to be able to calculate the amount of working days between two
specific dates. For example, if we entered 1st January 2006 and today (17th
February 2006) it should give me a number of 41 (including today). Would
anybody be able to provide me with a macro for this?

No matter what I do  I cannot get a macro to run more than 20 times.  What am
I doing wrong?

I am stuck (who isn't when they post?) I have created a 4 step macro and the
3rd step, using transfer text, export delimited, with a named specification,
to export a text file using "C:\batchfile" &_Format(Now(),"yyyymmddhhmm") &
".txt", I get that '"C:\' is not a valid path.  

What built in macro is used to run a macro on startup
--
Pierc
Posted from - http://www.officehelp.i

I run a macro with a chain of queries for to update many tables. At every
turn of update appears a message of concerning warning the deletion existing
tables. I have deselected the option “Confirm Document deletions” but the
message appears afterwards. How I escape from message? ...

I use Garry Robinson's "Startup Properties" form to disable/enable my bypass
key.
For security purposes, as desired, holding down the SHFT key while
double-clicking on the MDB file does not allow me get "behind" the

I have a macro that will "clean up" my db after appending a bunch of records
from some imported tables.
after getting all the records appended, i want to delete the imported tables.
i've written the macro with "deleteObject" for each of the tables, but when

I have a form with a long textbox on it used for inputting notes for an
order.  It is roughly 4 lines of text high.  It is bound to a control that
is also used in a report.  If the user inputs more that the 4 lines of text
that are visible on the form it allows him to keep typing ...

I have a 303 page report that is the detail for 144 different groups.  I need
to export this report into separate pdf files one for each of the 144 groups.
Would it be possible to create a macro within the report placed in the group
header and footer that will break the report ...

I recorded and edited this macro to remove unwanted characters from a
word 2003 document. It does what I wanted and allows me to add or
change the characters as needed, but it seems the code is very
redundent and probably could be shortened to accomplish the same

Is there a way for a macro to open a table then pause while the table is
edited and macro resumes after table is closed?
Dave

Is it possible to put a timer in a macro to run action queries? for example
the macro to run every hour?
Regards
Alec

Is there anywhere that I can obtain a list that explains what all of the
different Macro actions will do in Access???  I'm not looking for anything to
do with coding, just with the Actions that Access provides.
Thanks!

I have completed a macro that saves multiple reports in snapshot format.  The
macro repeats for each consecutive report to be saved.  But, I have not been
able to figure out the syntax (if any) to allow the snapshot report to have a
saved file name different than the initial name ...