Client surveys prostitutes around the world for a health organization.  Unfortunetly, the questions and their possible answers are constantly changing during a process of questionere revision.  Answers are either restricted to a possible list, or are a two digit value.  Once the ...

I'm using Access 2000 and 2002.  I'm trying to find away
that will allow me to update a record on a form.  Also,
I'm using the switchboard and trying to create a search
form which I was able to do but when I pull up the search

I am trying to set an input mask to fill data from the
right but to auto fill the beginning with zero's.  That
is:  Typing 12345 would yield 00012345 ... typing 123
would yield 00000123.  Is this possible?

I have a partially developed database docementation system
Within that I wish to extract the contents of field descriptions to a table
of field names.
The online help shows that field descriptions are specific to Access,

I have a table with multiple records containing uninitialized DATE/TIME
fields, displayed as 12:00:00 AM.
I want to query for them, viz:
SELECT * FROM MYTABLE where MYDATETIME = 12:00:00 am.

I have two alternative designs, and I would value your opinion as to which
is better.
The problem is the old one of bitches giving birth.  I want to keep track of
all those animals born on the same birth date, to the same mother.

I'm developing a database to track patients who are
enrolled in one or more studies. The database will be
large and complex so I wanted to float my ideas here
first to make sure I'm on the right track with the design.

I realize that there are several variables here, but I'm I looking for suggestions on how I can save memory.
Here's the situation:
I created an application withe Access 2002 on a machine with a 2Ghz processor and 1G RAM, running XP Home Edition, saved in Access 2000 Format.
I took ...

I posted this question to another newsgroup but did not get an answer.
Hopefully, I will get one here.
Yes, I am a novice. I am home for two weeks on Christmas leave so I thought
I would teach myself Access. I am signing a database to retain information

I think what I want to ask has to do with the validation rule in my table, but it may be more complex than that. Could anyone help out on this?
My database is designed to track the maintenance activities on around 50 cars in our fleet. What I want to tell it is...
When entering ...

I have an Access 97 database that is to be used as a call
logging tool for an IT Helpdesk.  One specific field that
I am having difficulty with is a Time Open field which
will be a calculated field to show the total length of

I'm at an impasse with this.  I've got a series of work records that get
labor rates applied to them, with the labor rates being updated yearly.
Ideally, I'd like to store the rates in tables (year1rates, year2rates,
etc.) and have a field in the work records that identifies which ...

How do I insert a row in an Access table?

I have a database for entries for a swimming gala.  Once
I have received all the entries I need to allocate a
competitor number to each swimmer for each race by
putting them into a random order and then allocating the

My database file has jumped from a reasonable 1.5 megs to 14.5 megs just as a result of LINKING ~30 Word documents (of ~40kb each) into an OLE field in my table. I'm a little at awe as to why as I was under the impression that LINKING (as I've permitted only via the Properties ...