I need a msg to appear if the combo box a user clicks on doesn't have any
values listed.  I've tried on click, on focus, on enter  If Me.Combobox1 = ""
Then Msg ("...."), but nothing is working so I'm thinking I need to code a
different way to count the number of values.  Thanks ...

I`m traying to create a line chart based on a query.
but the data for the vertical axis is always a function (sum, count etc..)
and that is a problem becuse I want to show the value according to the date
(which is the horizontal axis).

TIA all,
   I'm just NOT getting the syntax here, maybe I'm just tired. I'm not even
sure how to explain it, so bear with me if this is a tad unclear - a long
running project has had a change request requiring a new status which, if

If I wanted to dynamically add new text box controls (or any control for
that matter) to a form at run time how would I go about doing this?
Thanks,  Brad

Here's my table structure:
Employees:
EmployeeID (primary key)
FirstName

I need to set up a database using stop watch times.  I am timing equipment
failures and using a stop watch in 100's of seconds.  I can't figure out how
to do this in Access so I can use the time to calculate variances and
differences.

I'm in the process of building a customer service type of database.
On it there are two forms, say frmMain and frmReview. frmReview is a subform
of frmMain and is related to it by an AutoNumber field. Referential Integrity
is enforced. Incidentally, I've tried solving withis ...

I have an SQL statement that is getting hung up on the percent field.
The data type in the table is Number, format is percent.  The field on
the form is unbound with a percent format, 0 for the decimal places.
Dim PMSQL As String

I have several tables that I want to export to Excel and have them exist on
separate worksheets within the same workbook.  I'm using this code which
creates the Excel workbook.  How do I cause the second output query to
create the second sheet in the same Workbook. instead of ...

Code Problem - It stops on the - Me.Bookmark = rst.Bookmark. I can;t figure
out whats wrong. I have used this code before in other forms to do a lookup
and or add an item if it doesn't find the item. It is getting to this one
step and fails. Any ideas?

My database involves volunteers.  One may be a primary volunteer [vol1] or
secondary volunteer [vol2].  Any volunteer whether primary or secondary
accumulates kilometers driven.  I have a report which needs to total kms driven,
regardless of whether it is the primary volunteer ...

Hello again,
What could I use to perform the following.
I have a CD with data on it except its not all in one directory
eg:

Hopefully someone can assist me with this particular situation:
I have a search form that checks three text boxes to see if there is
anything entered in there, and then checks two more text boxes to set up a
date range for the search. However, when you enter the information and ...

I really am a better Access programmer than will come across here.  I have a
relatively simple problem which for some reason is really stone walling me!
There are 3 tables, a form, and a report involved.  So here goes:
The first table is names of volunteers.  It is related 1 to 1 ...

I am trying to do a count of records within a textbox at the form's on
current event.  The following is my code (which isn't working), I am not
getting an error message - just the wrong count.
Current_Vendor_Count = DCount("*", "tbl_Vendor", "(tbl_Zip_Code.Zip_Code =