Barcodes Bar-codes along with a bar-code scanner can be a very useful feature to add to your database. You can quickly scan in serial numbers from mass deliveries of items / components. Bar codes are also very handy for managing the repair process of an item returned for repair. For example, by recording a repaired … Read more
Normalization Tool This “Transpose Tool” – “Database Normalization Tool” allows you to easily convert Spreadsheet structured data into MS Access structured data. This transformation of your data allows you to build incredibly powerful MS Access Databases. This transformation is a critical process, only known to and practice by “Power Users”, users with a good grasp … Read more
Option Group Label Color Change The technique employed in this sample is well worth learning and applying in your own MS Access database. There's always a gotcha when you are developing new code, and I hit one when I was trying to build this. I wrote the code to change the label colours, but it didn't … Read more
Passing Form Values A common requirement is to pass values from one form to another. In these videos I demonstrate some problems you might face, and demonstrate a good and robust way of doing it. Open One Form From Another Open One Form From Another Video 1 (3:15) I have used the technique shown here, for many … Read more
Northwind Database I'm not sure when the Northwind database became available, but it seems to me like it's been around right from the beginning. I have blogged about the Northwind database several times on the Nifty Access Site… See below for info on How to set Northwind up Setup the Northwind Sample dB Northwind Sample … Read more
You cannot Always omit “Value” I often see people are advised they do not need to refer to a Control’s Value implicitly like this:- Dim strValue As String strValue = cboCurrent.Value This advice is given because “Value” is the default, therefore it is unnecessary to append it, So you could write the above like this:- … Read more
CSV Import I’ve done quite a bit of research into importing Comma Separated value Files into MS Access. In particular, I’m working on importing CSV files with more than 255 columns. I have had a reasonable amount of success, but it was thwart with complications that were difficult to resolve. Not ready to release my … Read more
List Box Default Please be aware that while upgrading the Nifty Access Website I discovered this post. I tried to link it back to the original post on Access World Forums, however I couldn’t I find the post. I found one that looks similar, but I don’t think it is the correct one! I’m going … Read more
Control Wizard The Control Wizard is a very handy feature of MS Access. It provides built-in wizards, which simplify many of the processes you have to partake in to build your MS Access database. Button Wizard (Access 2007) Button Wizard (Access 2007) Video 1 (2:09) Demonstrate how to use the MS Access (2007) command button wizard … Read more
Enable or Disable by Command In this video I demonstrate how to make a control appear greyed out. In other words, you can’t do anything with it. I demonstrate the process by using two separate command buttons, however it is possible to do it with a single command button. I have a video demonstrating this, … Read more
