|
||||||
Access MVP (2010-2015) |
You found a piece of code, it says to copy/paste into the Event Procedure of your Control, great! Hmm, now where exactly is that? First, open you Form in Design Mode making sure the Property Sheet is open. Select your Control and on the Property Sheet select the Event tab.
Go copy the […] 1,255 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, 1 views today 1. Create a new database naming it differently then the original. (No worries you can rename it later.) 2. Uncheck Track name AutoCorrect info under File > Options > Current Database, as well as, any other options you don’t want. 3. Go to the External Data tab and select Access under Import. 4. In the […] 641 total views If you do Quotes and Invoicing (or Purchase Orders and Invoicing) they generally share the same layout, the only difference being the Label identifying them. Rather than creating to reports you can change the Label Caption depending on which Form you are opening it from. Step 1 Create the Report and for the Label Caption […] 2,514 total views, 1 views today 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 While developing you may find yourself in the VB Editor adjusting the Function for a Control or the Form itself. When it opens you have to hunt down where the cursor is flashing, even though you have clicked the After_Update event for a specific control. There’s an easier way… When you click the Build button […] 854 total views, 1 views today “The Microsoft Access 2016 Runtime enables you to distribute Access 2016 applications to Users who do not have the full version of Access 2016 installed on their computers.” To download click here… 749 total views 749 total views Recently, I saw a post regarding moving a Query (SQL) to VBA. I remember I saw something somewhere that automated this task but could not remember where. Well, after a little surfing of my favorite sites I found it… Copy SQL statement from query to VBA by Allen Browne. And, because I couldn’t leave well […] 1,806 total views, 1 views today Normally, it’s not an issue if an End User tries to type in more characters than the Control will allow… they just can’t type anymore. BUT, if you are using an UNBOUND Form for data entry this is a big problem, they will not be able to Save and with a not so nice message. […] 1,287 total views |
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 |
||||||
