I'd like to add another field to my table and for whole
field to have all the same entry, namely the
number "1".  How can I do this?  (I know how to add a
field-- just need to know how to give it all the

Hoping someone can help. I want to setup the following relationship:
--Employees, which can be supervisors or non-supervisors, may have one
or more supervisors. Supervisors may also manage one or more
employees.--

I am making a simple database and I was wondering how can
the information from a field containing strings of both
numbers and characters be broken and entered other
fields. I am dealing with a code that looks like this:

I'd like to add another field to my table and for whole
field to have all the same entry, namely the
number "1".  How can I do this?  (I know how to add a
field-- just need to know how to give it all the

I have a split database and need to send to other office to use.  In that
office, they do not install link manager so they are unable to change the
table path.  The back-end database is located in the folder of "Data" under
the front-end database.  Can someone advise how to relink ...

I have a list of 1000 discrete passwords (and that list
may grow from time to time).  I'd like a system where
when I click a command button ("Generate Password"),
Access will take the first password from the list, insert

How do I get the weekday function to return a weekday "label" instead of the
number?
Thanx,
Paul

I have created a lookup colomn in a table that gets it's
list from a query that has two colomns. Once I have chosen
from the lookup list, only data from one of the colomns
are visible, but my users need to see both colomns from

I have a table with 3 fields licence number = 6
characters / name of license holder & address off licence
holder. The second table are individuals who may operate
under those license numbers in the first table. My

In a table I have 1 field(expense_id) which is a auto-
number field.
I want to create another field using the same value as the
(expense_id) BUT appending H in front of it.

Please help...this is killing me!
Is there any way that I can enter certain information in
one table (i.e. account #) and it create a blank record
in another table with with the same account #.

Scenario:
Table 1
UniqueID is created=
2004-01

I created a new table in the be of my split database and I
cant get it to show on the front end... what's up with
that?

I wish to be able to input a training for and entire group of employees at
once. Without having to enter the Class name, Date, Start and End times for
each attendee.  The trainer would choose the Class name from a drop down
list, then input the date, start and end times, once ...

I have a field on my form which will be used for entering dollar amounts but
when a number such as 374.45 is keyed in.....it automatically converts to
round it off to 374.00.This infomation will be used for tracking even the
smallest amount so all data is needed.What do i need to ...