Search results

This question is based on a thread from the query forum which you can find here http://www.access-programmers.co.uk/forums/showthread.php?t=233742 I have set a breakpoint in my code but I clearly do not know how to use this tool. When I debug, it does nothing that means anything to me. I...

Well, the code compiles and the system doesn't return any errors but it's not working the way I think it should work. I continue to get ", , box" for some entries. It is unclear to me why the commas would display before the data. It is also unclear to me why the system inconsistenly returns...

I've typed what you have below but when I compile I get a synax error message. 'Loop through the matching records Do While Not rs.EOF If bIsMultiValue Then 'For multi-valued field, loop through the values Set rsMV = rs(0).Value Do While Not...

Do you mean in the query or VBA?

Hi Bob, Thanks for your response...this works, but it makes the query slow. Is that typical?

Yes! This works!! But now I have the following problem. I am concatinating rows and then also concatinating the fields.... ShipperID Material Container Equipment 3 10 Shoes 10 Boxes Tarps 6 15 Pants 15 Bags 7 5 Coats...

I understand what you are suggesting and I have done that for other reports and it works well in many cases. However, The the simple reason I am trying to do the query in this way is because I need for all of the data for the shipment to be on one line. I know it is possible to list the...

I have a shipment database with a Shipment Table and Materials/Containers Table Each shipment can have multiple containers and materials. I want to create a querry field that lists all materials and containers for each shipment. How do I do that?

I found the following instructions...and was able to do this as an excel spreadsheet OR a word document. And as a bonus...I can edit the document inside the form. That's awesome! Open the table your form is based on and create a new field - define it as an OLE Object. Enter Datasheet view...

Found it, Thanks!

I know it is counter intuitive to make a table outside of access, but the data is just a bunch of text that needs to be printed onto one form. It is really not data that needs to be stored by us. Not only that but it is a lot of data to be entered for a relatively small return. This data...

I'm not sure where this question belongs but I need to give users the ability to create a small table in MSWord or another program, and then paste the table into a data field. An image of the table would be fine. But it needs to be user friendly. If that's not possible they could just...

Ok, it appears that if I put the "Header" section and the truck content under the "Truck" level grouping in the report....it will put all the contents on the correct pages. The only apparent remaining issue is that the "Page footer" appears to be functioning as a "report footer" as it creates...

http://www.access-programmers.co.uk/forums/showthread.php?t=230122 This is a follow-up question to the above thread for some background information. Essentially, I am creating a report that is a Bill of lading. I need each truck to printout on a separate page but they all seem to want to...

That's it! I couldn't open the link from work...they have it blocked for some reason but I was able to do a search for "wherecondition" discovered the solution. I added a where condition "[trackPackages]![ShipperID]=[Forms]![Add/Edit/Delete/grayscale new]![ShipperID]" to the button macro...

I have a form to enter shipment data and a subform to enter and view serial numbers for that shipment. The subform displays only the related serial numbers for that shipment. I would like to just use an "Open form" button to open the serial numbers form, however, when I use the button it...

There was nothing obviously unusual but I re-entered all of the data and created a new record for that date, and it now works. Thanks!

I have a report which groups shipments by shipment type and whether it is one-way or round trip. I run the report by month so my parameter boxes query between the start date and end date of a one month period. This works for all months except August. When I enter 8/1/2012 and 8/31/2012 I...

That's what I was thinking. I think I just need to add a column to my materials/containers table for truck number so that I can group which materials go with which truck, which is what I've done above, but I can't get the report to display how I want it.

I've created this bill of lading. It should print one truck per page, but it ends up printing several all of the materials for every truck in the detail section. What do I need to change.