I have the following crosstab query called [BuyerIn] which is the
recordsource for my form.  The purpose of the query is to show the best time
to call my buyers back.  It counts how many times I got a hold of them in my
call log table and groups by hour of the day.

When I have 2 mdb's open, one is maximized on screen, the other minimized.
How do I, using code have one activate the other so it becomes maximized.
much thanks...

Is there any free Internet resource available that explains in depth how the
Access 2002 (VBA) Event model works?
Particularly the events hiearchy and how events are fired when a form is
loaded...dunno why but I'm experiencing strange (to me) beheaviour tracking

I am creating a database with checkboxes and option prices. I want it so that
when they check the box it automatically tally the price of that particular
option at the bottom in another field. How can I accomplish this?

Is it possible to set a control's visible property to False based on the
system date and time. Example: If system time >= #05/07/2005# Then
                                  Me!CheckBox.Visible = False
                            End If

I'm programmatically setting a combo box value using a DLookUp, and I would
like to simulate the combo box's AfterUpdate event. The problem is, I'm not
working with the control directly -- I'm iterating through the Controls
collection and setting each control, something like:

I should know this but am drawing a complete blank!!!
I have an Append query.
How do I run it from code?

I have a form (which was designed in Access 2000) with the following syntax
in one of the Subs:
Select Case Me.Form
(more code)

I'm trying to convert (and recompile) a 2000 database. In the form, I have
something like:
-------------------------
Private Sub SUB1

i can use the forms to populate the table.
but if i need to fix something it doesnt update.
i have the forms  set so that i can only see a new record(so that then u
scroll the mouse it doesnt go through ur records it just shows a new blank

In the db I built I have a form that searches for a value in a specific
column in the db.  I have used the expression builder to link the button to
the field in the db.  The problem is that if the value is not found in the
table it goes to a new record.  I need an error message ...

Access 2000
We currently email snapshot reports using an SMTP mailer
We want to change the SMTP mailer we use, but the one we are currently using
will generate a temporary filename in the relevant users local directory,

Hi! This is a long one, so here's the background:
I've got 2 tables, one called tblEnergy and one called tblPackaging. In
tblEnergy I have data for energy consumed for production of some different
types of packaging. The columns in the table have (amongst others) the

On my switchboard, I have an option called "Enter New Job".  When clicked,
the command button calls a macro that opens our Main Form in Data Entry mode
and gives you a blank form in which to do data entry.
There is also a command button on the menu bar called "Enter New Job".  You ...

I have developed an application for learning the
multiplication tables using Access 2000.  I am a little
worried about the kids hitting odd keys, and bringing up
messages they will not be fimiliar with.  Is there a way