creating a form or report

  • Thread starter Thread starter kitty
  • Start date Start date
K

kitty

Guest
i am completely ignorant to access. i have read the access for dummies, however and i am still confused about a couple of problems i am having. i have 2002 version.

i am in transportation and am trying to develop what is called a load dispatch sheet. first, this will have a shipper (code and info coming from a database table) a receiver (same thing) and a trucking company (same thing) each of these (shipper, receiver and trucking company i want to have a code (4-8 letter) that i place in their fields on a sheet and boom the mailing address pops up. how do i create this sheet in access and how do i get this information to pop up. i have read several different things and i can't get this to work. please be very specific in your detailed lesson.

also each of these sheets must carry a consecutive number( starting new each day). for example, today we may have done 001, 002 and 003. tomorrow we start over so we can see how many loads we do each day. the prefix to the 001, 002 is the date. again, for example, today is feb 18, 2003 so the load numbers would be: 021803-001 etc.

please help and be very detailed

write soon

kitty
 
I'm not sure if I'm the best person to answer this since I really am an amateur at this but I have done similar tables.
If I understand you correctly, you want to end up with a sheet where you have:
Load Code Shipper Receiver Trucking Co
021803-001 AAA001 BBB002 CCC003
and you want to be able to call up the Shipper/Reciever etc. address by (for example) double clicking on the AAA001.
If this is close to what you want, start by creating a table "Dispatch Sheet" with the fields as above. Include a date field also. You will also need an Ident number field in each of the tables containing the shipper, receiver and trucker addresses so you can link to them.
Then create a form (use the form wizard) to enter data into this table. Use a combo box to enter the Shipper, Receiver etc. since these are entered as a Reference number to an existing table.
Once the form is created, you can modify it so that you can see the addresses by double clicking. This is done by creating a pop-up subform for the address table which is activated by double clicking (set the on double click property in the cell to open the subform).
This gets the data into the table. To get a printout, first create a query which will filter the data to a single day, then create a report which gets the data from this query & prints it in the print layout you want.
Sounds pretty complex but give it a try, post again if you get stuck.
 
give it a try

after i try all this info i will post again if more info is needed thanks.

kitty
 

Users who are viewing this thread

Back
Top Bottom