I have programed a maco to open one of various forms depending on criteria on
an open form.  Is there a way to run a "follow up Macro" based on which form
opens? In other words can I run a macro based on wheather a certain form is
active?

I have a few text boxes that need to overlap for colouring effects (don't
ask), but i can't seem to let the "top" text box (or label if you may) be "on
top" and transparent.... this is the one with the actual text on top of three
adjacent boxes each with a different colour. Where ...

my application have customers and invoices.  each customer can have 1
or more invoices. on my form i have a subform for customers and one
subform for invoices. both subforms are in datasheet view. if i click
on customer A in the customer subform i want the invoice subform to

I have a problem where after I created this form, I entered data in one field
and for some reason, data in another field pops up automatically. The strange
thing about it is the field that pops up comes from another table. So the two
fields are unrelated.

Help I'm totally baffled by this formula.
I am working on a holiday database for our staff and need to stop employees
booking holidays if they dont have enough hours.
I have a main form which holds their entitlement, totals from 3 sub forms

Any ideas for a newbie as to why this statement won't work?
SELECT (Format([Date],"DDDDD")),Sum([ClalibratorOD]) AS
[SumOfClalibratorOD] FROM [tblBBiEIAQC] where ([Date] >= 1/1/08 AND
[DATE] <= 3/30/08)  GROUP BY (Int([Date])),(Format([Date],"DDDDD"));

I have a main form (no data source) that I use to hold objects for navigation
(QBF fields & buttons, Report form buttons...)  On the this form I placed a
subform (PendingCalls) based on query to give show the basics of pending
calls only, on that subform is a button that launches ...

I’m having a problem with a “total” box in a Call Sheet (request for payment)
form using Access 2003.  The total is a number (currency).
I have ten subforms in the form that link to the term “Call Sheet #” titled:
“line 1 BPA data subform” through "line 10 BPA data subform"

Access 2000
My checkboxes are so small that you cannot see entire check.  How do I
increase the size of the box?
Thank you

I am not familiar with Access, so please bear with me as I try to explain the
problem. I have Access 2003 SP3 running on a Windows 2000 Terminal Server,
and the user has an Access form pulling data from an Access database.
When the user open this form, there are a number of fields ...

I have a form that has a tab control. The tab control is for yearly info
(2003,2004,etc.) and has 5 pages. Each page has 4 identical subforms
displaying monthly data (month and amount). Do I have to have 20 subforms, (4
subforms X 5 pages) or is there some method where I could use ...

I have created a button that is supposed to duplicate a record, but every
time I try it , I get the following:
"Record(s) that CAE Project was unable to paste have been inserted into a
new table..."

I am having issues on my search page.  I cannot seem to get certai
fields to search correct.
The fields I am having problems are listed below...
1) ID = This Field should be coming from Qualification Area FORM

This has to easy not requiring any programing.
I have two columns in a table. One column is "customer name" the other is
"customer code". I have a form where I currently use 2 combo boxes where I
either select from a list or type each in. I would like to enter the

I have created a form that has one combo box on it, ftom the the user clicks
on the list of available "account codes" then hits a command button that
produces the report, It works fine in Access 2000, Access 2003 and Access
2007, now place the exact same data base in a machine ...