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

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

Open one Form from Another and transfer Data

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. [wp_ad_camp_1] Open One Form From Another Open One Form From Another Video 1 (3:15) I have used the technique shown here, for … Read more

Setup the Northwind dB

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 [wp_ad_camp_1] Setup the Northwind Sample dB Northwind … Read more

TempVars Value Error

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

Import CSV

  Import one CSV into two Tables Import CSV Video 1 (2:15) Import the Comma Separated Value file (CSV )into a staging table. Then run two queries against the staging table. One query to extract “H” into a new table, the other to extract “R” into a new table. Video 1 (2:15) More Info on Import CSV:- … Read more

List Box Default Selection

List Box Highlight a Default Selection  Highlight a Default Selection  Video 1 (1:59) Set the listbox controls default value so that the list highlights the same row … Video 1 (1:59) Highlight a Default Selection – Bullet Points 00:27 go to the list box properties00:45 put something in the default value00:47 a “2”01:12 and you can see … Read more

Control Wizard (Access 2007)

Control Wizard (Access 2007) Control Wizard Video 1 (2:09) Demonstrate how to use the MS Access (2007) command button wizard to open another form and filter it to display the same record on the second form as you were looking at in the first form. …..[wp_ad_camp_1] Video 1 (2:09) … …

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.