I have an extensive parts list and only some parts apply
to each individual unit, after my parameter search comes
up with my results, I still have columns and columns of
0's in the one's that do not apply to the part.

I am still trying to work out the bugs of my database, but I am having one
more problem.  I have a subform called, Ledger, and it is just that a ledger.
The problem is that I am trying to have it calculate a balanced owed after a
payment has been made.  I have date, type of ...

Fixed one problem and caused another...I think.  Earlier, I had a subform based on a query but I couldn't add records on the subform even though all of the enter data properties were set to yes.  When I took the group by out of the query, I could update my subform.  My main form ...

I'm more an excel guy but trying into Access and filemaker... so far
Access looks better.  here goes my question.
I have a textbox called lets say txtpoints &  txtcalc
 so far the expression\formula is kind like this

I only know slightly more than the basics in Access, and I'm sure there is a
better way to do what I want to do.  I am also familiar with bits of SQL and
VB, but only bits... now, onto the question.
I'm doing Masters research and have created an Access database to track my

I asked earlier for assistance in creating a Word document that I had more
control over in exporting Access records to.  Alex Ivanov provided valuable
assistance, and an example: http://www.aleksoft.net/samples/Access_Word.zip
This example uses a module with a line of code that ...

I have one large Table (200,000 records). Each month I get another 25000
records. Some fields contain many duplications, eg The date field contains
the same date for all recods in one month. For use in various queries, I need
to maintain a Table that contains only a short list of ...

Ok i have no idea how i am going to explain my problem, here goes
I am creating an internal database for my stock of a clothing company.
I have created tables with fields in style number, colour, unit price, sizes
(one cell for each size), total quantity and total value.

Access 2000, When I go to Get External Data, Import, I do not have Microsoft
Excel as a File Type to import.
All that is in there is Microsoft Access and ODBC Databases.
Can anybody tell me what controls the File Type options that I can import?

Please,show me how can I create custom input mask for
DATE/TIME field.
I would like to have a input mask like #01 12/11/04.
----------

I have a great DOS address book file I'd like to import to Windows. Is this
possible and if so, how do I do it?

I have a form (unbound) with various tick boxes on it. I also have a table
"tblNotestoPrint" with a Yes/No field called "selectedYN". I want to
automatically change that field to Yes when the checkbox is ticked and No
when it is unticked.

I want to set up Access to use a barcode scan for admission to the
lunchroom at the school I work at. We already have the scanners and
computers. I just need to set up a program to recognize the student
barcodes on their ID cards to know which students can be admitted and

1. How come one can not make a good query based on more than 2 tables so as
to allow a person to make a decent form that contains all necessary fields?  
2. The object of data normalizing is to breakdown the objects onto the
smallest unit for reliability, etc.. if so, how does one ...

I'm new to Access 2003. How do I open or convert my Approach database files?