We have a Acess 2k, 2k2 & 2k3 db split BE on the server & FE on each PC. It
is currently developed in the "normal" way <grin> of using an ID number
field as the record ID with the ID value being created by Me!ContactID =
Nz(DMax("ContactID", "tblContact")) + 1 in BeforeUpdate of a ...

    I've got a set of simple data types (numbers, a text
field) that I want to store in my database.  The problem
is that I don't know at design time how many of these
there will be.  I can specify the set of types (for

I've got a table with the following fields:  
Week, Data1, Data2, WeekDayofData1, WeekDayofData2
I want to make a table validation rule that if the Data1
field is filled, then WeekDayofData1 must also be filled.

Can I bound a picture with a field as a link without to
transfer the picture in the database in order to avoid the
big size but at the same time I want to be able to see
automaticly in our report or forms my pictures?

What is the best way to empty several tables in VBA. I'm writing a conversion routine and need to do this when I do a rerun.

I'm having trouble getting started, particularly with the tables design.
Whatever I come up with seems not to fit all the cases.

I would like to build a database that I can scan in
articles etc, and retreive them through a keyword list. I
would like the database to be able to refine content
retreived by the amount of keywords used. e.g. Lake name

I have a column in a table and I'd like to make all 7100 values to be
negative, what's the fastest way to do this.
thanks,
Brendan

do you know if there is a way to select multiple items
from a drop down list (like using the ctrl or shift key)
for a particular column and have them associated (stored)
with that row in the table? (verses just one item from the

I have a large table and am trying to enter a few more
fields.  Yesterday as I was doing this and trying to save,
I kept getting a "Too Many Fields Defined" and then it
would give me an error and tell me it couldn't save, but

I HAVE CONVERTED A TABLE FROM ACCESS 97 TO ACCESS 2000 SR-
1 PROFESSIONAL AND AM HAVING A PROBLEM WITH THE DATE
COLUMN.  I USE A MM/DD/YY FORMAT AND THE NEW PROGRAM HAS
CHANGED IT TO A MM/DD/YYYY.  I HAVE CHANGED THE INPUT MASK

is the memo field searchable? We want to use it to record
notes, and we want to search the notes in the future by
keywords...

If this is the wrong place to post this, I apologize.
I am having a problem that I just can't seem to wrap my brain around
regarding tables and their relationships.  Part of the problem is that
I am not sure I can even articulate the question, but here goes.

Okay, so I am pretty new to Access... I am creating a
table and I get this error message.
The changes you requested to the table were not successful
because they would create duplicate values in the index,

I have a new laptop that came loaded with Windows XP. I
loaded my Access 97 (several times now), making sure all
options were selected; however, when I'm in table design
mode and choose Lookup Wizard, it doesn't work. I don't