Is there somewhere I can go to find out exactly what all the "event" names do?
For example, when exactly does the "on dirty" event happen or "on focus", etc.
..  Is ther a list out there somewhere?
Thanks

Is it possible and if so how can I change the background color of the
relationship window. I want to make it white.

I'm using a rich text control (the FMS version), and am using the SaveFile
method to create an RTF document from the control. I need to be able to set
the right and left margins of the created RTF document.
The FMS control exposes the Microsoft TOM Interface by providing the

Access2003 in XP
I'm using the code below to append any new records from
(tbl_From_Mainframe) into (tbl_Appended_Data).
It takes more than a minute to search 7000 records for a dozen new

I have a Table of Payments with PaymentAmount, PaymentDate and PaidToID.
PaymentDate is set to Now() On any day, a number of payments can be made to
the same person. I want to create a query that will add together all
payments paid to that person paid within say 1/2 hour of each ...

I am trying to use a LIKE statement in a query to return all records with
certain numbers but I can't seem to get the syntax right.
Here it is with characters:
WHERE     (State LIKE COALESCE (@State, N'%') + '%') AND (Name LIKE '%' +

My db is for a metal stamping production plant. My db design has the
following:
tblEmployees
w/

I know how to use the File Dialog control but I'm not sure how to
actually open the file that is selected.  Here's my code:
'Create a FileDialog object as a File Picker dialog box.
Set fd = Application.FileDialog(msoFileDialogOpen)

I would like to call a function that "returned" several values - all
of which are relevant to the needs of a procedure on a form. I do
understand that FN's return a single value.
I'm wondering, is this a good place to employ a user-defined Type?

I'm trying to use the File Dialog to select an open a file.  Here is
my code:
Set fd = Application.FileDialog(msoFileDialogOpen)
With fd

I am creating a Zip Code search tool. I have a Table with every zip
code and its corresponding city and state. I have also created an
input table that allows the user to input cities and states. These two
tables are connected by a query that looks up the city and state in

When I moved my database onto another computer, the object menu disappeared,
and I cannot design or edit the database anymore.

I'm testing a user's db that contains a very large number of records. I have
an invoice screen, with an invoice select dropdown box that shows all
invoices, and the customer's name, etc. With 80,000+ invoices in this
particular db, clicking the dropdown is painfully slow accross ...

What is the best way to accomplish the following:
I would like to generate a report that changes the text size and
italicization based on a boolean variable (present in the row of the
data source returned by a stored query).

I have a fairly complex interface screen (form) that is comprised of
several subforms that perform different, but related activities. I am
designing a search/filter form that should be able to change the data
displayed in one or more of the other forms, but I cannot find the way