Author: mbarnesatbbs

Peter has generously shared a zip file – webinar28Jan20– that contains 2 databases which provide more detail from his presentation that he thinks will be useful. The db CodeForNormal.accdb has been updated with a form that details how to view tint and shade values. It has code for creating normal form to trigger reuse of […]

Attached is the PDF from the November meeting for your reference.  Also for your reference, this is the Sample Database that we reviewed during the presentation.

Attached is the PDF from the September meeting for your reference.  Also, while we were talking about parts of Access which could use some work, someone brought up the Relationship window.  Here is the link for Stephen Lebans’ tools for the relationship window: http://www.lebans.com/saverelationshipview.htm

Here are links to the slide deck and demo database from our May presentation.  Thank you again to our presenter, Jim Dettman for this interesting presentation!  Please note, if you have difficulty downloading the demo database, you may want to try a different browser.  I was unable to download it in Edge, for example, but works […]

Attached is the PDF from the March meeting for your reference.

Attached is the PDF from the Feb meeting for your reference.  Also note that the video from approximate 16:10 – 21:00 contains updated information about using multi-valued fields as SELECT Criteria that you may want to review even if you attended the meeting.  Finally, a follow up on Deleting values.   DELETE MultiValueAccessList.MultiValuedColumn.Value FROM MultiValueAccessList […]

Attached is the PDF from the Nov meeting for your reference.  

Attached is the PDF from the October meeting for your reference.  If you attended the meeting or are reviewing this after viewing the video, notice that I removed the reference on the second slide to the Properties(“LabelName”).  I was confused, the Access team enabled the entire object model for the new ChartObject from code.  So […]

Attached is the PDF from the September meeting for your reference.  Also note that I incorrectly stated that the Improved Linked Table Manager was available in Office 2019.  In fact that is not the case.  It is only available in Office 365.  It rolled out with the August feature update and should be available for […]

Attached is the PDF from the May meeting for your reference.