Tables
---------------
tblItems: itemId (PK), & other item fields
tblVendors: vndId (PK), & other vendor fields

I need to have the contents of certain tables within my database auto-delete
after a certain period (i.e. contents in table one delete after 30 days)of
time. Is that possible?

I have many records that have a field in common (SBL) but different owners
names.  I would like to have one record with SBL and all the owners names
listed.

Is there any way for Access to automatically post depreciation amounts every
month?  It seems that it would be a massive task to type in depreciation
amounts for every asset every month.  I would think that if I gave Access the
original value, the depreciable life, and the ...

I am looking for an Acess template that is adaptable to a small weekly
newspaper. I need to be able to track draws (paper orders) and returns by
location/route/zipcode.  Reports should be excel format.

I have two numeric fields and would like to create a field in the table that
will calculate a value based on the two fields.  Is this possible to do
within the table, and if so how?

I want to list different fields going down and employee names going across,
is this possible?

My firm tracks its meeting minutes in a database and numbers each meeting
sequentially and each item is number sequential as well.  I have created a
table with uses these two numbers as the primary key and no duplicates are
allowed.  I was wondering if there was a way to set up ...

First of all, Thank you to all who are willing to help and have helped so far!
I am essentialy making a billing database for a department that charges
other departments for sevices done to equipment.
The billing works perfectly for the setup of new equipment because it gets

Can anyone help me to set a field up in access, which looks at the field in
thelast record, takes that value, adds 1 to it and places that modified value
in the current record.  I have an idea that it may need a VB function, but
don't know any or indeed how to utilise them.  Your ...

hi,
 I have this quesion.. i have jus started using Access, and im sure a lot
of ppl would know to do this. i want to create a field "employee ID" and i
have to assign 4 digit numeris random numbers. can somebody help me on this

I am new to access.  I work for a small not for profit organization that has
lots of address labels.  The problem I am having is that i don't know how to
create an address database that will let me have one contact in multiple
categories.  For example  I have  a John Doe that is ...

Good evening!
I have built a database that stores data about a given product in form of a
tree. I didnt have any idea of how to make it, so I created a single
'LEVEL' column to deal with the tree structure , and it works like this:

I'm in the process of creating a new database and want to pull in the
contents of an existing database rather than building on the existing one.  
The existing is not very large, however I would like to pull in all it's
tables and data, queries, forms, reports and all associated ...

I am trying to set the DisplayControl property on a field using DAO in
C#.  I've found lots of sample code for VB and am trying to adapt it
for use in C#.
This is the code I'm running now: