I have a question on whether it would be possible to automatically fill a
text box with the same information when a selection is made in a combo box.
The form is currently set up:
Combo box 1: Select to filter all relevant records in the category

I have an Employee table that is linked to three instances of an Inspection
table.
tblEmployee
   EmployeeID (PK - Integer)

If I would like to store a person's age as a column in a table, could
I calculate the value of the column based off of the Birthdate field?
I was trying to do this using the defaultvalue of a column, but I'm
thinking that is not the proper way to go about it. I am an oracle

Thank you for your time and patience.  This board has been a wealth of
information and knowledge.  I hope you can help me with my latest Access
challenge.  I’ve been troubleshooting for the last 3 days and have exhausted
my troubleshooting knowledge.  I’d appreciate any ...

I have a table that I would like to occasionally add rows to.  I need to add
28 rows at a time and three of the columns would all contain the same data.  
If anyone needs to know or cares it's a DS3 inventory table.  When I add a
new DS3 I'd like to show the DS3 ID to each of the ...

I have tables and queries that reside on a sql server with an odbc connection
to Access 2003. When I need to open one of those tables or queries, I log in.
I now have a bunch of forms and reports based on those tables and queries
that I want users to be able to use but I do not ...

I am still trying to design my database (keep getting given extra info which
changes things). It is all to do with sites for housing developments. Each
site will have a part of it set aside for affordable housing. There will only
be one such element on each site. And this ...

how do I enter a value into field using a check box
if the insurance check box is checked I want to enter $7.50 into the
insurance field
if the box is not checked I want the field to have the default value of 0

I am a bit confused by my relationships and primary keys.
My database contains customer details and each customer can have one or many
maintenance contracts.  Each maintenance contract can have any number of call
outs.  

I am building a 'simple' invoicing db.  I need to be able to create
quotes/estimates as well as actual purchase invoices.  Should they all be in
the same table and simply differentiated by 'Type' or should they be in
separate table?  Be give an explanation so I might learn a ...

My question is : How can I replace a primary key of type nvarchar width 65
by something smaller ou more rapid ? I'm using SQL server 2005 Express
edition in an Access 2007 project.
The structure is :

The form and subform are based off two seperate tables.  The record source
for the form is a query of the two tables using the query builder under the
properties of the form.  When in form view, the form will not advance past
five records.  I can add info into the form and ...

I understand the maximum data storage size for Access 2007 is 2GB. I have a
database to store video clips, photographs and sound as you can imagine this
will seriously limit the amount of data I can store on my database.
Does anyone have any suggestions as to how I can save more ...

what's the trick to printing just the current record in a form?

I have created a school nursing database for 32 schools.  I have a main menu
and  a form with a lookup box for student names.   I have a form and a sub
form.  When I open the form from the Main Menu there is previous data in the
subform showing without having chosen a student ...