So many times I needed to do maintenance on the database then update the frontend but couldn’t because other users had it open. Well, I finally found a fix! Now I can give the users a warning before the database closes on them. Here’s how: Go to this site and download the file. (Scroll down… Continue reading MS Access – Knock Users Out of Database
Using the Firefox browser, press CTR+SHIFT+K to bring up the Developer tools. Click the gear button on the right to bring up the settings. Scroll down until you see “Take a screenshot of the entire page”. Check that box and a camera will show up next to the gear settings icon. When you click this,… Continue reading Print Entire Screen using Firefox
Microsoft Access can’t find the database file….Make sure you entered the correct path and file name.
You have a split database, end users can’t access the database because you’re getting an error message saying Microsoft can’t find the back-end file even though you know it’s in the folder it’s listing! Besides making sure the end users have the proper permissions to the folders, the problem could be that the users do… Continue reading Microsoft Access can’t find the database file….Make sure you entered the correct path and file name.
Flash Fill Recognizes patterns in data and fills out the rest of the fields for you. Look for the Flash Fill button is under the Data Tab in Excel! Fill out the first cell so that Excel will know the pattern it’s looking for (field C1 in the image above or D1 in the second… Continue reading Three Microsoft Excel Tips
I’ve got to give all props to Graham Mayor. His add-on was brilliant and did the job! If you need to have more than one record put on a Word document, based on a field’s value, Graham’s add-on is your solution. If you have several items that need billed to one account, for example, you… Continue reading Microsoft Access – Merge Many-To-One Records to Microsoft Word
How to disable this message: PERSONAL.XLSB is locked for editing Open ‘Read-Only’ or click ‘Notify’ to open read-only and receive notification when the document is no longer in use. In Excel, go to the View tab and choose Unhide in the Ribbon under the Windows group. When the dialog box appears, choose “PERSONAL” and click OK. Go… Continue reading PERSONAL.XLSB is locked for editing
There are many adjustments you can make that can really improve your quality of sleep. Getting up at the same time every day, going to bed around the same time, eating healthy, avoid caffeine, alcohol, nicotine, keep naps short if you take them, exercise, etc. I’m sure one thing you’ve also heard of is to… Continue reading A Setting On Your Phone That Will Help Give You A Better Night Sleep?
