How can i set up a table design structrue that allows me
recording events, which are 4 month apart?
In the database I need to record 2 vaccination. the first
dose and the second dose. The second dose has to be given

My database has four tables, customer, products, orders
and order/product link.  Is it possible to delete a
customer with a command button, I have tried a few
different ways but because the customer may have an order

How do I update a table with a calculation performed in a
form?  I enter the data in the form, have a field for the
total, have the correct calculation showing in the form,
but the field in the table stays at 0.  I would like the

how can i populate a table(table2) with data from another
table(table1)?

I am creating a database for a local sports team. I need to enter box scores for when goals are scored during the 4 quarters (and overtime
periods). Each quarter is 15 minutes long, and I would need to be able to perform querries based on the times entered (such as how
short/long a ...

I am comparing data from two tables and wanted to create
a field in one table that will only search by the first 6
or 8 characters, because we have some records that are
spelled differently between the two tables. For example,

does anyone knows how can i calculate the size of my
tables or the size of any other object?
thank you in advance

I have a lookup field pulling info from a publications
table (called materialslist).  In the materialslist table
I have 4 fields; pubcode, content, title, and source.
Right now every time you choose a publication only the

I need to increment a number field in a table that will
work like auto number but I have data that was migrated
from Lotus Approach so I can not use auto number.  Does
anyone have a routine to do this?  I also have a problem

Hello--
Whenever I run the Performance Analyzer I get the
following "suggestion":
Table 'tblTasks': Relate to table 'tblTasks'

Acess 2002...... I am loading pictures (to view in forms)
and My database grows incredibly large compared to the
size of the pics I put in it. My pics are 50-70 k big.
When I put in 100 it grows by 300 meg in size.  Does

Please help
how can i only allow user to type leters (like
christopher) only!! not characters (like chris%&her)
   many thanks chris:)

I am trying to delete two fields in a table.  When I
delete the two fields and try to save the table, I get the
following error: Could not find field "XXXX".  What is
causing this and how do I get around it?

Anyone have a routine to reset an autonumber field to 1?

Does anyone know the max records Access can hold before it
brings a network to its knees?