I posted the same question in access.gettingstarted forum but no answer, I
think I may have posted in the wrong place so I am trying this forum.
I have a VB6 form which uses a .mdb file as its database to save some
textual data. The users want to be able to draw some graphic ...

In a db built for surveys, can I sort (rank) multiple numeric fields for one
record?  Each record has 24 fields ranking students on performance.  I want
to be able to rank the responses to show at which of the 24 areas the
students are strongest and at which they are weakest.

Question:  How can I program Access 2000 to sequentially create the
scheme for each new record:
A001, A002, A003, ...A999, B001, B002, ....B999, C001, C002 and so on,
ending at Z999.

I am using Access 2003 and am trying to figure out the RowSource for a field
in one of my tables. I am trying to limit the values that can be entered in
said field.
I have created a query with the following SQL:

I have a pre-designed table that contains a memo field which I need to
convert to a text field for use in analysis.  I'd like to automate the
process rather than opening the table and performing the conversion each time
- any suggestions on how to quickly accomplish this?

Before Christmas I was asked about the possibility of setting up a training
database for the employees. Instead of typing out the fields for every table
I have decided to describe the relationships instead:
Each department has many sub-departments

Using Access 2003. I have a school volunteer database. Trying to figure out
the best way to design my tables. The database contains families where the
members have different reasons for being in the database, e.g., student,
parents in various volunteer roles, etc. Do I need a ...

I am creating a form with a subform...the tables behind the forms are
PatientData and MedicationRecord in a one-to-many relationship with
strChartID as the primary key and linking field. I would like to generate a
unique chart number and so far I have built the following:

Tried everything I can think of and it looks good right up until the new
field is displayed

I have a question about splitting the database and making into an
MDE file to distribute front ends.  I have several reports in my database
that run and use a temporary table that is populated by a query.  When I open
a report, I select certain parameters, and then a temp table is ...

I have a field which is a primary key field in that table.
In another table, I set this field as autonumber but it disallow me to do
that because I have primary key field to be set with data type autonumber...
So, what should I do? I want it to be update cascade and delete cascade ...

I need to create an autonumbered field in my access 2003 database that
looks like the following:
DCR-07-000
The DCR is a constant, the 07 is the year and will need to update as

i've created a custom input mask (which is now a part of the input mask
wizard) and want to remove it so that it doesn't appear as an option from
within the wizard.  how do i do that?
thanks,

I have created a table to capture the system date but it will not work.  It
says there is a "in table-level expression" error.  For the date capture, I
used Date().  For the time capture, I used time().  I don't know about the
time expression since I have never used it before.  I ...

I’m trying to develop a database to track Engineering Change Requests (ECR)
and prevent drawings that are under ECR from being printed.  Once an ECR is
initiated, the drawing's status will read "Under ECR Control" and there are 8
Yes/No questions to be answered (such as is there ...