I have two fields: Date/Time Started and Date/Time Finished.  If I create a
third field called Amount of Time Spent, Is there a function I can include in
it that will calculate the amount of time elapsed between Date/Time Started
and Date/Time Finished?

I have a Phone list that I would like to set it up so the user could just
click on the name and it will open a form that has the record for that name.
Here is the code that Im using.
Private Sub POC_Name_Click()

I have a combo box on a parent form that when a selection is made, it
retrieves a set of records that are displayed in a sub form.
I want to set the sort order of the subform from the parent form but I can't
get the syntax correct.  It should be something like this:

Well, according to http://support.microsoft.com/?kbid=208998 I should be able
to reference the value of a subform field by assigning the control source.  
However, while I can get the value by qualifying it from the immediate window
I get the #Name? in runtime mode.  Anyone ever ...

How do I change the color of the title bar?
On the whole application or on the forms.

Microsoft Access 2002.
I want to create a form that only shows records in a table that meet the
criteria of a certain field, not one that shows all the records in a table.
Example: table fields include name and sex (2 options). Can I create two

Which property tell me that a form is opened as modal dialog with
docmd.openform ...., acDialog?
I have checked the property Modal and Popup, these are false.
Thanks

I have a combobox ('sexcode', in this example) that if 'f' (for 'female') is
chosen, I want to gray out a frame that holds an Option Group.  I want to
also gray out an Unbound label ('Label8' , in this example) next to the
Option group.  The following code grays out the Option ...

I have been working on this and it may be over my head. I need to set up a
cmd-btn that the user can use to send a report. Im working on the DoCmd.send
but I cant get it. Here is what I have now. But I get a Compile error. What
am i messing!?

I used the command button wizard to create Next Record and Previous Record
navigation buttons, but if you click on one of these buttons when you're in
the First or Last record, a useless error message appears saying "You can't
go to the specified record."

I have a weird problem happening in an Access form.  My form has several list
boxes on it.  If the user selects something from List Box A it limits there
choices for List Box B.  This code works fine.  However if I put a line of
code to in List Box A to deselect any choices from ...

Access97
As part of the loading routine of a report front end I have the following:
    DoCmd.RunSQL "SELECT tbljobdata.JobId as JobNo , tbljobs.CustomerId
as Acct, tbljobs.[Date Received] as DateIn, tbljobs.OrderNo,

I'm not sure if this a problem with the form or not, but it only occurs in
one particular form when I attempt to create a new record starting in any
field in that record. And even then, it occurs sporadically. Once I click
the OK button, the table takes the new record as though ...

How can I rename a folder using vba
tia
Tom

My problem is that I have two subforms on one main form and i want to compare
the data on the two subforms. The fields are the same for both forms. the
data for one of the form has actual cost and the data for the other form has
forecast cost. When i view the data on one of the ...