is it possible to write a macro/sub/module that would at a specified
date, automaticly send an access report by email to somebody?
Thanks

Is there a way to automate running a backup of your data base on a daily
basis or is the only option to just copy everything tables/forms to a cdr
manually?

In Access 97, I have a field for e-mail address.  If
filled in, the label turns blue telling the user they can
click on the label.  When they do it brings up the Outlook
Express create mail form and adds the e-mail address to

I have a macro that creates several temporary tables and
then deletes them at the end. The problem is that one of
the tables isn't created all the time so when macro gets
to the delete line I get a halt because it can't find the

I have a database that opens Excel with the
RunApplication command from the Macro Builder.  Is there
a way that I can tell Access to close Excel after a
couple of other commands? I'm a pretty novice programmer.

How can  I set up all input text in uppercace in Access.  Thanks

I'm trying to automate a process that sends a fixed-width, text file (a
query).  If I use "sendobject", it formats it as a delimited text file which
is unacceptable.  Currently it is set up as a two-step process - (1) export
to desktop using an export spec, and (2) email the text ...

I am using a macro to import a spreadsheet into a table
(see macro below).  The macro works well to import the
whole sheet when there is only that sheet in the
workbook.  However, I need to specify certain ranges on a

I'd like to have a Macro open an Excel file.  The file is
located on a network drive (e.g. V:\Manuel\Work\Data.xls).
Anyone have any ideas how to accomplish this?
Thanks,

Hi, I'm new with VB and access and would like help
I have a query that filter data from a huge table
Now I've created a report to present data from this query.  What I
would like is to write a macro (or sub or module or something like

Could someone please tell me what needs to replace the «type» field in the
following example?
=IIf([DeliveryorPickup]=1,"Customer Pick
Up",IIf([DeliveryorPickup]=2,"Delivered",MsgBox ("Please select a Delivery

Where in this code does it say that when you go to delete a message box
pops up.  I don't want the message box to pop up. I want to remove it
from his code. Thanks
DS

How can I open a specific word document from inside
access. I can open word from a macro, but if I try and
give a path to the document it comes up with a message
that the path is wrong or something missing. Any Ideas?

Hi, I'm trying to learn VB within access and excel, and I'd like to
know what is the difference between a sub and a module, when to use
which

(Access 2000)  I have a macro, with "transferspreadsheet" action and "File
type" of:  ="A:\" & [Forms]![ExportToFloppyA]![FileName] & ".xls"      which
copies files to the floppy A disk.  I would like an error message pop up
stating; "Please Insert Floppy Disk" when a floppy disk is ...