I am trying to have my night process in Access kick a report to someone.
When I run the macro using the SendObject command a window pops up from
Microsoft Office Outlook asking if its okay to send this. Anyway you know to
bypass this and have Access automatically send an e-mail ...

I have come across the following KB from Microsoft that has helped me to
print a fixed number of copies of the labels that I wish to print.  This
works pretty well.
http://support.microsoft.com/kb/299024

If there is a better way to approach this problem I am open to changing my
implementation.  I have a report that is based on a query.  This is overly
simplified but for example the query has 3 fields FName, LName and City.
For the 3rd parameter I use a Like [ENTER City] so that ...

I am trying to append three text files to create a new file.
Is there a function similar to the DOS Command copy which allows this
functionality?
As an example

oops, forgot something
for each n in sheets("sheet1").NAMES
 n.delete
next

I have a macro set to open a message box in the "on update" event for a data
entry form.  Can I set the condition of this macro not to run for new
records?  I want my users to be warned if they try to change previously
entered data but not when entering new records.  The users ...

I want to sum records from a table. the second row is the sum of the first
and second row. The thirth row is the sum of the first, second and thirth row
etc. Is someone who can help me?
Best regards

I'm developing a simple front-end for re-organising information based on
some text tags (for example, animals might have tag fields for size with
options big, medium, small; another tag field for [diet] with options roots,
shoots, leaves.)  The way I'm doing this it to let the ...

In the below Macro, I would like to value of RowCount to be displayed in a
form.
Public Function RunRecordCount()
   Dim dummy As String

I would like to place a combo box on my form that the user can select from,
then based on their selection, a new form will open.  
Can I make the combo box a form, and how?
Thank you!

I've got a workstation with Office 2007, and several others with Office 2000
+ the office compatibility toolkit. Documents are created in Word with macros
and are saved as docm on the 2007 workstation. The problem is that when I
open the docs on the 2000 machines (which have the ...

I was wondering if anyone knew what registry key I would need to change or
create so mutli-users would have the same settings in Options>Edit/Find
Confirm: Record changes unchecked, Document deletions check, Action queries
unchecked

Using a macro within a workbook, I am wishing to paste information from other
worksheets into an existing work sheet which already contains rows of data.
The macro should be able to determine the first empty row and then paste. I
cannot determine which function to use and how?

Hi, I have a table with multiple null values in multiple columns. how
can I replace all null values in this table for zero. all at once.
Thanks for your help.

I have a rather basic knowledge of of excel macros so I would really
appreciate any help.  The task I am tryng to complete is:
I have a form that I have created in excel where a staff member enters data
on a flight they are booking and from the data they enter the CO2 emissions