Search all of our videos below:
- 1. Using MS Access to fill Word Mail Merge Documents - Feb 2021
When merging information from Access into Word, there are different ways to go about it. Perhaps you have a table in Access with information for a letter and then need to decide which Word template should be used based on what type of letter they should get. Other times, Access may completely generate a document based on data in Access and what needs to be there.
Using MS Access to fill Word Mail Merge Documents
Dale Fye ( dev-soln.com )
19 Feb 2021
Using Word to create and format documents is much easier than trying to format a lot of text on an Access report such as for letters, instruction manuals, and legal documents. Word also makes it easier for the users to control the output since all they need to do is edit a Word document as opposed to giving text they want to see to the application developer, and then waiting for them to set up or change an Access report.
Once a merge document has been created by those who know what it needs to say, merge fields can be used to indicate where information from Access needs to be inserted. Conditionally text can be included based on values in the database. All of this is demonstrated so you can learn how to do it. You can also download the database and supporting files so you can try everything that Dale demonstrates for yourself!
Dale shows you all the steps to become a whiz at using Access to fill Word documents, and the VBA code you need to make that happen from creating the data file for the merge to opening Word, loading documents, merging data, and creating the final document with all the merged information.
- 2. Cascading Combo box in Continuous Form - Jan 2021
The RowSource of a combo box is exactly the same for every record, so if you change it for a record based on values in that record, the RowSource also changes for every other record. So when you look at values in another record, they might appear to be missing when they're still actually there, just not showing.
So how do you get around this? One way is to display a textbox that does have the value on top of the combo box. This gives you a way to overcome the issue of data that doesn't display in a cascading combo box. This will work in a continuous form, but not in a Datasheet since controls can't be stacked on top of each other.
- 3. ADT Find and Replace add-in - Dec 2020
Philipp Stiefel demos his new “Find & Replace” tool that is sold from AccessDevTools (ADT) as a com add-in to run in Microsoft Access. It has some slick features and can save time when to look for and replace information in objects and code.
- 4. Building a Secure Access and SQL Server Solution - Nov 2020
Dive into SQL Server security for the Access Developer and learn how to set up custom database roles, assign security permissions for that role on different objects, and much more. To implement security, you must understand it. Anders has a wonderful way of explaining that compels you to keep listening and learning. Like a story that pulls you in, he illuminates a topic in a way that is interesting even if you don't know much about it, and highly informative for those that do. His explanations are thorough and gradually get deeper. The light comes on.
Although Anders explains setting up permissions for individual users, he stresses the ease to use Windows AD (ActiveDirectory) authentication for a group, which he shows how to do, and that makes both developers and IT happy.
- 5. Crosstab Forms and Reports - Oct 2020
Crosstab Forms and Reports.
- 6. Access Layout Grid - April 2020
Microsoft introduced the layout grid in Access 2007, but without any real promotion from Microsoft it did not get the attention it deserved, and until Access 2010, there couldn't be any empty cells. So come learn what the grid can do for you.
- 7. Integrating Google Maps with Access using .NET - March 2020
Get distance between addresses. Uses VB.NET for flexibility and extensibility to make it easy to incorporate across multiple platforms like Microsoft Access.
- 8. Using IIF() and Tempvars in Cascading Combo boxes - February 2020
February’s meeting was presented by George Hepworth, of Grover Park Consulting. George is an author and long time Access MVP.
- 9. Calendar Maker - January, 2020
presented by Crystal Long
17 January 2020
hosted by Dale Fye
Draw monthly calendars with Microsoft Access using a report and VBA. To make it easy, there is a menu form, but you don't need it to make calendars. There can be a big calendar on a page with one month, or multiple calendars per page showing however many months you want to see.
To draw a calendar on any report, anywhere, whatever size you want, call the CalendarMaker sub, which has parameters for the report object, xy coordinates, width, and height. The report object doesn't need any controls for the calendar, it just needs a page to act as a canvas to draw on. To address any coordinate on the page, the code should be in the Report_Page event.
When each calendar is drawn, the language used for month and day names is controlled by your Windows region settings. Start weeks with any day, like Sunday, Monday, or whatever you like. Show information on days using queries that you design from your database.
- 10. Goodbye, memory errors! - December, 2019
This month’s presenter is Karl Donaubauer, long time Access MVP and organizer of several annual Access conferences in Europe, including an English language version in Vienna, Austria (25/26 Apr 2020).
- 11. VBA Code Quality - November, 2019
- 12. Data replication with Access (part 1) - September, 2019
- 13. Denormalizing Data - March, 2019
- 14. How to add shortcut (right-click) menus to Access applications - February, 2019
- 15. Demonstration on using Power BI with MS Access - December, 2018
- 16. Open Discussion - May, 2018
- 17. Reports - December, 2017
- 18. ListBox Selection - November, 2017