Recent content by tinabee

Hi Bill - that looks great! Since my VBA knowledge is limited though, could you please explain to me how the # of lines is determined?

I have a WO Table and a related WO Procedures Table. I would like to add a specific # of blank lines/records between each record but that # will vary. So the report will show the WO Procedure Desc then a specified # of blank lines below it and then the next WO Procedures Desc then a specified...

Can you tell me what the code would be to put the WO Info from Access into the Word Doc? Would I use bookmarks or merge fields on the word doc?

Hi - thanks for your reply. There are many inspection reports and they sometimes have to be edited so I think it is best that they remain in a Word format. I thought there would be a simple way to merge the Access data into the Word document.

Hello I have a database to track work orders. Each workorder has one part#. Each part# has a 2 page inspection report page created in Word. (1 page for the workorder info (CustomerID, Serial# etc along with other info that does not come from Access and the other page is a drawing). I would...

I think I figured out something that will work. I added a field to the segment table called Segment# (so it would have 3 fields SegmentID, SegmentName & Segment#). I gave the segments 1-5 the number 1 and segment 6 the number 2. I then created a query (WIPQuery1) using the Work Order &...

Right now if there is not WODetail for a segment the heading does not show either so if there were no details for assemble it would not show.

Assemble can be visible anytime - it's just only the Work Orders that meet the criteria should be listed there.

Every Work Order will have a Work Details record for "Dismantle" and one for "Assemble" and will have 1 or more records for other segments. So if Dismantle is not checked Work Done or any of the other segments are not checked Work Done then it will not appear under the Assemble section. The...

Adding the "Me" solved the error problem but the report is not what I need. On the report I have WO#28809 and it is listed under Machine, Chrome, Grinding and Assemble as none of those WODetails have been checked WorkDone. I want the WODetails for Machine, Chrome and Grinding to show but not...

I am getting an error "compile error: Method or data member not found" and txtCount is highlighted

Yes there are only 6 segments and I can get them to show when Work Done is no with a query. But it also shows the Assemble segment and I don't want this segment to show unless all the other segments are checked Work Done. The report is a main report (no record source) with a subreport (record...

This is a better sample of the report

The segment table has a autonumber field there are 6 of them. Each work order detail has a segment that is a combo box populated from the segment table. Every detail has segment 1 (dismantle) and 6 (assemble) and at least 1 sometime many other segments. The ToDo report shows the Work Order #...

This database is for a machine shop. I have a table called Work Orders and a table called Work Order Details. Each WO Detail has a segment (there are 6 segments in numerical order to choose from) and a Work Done checkbox. I have a report called ToDoToday grouped by segment. I would like the...