Creation of VBA-based machine tool fixture standard parts library

OLE, database, standard parts engineering drawings and other technologies that need to be solved in the standard parts library of machine tool fixtures.

;! A language AutoCAD is a CAD software platform developed by Autodesk Corporation of the United States. Although it has a strong graphic editing function, it is felt in the data processing, especially when it is necessary to comprehensively process design calculation, data processing, graphics drawing, etc. The power is not in the heart. For example, in the common engineering design of enterprises, the design of common parts and standard parts inside the enterprise, such as pressure plate, briquetting block and V-shaped block, are often encountered. These parts have a similar structure but are not versatile and the dimensions need to be changed frequently. Therefore, it is necessary to carry out targeted secondary development of AutoCAD2000, and use the VisualLISP, VBA and ObjectARX development tools embedded in Auto-CAD2000 to meet the needs of engineering applications and reduce the repetitive work to improve design efficiency. In particular, VBA development tools are embedded in AutoCAD 2000 compared to VB, but they are a subset of VB. Therefore, it has the characteristics of easy learning, high development efficiency and object-oriented programming. 1. Combined with the ActiveXAutomation technology frame supported by AutoCAD2000, it can provide a powerful interface, which can not only operate Auto-CAD internal objects but also in other applications. Transfer or receive data between programs shows the advantages of developing applications. 2 1 System framework of machine tool fixture standard parts library 1.1 Information flow of machine tool holder The standard parts library has the following main function modules: standard parts library application, standard parts The database, image library and AutoCAD. Image library are used to store drawings of different kinds of fixtures for preview. The data in the standard parts database is the size of each type of fixture, and the application program is used to generate drawings in AutoCAD.

The information flow of the function module is as shown. The application calls the drawing of a certain type of fixture in the picture library, and calls the size data of a certain type of the corresponding type fixture in the standard part database through the interface program, and finally calls each drawing program to generate the fixture of the specific specification under the AutoCAD interface.

kf-rW can be applied to the structure of f1 and 12 libraries. There are many types of machine tool fixtures. In order to facilitate the user to quickly retrieve the required standard parts, it is necessary to organize the types of fixtures reasonably. Looking at the machine tool fixture design manual, we divide the fixture standard parts into three categories and 19 types of gauges. As shown, the positioning components mainly include support nails, support plates, adjustable support screws, positioning pins, positioning mandrels, and V-types. Piece. The clamping elements mainly include a slanting jaw, a pressing screw, a nut, a swinging pressure block, a pressure plate, a hook-shaped pressure plate, and a circular eccentric wheel. Other special components mainly include the cutter block, the feeler gauge, the positioning key, the drill sleeve, the bushing and the fixed bushing.

Information flow chart fixture library structure 2 machine tool fixture standard parts library interface and usage 2.1 machine tool fixture standard parts library user interface application development test, in order to facilitate user use, do not need to enter the VBA development environment every time. It can be loaded into AutoCAD as a menu or toolbar button, and the fixture standard library application can be called directly through the menu or toolbar buttons. Here's how it works as a menu in Auto-CAD. The application is first loaded with the name of the text file and yyyy is the main program name or module name for the program. In this way, each time you enter Auto. CAD, just click on the menu program “Yes. After the operation, the main interface of the machine tool standard parts library as shown. The interface is composed of the fixture category” list box and two command buttons.

The main interface component and other specialized components for the VBA application fixture library. Click the Cancel button to exit the fixture library. Click the OK button to enter the next level dialog box as shown, the fixture type selects the dialog box mainly by the fixture standard part type "list box, graphic box and 3 command buttons Composition. After selecting a fixture class, the graphic frame displays the fixture to be generated in real time. The previous page "Button is used to return to the main interface of the machine tool fixture standard library. Click the Exit button" to exit the fixture library. Click OK to enter the first button. The three-level form is selected as shown in the specification of the fixture.

Fixture Specification Interface This form consists of a detailed specification frame bar, a specification list box, a test spindle diameter input box, a graphic frame, and three command buttons. When different fixture standard part types are selected, different information and contents are displayed in real time in the detailed specification frame bar, specification list box, input box and graphic frame. Fixture specification list box for selecting fixture specifications Use the specification list box to select different sizes H. When testing the spindle diameter input box, the left and right size ranges will change accordingly. When the input value is not in the selected range or is not a number, a warning box will pop up to select the fixture specification and input the mandrel diameter D and click the OK button to automatically generate the required fixture map in the AutoCAD environment.

2.2 The use of the standard parts library of the machine tool fixture is based on the selection of the V-shaped block. First select the fixture type positioning component "Click the OK button. After the second dialog box appears, select the fixture standard type V block (GB2208? 80) * Click the OK button. The third dialog box appears to select the specific size H After entering the mandrel diameter D and clicking the OK button to run the fixture library program, the V-shaped block of the selected specification is generated directly in Auto-CAD as shown.

Key technologies in development 3.1 use objects. The ADO object is a data access interface that encapsulates the various properties, methods, and events required to access the database. Using the ADO method to access the database will enable you to write data that can be used in the database server via OLEDB. Access and operation of the application. OLEDB provides high-performance access to any data source. Its main advantages are ease of use, high speed, memory overhead and less disk space. ADO supports the main features for applications such as client/server and web. ADO is an object model that combines the easy-to-use features of OLEDB with common features that are easily found in models such as RemoteDataObject (RDO Xiang DataAc-cessObjectS (DAO). ADO is running entirely in program code and is much simpler than RDO and DAO. A more flexible object model. Before you can reference an ADO object in a program, you must first set the ADO library as a reference project.

3.2 Establishing the fixture standard parts database The table design geometry is applied by a series of design methods suitable for standard parts and common parts of mechanical parts. By analyzing the fixture standard piece data, a database is created for each major class of standard parts, that is, the positioning component data indicates that the input value is not in the selected n range, not a number, and should be re-entered. The decision form of the semantic distance then gives a different calculation method for the semantic distance of different attributes of the part based on the combination of the domain knowledge, thus providing a quantitative representation of the degree of similarity between the parts and the relationship between the parts categories. It's not just a simple division of the category of the part. Finally, based on the hierarchical clustering algorithm, the part clustering tree is established, and the time complexity of the algorithm is given, which provides intelligent database support for the whole CAPP system, which effectively improves the accuracy of part classification. By accurately classifying the parts and establishing a mapping relationship between the classification results and the part process, a dynamic parts knowledge base with self-learning features can be established to lay a foundation for establishing a CAPP system with strong adaptability and flexibility.

(Finish)

Electric Chain Hoist

Eurocrane Electric Chain Hoist is compact and reliable. The modular design enables a wide application in complex occasions and customization. Because modularization brings a flexible combination of different lifting capacities, different lifting speeds and working levels, and outstanding performance for quick transportation and precise assembly. The main driving component in hoists of this series is designed to be maintenance free. The electro-magnetic disc brake can reduce the running noise effectively. The standard and humanized design not only improves the operation performance, but also reduces the maintenance cost greatly.Eurocrane Electric Chain Hoist is compact, reliable, durable and suitable for a wide range of applications.The hoist of this series has adopted the Germany design concept. Eurocrane Electric Chain Hoists are designed and manufactured fully in accordance with European FEM, EN and Germany DIN standards as well as the ISO and Chinese GB/JB standards.

Electric Chain Hoist,Chain Hoist,Electric Hoist Lift,Electric Hoist With Chain

EUROCRANE GLOBAL , https://www.eurocranepart.com

Posted on