Is there an easy way to set a validation rule for a table field that is
based on the value that happens to exist in another field in that same
table?
What I would like to do is that if "field1" has a certain value in it, say

I have an Table tblassets which has a field fldcurrentloc. In another table
tbltransactions I have another field fldlocationto. What I want to ensure is
that fldcurrentloc is always be the same as the latest entry in
fldcurrentloc. The tranactions table does have a flddate so ...

Using Access 2003, table one is the main table for storing report
information.  Table two is a lookup table with records to be able select a
specific unit for the record in table one.  The unit data selected from
table two is stored in a single field in table one.  However, there ...

ia m forget my administrator work group password and ican't access to my
formes so can you help me to solve this proplem ......
note : my access is 2000

In the employee table I am making, the employee name is designed to be
entered into three separate fieldnames namely, lastname, firstname &
middlename.  How then do I set up a primary key base on the employee name, in
either "lastname, firstname middlename" or "firstname ...

I'm trying to figure out the following in order to get around the 255 field
limitation per table:
Table:Details
Table:Apps

I am creating a database for credit card payments recv. This is information
is already on a Excel spreadsheet but cannot hold so much data anymore.
Can I import this Excel sheet into the Access Database or do I need to create
from scratch?

I really hope you can share some light on this as its driving me nuts!
I am creating a Contact Management DB which is supposed to be simple (in
principle), however i am seriously stuck on something trivial and wonder if
anyone can share their knowledge with me.  I don't know where ...

I have a table which contains 245 fields. I need to change properties of some
fields and get the message "property value is too large". I couldn't save any
change. I try create a new table in different name and paste all the fields
to new table. It only let me paste about 190 ...

Last night I sent an email with document attachment.  Approximately 15
minutes later, I refreshed the page for new emails and received a failure to
deliver notice.  I have not been able to conduct any further activities since
then.  When opening outlook this a.m., the failure ...

How do you stop the Outlook pop-up warning "A program is trying to access
email addresses stored in Outlook". I would like to stop automatic access to
my email address list.

Personally I thing several defaults in Access that ought to be changed.  I
hate the fact that I have to set every new profile in my office to get rid of
the delayed drop down menus to reveal all that is on the menu.  We can't
imagine anyone ever wanting that feature.  And it was ...

an entertainment agency needs to list available dates for the year ahead for
each entertainer.  help how do I do this does anyone know.

I have the trial key but it says that the key is invalid.
I tried and tried but it doesnt work,
I dont know what else to do!

Acess 2000.  I have a multi-user database and I want to institute record
locking.  I do not want two users to be able to edit the same record at the
same time
I've read all the stuff in the help menu and think that I have to use