The Challenge One of my clients is using an Access database in a multi-user environment. They had a form that they use on their production floor for scheduling jobs. They wanted to have the form update automatically for the PCs on the production floor to reflect the changes made in the office for scheduling jobs. [...]
Archive for the ‘Forms’ Category
Timer Auto-Refresh Forms
Posted in Forms, VBA Code, tagged forms, timer on May 11, 2010 | Leave a Comment »
Cool new trick – using TempVars
Posted in Datasheet, Forms, TempVars, VBA Code, tagged Datasheet, Form, TempVars, Text box, Unbound, VBA Code on April 22, 2010 | Leave a Comment »
I knew that Access provided an in-session variable array called TempVars and I have used them a few times but never had much need for them. However, a project that I have been working on this past couple of weeks required some creativity. TempVars were just the ticket. You can use TempVars through either macros [...]