Running Access XP
How does one remove a lookup field from a table.
I have gone into the relationships area and there are no relationships
visible.

If I type in BVE in a text column in my table it changes
to BE automatically.  Does anyone know why?

If I set-up a linking table, can I use a look-up menu in
this table?

does anyone know how to filter a recordset for a specific date.
for example. i keep some dates in an access database of cpr training. i am
making a repeating region listing the people whose cpr license will expire
in 30 days. well how do you construct that kind of sql sentence

I have a user who needs to put up to 25,000 lines of data in a table a year.  We will be generating weekly and montly reports from this database.  They have access to excel.  What's the best way to deal with this size issue.  I'm afraid of loading down the database and making it ...

I set up a temporary table to be able to copy names &
values via the internet to excel and then into my
database.  I only used it once, and now whenever I click
on it, I get the error report to send to Microsoft.  I am

I have a database that is entirely dependant on an Excel
workbook and 14 worksheets through linked tables.  The
spreadsheet is used to forecast needed 'employees' on a
given date.  It uses the actual data that is entered in

Right now I have two forms/tables in ACCESS.  The first
is my working table... the second is a table I import
from HQ that says what my current seat order is.  I have
a validation query that looks for the difference in the

Hello ...
Many thanks in advance ...
Does anyone know of a database/template on scheduling school bus or
public transportation bus ? I would like to look at a database that

sorry for the length of this post, but before i state the problem, i'd like to provide enought support info.  here's the layout of the db - i've got 3 tables
tblMileageExpens
 MileageExpenseID (PK
 MileageTypeID (FK

On a form frmProba there are two unbounded combos: cboSifOO and cboSifOsoba
(just for this example here).
cboSifOO selects one of the departments from a table tblSifOO (text like
1.3.). Depending on this value the second combo selects the people from this

I have a strange application where i need to place 389
fields on a report. Ideally the fields would come from
one big table. I have tried to join eight tables together
in a one to one manner, as soon as i exceed 255 fields

For a genealogy/family tree database some dates are
approximate. For example: my birthday is exact (January 1,
1970) and my ancestor's is not (just 1760). Some
are "Before 1600" or "After 1433", some still are

I use copy and paste to duplicate tables to ensure a
consistent structure for importing data from text files.  
Since I've switched to SQL to handle my databases I must
use a primary key so the data can be modified.  When we

Hey Group,
Sorry i know i`ve asked this before and got loads of responses but im
confused as to what to do:(
I have a Table: