Having briefly parused, entries (posted 7/29) regarding this subject, I was kind of shocked by the argument that ensued after a good gesture. Truthfully, I found the gesture competively flawed, but was not impressed with the pseudo-eccentric approach initiated by the Access MVP.
I ...

Ok, I am going crazy over this one.
I have two tables.  One table holds all the inventory transactions for several different days per product (called Transaction History).  While the other table holds product information per purchase order (called Inventory Transaction).  So in my ...

To All:
 Found this today and I know that it will be usefull for
me so I thought I would pass it on.
 If you have ever set up a database and started testing

I am trying the set up a Staff Attendance/Absence
database in Access and I want to use Arrays fields for
the days of the 12 months of the year, but I unfamiliar
with using Arrays in Access.  I am sure there is someone

I am setting up a database to track my customer and
inhouse orders. My inhouse orders use NW-0000 for an
autonumber identifier and amy custom orders have KI-0000
for an autonumber identifier. I would like to be able to

Hopefully this is the right newsgroup to ask this (and I apologize up
front--this is probably going to get kind of long).....it crosses so many
lines it's hard to tell, but since it all starts with the tables, I thought
I'd start here.  Anyway, the boss wants me to create a db for ...

I use access to manage my inventory, which comes in with 4
identifying numbers.  The problem is, no one of these
numbers is 100% unique.  An idea that I have is to use all
4 numbers to generate a truly unique number for each

I am using Access 2000 to import data from an Excel spreadsheet with
the Get External Data command.
A couple of the columns in the Excel spreadsheet contain more than 255
characters. Thus I have prepared the Access table in advance,

I would like a field in my table to have 5 characters. If
the entry have less than 5, a Zero adds to the front of
data.
If enter 345D. It should correct to 0345D.

I am trying to modify a database that has entries in
several tables that have options from zlookup tables.
What I need to do is modify the design so that the
options in the second dropdown list change as the entry

I have recently started using Access 2003 and notice that
when I make a new database it automatically will add
tables that begin with msys (as example msysobject). I
can't delete these but don't know what their purpose is.

I need to know, is it possible to do a find or a search in
multiple fields in a table. I've got 4 fields of serial
numbers in my table and I am having to search each field
one at a time. Can I do a search by just highlighting all

I start with tables x and y. Link DIST and OBS1
I get query1 with a select query.  
I want to get Query WANTED.  
I've tried NOT linking.

I am trying to figure out how to set the default value of
a field called email.  I want the default value to be
pulled from the inputed data in a field called username
in the same table...

I am creating an inventory database that tracks server
parts. (Specifically I have 8 servers, the parts within
each server vary.)  I want the quantity of the parts to
automatically deplete when a technician removes a part and