Hey guys & gals hope all is well with everyone. The company I work for has a huge database listing all there pieces and parts in MS Access. After our plan is finished I generate a bom in access, physically counting all these items from the plan I drew. This is what I want to do. I want to link a block item in cad to access. I thought I could make a block in cad using the pre-established product code name in our access database as its name. Upon creating all the blocks for the drawing and linking them to access, I then could have a bom generated in access for me without physically counting each piece. Is this possible or do I need a different approach? Please be kind, my knowledge of VBA is next to nothing. Any help would be greatly appreciated.
I know what Fish wants.
My last company that I work for had this but the company used Microstation. And they pulled it from Syteline, an ERP software. YOu built the BOM in the ERP software and then you went Microstation and mashed a function key that was configured to import and create the BOM (inculding line work and Data.
Very very very very Slick. Did I tell how slick It was.
Some information
* All part data was stored in the ERP software.
* The user would querry and/or create a part and its descrption in Access and SQL (I know nothing about Access except as ready-only user). Access would feed the data of the newly created part to the ERP.
* The user would enter the BOM P/N and Quanity in the ERP software.
* The user would open cad file for the assembly and hit the function key to import the BOM.
How to do this with and Autodesk product and Access. I have no freaking clue.
Sorry Fish
Can"t Feilds read data from Access???