Can someone please tell me how to code for the following?  I have to date
fields.  Date field 1 is red/bolded when Date field 1 is less than Date().  
Date field 2 is Blank.  However, When date field 2 is filled with an actual
Date, I want Date field 1 to turn grey and not bolded. ...

I have a search facility using the following in the after update event of a
combo box:
Dim rstClone As Object
   Set rstClone = Me.RecordsetClone

I'm currently working on the following form (from a Field List):
(these are in form header section)
TECHNICIAN-START DATE-START TIME-FINISH TIME-DURATION
TECHNICIAN-START DATE-START TIME-FINISH TIME-DURATION

Need to multiply the quantity times the input cost and retail on a form is
this possible. So the table can reflect the quantity recieved, total cost of
the item and total retail of the item....
I have tried several combinations to no avail. It would be like extending

Does anyone have a good ZipCode db they dont mind sharing? If so
please send em a copy at d9pierce@mchsi.com
Thanks!

I have a form, listing Invoice Header data. One Invoice per line. On each
line is a button "Select".  When the user presses that button, I want to call
another form and show all the invoice data.  
How do I pass the Invoice Number , as displayed, from the row that the user

I had to upgrade from OffXP Developer to Off2007 because of SQLExpress2005.  
Now I have 2 Access Databases which have forms with command buttons on them
with events which are run from procedures that do not work.  I have seen
where Macros are diabled for security, but nothing ...

I have an active employee Yes/No field in a table.  If my employee has a
checkmark in the active field he shows up on a form called Batch Cover Sheet
and works great.  However, If I uncheck the employee leaves then all previous
records that are related to that employee are left ...

I have a subform and at the botom of the form I have a field called subtotal
which is the sum of the extprice. I have just installed the database on a
system with Vista and Access 2007 on it and for some unknown reason the field
will not sum up the values in extprice

Hi
Currently I have a form where staff members can search for clients.  It
shows Surname, First and Phone.  It also has the client ID and Active Status
of the client (but they are hidden)

I have built a database who's analogy is similar to MS' Forms II How to use
Subforms.  My problem is that in the two part form I can add a new Order
record, but when I had the Order Detail instead of it adding Chai Tea to the
Order Detail it adds another Chai Tea to the Products ...

Hi, this is probably something really simple.
I have a drop-down box that gets its selections from a table, all I want to
do is set it up so that it automatically comes up with one of the items like
a default value unless someone wants to change it,

Okay,
I keep running into problems on this database here and there. The problem is
that I have a table with Employee Number, Date, Job Type, Training code,
Pass/Fail checkbox, Hours, Minutes. I would like to create a form that lets

I am fairly new to vb coding fo Access so forgive me if this seems
obvious.
How do I create a form to allow the user to enter new data thereby
creating a new record, that needs to be inserted into the table along

I am building an Access system that was originally developed in
Excel.  It is primarily a data storage system (hence the conversion to
Access) but its presentation is primarily done with graphs/charts.
Is there anyway I can create nice looking graphs to replicate the ones