I am new to access and I have removed a record from a "Customer ID" field and
now when I run a query it shows 24 records and there are only 23, which makes
all records after the deleted file off by one , is there a way to correct
this ....

I have a field which I want to have an initial capital - I know this can be
done by an input mask but I was wondering how it would be done with VBA?
Some code in the Before Update property?
Thanks for any help,

I have a property table and a tenant table.  I would like to create a new field
{propertyID} + {TenantID}.  One property might have several tenants or none
at all. Also this field needs to be a primary key for new table

Trying to create a dbase that keeps track of client name, their affiliated
codes (could be more than 1), and the reports they use.  We have about 150
reports but not all clients use every report.  Trying to sort out a proper
dbase and the required form for entry of new client, ...

I'm looking for  database to manage my stamps collection. I'm using Access
2003.

Please Help.
I downloaded the time ad billing database and I havent change anything, But
when I checked the invoice, and I put a start date a run time error 2465
shows up, it also says Print Invoice Time Subform cannot be found and if i

I use Word 2002.  While editing text (and occasionally typing a text) I find
the cursor speed and letter image-reproduction to be very slow.  What
accounts for this?  
Mal

How effective are the Forms generated by Access for doing the things you want
in interactive applications? ie, if you were building an end user application
with Access, would the Forms generated by Access using the wizards allow you
produce some or all the functionality you ...

Good morning!
I made a form with command button that opens a new form. Can I put a piece
of code to close the first form in this code too? If so what piece of code
and where exactly to put it?

I have 5 checkboxes and I was wondering if I could make it so that when one
checkbox is ticked all the others can't or with some only certain ones can be
ticked
Morning

I did a little searching in the groups but have been unable to find this
information.  If someone could offer advice I would really appreciate it.
I have split the database so that multiple people can use it and so I can
continue to develop the front end.  I want a button on my ...

I store the company name that is displayed on all my forms in a table. I use
DLookup("[Company Name]", " Company Details") to retrieve the company name
from this table. Is it not better to retrieve the company name at startup
and store it to a global variable?

I created a database that use's the check box(yes/no) my question is "How can
I
tabulte the yes and no's. example: show if 5 or more meetings were attended,
for use in a query

I believe my tblECR Needs to be broken apart to achieve 1 EmployeeID field
per table, but I'm not too sure on the best approach for this. This is an
engineering ECR tracking database where each record shows multiple tasks
performed by multiple employees. Can someone point me ...

I need a validation which will not allow booking's < 1 week and not more than
2 months in advance of the date booked.
If any body could offer ny advice I would be very grateful