I have setup two combo box fields with list value row
sources equal to the Row (EE, ES, EC, EF) values and
Column Headings (HS, HL, MC).
Here is the Table I want to lookup from:

G?day All,
How do I create a quote number that relates to a an already existing number.
IE The old hand quote numbers might stop at say 1000.  At the moment, my
test data base uses an autonumber for the quote number.  From flipping

A2K
I want to click an item in a list box on a Main form and create a new record
in the Subform with the same field automatically filled in.
For example, first of all the main form has an unbound combo to select a

I have a problem with Internet Explorer, the screen locks up alot while i am
on
the internet. Any ideas to solve this is greatly appreciated.
Thanks, Ralph

I just got Word 2003.  In a previous version of Word, I always recorded a
short macro to Hide Spelling and Grammar Errors for the current document.  I
did that with Word 2003, and, while it selected the two check boxes in the
Options menu, it did not hide the spelling and grammar ...

When my Access 2002 query returns records, I also want a total count of
the records returned.  An example would be:  I run my query and return
detail records for college freshmen, (say their names, major, age and
grade point average).  I also want to have a count of records ...

Hi. Is there a way for Access alerting you  by way of pop up or something,
when you are entering data twice, i.e. new customer, to let you know that,
that name has already been entered before just in case you are duplicating a
record? If you have 4 thousand records, it would help ...

Is there a quick way to convert a form to a report?

does anyone know where I can download files (list of city, states) to be used
in msaccess combo box? Also, has someone have a sample code on how to link
these files in a msaccess combo box? Thanks.

I've got the following query and it's prompting me to input Account
Status.   I thought I had it coded to look for AcctStatus is 'A'.  I did
this in design view.
SELECT DISTINCT qryUsedDIDs.DID, qryUsedDIDs.ClientName,

I have written a function to format a value in a form's recordsource.  But
when I run the form, I get #Error where the return value should show up.
Here are the hypotheses I have tested.  The text of the function is at the
bottom of this message.

I love Access, really looking forward to using it?

I have a query that finds the exact data that I need for a report. It
presents it in table form which is fine.
Then I need to run a report against the data acquired by the query. How do I
tell the report to use the data in the query result and not the data in the

I have entered the following VB to create date sort criteria.
Private Sub Command4_Click()
Dim strReport As String
Dim strField As String

I tried searching these pages in hopes that someone else was having the same
problems as I was but even the new users are more advanced than me.
I am trying to create a database for a small commercial imagery site that
will allow us to track our collection progress.