I would like to set a date to be red if MOT is due this month and yellow if
next month.otherwise leave it black
but doesn't work ... why ???
(put it in the Form_GotFocus event as well ) same result ... no change of

I have some code that is updating a DB table using SQL.
There are various field types, currency, boolean and string
I am using a function to set a value and in that function I want to check
for null values. However, the value passed to the function is of type

Group
      I would like to be able to copy the string data from a variable to
the clipboard. For use in my CAD package via the paste command.
Thanks

I'm trying to remove records in one table that match those in another table.  
I have the following code but this seems to make Access 'Hang'.  Is this the
best/correct way of performing this type of operation?  Any suggestions
gratefully received!

How can I add a autonunmber from table1 into  table 2, however there is
already data contianed in Table 2 (which was copied over from Table 3) in
other columns and I need the autonumber to be entered next to the data.
The following code I have tried but one add's a new row and the ...

How to display 2 images from a folder in a form and save in database

I am getting an error code, "You can't carry out this action at the
present time" with only an OK button.  It occurs after I update a record
set and try to close my form or navigate to some other record.  I have
to close Access to get out.  What is happening, and what am I doing ...

on my form I have 7 selection boxes (if  translated  well) which I can check
or unckeck.
Now I want to add 2 new ones but I can't find a way to "combine" these new
selection boxes with the previous created ones...

Hi people.  I'm having trouble with a combobox; I'm not sure if this needs to
go in the "queries" posting, however.
I have a combobox and command button in a main form (frmWGBRESID), which
also has a subform(sfrmLINECOVERID).  The command button assists the user

I get e GPF when I print from a form.  I even went back to make sure the file
was compiled.  Strangly enough, I was thinking that the file was corrupt
because I tried to use another db that makes the AllowByPass = False and got
a DLL error # 48.  I created a new db imported ...

I have a field called "Policy Number" which I defined as the "Number"
datatype. I need to know if the number of characters in that field are either

I tried using the LEN function but it only seems to work on string data types.

I'm trying to create a data entry form that will spot duplicate pay dates.
Each record will have an employee number, amount, start date and end date.
The record can be for a single day(start date) or multiple days(range between
start and end dates) so not every record will have ...

I have a subform that contains child records that a user can add/delete.
Based on a particular selection on one of the fields (a combo box) , I want
to disable a field (control) on that particular row - ONLY for that row.
When I disable/enable a control on the detail row, all ...

programming is not my cup of tea, but someone has do it
I have a submit job form, with has 4 command buttons,
1) submit job
2) clear job ( which clear all the text on form while its open)

Consider the following code sample, and in particular, the assignment
Me.Dirty = False.
------------------------------------------
Private Sub cmdPreviewFax_Click()