Need to know who in your business added a particular record? Or who updated it last? It’s a pretty common requirement, but unfortunately not one that Microsoft Access has built in functionality for. Simply adding a "last updated by" field to your table can (in many cases) be enough to meet most needs, but just how do you know who updated the record if Access can’t tell you? A little VBA code is all you need, as this article will show you.
No need to create your own “login” form to capture user...
Read more »
In this article, we intend to provide you with 4 ways to quickly insert same hyperlink for multiple times in your Word document.
Now and then, you will have to insert hyperlinks to your file. However, every time you will need to select the text and then enter the Internet address. It’s quite annoying to insert hyperlink one by one, especially when there are multiple same texts which require identical addresses.
To free you from such a shackle, there are 4 actual working methods for you to...
Read more »
In Excel worksheet, you can also make a lucky draw. In this writing piece, we are going to show you how to finish this task in Excel.
A Lucky draw is very common in our daily life. For example, you need to give bonuses to employees in the end of a year. You would like to select some lucky employees randomly. Therefore, you can use the Excel file to make a lucky draw.
Make a Lucky Draw
In this part, we will introduce the methods in detail.
Open the Excel file with all the information...
Read more »
