I am currently working on a database for an organisation that deals both with
individuals and families. I am particularly struggling with how to organise
the relationships between tables when it comes to coordinating information
about families.

I'd like to have a defult field in a table to display the number of "Yes's"
in the other fields of the table. Is that actually possible? or do I have to
do that with a query?
I'm assuming it's something along the lines of count([field name}if "Yes"...

When I drag a command button on my form, the wizard doesn't start. How can I
get it back wihtout re-installing Access ?
Thanks

Access help says Yes/No format displays checkboxes on controls, but how do
you get it in datasheet view?  It's possible because I have some that display
checkboxes, but any new design won't do it.

Hi, I have a table designed, there are over 1000 records and I need to create
a link/hyperlink from each record to a tiff file on a CD rom. I have one
column whose field name is the same name as the tiff file name (how will the
extension be read?). If I had to complete this task ...

The company needs me to merge two spreadsheets from two different departments
and put them into a database all can use. Both spreadsheets have over 15,000
records.
The first speadsheet has company, address, and some accounting info. The

I know this has probably been asked before but I was wondering how I can add
a new record to a List table when it is typed in from the Selection table?  I
would like to add new City names to my City list table when it doesn't exist
as a selection from selection table.  Updating a ...

I was wondering if there was a way to create a validation rule for a table
field for this situation?  I want to be able to validate and make sure that
the Name entered has a minimum "2 text characters" followed by a "comma" a
"space" and then followed by another minimum of "2 ...

I'm creating an attendance database, and I've figured out how to click time
in and out and then in and out for illness. I'm doing all this in a subform
and the mainform has the client's name/information (169 records). The problem
is I don't want to add today's date for 169 ...

I am trying to secure an application against Users being able to access
Tables, Queries etc>
MDE is not working for me on two counts:
1. after carefully 'converting' my database to 2002 format, and then

All,
I consider myself a decent (albeit rusty) programmer, but I don't have a
lot of (recent) experience.  I created what I think is a decent database
that will manage the annual evaluations for my office of about 210 people.

I am working in Access 2000.  I am creating a database to record Yes/No/NA
answers to 92 questions of an assessment.  The purpose of the database is to
provide standardized recommendations to any questions answered with a "No".  
The 92 questions are grouped in 12 category ...

Would anybody know of a code I could use in the format section of a field
wihich will cause only the first letter of seperate words to be in uppercase.
e.g.
A name in the format of John Smith?

I want to print a report (of my checkbook) of the upcoming bills for two
weeks in a calendar format:
SUN         MON    TUES      WED      THURS     FRI     SAT
Phone                   Elec                     cable

When some one calls in they need to provide us with their acct number
so my form will look like this
Account Number__________________
Re-enter Account Number ________________