I normally provide free tutorials rather than downloads because:
- I do not wish to become a developer.
- You can modify the databases, codes and forms as you please.
- The principles of my processes can be applied using other systems and programming languages.
- You can incorporate the forms into your own databases instead of buying stand-alone forms.
- I personally do not download from unknown sources and neither should you!
Therefore, I occasionally upload completed databases to my Google Docs pages for downloading.
The Difference Between MDE and MDB Files
Developers sell mde files. I offer free mdb files. What is the difference? They are both Microsoft Access database files. However, you cannot alter mde files nor can you view the code. You are stuck with the developer's design.
I don't know about you but I am no fan of applications with miniature forms and microscopic characters that require The Hubble Telescope to view. I also prefer pretty colors to gray and boring. I dress up my personal databases with funny cartoon characters and images for which developers would have to pay royalties. And pass the expense on to you!
Sorry, I do not include these cartoon characters and images in the free downloads due to copyright law. But you may use your own images to dress up your databases and that is the freedom that comes along with mdb files.
These databases are freeware with no support. They are also subject to my Terms as spelled out on my Terms (http://www.vbquick.com/p/terms-of-use.html) page. If you have problems and I am not overwhelmed in other areas of work and life, I do enjoy helping people so do not hesitate to contact me. I cannot guarantee, though, that I will be available 24/7 to help you.
No, you will not have to visit the library to use the downloaded databases!
However, databases are rather fussy and do not like being moved to other machines. Microsoft Access requires Library References. You select the References for the code you write from the Visual Basic Editor. If you do not know what References are or how to select them, see this post on VBQuick that explains References with pictures and how and where to select them:
Your computer may store these Libraries in other locations than my computer does. When you download a database that stores References in a different location than your computer does, you must tell your computer where they are. You do this by selecting them from the Visual Basic Editor as explained in the post above.
Additionally, your computer does not like opening other computer's databases. This is a safety mechanism and you must grant your computer permission to open a downloaded database. Never grant permission for your computer to open a database from an unknown or untrusted source. You must at least use some sort of anti-virus software to scan the download and confirm that it is virus free.
Instructions for how to grant your computer permission to open downloaded databases can be found on my other blog: The Generic Database on this page. It is simply a matter of checking a box in the file's properties box.
And now for the free stuff. Be sure to check back in the future for new additions. I am pretty lazy about sending out emails when you sign up for updates. That is better than inundating you with emails about every little thing but you may miss important additions if you don't check back once in a while.
This form resizes unmoveable, unsizable forms in your Microsoft Access database while in Form View. This lets you see and make changes on-the-fly while designing.
If you do a lot of database design, you already know how handy this will be.
When creating a form, you often switch between Design and View modes. When in Design mode, it is difficult to see if your form will contain all the controls. If you want your form to be unsizable so users don't mess with your design but you make frequent changes to the design yourself, then this will come in handy.
Additionally, you may add controls to forms in the future or play with designs (as I do!) and resizing becomes tiresome.
I use Form Resizer quite often and have one in each of my databases since I'm always changing designs, adding controls, etc.
I created this form because I was tired of switching back and forth between Design and View modes and believe me, this little form has made my life a lot easier. I think you will enjoy it.
On each form you wish to resize on-the-fly, you:
- Place a button on the form
- Add one line of code to the form's Open Event that calls the function that to resize and move the form to the last saved size and location
- Add one line of code to the button's Click Event that calls the function that opens the Form Resizer so you can move and resize your form using arrow buttons while still in Form View; even if it is unsizable and unmovable.
You can build this form yourself from the fully illustrated tutorial at my other blog The Generic Database:
Or you can download the complete database from my Google Docs page here:
QuickBooks Profit & Loss by Class Exclusion
This handy Microsoft Access database imports your QuickBooks classes with a button click. You select the classes you do not want on your Profit & Loss Standard Report.
Click the button and your report is created but without the classes you selected.
The code uses QODBC sp_reports and subtracts the classes you selected.
In mdb format so you can alter the code to suit yourself and design the report any way you like.
An Experts-Exchange member was looking for a way to do this. I created the form out of curiosity whether it could be done.The member was very happy with it and considered the solution an excellent one.
The member created the form form this two-post tutorial here on VBQuick without any problems or questions and it worked for him without any alterations.
This form is also available as a downloadable database from my Google Docs page. You could use it as is or incorporate it into one of your own databases or design the form differently if you wish. You could simply study the code and apply the principle to another system if needed.
If you read The Link Principle (http://www.thelinkprinciple.com/), you may use a Temporary Filing Cabinet to help organize files.
If you do, this database is for you. It stores your permanent and temporary folder locations in categories that you create and lets you move files between them without opening any folders or sub folders.
Once you implement The Link Principle, you will discover more reasons to use this database.
The form below has been narrowed to accommodate the web page. Since this is an mdb file instead of an mde file, you may redesign it any way you like! If you mess up the database, just download a new one or keep a good copy as a backup.
All you do is highlight the files to move and click the arrow buttons. If you want to move files to a sub folder, highlight the sub folder.
If you decide to try the sample databases, please let me know how they work for you. I enjoy all feedback, positive and negative, because it helps me improve the site. If you have any questions, leave a comment so I can get back to you.