Does anyone know of a simple database design for P.O.s
that is free to use?
Scott

I have several linked tables. When I use my db from
another PC, the tables are not found if the other PCs
drives are not mapped the same. I cannot find a way to use
the universal server name as opposed to the drive letter.

I know I'm missing something simple, I can't get my table
to display a number in a decimal format.  When I type
in .75 the table turns it into 1.  OK, call me stupid,
what am I forgetting?

I have an access 97 database and in that database is a
table that is located on a sql server.
I want to create a button that allows the user to relink
the table automatically.

I am new to access and I am learning as I go.
I want to put values in a field that will transfer
automatically to the next record, until I change that
value. Then the new value should appear in the next record

I have used Access 2000 to create a table which contains a status field
I have defined it as memo and use it to maintain a running log
My question is,"Is there a way to update this field without zapping the data
that's already entered?

My client would like to show leading zeroes in a numerical
field. I have the field set as an Integer, made the format
property Fixed and I have set the input mask to 00.
However, even though it requires 2 digit input (03) it

Let me breifly expalin why I am in the situation I am in,  I work for a company in business 114 years with little computerized system.  I came on board 2 years ago and have been developing Access databases (due to extremely tight budgets that is what I have to work with).  These ...

I have a datatbase containing e few tables( mailing list, client list
etc) and i have to start a new one.
This table would have to contain customer info, contract info(such
as exp date, type of contract, invoice # etc) and equipment info

Can someone please help me establish a unique order
number for each record entered into my table. It has to
be in a format of 04-xxxxxx. My biggest hurdle is I have
3 years of records in my table. I was told I can ignore

I am creating a table that has a lookup field based on
another table and have chosen 3 columns.  When I open the
table in Datasheet View, I can only see the first column.  
Is there a way to view all 3 columns without having to use

I would like to know if there is any way to make a
field/column in a table be autofilled based on what is in
another field/column?  To give you an example - At my
work, we use Access to keep track of all of our tax

I need to create a alphanumeric sequence that is
5955PARS0014401 that is the start of the sequence
and i want the numbers after then PARS to increase by 1
please help

Is it possible to remove the subdatasheet column from the table view for tables with existing relationships? The additional column usually has "+" in the field which, I'd like to remove

I just imported data into a new table, but I can not
center the data. I tried puitting the center icon on the
toolbar from the command box by dragging it. The problem
is that I can't access it because the center icon is