Access database 2007 functions for search, save and recall

[Flatdown]

Hi All

I have no idea how access works I just don't understand it's language, I have looked around this forum and other internet pages and cannot work out what I need to do to make my database function. Unfortunately no-one here knows access either and I find it easier to learn with someone showing me than reading it.

I am trying to keep a track of pallets/cartons we send to various customers.
The idea being we open a form and add the pallet dimensions to that customers account, this will change across the month as new items are ordered, each order has a new invoice number which would be added to the open form.
Once the pallets/cartons are ready to send we update the tracking information, print the file for packing into the pallet/cartons and archive that file to the database, then start that a new file.
I would also like to be able to hyperlink our invoices we keep those in another folder on the network.
Then I would like to be able to search by account and invoice number so that the now archived file can be recalled to show the details of what we sent to that customer and when.

I am not sure if I am making too many tables or not enough? Initially i didn't think this would be this difficult

To further compound my misery the file I am trying to upload is not recognised it also seems quite large at 1.23mb for the little work I have done

Any help or pointers would be massively appreciated as my head hurts a lot
Keith

[Norie]

Keith

How many tables have you created and how are they structured (field names, types etc)?

[Flatdown]

Keith

How many tables have you created and how are they structured (field names, types etc)?

Hi Norie

Thanks for the quick response. I have three tables, one is just for a combo box drop down list, another has a list of the customer details address phone etc and the other just has the field headings for account number, invoices and tracking, although I am not sure this is needed as this data would come from a form as we enter the data into the fields
Where each header was labelled "field 1", "field 2" it now has "Account Number", "Address" and so on
They are all just text or number fields if that is what you mean by type?
I have not added any relationships to the tables.

Thanks again

[alansidman]

Run a compact and repair on your file before trying to upload. During development this should be done periodically as db size swells as you add and delete. Then zip the file before updating.

[Flatdown]

Run a compact and repair on your file before trying to upload. During development this should be done periodically as db size swells as you add and delete. Then zip the file before updating.

Thanks alansidman that took it down to 4.00kb

[Flatdown]

Sorry 400kb (big hands no good for this little keyboard) :P

[Flatdown]

Hi

So I'm slowly getting on with this but I'm stuck again I need to get the columns to add the total weight in the shipment entry form as i understand it a query is a more ordered way to to do this? Can anyone tell me how I would make this work please?
Also can you advise me if I really need two databases, I want to add the address to the shipment entry form, but the address is in the account database and I don't know how to link the account number on the shipment entry form to the address fields on the account details database (which i haven't added a box for yet)

Your help again really appreciated