Straight-up thanks for taking the time, if I can help in the future I'd be
delighted...
Here's what I do...
I love using labels that do something on-click.

I have a form with alot of comboboxes on it. Space is limited. One one
occurrence a have a listbox, so I can have multiple selections, on the form.
The current height is the same as the comboboxes .1667. When I write code to
expand the height on the GotFocus event, the listbox ...

I have a Currency field.  When I run it in a Query to display it on a form
it spaces to the right.  When I run it from a DLookUp, or DSum function it
spaces to the right but with a slight space.  Does D Functions have a
different format than a Query?  If so how do you fix it?

I'm working on an inventory of chemicals, where the user selects from a set
of pre-defined hazards.
These records are to be displayed on a subform, which links the primary key
of the chemical record with a linking table (ChemID, HazardID).

I have a form with 4 combo boxes.  1 combo box is independant of the others,
and works without any problems.  The other 3 are a hierarchical control, and
each level's data is dependant upon the selection made from the previous
combo box.  This all works fine, but there is one ...

This problem occurs in the on-click event of an unbound combo box in a  
nested subform.   When a record is selected from the combo box, I want to
update that record with the crewid from the parent form.   When I try to
assign the value, I get the message "you can't assign a value ...

I am using access 2003.  I am attempting to setup an inventory
database for equipment that we loan out to various clients.  I have
followed the Northwinds Example and everything seems to work well when
using it.  Now I am trying to customize the use.

I am having problems here and I know it's something simple and stupid that
I'm missing but here goes.  I have a form that creates a new record into the
table "ASSET".  The table "ASSET" has a one-to-many relationship with
"INTERVAL".  I am able to add the record to "ASSET" no ...

I have a form (continuous) where the user sees a list of all people with a
yes/no checkbox beside the name.  They can scroll down the list and select
individuals by clicking on the Yes/No checkbox.  
I would like to add a button that allows the user to select all or to

If I take out the Dlookup part all is well but I really need that Dlookup.
Can someone explian why?
Const strSQL = "SELECT tblLister.lListerID, tblLister.lFirstName,
tblLister.lLastName, tblLister.leMailAddress, tblLister.lFaxNumber,

Thanks in advance
How do I in code open another database in a different folder and close the
one I am in.
Thanks

I have two unbound combo boxes cbo1 & cbo 3. I would like to have values
that are in thoses boxes to show all record that are in the table.
the fields in the data table are [Program type] = cbo 1 & [Week of]=cbo3
So if ECF is chosen from the dropdown in cbo1 and 1/07/07 is chosen ...

I'm hoping this is an easy enough question for those with more experience
than myself.  I am trying to copy all values from a form which has many
subforms on it to a new form...this works perfectly with the built in button
control "duplicate record."  However, I really need two ...

I think this is easy, but I'm not sure how to do it.  My form has a combobx
that pulls its values from a lookup table.  When the form opens, I want the
combobx to be showing its first record already (without it having to be
selected).  How can this be done?

I am creating a mail parcel database that contains information such as first
name, last name, apt # and our unique mail parcel code that we put onto
parcels when they come into our office, for our resident parcel mail.  I am
at the point in the development of this database where ...