I am new to ACCESS but i want to use an AUTONUMBER field, but i want to the
autonumber to be CD001, CD002, CD003 and so on.  Is there any way of having
that field in the autonumber in the 'CD000' format?  Any help would be
appriciated.

I am trying to create a contact management / lead fulfillment solution for a
magazine.  Advertisers to the magazine can get leads two ways.  The readers
can 1) Enter in the direct Reader Service number for the advertiser or
product, 2) Check a box to show interest in a category ...

I don't know too much about access but all that I know I am learning from
mistakes.  I have built a database that will help all administrative types in
my command keep track of data.  I need to put check boxes into the spread
sheet and I don't know how everytime I try to click on ...

Does anyone know of an existing template for Access which I can use as a base
for a club membership system.  The 'Contact Database' template which comes
with Access only partially covers the sort of information I need for club
members.

I'm helping a local county office with a fairly big project. This county office does Assessment,
Taxation, Survey, etc. We're just at the beginning stages of setting up tables in Access. Tables
will eventually be upsized to SQL server. We're also going to have to migrate 15+ years ...

Suitable to respond to very blunt questions on the legitimacy of my
statements in a previous response

How can I control a field to be read and written only (can neither delete nor
edit) in a data entry form, please?

I would like to download and customize a database from Microsoft.   How can I
customize this the easiest?

I have tried using the current formula online ...namely...
=DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now(), "mmdd") < Format(
[Birthdate], "mmdd") )
but the program [access] doesn't like this, and keeps spitting it back as

I'm building a database in which I would like to have checkboxes
automatically checked on a summary form once certain other information has
been entered into the underlying table.
Is there any way to do this???

Not sure if this is possible, but would like to automatically add new data
from Field1 into Field2, but keep data currently in Field2 as a history.
Field1 = StatusCurrent (Memo Field)
Field2 = StatusHistory (Memo Field)

I want to make a  calculating machine.
IF i have a score, i want this value become a string
e.g.
if [num]>80 and <100 = "A"

Try this test open any simple form and close again ,eventually MSAccess will
bring up message not enough memory.
eg try Northwind database opening categories form..
Point at which it happens depends on complexity of form .This is a Big BANG

I am trying to build a one to many relationship where the One is a normal
field named 'UserID' within the first table while the Many is a Primary Key
named 'UserID' in the second table. I also want to enforce Referential
Integrity at the same time. The problem is that Access ...

I have two  SQL statements, one is giving me the total Quantity
available(from Stock table) and the other one is giving me the total number
of Quantity sold out.(from Sales Table). All these are GROUPED BY Item Name
e.g Handbags 3