Say I have a table with Parts Numbers that are something like A101, A102,
A103, B101, B104, B105, C101,.... etc.  I'd like to be able to hit a button
for a new record, be prompted for the Prefix (A, B or C) and then have
Access figure out what the next available number would be ...

Suppose I have a table in which there are two fields called, let's say,
Sender and Receiver. Sometimes (eg. when the value of a third field is
"holiday") the same person is both Sender and Receiver. How can I automate
this, so that when "Joe Bloggs" is entered for Sender on a ...

As always, much thanks in advance!!!
I have a table that lists payments from clients.  One column of that table
lists visits numbers and diagnosis that are connected to that clients.  For
example, one client (#12345) might have two visits (1 and 2) and have two

I am a new Access user and I am an in the early learning stages.
I have multiple tables, one of which has customer order information in it.  
I will provide the SQL of what I currently have, but this is what I want to
do:

is it possible to move down more than 1 cell at a time when enter is pressed ?
as I am entering numbers and the cell above is used to i.d the week number
and so I have to go down two cells to enter each number. I am using excel on
a pc using windows 2000

I have a form with two multi-select list boxes then a command button to run
the query.  The results are then displayed on another form.  Here is where my
problem starts. I want to be able to print the results.  I created a print
form button via the wizard but it just prints the ...

I have created a database table containing contact details of club members. I
now want to add a way of recording which events they attend and how many
guests they bring. The idea being so we can monitor which of our members are
active

I have several fields that have yes/no and would like to run a report
that shows just the total of "yes" for each field.  Some of the records
have yes in more than one field.  Any suggestions?

I have a simple table with 4 columns.
ColA = just sequential id numbers
ColB = machine ID
ColC = owner ID

I have on my database a listbox where you can make multi selections. How can
I make it so that when I close and then re-open the database the selections
are still in place?
I'm a complete beginner with Access so any help or advice would be greatly

i want to insert a text box in web page and retrieve its contents from an
access database

Can any body suggest me that how sud i start.What is exactly
Payroll.Can any body has sample of database diagram of Payroll database
Plz help me it's very urgent

Is there any way i can choose more than one value, using a list box in a
table?
In one of my tables employees sometimes belong to 2 or 3 categories (shemes).
How would i show whos in what category (sheme)?

Hello, I'm using Access 2000.
Does anyone have an example of how to hide or unhide a form programmatically
?
Don @ SureFireSolutions

I have several fields that have yes/no and would like to run a report
that shows just the total of "yes" for each field.  Some of the records
have yes in more than one field.  Any suggestions?