Time & Date I need this “Dates” page as a general page for the top of my Dates Menu. Will add more information about dates as I find useful stuff on the internet. In the meantime, just below here is a drop down menu which gives you links to the stuff already on my website … Read more
MS Access Links I gather links from all over the internet related to MS Access, and of course other things of interest to me in creating novel MS Access Solutions. I was finding it difficult to maintain lists of links on the Nifty Access Website, that is, until I found this WordPress plug-in:- “Inline Google … Read more
Is This Control a Hyperlink? Gasman asked the Question:- Hi all, In the Northwind 2007 database, the id control on the form for Customer List appears to be a hyperlink. However I can not see how this is done.? The isHyperlink property is set to no. Al I can find is in the Tag property … Read more
Insert File There’s a fantastic, useful, clever feature of MS Access (actually I think it’s in all of the VBA products) where you can store code snippets in the normal file structure of Windows. Basically you have a folder which is accessed quickly and easily through the — >>>Insert >>>File — menu. This menu is … Read more
A very simple but very useful technique – bring the latest code you are working on to the top
Display a Message for the User There are many ingenious ways to offer help to your MS Access Application user. In a help table in a Text Box. There is a YouTube video by way of explanation here, and a downloadable example database. Display Message inside TextBox Display a Message for the User Video 1 (1:24) … Read more
Nifty Gotcha’s Most of the time MS Access provide some Nifty features which help you develop your code. However sometimes MS Access can be too helpful; the additions alterations to your code that MS Access makes can really mess you up! I’ve started a list of them here:- Access takes Liberties MS Access takes Liberties … Read more
Move Info from One Table to Another A brief summary summary of the “OP’s” (Original Posters) question HERE. I’ve done a set of YouTube videos to answer the question. The first answer demonstrates the INSERT INTO method of adding records to another table. This method is where you update the underlying table by adding a … Read more
Filtering – MS Access Forms This video should be of interest to anyone who wants to easily apply filters to an MS Access form in datasheet view or continuous form view. In this demonstration I show how you can apply filters in a Form presented in Continuous view and also in Datasheet view. When you … Read more
Multi Value Fields Links Can you imagine in Microsoft offices, some bright spark, probably someone from marketing comes in and says, MS Access Needs “Multivalued Fields” – we’re going to make MS Access easier for people to use! Can you imagine, all the developers jumping up and down and shouting NO! I can understand the … Read more
