I want to change the backcolor of a text box (question) based on another
field (TL) in my query (true/false).  This is used in a continuous form.
Thank you for you assistance.
Jim

I'm running an after update event on a form using the following code but it
seems like it is incorrect (VB won't run: I get a debug error)
If Me.Partial_Status = "Closed" And Me.Partial_Closed_On Is Null Then
Me.Partial_Closed_On = Now()

Hi I am trying to set up a code so that when values are entered in a form
they are displayed with capital letters at the start of each word for example
a name entered john smith would be viewed as John Smith.
Somebody very kindly sent me the following code to use afterupdate event ...

I have just upgraded to Access2003 from
Access2000.
I have WindowsXP pro MediaCentre.
I have a new dual-core Pentium IV and 1Gb

Some help again please.   I am stuck.  I have gotten some help from the
newsgroup regarding filtering records in a form based on a value in a
combobox.  I have tried this and it does not seem to work.  I have created an
option group and applied the code below to the after update ...

I'm trying to select a record in a listbox based on the value of a field
on a form.  I thought this would work but it doesn't.  Any help appreciated.
Thanks
DS

I have three list boxes on one form. When the form opens up, only one list
box is displayed. I would like the second list box to be displayed when the
user makes a single selection in the first listbox and display only the
related records to the selection. The three list boxes ...

I have an unbound form with an unbound listbox.  The form is being used to
update a table.  Since it is unbound, I have to code for "write-after-write"
conflicts.  I define this as:
1) User 1 selects a record from the listbox to edit.  My code puts the

I have a small problem... My cursor is going into wrong text box when
opening some forms.... Tab order is correct and  it doesn't change the
problem even if I change the taborder....
Any Ideas?

Can anyone tell me what this means. I get this from my forms "Before Update"
procedure that checks each If statement for me which works fine. I just get
this message after. Do I need this and if not how can I get rid of it?

I have a list box with 4 columns, Two column are text and the rest are
numeric values.  However, these numeric columns are always left justified
just like text column.  Can I format and display these numeric columns to be
right justified like a value should be?  Thanks in advance ...

I have one form with many fields .this form is set to maximize on open.now i
have many other command buttons to open other forms i.e.to add new Name or
new country.those forms are small in size.so i want them to open with there
size only not maximized.without affecting my main ...

I created a database in .mdb format and want to distribute locally in .mde
format. Part of my code below checks for either the .mde or .mdb format and
opens the database accordingly.  Is this a correct method or is there a
better way.  The purpose is to allow me to test and develop ...

I have a form tblDISCIPLINE that is based of a qryDISC which is based off
tblDISC
For some reason when I input new discipline records and close the form, then
reopen it they are gone. (I do have 1 update and 1 delete query that run

Let me start off with - I'm not a programmer - I'm a person that has been
using access for years (the backend tables and queries and reports and such)
and has never had to try to design a user interface.  
I'm trying now to get through creating a user interface for my boss so he