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 Reports in an MS Access Database. This shows how many reports are in the database and prints out the source of each report. In order to print the source of each report, the report is opened in design mode. This is a complimentary article written by the MAARS team for […]
This procedure finds all the modules in an MS Access Database. This shows how many modules are in the database and prints out the number of lines of code the module has as well as the code in that module. This is a complimentary article written by the MAARS team for the MAARS user community. […]
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 (sub) will add all the fields (text boxes) found in the underlying source table to the report programmatically using VBA. This also adds the proper buttons to the report output. This is a complimentary article written by the MAARS team for the MAARS user community. Code in this article drives the operation of […]
This procedure (sub) will create a report for the given table dynamically by adding all the fields found in the table. If “_P” is passed to the 2nd parameter, it will create report in portrait report, if “_L” is passed, it will create a landscape report. This is a complimentary article written by the MAARS […]
This function will ask the user to provide a name for the application dashboard and it will create the form, set the height to 4 inches tall. It only creates the form by using another form called “frmBlankForm” as a template and does not add any controls to the dashboard form. This is a complimentary […]
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 procedure, AddAllNeededReferences, will dynamically add references to VBA, STDOLE, DAO, Excel, Word and Office libraries. If you are writing an application that needs to interact with MS Excel, Word, enter data into MS Access tables using SQL and VBA – you can use this procedure to create references programmatically. This is a complimentary article […]
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 […]
This fully commented procedure below describes how to create a new MS Access form by copying an existing form and then change the data source of the newly created form. This procedure eliminates the need for developers creating MS Access forms manually and speed up the development process significantly. Once the code has been fully […]
This fully commented function below describes how to check if a report exists in the database or not. If you are writing reports dynamically using VBA, you must have a function like this one in your database to ensure you are not overwriting fully functional existing reports. We use this function in MAARS code base […]
This article was written by Bashir Ahmed. Code in this article drives the operation of MAARS (MS Access Application wRiting Software). MAARS is an intelligent automation program that speeds up MS Access Application Development by 10x, 20x or 100x times. To learn more about MAARS, click here. Disclaimer: Some information included in this article may […]