ZHU Limin. Development of Engineering Material and Heat Treatment Inquiry System based on VBA[J]. International Journal of Plant Engineering and Management, 2020, 25(2): 65-76

Development of Engineering Material and Heat Treatment Inquiry System based on VBA
ZHU Limin1,2
1. China Coal Technology Engineering Group Chongqing Research Institute, Chongqing 400039, China;
2. National Key Lab of Gas Disaster Monitoring and Control and Emergency Technology, Chongqing 400039, China
Using VBA secondary development of AutoCAD, a kind of common engineering materials and heat treatment query system is designed, in which more than 400 kinds of commonly used materials were established based on the Access type of application and heat treatment database, recommend suitable material to designers to design and manufacture of a particular components. The system interface is concise, can be continuous, over and over again, no order query, can query to the characteristics of material usage and heat treatment process, as a CAD aided design software has positive design reference.
Key words:    VBA    ADO    database query   
Received: 2020-03-20     Revised:
DOI: 10.13434/j.cnki.1007-4546.2020.0201
Corresponding author:     Email:
Author description:
PDF(KB) Free
ZHU Limin

[1] Du G, Liu D X, Zhang L. Secondary development of AutoCAD based on ObjectARX and its application[J]. Machinery Design & Manufacture, 2004,(3):30-32(in Chinese)
[2] Xu J J, Shen J H. Development of automatic detailed list of assembly drawing marking system based on ObjectARX custom entity[J]. Mechanical Engineering, 2011,(4):30-33(in Chinese)
[3] Yu W J, Wang Y. Research on AutoCAD annotation attribute information extraction[J]. Journal of Qingdao University, 2007,(2):55-60(in Chinese)
[4] Han T C, Fan F X. Development of partial enlarges in AutoCAD environment[J]. Coal Mine Machinery, 2001,(12):33-34(in Chinese)
[5] Sheng L, Zhang L Y, Xie L X. Analysis and discussion of precision sketch on secondary development of SolidWorks[J]. Modern Manufacturing Engineering, 2014,(4):68-71(in Chinese)
[6] Qiao Y, Shen J H, Zhang M. Gear profile fitting of gear pump based on VBA[J]. Coal Mine Machinery, 2017,(9):190-192(in Chinese)
[7] Song E, Li S G. Interface design technology in advanced developing of PROE[J]. Machinery Design & Manufacture, 2005,(5):56-58(in Chinese)
[8] Wang L C, Zhao J W, Wei S, et al. Implementation of re-development to Pro/E in function integration[J]. Machinery & Electronics, 2010,(7):6-9(in Chinese)