|
||||||
Access MVP (2010-2015) |
Taking the Splash Screen up a notch… Sometimes you want to load some data before your database opens? You don’t want your Users wondering what’s happening, so here’s a way to keep them advised of the progress. (To download this example click here.) To use in your database, import the basProgressBar and frmSplash into […] 10,184 total views, 1 views today Recently, I watched Free Tools for Microsoft Access recorded by Crystal Long and Adrian Bell (Microsoft Access MVP’s) on Channel 9. Upon looking at comments below it dawned on me there is no central location for all those great free tools! How is anyone to find them? After all, you may not know they […] 651 total views Probably the hardest part of designing a database is constructing normalized tables. Get them wrong and everything else is down hill… you can’t get the Forms to do what you want and the Reports just don’t work. Let’s see if any of these can make your job easier… Clubs (or Associations) Complaints DVD’s Grocery List […] 593 total views I use Initials in Combo Boxes for space conservation on a Form. I don’t depend on the User to enter them, instead, I enter the below in the After_Update event of the Last Name Control on my Form… Me.txtAssociateInitials = Trim(Left(Me.txtFirstName, 1)) & Trim((" " + Left(Me.txtMiddleInitial, 1))) & Trim((" " + Left(Me.txtLastName, 1))) 1,059 total views Using just… CommandBars.ExecuteMso "MinimizeRibbon" ..fails. Why? Because if the Ribbon is already minimized it will actually maximize. So, you need to check the Ribbon state first… If Not CommandBars.GetPressedMso("MinimizeRibbon") Then CommandBars.ExecuteMso "MinimizeRibbon" End If 766 total views 766 total views Access 2007 and higher… While the 4-Pointer cursor is showing, usually when on the Title Bar, click and hold the mouse key and drag. To return it back to its docked position, double-click the Title Bar. 5,337 total views, 1 views today 5,337 total views, 1 views today There will be times when inherit a database and the Field Names are all in capital letters. You want to convert them to CamelCase but when you try they revert back to all capital letters. Here are two different ways to handle that…1. a. Change the Field Name by adding a letter to the end […] 549 total views You just went grocery shopping and your car is full of groceries. Which is faster? Take bag from car, open door to house, put bag inside house, go back out door closing and locking it behind you, repeat as many times till done OR And, here’s the persistent connection part… Take bag from car, open […] 17,562 total views, 1 views today |
Have an Access... ential you want to share? Drop me a line!
Note, all tips are moderated before posting. |
||||
|
Copyright © 2024 Access… entials - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
