In gathering requirements I learned I will need a field
that represents how long a mfg run took and the request
was that it be entered in HHMMSS format. This RUNTIME will
then be used with another field,MASS(kg), to calculate the

I'd like to insert photographs into my productdatabase and i used OLE-object
as a datatype for the field i want to store Jpeg files.  This doesn't work.
What is wrong with te picture?
Tx

It is a 'school' example: on a form one can use a record selector to see
some data like FirstName, FamilyName,  address data etc. All the data may be
selected and seen, but not edited by the default.
To find some data in a faster way I use a cboFindRecord on the same form to

Can I have a number field begin with, say, 5000, and then
go up from there?  If so, how?  Thanks!

I'm tring to build a data base of a Percentage of
realative humidity. My company tracks it in different
locations Daily. Should I create a table for each
location with the same fields. Would the date be my

Why do Leading 0's fall off? Access 2K
I have a table with the field as text ie; acctnumber
I am trying to place the number of the account
into this field as default value but the leading zeros do NOT

Hi, I just realized that in my Relationships window I have
a copy of a table (original name: tblPeople, copied as
tblPeople1) and tblPeople1 has as well the same
relationships that tblPeople has to other tables. Is

I have an outline that contains multiple levels.
        1
1.1
1.1.1

I want to push data (calculations and expressions from
query and form) into a table record.  I know everyone says
not to do that and that it is a waiste of resources.  
However I have a need for this.  So please do not lecture

Everyone,
I think I have hit a limit that I did not think would exist. I have a
database table structure for a fairly major application where we store the
template data structure in Access and we have written a fairly complex

Database design need suggestions and forms- multiple primary key proble
The purpose of this database is to be a list of parts in the department as well as to easily see which parts are at which station/substation (and the # there), as well as tracking whether it is critical or not ...

I have a table that uses an autonumber as the primary key.
On two separate instances when trying to insert a new
record into this table through a form, I've gotten a key
violation error. When I went to the table to try to insert

I am trying to convert a table Access 97, that is linked
to an Excel file. In the conversion process I get an error
message that gives the table name followed by a $ sign. My
guess is that the $ sign is indicating the link to the

I have a table that I would like to have a time field to
record minutes / seconds. It is to record the length of a
conversation. We never have had a conversation last more
than 20 minutes and 90% go under 5 minutes. For the user

I would like to create a mechanism, where on opening the
database from the server, all my tables would be loaded to
the user's local drive.  When the user closes the db all
the updates have to go back to server.  The reason for me