Running A2002
I have a main form with subform.  From that subform, I launch a popup form
for data entry.  When I close the popup form, I want to do one of two
things.

I Have a form named "Suppliers" when I click on a product in the suppliers
Subform it opens a form called products listing that particular product. I
use this form also to enter products.
Question: When I click on a product from the suppliers subform I would like

I may be kicking a dead horse but is there a way to find out what the
background color is that is being displayed?  I'm talking about the
background color that you see when Access is running and there is nothing
else displayed but the database window.  You know, the big blank ...

using a2k if it makes any difference...
when a certain condition in my before update event code (below) is met, i
want to update a record using a query in a certain table in my database. the
thing is that it's important to test whether that matching record is already

I am working on a project that requires approx 600 queries to be
exported into Excel.
I have coded it using the DoCmd.TransferSpreadsheet command.  However,
there are 600 queries that will be exported into approx 50 workbooks.

Attempts to compile Access modules to improve performance results in a
compiler error on the following declaration.
   Dim objOutlook As Outlook.Application
Any suggestions on how to compile this?  Should objOutlook be declared as an

If I want to use the standard Windows SAVE AS box programmatically in Access
2002 VBA, how can I do that please?
Thanks!!

I have a combo box that is populated with data from a query.  I have the
properties of the combo box set so that entries do not have to be from the
list.  However...
If the entry chosen is NOT from the list then I would like an alert to appear

Hi Experts,
A2000, continuous form with 91 textboxes (as squares) based on a query.
Displays and performsproperly. The form displays as a rectangle of 44 (rows)
x 91 (boxes).

am using a2k in case it matters.  
i was pretty convinced what i was wanting was to write this vba in the
AFterupdate event of the form's. what i'm trying to do is test if the user
has made any changes to the controls spelled out in the code and if so in at

I need to create a query to summarize the current month and prior 11 months
invoice totals. The query will be run each month.  Here is a sample of the
code that I created, which is meant to give me 12 months running of invoice
totals:

I have a form that I need to automatically populate a count of the matching
type +1.  I've tried for the value (or default value of TypeCount in a form):
=DCount("[EntryType]","[Components1]","[Components1]![EntryType]=[EntryType]"),
but this gives me a count of all of the ...

I originally posted this some months ago and now trying to attack it again.
I'm relatively new to this, i'll explain as clearly as i can.
What i'm trying to achieve is on my form i want to calculate a current
payout figure based on the current date and start date of lease. I can do ...

I have problems showing both values from a select statement in my list
box.
This is my query
lstArtOversiktOrdre.RowSource = "Select T_ARTIKKEL.NAVN,

This one caused me a few problems.
I have a form /subform where sometimes I want to link by Surname alone, and
sometimes by Surname AND first name. The difference is selected by command
button.