I am calculating a total in a calculated field on a Form. I then want to save
this value in a corresponding field in an underlying table. Whatever I try,
the Table value is not being saved!

I'd like to make a linked table for a CSV-formatted text file. The file has a
".log" extension, which is required by another program that uses the text
file. Access apparently doesn't support linking to ".log" text files. Is
there any way make a linked table without changing the ...

I have created a data input form which should track the data through to a
database using the template wizard.  The wizard is set up correctly (ie all
of the cells are linked to the correct ones in the database), but when I fill
in the form and save it, it doesn't automatically ...

How do I prevent rounding up or down.  I'm using 2000 and regardless of what
type number I select, the result is rounding up or down.  I want to be able
to enter a number i.e. 1.5 and have it appear and calculate as 1.5.
Thanks!

I have a database that some time ago I split - one holding
the tables, codes, etc. The other one holds tables. This
db has changed over a period of time and I am coming back
to update it. However, now when I try to open it it is

I am trying to do something fairly simple in a access db. I have a table
that contains a record for every sale made. Each sale needs to have an
unique number of the form yyyy-mm-dd-xx (where xx starts from 01 each day)
allocated when a new sale is entered, along with other info in ...

In my database the ID number is an Autonumber field; the problem suddenly
happens that when a user adds a record, the ID has 8 digits vs. 5 digits as
it used to generate before. For example, it went from 21951 to 49089777.
Any help with this will be greatly appreciated.

I have a flat database that will not do.. and need to make it as
relational as I possibly can. This is for a non-profit organization,
and deals with coal miners that populated the area in the late 1800 to
mid 1900's.

I have a people table and company table. Each person and each company can
have multiple telephone numbers. With respect to a telephone table(s), should
I have two tables, a people telephone table and a company telephone table; or
one table and have a 'Type' field to distinguish ...

Help,
I need info on corrective action or cappa templates

Looking for a reality check to see if I designed this correctly. Found a couple
examples and based this off of them.  A project has
at least 2 sites and 2 pieces of equipment. I want to make sure I've set these
relationships up correctly.  Any input/suggestions would be appreciated ...

I'm not sure I can explain this clearly enough to get help, but I'm going to
try.
I have a bunch of queries, and forms based on those queries which were
working just fine.

I have an Access Aplication that I designed & it currently resides on a
Server here in our office & has other offices from different locations
accessing it via a WAN.
The problem is the speed.  From the other locations the speed is VERY VERY

I have self taught myself to build databases and I have a great one going for
work, but I need a search box to select and open forms and reports based on
records already in the system. I'm currently using a query with a [Enter
Date] command before opening the forms, and then ...

I have a problem entering details in a one to one relationship.  I am using a
one to one to manage the large amount of information for each record...each
exhibitor can enter one or more sections and for each section there is
different information required.