I've build a couple of forms utilizing queries to first gather data from
several tables and then allow the updating of that data back to the tables.  
Probably a very fundemental process but relatively new to me as an Excel
junkie.  Anyway, the fisrt form's query draws certain ...

I am trying to create a form with 5 combo boxes with each combo box being
based on the one before it.  
For instance Combo1 is populated with a choice of 1, 2, 3.  Choosing 1 will
populate Combo2.

Greetings all.  In Access 2003 I have a form where I set the rowsource and
column count based on the value of a text box.  What I need to do now is to
also be able to adjust the column widths like this
Private Sub label_click

I'm trying to sort out what I can find in HELP
regarding the use of bit string functions, but so
far I've not found how to accomplish that.
It may very well be that I don't have the right

I have a combo box with a record set based on a table tblJobNumbers. What I
want to do is to be able to filter this recordset by a date field
'jnFinishDate' so that you can show either all job records or records without
a date field (null) and with a date within the last six ...

The following code was plucked from a previous post. I'm trying to implement
it in my app, but I'm very much the rookie coder and could use some help.
What I'm trying to do is create a record in a table when the user dblClks on
an item in my list box. With the code below I get a ...

I have 5 command buttons (cmd_Cust, cmd_Agent ...etc)  each with code like
this:
Private Sub cmd_Cust_Click()
   cmd_Cust.ForeColor = RGB(255, 0, 0)

I need some help on probably on something relatively simple.
I am trying to guarentee that something  has been selected in a listbox
before the user can continue.  I am checking a simple multselect,multicolumn
listbox .  The problem I have is if a user selects an item, then ...

Can you code a field in a form to calculate a person's age for another field?
I am doing a database where the user will need to know the age of a person.
If I do a date of birth field, can this populate another field with the age
of the person?

I have a record set that has only one column basically.  It hold
between 0-5 distinct values ascending.  These values can combine to
mean different things.  So, I need a way to look at this data and
evaluate it.  This is within a for loop that looks at each record on a

I have a subform that I have filter based on 4 Combo Boxes. Thats the easy
part, I have the LinkChild and Master Fields based on the cboBoxs.
The hard part that I am struggling with is to turn off the filter on 1 or
more of the cboBoxs.

I have an ‘Auto Expand’ combobox for addresses. The users know most of the
addresses; and in an ideal situaton would just type the first few characters
until the correct address appeared in the box. Except it’s not an ideal
situation because the addresses very often have a street ...

I have been trying to get this to work and keep getting a data type mismatch
error.  The field,"FY_Estimated_PP" is a number - long integer in the
tblProportions table.  I suspect the problem is that data in the form is text
and the field used as a criterion is long integer.

I have a hidden text box on a form. To get information from it, I have to
unhide it (i.e. make visible); set focus to it; get the data into a variable;
Okay, all is well so far;
BUT, to hide it again it can't have the focus. I know to set focus you use:

Is there an easier way to code this?  I have 41 Textboxes and I'd like to
use a variable or something so I don't have to write 41 select cases or if
statements.
Me.TxtDay = Format(Date,"d")