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 Introducing the “Transpose Tool” or “Database Normalization Tool,” your go-to solution for seamlessly converting spreadsheet-structured data into MS Access-structured data. This transformation not only equips you to construct exceptionally powerful MS Access databases, but is also a critical process exclusive to power users—those with an adept understanding of MS Access, often regarded as … 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
