Search results

EDIT: I forgot one field below and added it here. So I think I need: Table 1: Shipments with the following fields Shipment# Shipment Month (Required) Shipment Dates (Optional) EDIT::Delta: # of days Trailer will be in use for this shipment. Table 2: Trailers Trailer# Table 3...

http://www.access-programmers.co.uk/forums/showthread.php?t=236127 After looking at the forum options, perhaps I posted this in the wrong forum. I need to develop a database that will automatically assign trailers for shipments during a specific time period. See the attached link for...

So I think I need: Table 1: Shipments with the following fields Shipment# Shipment Month (Required) Shipment Dates (Optional) Table 2: Trailers Trailer# Table 3: TrailerSchedule Shipment# Trailer Shipment Dates Does this seem Right?

I need to build a database which assigns trailers, for a specific date range, for shipments so that trailer usage is as efficient as possible. Essentially I need to have the following inputs: Trailer# Shipment# Related Shipment# (for return trips so that the same trailer will drop off a...

In my opinion the union query is unavoidable in this case. Really this is two datbases being combined into one. This started as a shipment tracking database. We ship packages and we want to know when where and why. The second database is a package maintenance and package tracking...

Tables (BASIC ELEMENTS OF THEM): Means I have multiple columns that I do not want to list here because they are irrelevant. This table holds all the trailers. Maintenance_Tbl PackageID Trailer_Number On_hold (this tells us if the trailer is being held for Maintenance) Dates THE LONG...

I need to develop some code that will schedule and track availablilty of truck trailers based on our shipment schedule and maintenance. What I would like to do, is develop an Event Procedure that will assign the trailers automatically to shipments based on their availablility. *Tables*...

UGh...that didn't work. Now I'm back to the query idea...

Oh nevermind, I was making it too complicated. I realized that I just need to go into the Data Properties and point it to the correct Navigation Target, and then Point to the Navigation Where Clause

Essentially what I want to do is use the tab caption as the criteria for the query. So that if I click one tab it will use one criteria, but if I choose another it will use that criteria. Is that possible? I understand that I can create a macro and open the form with a filter. But the...

Warning: When converting a database to 2010 from and older version I converted the back-end of this database from Access 2003 to 2010 before this problem began. Unbounced to me, Access 2010 has a "caching" feature which is not available in 2003. When I converted, this somehow got turned on...

Thanks for posting this, I'll be doing this soon myself! Post back here if you find a good resource.

Try posting on the VBA Forum Board on this site. I'm a code neophite myself so I'm not the one to help with that.

I've never done that and so I can't really give you direction, but I wouldn't say it's not possible. Almost anything is possible with code.

Yes, I renamed the back-end, relinked everything....sent out new version. I've connected remotely to her machine and watched her navegate to the back-end. She follows the same path. But I agree, we must be connecting to different files. The only thing I can think of is that it is somehow...

We've been sharing a database with another office on the east coast, while we are on the west coast. The back-end resides here with us and we have been doing this for about a year and a half. While it doesn't always work great or speedily, it has worked and updated data so that we can share...

I just spent about 10 minutes typing a reply and something happened and it was wiped out...the short version is.... 1/ Try moving your back-end to a high level folder...don't burry it in multiple folders. 2/ Try creating your backend tables in Sharepoint if you have that available. 3/ Try...

Nevermind, I figure it out.... SELECT [Material_Description(x)].ShipperID, Sum([Material_Description(x)].[Weight_1]) AS SumOfWeight_1 INTO Current_Shipments FROM [Material_Description(x)] GROUP BY [Material_Description(x)].ShipperID;

Is there a way to add weights for related records in a query? I have Shipmenttbl Shipment # Materialstbl Material Truck1 Weight Truck2 Weight Truck3 Weight I'd like to have Shipment# Total Weight Is there a way to do this in a query?

I was having a similar problem over the VPN...my solution can be found here http://www.access-programmers.co.uk/forums/showthread.php?t=227446 Essentially, the front-end for VPN use needed to be linked to the tables via a direct network path, and NOT a mapped drive.