I am at a loss.  I have a button on a subform (continuous) to select a record
to display on another subform, which has some onCurrent events.  This works
just fine but does take a few seconds and I wish to display a please wait
label on the parent of the subform that houses the ...

I have a subform located on the footer of a Form.
I need to Sum everything in the subform "HrCost" field.
These are the form names:
Main form name: frm_ProjectDetails

I have a combo box in a form with the project list. When you select one
project, the project information is shown. And then if you click on the
'create' button, it launches a subform called MWRsubform and it is a data
entry form.

Hi, I'm having a problem trying to build query selection criteria from
a form... what I'm trying to do is
pass a value from vba to a textbox for use by a query. The value is a
LIST as follows -

I have a form where there are two controls I want users to fill in but don't
want to set the property to required.  I want the form to not be able to
close if they haven't filled in these two fields and if they tab past the
field, it should give you a message box saying you must ...

I have a field called "TimeStamp"  What I would like is that if someone
modifiys or make  any change in the form that  the "TimeStamp" will record
the time and date of change.
How can this be achieved?

I have the following in a database:
MainTable - - fields- phone1, phone2 phone3 phone 4
MainQuery - based on Main table with all four fields
Report - all four fields in the query

Can you change the background of a checkbox to a different color?  Due to the
limitations in Conditionaly Formatting, I would like for this one particular
checkbox background to turn yellow when checked.  If so, can you please
provide an example in code?  Any help will be greatly ...

We have a form with values taken from an sql query that comes from two
different tables.  We would like to enter the information into a third table.
Can some one direct me to code that will do the following:
1.  Provide the Insert sql that shows us how to add the form values to the

I was wondering if someone can help me with an issue.
I have a database that has a CBO called "Balance Change". When the user
clicks the CBO to change the status to read "Closed", I would like for the
"Effective Date Addition" and "Begin Date" fields to be blank or deleted on

I am wanting to set up a check system based on multiple criteria (explained
below) and then depending on the result, will then do A or B.  I figure it is
a pretty basic set up of:
If result = A then

I want to have my Office symbol query using 'like c* or c%' , using wildcards
like you can do in a query... this works but I can't use wildcards with it...
help?  
DoCmd.OpenForm stDocName, acFormDS, , "[group]= '" & strGroup & "'" & "AND"

I have created a small database, for recording details about suppliers. Some
our suppliers offer more than one service, so i thought the best way to
select multiples would be to create a list box.
I have changed the properties to allow me to select multiple options,

I have the following code programmed into a command button to allow the user
to filter records. After the filter has been applied the user closes the form
and clicks on the same command button to apply another filter. Can the form
be programmed so that the form holds the data ...

I have a form with a combo box whose row source is as follows.
SELECT DISTINCT tblAcademics.Description, tblAcademics.Sequence FROM
tblAcademics, tblStudents WHERE
(((tblAcademics.Student_id)=[tblStudents].[Student_id]) AND