An Intelligent Automation Platform for Office developers and professionals
This function will list out all the procedures and functions that exist in an MS Access module. This is a complimentary article written by the MAARS team for the MAARS user community. Code in this article drives the operation of MAARS (MS Access Application wRiting Software). MAARS is an intelligent automation program that speeds up […]
This procedure finds all the Queries in an MS Access Database. This prints out the name of each query plus the SQL behind each query. This is a complimentary article written by the MAARS team for the MAARS user community. Code in this article drives the operation of MAARS (MS Access Application wRiting Software). MAARS […]
This procedure finds all the forms in an MS Access Database. This shows how many forms are in the database and prints out the source of each form. In order to print the source of each form, the form should be opened in design mode. This is a complimentary article written by the MAARS team […]
This procedure will transfer a table definition plus data from one database to another. Manually copying objects such as tables, forms, reports, modules etc from one database to another database is simple but unnecessary and time consuming. This can be achieved quickly with these few lines of code. This code is used in MAARS implementation. […]
This procedure will transfer an entire module from one database to another. Manually copying objects such as tables, forms, reports, modules etc. from one database to another database is simple but unnecessary and time consuming. This can be achieved quickly with these few lines of code. This code is used in MAARS implementation. Feel to […]
This procedure will transfer an entire module from one database to another. Manually copying objects such as tables, forms, reports, modules etc from one database to another database is simple but unnecessary and time consuming. This can be achieved quickly with this few lines of code. This code is used in MAARS implementation. Feel to […]
This procedure will transfer a form from one database to another. Copying objects such as tables, forms, reports, modules etc from one database to another database is simple but unnecessary and time consuming. This can be achieved quickly with this few lines of code. This code is used in MAARS implementation. Feel to free use […]
This procedure, AddATabControlToThisFormGeneric, adds a TabControl to an MS Access Form. Tyically developers adds TabControl in a form manually and then adds pages to the tabcontrol by hand. We think that’s a waste of time. So this procedure automates the mechanics, freeing up the developers time to do the design work. This code is part […]
This function, ControlExists, checks if a control object already exists in a given form. This is a must have function if you are writing MS Access Form or Report dynamically. Before adding a control to a form, you can use this function to check if it already exists and then decide whether to add or […]
This fully commented procedure, AddAHeaderLabelToAFrom, adds a label text to the header section of a given form. The code also dynamically adds an event procedure to the label, when the label is double clicked, the form will close. This procedure is part of MAARS implementation. Feel free to copy it and use it in your […]
This CheckIfFileExists is a simple but very useful function when reading or writing files to the Operating System using VBA. Call this function first before reading a file or writing a file. If reading a file, call this function to check if that exists before trying to read it. If writing a file, call this […]
You may be wondering – what is a meta program? Let me give it to you straight away without wasting your – it is a program that writes other programs. Typically an MS Access Developer can create an MS Access Database using the MS Access Software. Then he can create all the objects (tables, queries, […]