Hi, this is my first project and everyone has been very helpful to me. Thank
you.
I have one more hurdle, if someone can help. I have a list box which pulls
customer orders as the result of a date search. When I select a customer in

Subform in datasheet view.
"If field 1 contains no data, use field 2, else use field 1"
Field 1 is formatted for date, ie "dd-mmm-yy"
Field 2 is formatted for text

Any recommendations on basic manuals for Access?  I'm currently using an
Excel spreadsheet to track approx. 1000 pcs (lines) of correspondence in a
year(approx. 28 fields/columns).  I think that Access would get me
better/faster/easier reporting.  However, I have almost no ...

I have set up a database with Two Tables. I have created one of the tables
and have inported a table from another exsisting database. I have set up a
one-to-many relationship but now I am not sure what to do to make the
information link to the new table.

I have a form that allows add/edit /view ENTRIES. The record source of my
form is the master_table (not a query) that contains all the ENTRIES.  I used
the record navigation functions of ACCESS (prev record, next rec, add rec,
find a record and so on..)

I was asked by my company to sort out some shared excel workbook problems
and I thought I'd give access a try.I created 3 tables each being linked to
one another and then created a data access page.My question is can you run a
active query on a field  that constantly searches the ...

I have a Access database that I inherited, and I do not want to alter
the inital table or forms.  I am adding a table and I want to insert a
new record and assign fields of that record with some data from the
first table with data from the first table in the second on a button

I have a button on a customer form that sends a message to the customers
email address.  When I click the button a new Outlook 2003 message opens
with the email address filled in.  Very nice.
If the customer happens to be in my outlook contacts I can view a log of

I know this is a basic question, but I'm trying to design a query in a
database so that I can enter one field (for example a music cd name) and have
it display all information about the record that is searched on. So far, I've
manager to build my query but it shows the entire ...

I have been reading a lot lately about possible database configurations and
I am not sure whats best for my situation.
I want to make a database for my office.
About 10 people going to work with the database and I made an estimade of

I have a subform embedded inside a form.  It only shows one row of data.  I
would like for it to show all the data.  The subform is linked to a query.  
Thanks!

Using Access 2003 and trying to convert an excel formulat into Access, but
Access doesn't recognize "then".

I am trying to create a search criteria for a query which selects for entries
by a specific user in a database, or if no-one is specified returns all user
entries.
The following criteria performed the task to my satisfaction:

I have created a combo box with 5 drop down choices.  I want a date to be
enabled if the user chooses 3 out of the five choices, otherwise i want the
date field to be disabled.  I know how to do this for a yes/no combo box, but
not if there is more than one choice. Any advice ...

I am creating a form where I want to conditionally format one control based
on another control.  The first control is a Yes or No question, and the other
is a "If yes, then give the date". I want the second control to be disabled
by default, unless the first control is "Yes".  I ...