Search results

Attached is an image of what the tables and relationships now look like.

Yes, some shipments require more than one truck. And of course one truck can be used for more than one shipment, but we don't really care if the same truck is used for A, B, C, or D shipments. We do care which packages are on which truck.

I have a query like that, the only thing is that to this point, the containers are not assigned to a particular truck. Which trucks go on which shipments (some shipments have multiple trucks), but we havne't tracked which containers go on which trucks. So I need to add a "truck #" field to the...

I noticed that I forgot the attachement and then added it to my above post, sorry~!

Well I was trying to simplify the concept when I explained it so the tables are a bit more involved. But this attachement will explain what I think you need. And yes, we do (or will) track trailer numbers for the BOL also.

Thanks but yes, that's probably too generic and perhaps this question isn't posted in the right forum, but that was the whole point to my question. It is unclear to me if I need to create a table with a record for each truck to create this report....or if I can just create a field for the truck...

I need to create multiple bills of lading from one shipment record. Each shipment could have multiple trucks. Each truck has mutiple container types. And each container has multiple serial numbers. Each Truck needs it's own bill of lading. I have a Shipment Table A container by shipment...

My solution was to link to the back-end tables through a direct connection to the folder in which it resides. Using a mapped drive causes it to time out. The mapped drive is faster in the office. The direct network path is faster on VPN. Thanks for the assistance!

That works!

I need to print a bill of lading for one shipment. I need a subform on the bill of lading which lists all seriel numbers....each serial number is it's own record. They need to be listed horizontally but can have several rows.

I am trying to display records horizontally in a subform. I've tried adjusting the # of columns, but I'm having two issues. I don't know how to adjust the size so that it's not just a very large page, AND it only displays horizontally when printing. Not in the actual form.

OK, thanks! Having the subform selects the correct data, (this is the wrong forum for this question, I know) but since this thread was started here...is it possible to make the subform look like it is just integrated into the form so that it doesn't look so intrusive if it's printed. Or should...

When I use multiple tables in a query, sometimes it will not let me edit the data unless it is in one table. And this is part of the problem The other part, is that I have shipment data in one table, and package data in another table (which is really a subset of the shipment data), and I can't...

Spikepl, You are correct, I do not want to make a table that looks like that. But I do want to make a temporary table that lists everything for the shipment in one row, because I want to generate a form to which data can be added. Data in this table would be deleted after a week or so (after...

Essentially, I want to make a table that looks like this ShipperID 800 Shipment# WEF_045 Departure Date 7/1/2012 # of Packages 24 PackageID's ww-001, ww-021, ww-035, ww-094, ww-009, ww-029, ww-039, ww-091, ww-008, ww-028, ww-038, ww-092, ww-006, ww-022, ww-032...

This is a piggy-back question on this thread for a query rather than a table http://www.access-programmers.co.uk/forums/showthread.php?t=227357 If I have the following tables Shipments_Table ShipperID (Unique) Shipment_Number Departure_Date Arrival_Date Package_Type Number_of_Packages And...

When off-site, it times out while searching for the mapped drive. Basically it takes too long.

>>The reason VPN users cannot access the directory is due to the fact that you must use the fully qualified domain name. It is unclear to me why this would be true only for remote connection. Any ideas?

I can open and use my Access Database when in the office and on the network, but it will not open when I am off site using VPN. I moved the database to a different folder on a different server in a different city. When I ran the test, it worked for remote users. Now it does not work at all...

Hey that worked. I created the new table, created a multi-item form, automated an append query to put the shipperID at the top of the page, created a combo box for the Serial number and that is exactly what I needed. After I enter one serial number, a new box pops up so that I can create the...