I have a macro that selects several reports to run, after they run I change
the focus via SELECT OBJECT as a way to size the reports specifically so that
multiple reports are visible on the screen.  In some cases, when there is no
data the reports will not run.  I have a no data ...

Hi All,
I am trying to write a macro that displays a text box only for one week
during a given month.  So I have the item line saying:
[Forms]![Menu]![Textbox].[Visible] but I really don't know what to put in the

Is it possible to write a macro so when I click on a cell in the data
view of the query it will become editable so I can make changes. Once I
make changes I want to be able to click away and have it update the
necessary tables. Does anyone know where I might find some helpful

I am trying to synchronizing two combo boxes (which are on the same
form) so that depending on what I select in combo box 1, I only see the
related info in combo box 2.
More explination below:

Is there a way to run a macro on startup, to display a report?

I'm running a bunch of code from the autoexec macro in sequence,
however if the first function fails I need to be able to stop the
whole thing from running.  Is there a way from a within a VB function
to be able to stop the macro which called it?

I've got a problem with an ACCESS-DB (2002) using VB-Macros in it's own
views.
Example:
There's a view 'v_test' like this:

Hi
i use the "setvalue" macro to store one calculated field from my form back
to table but the most time it takes so long time to display my calulated data
or it needs to change the record...is there any way to speed up that process ?

I have partially succeeded in setting up the SENDOBJECT macro cmd to work,
however there are some small bugs or roadblocks I am reaching.
1st of all, if I click new in Outlook, I always get my email template to
popup in HTML mode, which is normal.  If I create an email through the ...

I have access 2000. I have a couple of macros. 1 fires the other. I want to
automate the first one.
The first macro moves the cursor to a certain field then it fires the other
macro to sort the field ascending and sends the cursor back down the to first

I have a macro with 2 steps:  OpenForm & MoveSize
The properties in OpenForm are:
View = Form
Window Mode = Dialog

I've built a Access form which I can send E-mail text and an
attachment. This is working fine,
But now I will like to know how can I send two different report at the
same time?

Does someone know how to make a splash screen with moving text that I
can add in access 2000
Thanks you for your help!!

If these a way I can send via an access form, 2 different report.
For example, one report in rtf and the other report in snapshot.
Thanking in advance for yourhelp!
Fred.

Can someone help me,
First, I've built a Access form which I can enter data. this form bound
to two table. "Supplier table" and "problem table", Which I created a
relation these two tables.  All the data will be automaticaly displayed