https://marcushall.net/dokuwiki/ 2026-05-31T12:23:42+00:00 https://marcushall.net/dokuwiki/ https://marcushall.net/dokuwiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2023-10-15T23:06:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://marcushall.net/dokuwiki/doku.php?id=software:access:accessexamples&rev=1697411206&do=diff Examples Example Code Execute SQL (ADO) <http://www.classanytime.com/mis333k/sjdaoadorecordsets.html#tof> Dim MySQL as String MySQL = “UPDATE tblPeople SET IsSelected = Yes;” CurrentProject.Connection.Execute MySQL ' Some examples of SQL statements (also see DAO above) CurrentProject.Connection.Execute “UPDATE tblPeople SET IsSelected = Yes; text/html 2023-10-15T23:06:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://marcushall.net/dokuwiki/doku.php?id=software:access:accessinformation&rev=1697411207&do=diff order-of-events-for-database-objects <http://office.microsoft.com/en-us/access-help/order-of-events-for-database-objects-HP005186761.aspx> Knowing when events occur and in what order they occur is important Open Switchboard Fullscreen <http://www.techonthenet.com/access/switchboard/maximize.php> To maximize the Switchboard, open the Form called Switchboard in Design View. Select the property called “On Load