Hi.  Suppose that I have a field table1.field1 that might sometimes be
null but when it has a value will be a value found in table2.field1.
Now table2.field1 is guaranteed to be unique and can't have null
values.  Can table1.field1 be a foreign key constrained to

I hope I'm putting this in the correct forum.
I have a database that tracks tax abatements. Currently, I have a Master
form with three subforms to show the necessary information. Each form and
subform pulls from its own table. That is to say, the Companies master form

Does writing the VBA code to connect to a back end database mean one does not
have to link these tables to the front end?

I am looking for a data base template for an exam question repository. It
should be possible to label questions as (e.g.) questions on depreciation, on
the profit and loss account, on accounting principles etc - you have guessed
it, I am a managerial accounting lecturer.

I have a database that we use to keep track of clients; appointments, notes,
etc..  I need to be able to access scanned documents from this database.  The
client database is designed using tab pages.  I would like to have a tab page
to access the scanned documents.  Is this ...

I am setting up a database for lab entries where there are dilutions factors
applied. Is it possible to set up a functioin on the field so it calculates
the end number for me?
For example, I have a number field that will need to be multiplied by 6. So,

I have created a report that when opened, runs a macro that outputs the
report to an excel spreadsheet and also sends the report in a snapshot format
to an email in Outlook.
The problem is...the information in the email attachment is correct, but

In my database three of my tables are linked from another database and I want
to create a relationship with one of these tables but it won't let me.
cheers.

I have a table that records requests for filing extension. I wanted it to
automatically record the date the request was entered into the database. I
inserted the "Date()" function, using the Expression Builder, into the
default format property field.

I'd like to get my db to auto generate a unique user ID based on first letter
of last name and the number (say, Don Baker is first B, so he gets B-0001).  
Is there a way to do this without manually assigning myself?  Thanks.

I currently have a subform that populates a table named
TBL_Feature_Number.  The subform consists of 10 combo boxes and fromt
these combo boxes the user selects criteria from a list.  What I want
to occur is that when the user selects a value from each box that

First, I'm a beginner.  Second I'm working with a database that has already
been set up.  However, I'm trying to enter text into a numeric field. How can
I change this? I tried changing the data type, but it won't let me because
it's connected to several relationships.

I want Office XP in English.
Thank a lot !

MS Access 2000
I am designing a database which among other things, has a field for the last
names of parents and a field for the last name of their children.
Since the vast majority of children have the last name of their parent, is

I have developed a database where I need to track the equipment in each room
of a building. Since some equipment do repeat (Manufacturer and Model) the
database has a Master Equipment Table where the detailed information of the
equipment is stored (Manuf, Model, electrical, etc).