I have a number of combo boxes on my forms that we use to select info sourced
from tables as usual. Problem is I cant get the values that they selected to
show in a report or bound source. Only seem to get the ID ref number showing
that is kept in the source field once an option ...

I am new to creating expressions in a query.  This is the expression that I
have created to yield the number of hours an employee has taken in a given
period  and if no hours have been taken the field is blank.  I want to be
able to sum this field on a report.  The expression ...

I am developing a vendor management database for my company (an industrial
distributor).  The database seems like it should be simple, but this all new
and confusing to me (new Access 2003 user.)  My goal is to allow employees to
query vendors (about 200) and products (about 200) ...

i'm working on a database of businesses for a non-profit right now and i need
to format it in a certain way.
there are a number of fields for the database (about 20) so i'm having
trouble fitting all the fields that pertain to one history onto one page.  

I would like to have a combo box on a form to list the street names. To
assure that the name gets entered with the correct spelling. Should I have a
separate table with street names for the combo box to be bound to? This table
would have to hold several hundred street names. How ...

I've developed a form, tables, and queries that I would like to be able to
send to people that work for me.   The only problem is, they don't have
Access so they haven't been able to use it.  Is there anything I can do to
make it so they can use my form?

Working on a database to track "quotes" created for a project, "orders"
created for a project and 'change orders" created for orders of the project
the quote, order and change order whilst different purpose all have the same
format. They each consist of the main table ie quote,order ...

How can I prevent duplicates from being appended (on the fly via an append
query)
to a table when the type of duplicates I want to prevent are entire record
duplicates not just one-field-duplicates. (IOW: it's ok for all field 1

I have not given up on this idea, but I think it needs to be modified.  I
want the Subdivision to be modified automatically as well, I'm just not sure
how to make it happen.  Here is some sample data:
     Contract ID Division Number Subdivision

Hi, I'm building a database to help track fire sprinkler systems that are out
of service for repairs. I'm just starting and I want to make sure I get the
tables and primary keys correct before I go too far. This is what I have so
far:

I'm getting this messge when attempting to run a reasonably small make table
query.  How do I increase my temp disk space and what is this?  Any info
appreciated.

I have created a database, initially done in Excel.  However, the person who
typed it left quite a number of empty rows between some of the text.
I would like to remove these empty rows without it removing the auto
numbering ie when I delete the row the number sequence is also ...

I want a field on my FORM to have data REQUIRED to be entered.  It's a COMBO
BOX with a drop down list of options.  I want the user to HAVE TO select one
of the options in the drop down box.  If the user doesn't select one of the
options in the drop down box, then I don't want ...

I created a REPORT that lists the household inventory by CATEGORY (i.e.
furniture, collection, jewelry, etc).  I have a SUMMARY EXPRESSION after each
CATEGORY that states the CATEGORYNAME and how many detail records are listed
within the CATEGORYNAME.  The problem follows:

this is what i have just far in a procedure on a form.
strSQL = "select * from tmpDispatch " _
               & "WHERE PreferedMethod = '2'"
however, i cant figure out how i would write in a 2nd where clause. i want to