I am trying to use this code to count records and if the record is
found,"Your Data was entered".  If no record is found I am trying to give
"Your Part Number was not found" and not enter the data.  Here is my current
code, what corrections do I need to make?  thanks in advance.

I have a problem with multiple many-to-manys. I am trying to design an
application whereby I have all my contacts in one table. This is for the ease
in editing and maintaining my lists. The problem I face is that some of my
students qualify for all the following tables; ...

A counselor selects a student in this database's form and then in a subform
the counselor makes course entries. We have been entering multiple courses in
the subform for 3 years. Now we get an error message saying we have a
duplication in an index, key field or relationship. I ...

I am working in a database in which the original creator designed a primary
key and relational ID with a naming formula.  Overtime this has not worked
because people have changed the naming formula and some other mishaps.
My question is I would like to currently establish a ...

I downloaded the classroom management template, and have been working on
customizing it. When I create a new class the students sub-form of the
classes form automatically fills with all of the students in the students
table.  I want to make it so that I can pick some students ...

Does anyone know if its possible to save the table relationships diagram so I
can email it to someone? So far I can't see how it can be done.

I have a Supplier table that contains 'supplier name' and 'supplier number'
fields. Both are unique. I have chosen 'supplier number' to be primary.
In a related Contracts table I also have supplier number and relate to that
with cascade update selected.

I hope someone can help me with this one please.  I have a table of students
that contains many of their personal details.  I've used an autonumber for a
primary key in this table.  I also have another table that contains details
of numerous placements that they can attend, with a ...

How can you find out the size of tables in a database without having
to export each of the tables?

Is there anyway that I place a button on a main for form to switch the
subform form view between data sheet and form view? Or is there another way?
I don't mind manual workaround like right clicking something, but can't spot
it.

I wonder if you can help me, I am trying to create a database for a printing
company.
What I have so far are the following tables:
tblClients

Is there a standard protocal for setting defaults in a table to avoid Null
values from occurring? I'm thinking that all numeric fields should have a
default of zero (0), text fields should have a default of one space (" ") and
any status fields such as, in the case of a Purchase ...

I'm trying to build new tables in existing databases in MS Access 2003, using
VB6 SP6 on an XP box.
It's working pretty well, except for creating fields of type "Yes/No".
Here's some sample code (I left out the variable declarations and code for

Hi all. I am attempting to put together a database for a health
project..
There are 2 types of questionnaires, but they have in common that both
of them collect the same clinical measures. So there is tBaseline (one

I am building a new part of my database to show customers/customers
equipment/work done on equipment
Customers - is easy, its the other two parts, I need the equipment to show
the last time the equipment was sent back but to collect the info from the