I have a date/time field in a table for which the format
is general date. The default value is Now() which returns
for example 4/27/2004 12:31:10 PM. How can I change the
format of this field to produce these results minus the

What is the best way to have a database when multible
computers will be using it.  Their our 2 primary functions
for the database.  One is to have students log into the
system, and the other is for proctors to pull up the

I have a linked Excel file. Within that file is a field/column of numbers.
When I look at it in Excel - I see the numbers.
When I look at in Access - I see #Num! When I see it in the Form, I don't -
the field is blank.

IS THERE ANYWAY TO INSERT A DROPDOWN MENU ONTO ACCESS. IF
SO CAN ANYONE TELL ME HOW,STEP BY STEP.

Hello kind and helpful people. I have a field in a table
for which the syntax is 8 characters (both alpha and
numeric). The last 3 digits of these 8 characters will be
capital ACC. Examples: 12345ACC or A4B3CACC. I need help

I use a customized Format and Input Mask for all date fields on all my
forms. Is there any DISADVANTAGE to adding these to the table design for
each date field?
Thanks in advance.

I have been given 3800 excel spreadsheets and asked to fill out 65 existing
fields on each.
I know it would be easier if it was a database. Has anyone got any idea how
I could combine this lot into one table.

I'm trying to create:
1. choices can be typed by the user
2. hit submit, or run or go
3. box below fills with those choises only

I would like to create a validation rule on a lookup field in a table.....
the lookup table works fine, but i would like to make sure that people don't
type in anything in the field rather than use the lookup.... as this would
add a new record in the table with a name that i dont ...

I have a table customer with two fields customerid and
customer name.
There is one more table sales with customerid and customer
name in it.

I'm trying to design some tables for a simple booking
system for school rooms. I'm having some problems with
trying to come up with a workable design.
In Excel I have created one record for each school day,

My company tests candidates and / or existing staff
members for our clients.  Currently for each person there
is an Excel document created from a template that we work
off. The Excel template contains loads of very complex

I was trying to add a first record to a table called
BOOKING with the primary key defined as AUTONUMBER. I made
a mistake because I needed to put a dummy record in
another table first so no record was added. However when I

I'm making a questionaire database with to groups of
people answering questions, say teachers and students.
Currently the teachers and students are in seperate
tables since I'd like to keep track of which students

Hey Group,
How could I import a Data from a Excel Spreadsheet, into a Already Exsiting
Table, also can I choose which coloum(s) need what row of data in?
Many Thanks