I have a subform that tracks multiple activities for each objective. However,
one of my objectives always has the same three activities. What I want to do
is, from the click of a checkbox (with the value = True), create the record
for activity 1 and put specific text in the ...

I have a control in the main form with the following Control Sorce:
=[frmHolds].[Form].[RecordsetClone].[RecordCount] that count the number of
records in my subform. However, now I need to count only specific records
where the column(0) of the combobox in my subform (TXHolds) is ...

I am sorry to re-post this problem I have but I have not been able to find
an explanation. It is this: I want a user to be aware that a message has
arrived for him whenever he gets to the switchboard and then take him
directly to the message by opening the appropriate form.

We use (sometimes) date formats as "2008.04.21"
Using "yyyy\.mm\.dd" data can be displayed in the required format.
Anyway, "2008-04-20"1 should be input (keyboard), unless opsys
Language and Regional Options is set to "."

I need to make a report that will show me a sum of the total, regular,
and overtime hours of all employees for pay period "x".  I know how to
set up a parameter for the underlying query to ask me which pay
period.  I can generate the Total Hours sum easily but I don't know

Hi,
I am fairly new to Access 2003 and I am looking for SelStart and SelLenght
in the properties sheet  of a textbox and can't find them, they are not there.
What am I missing.

Hi,
I am fairly new to Access 2003 and I am looking for SelStart and SelLenght
in the properties sheet  of a textbox and can't find them, they are not there.
What am I missing.

heya all,
On a roll here with questions...   I know it's pretty simple to
disable the control box, min/max buttons and close button, but the
question is...

I have a form with one combo box for Employee Name and a few textboxes for
Employee details.
Upon a combo box selection, I want the details to be populated into the
textboxes.

Hi legends
Trying to reference field FIRST_NAME which is on FrmDetails, which is
on page1 of TabCtl0, which is on FrmClients!
I have tried all sorts of permutations, but Error wins every time!  So

I Create a split form and I would like change some foromanting:
1. change the alternate color
2. Change the font and the size
Thanks a lot,

I have a subform of a form, and the subform has an object property defined by
a 'property get'.
How do I refer to the subform property in a query?
When I used the (sub)form originally as a stand-alone form during the

I have an unbound form, and I use an option group/search box to apply a
filter to its subform.  Here is an example:
If Me.frame_choose_criteria = 1 Then
Me.txt_frame_choice = 1

I want to create a button on a form that will let the user copy a set table
and then prompt them to enter the name of the new table, then paste the
copied table into the same database under the user defined name.
Anyway to do from a form rather than manually F11 and copy/paste?

After using MS Access 2003 (ADP project) for quite a while, I've just
realized that I don't know how to implement something that appears to
be a very common requirement...
Let's say there are two tables, Customers and Orders. Each customer