SolidWorks BOM Table header removal
SolidWorks BOM Table header removal
(OP)
Using SolidWorks 2006 sp4.1.
Does anyone know of a way to remove or not show the header for a SolidWorks BOM Table?
What we are trying to do is put schematics and the like in the front of the BOM with an item number of 0 (zero) and a quantity of 0 (zero). I have a template that does this. Then I would place the real BOM above this one. However the BOM header shows up and looks funny having two headers. In Excel we would insert a row and manually type in the data.
Management will accept the two headers, but they will not accept the data in another area of the drawing. They say we have been putting this information in front of the BOM for too long to change now. I have put in an enhancement requests.
Does anyone know of a way to remove or not show the header for a SolidWorks BOM Table?
What we are trying to do is put schematics and the like in the front of the BOM with an item number of 0 (zero) and a quantity of 0 (zero). I have a template that does this. Then I would place the real BOM above this one. However the BOM header shows up and looks funny having two headers. In Excel we would insert a row and manually type in the data.
Management will accept the two headers, but they will not accept the data in another area of the drawing. They say we have been putting this information in front of the BOM for too long to change now. I have put in an enhancement requests.
Bradley






RE: SolidWorks BOM Table header removal
Eric
RE: SolidWorks BOM Table header removal
We are trying to get rid of the item numbers and quantities. After we put in the schematic and assembly spec’s the item numbers would have to start at 1.
Bradley
RE: SolidWorks BOM Table header removal
Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: SolidWorks BOM Table header removal
Thanks for the idea, but that is more work than just leaving the header in the BOM. I could not get the table to auto fill with BOM information, like description and part number.
Bradley
RE: SolidWorks BOM Table header removal
1. Header row
2. One or more rows of item #0 qty 0 for schematics
3. The actual parts in the BOM.
You can still insert a row in a SolidWorks BOM. However, each time you try to edit a cell you get the nag box that asks if you really want to change the value. You can get around this with API/VBA. You would have a macro that would insert a row at the top of the BOM. You could populate the row in many ways, from InputBox[es] for each column value to a UserForm with text boxes and data validation for you to enter your schematic numbers/names etc.
RE: SolidWorks BOM Table header removal
Bradley
RE: SolidWorks BOM Table header removal
Re-reading your last post... Is your schematic table also filled out automatically somehow as a BOM?
RE: SolidWorks BOM Table header removal
I could not figure out how to insert a blank row at the beginning of a BOM, then have the item 0 and then the next row would be item 1 from the assembly model. Can you tell me how to insert a blank row in the BOM?
Bradley
RE: SolidWorks BOM Table header removal
1. Reads the part number column
2. Re-numbers the the BOM item number to the part number for all fab parts
3. Re-numbers the BOM item number to "101" for all purchased parts
4. Sorts fab parts at the top in part number order
5. Sorts purchased parts by maker then part number
6. Re-numbers all BOM item numbers for purchased parts beginning at 101.
If you want the BOM to start at 1 with all zeros above, you would have to get the parts portion of the BOM the way you want it and then in the table properties hit the button for "Do not change item numbers". You can then right-click on the first row and choose Insert->Row Above. You'll get a blank row that's numbered with whatever number is next. You can double-click on the cells of that row and edit them manually.
RE: SolidWorks BOM Table header removal
Bradley