I have a Macro set to run On Current set on a minimzed form.
This is used to export two queries to excel on the hour every hour (Rather
than use the ON Timer event procedure). However I cannot seem to get the Time
function to work as I would with Weekday or Date function criteria ...

From my main form in my database, if I filter by form for a subgroup of data,
I can use about 4 or 5 macros and then Access "crashes" -- all of the macros
stop working and I have to exit Access to continue.  If no filter is applied,
the macros seem to work fine.  I have installed ...

I have 3 queries that I would like to export to the same excel spreed sheet
at the same time and in a specific order, is this possible using a macro? Any
help appreciated.
Thanks

I would like to create a macro for getting external data (Import) from Excel.
I do  not know what command to use in the macro to open this option.

Hi -- I've read the posts and since i'm not a programmer didin't understand
most of them, but what i did gather is you don't backup a table inside a
database while it's open.  i saw something about batch files but don't know
how to do that.  I would like to have a separate Access ...

I have a form I'm working on. I have added a checkbox which I want to use to
change the value of a field. Actually, I have 3 separate checkboxes, all
working on one field (setting the field value to 1, 2, or 3 depending on
which checkbox is checked). The reason for using 3 separate ...

I have a macro which runs multiple reports at one time.
How can I stop the printing report dialog box flashing on the screen for
each report being run.
Thanks for any help.

I have the following string I need to add into a query.
(tblGBREPORT.StartTime)>=08.30 And (tblGBREPORT.StartTime)<=09.30
but for it to work I assume that I need quotes round the times.  How do I
insert the quotes without VB thinking that the first quote is the end of the

How do I stop outlook from blocking e-mails from ms access item.send?  I get
a popup box waiting for me to select yes or no

I have a macro in Access that opens an Excel Spreadsheet. I then run a macro
from within Excel, after execution close Excel and return to Access. Can I
possibly run the Excel macro from within Access?
I have to use Excel to get the data from an external source, refresh from

Here's the situation.
I have a master file. Let's call it A. I have a continuously downloaded file
that needs to be appended to A. Let's call it B. So basically I need to
append all data from B into A without erasing any data in A.

I have set up a macro to e-mail several reports however, they are all sending
on separate e-mails, is there a way to get them all to send on the same
e-mail?

Good day,
I used two quires to create a header and detail record for a fixed-width file
and used two macros to export the data using the Transfer Text action with a
Export Specification file which in turn is creating two files instead of one

I recently bit the bullet and converted an Access 97
database app to Access 2000. My AutoKeys macro appeared to
convert correctly, and returns no errors when I run it.
however, the commands I place there don't seem to work.

I have a form (Add Record) used in entering data into a table and I have two
textboxes (Text1 and Text2) that I will need to clear based on selections
from a combo box (Combo1) .
Question is, what is the expression to use, such that a textbox can be