Rank with VBA With the Google presentation and a video below, I demonstrate how to change the rank of an item in a table. This is particularly useful if you have a lookup table and you want to offer your user the ability to move an item up or down the list. To add this … Read more
Recordset Loops I recently answered a question on my Facebook site… Link:- Full Text of my Answer:- basically it would be best to use a record set loop to solve the OP’s problem. I agree with Sherry, you need to use a Recordset Loop… I did a set of video instructions on how to create … Read more
Recordset Loop – Create Records Becoming an MS Access Power User ????Once you start converting queries into SQL statements – in other words, a string version of the query – you can take that string and manipulate it, extract things from it, and do all sorts of things with it! One of the best stepping … Read more
Combo Boxes Combo Boxes are the most fascinating and useful “Controls” you can have on your Form. They have Many uses. Combo Boxes can be manipulated in all sorts of ways without using VBA. Once you’ve mastered the combo-box, and once you have mastered Queries, the building of queries in the query builder grid, a … Read more
“Advanced” Message Box Message boxes can be modified quite extensively to give you your user a much better experience. So before you set about creating a Form to use as a Messsage Box, consider using the more advanced features of a “Built In” Message Box. There’s a really nicely done example database on message boxes … Read more
Searching For Answers The upgrade to the Access World Forums (AWF) has also provided a much better search facility. So this blog is practically obsolete! However, I still find that the Google Search offers a much greater control over what you are searching for. If you’re trying to find something obscure, give it a try, … 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
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
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
Transform, Concatenate Examples A common requirement in MS Access is to extract Columnar data into horizontal data, for instance to make reports look better, to provide a list of emails suitable to send to with Outlook. In the YouTube videos below I explain how this can be done. Display Field Data Horizontally Display Field Data … Read more
