I am trying to create a default value for a field in a
table based on the first 8 digits of a control(ProjectNo)
in a form (frmProjectDetails). The expression I use is
=Left([Forms]![frmProjectDetails]![ProjectNo],8) - when I

I own and operate a taxi company in CT and need to computerize my operation. A friend has suggested using access to store our accounts, reservations, print reports, etc. I am currently using Access 2000 and have been studying it alot lately trying to figure whether or not my ...

Can anyone out there assist me, i have just spent money on a handwritting font program call VLetter ver 4.5, and i cannot figure out how to import these fonts into Access or even Excel. Does anyone have the answer for me, i really would be very greatful for any suggestions

I have an Access 97 database that my user's are presently
using. I am in the process of developing their current
application (which was developed in Access using forms,
etc) to a PeopleSoft application with an Oracle database.  

I'm making some changes to a Ms Access 97 application. In
order to support some functionality changes, I need to
make a couple of changes to the structure of tables in the
back end database. The first change is remaining a field,

Dear everyone and Mr. Hookom,
I have a questionaire db much like the "At Your Survey" db.
I'd like to have customised input forms for each
questionaire as they differ a lot.

I am sorry I caused confusion with not explianing it
fully.  First what I have:
Table 1 has a full listing of data.  I work off this
listing, so if there is a change in an order I make it on

If I have a table of customers and the prices they are charged for
product depending on the quantity they purchase (such as);
0-10  Items $1.00
11-20 Items $1.25

If I have a table of customers and the prices they are charged for
product depending on the quantity they purchase (such as);
0-10  Items $1.00
11-20 Items $1.25

I can expand the subdatasheets in the table. But, when I
preview it, I don't see the subdatasheets in the preview
mode. I do not understand why the subdatasheet disappears
when I preview the table.

I am familiar with using a junction table for a "many-to-many" relationship.
However, I'm not exactly sure how I could string multiple "many-to-many" or
junction tables into an architecture.
Does anyone have a suggestion?

WE are currently using Microsoft R Access 97 and are
having a problem when we enter our customers sizes we put
the smallest tube size first and when we hit save and
reopen they are not in the same order that we entered .

I'm trying to increase the amount of text allowed in a field..... I've increased the size of the field but I'm limited to approx. 1/3 of the field for text.

I have 2 tables that have data obtained from a mainframe application on a daily basis. One is Loans Approved and the other table is Loans Funded. The Loan number would be the common element in both tables
I need to be able to show only those loans from the loans approved table ...

Here is the scenario.
I have linked a table from a SQL database to MS Access.
There is a text field in that SQL database table which
carries more than 255 characters. However the link table