If you have two unbound text boxes on a form, and the likely scenario is for a Date Range for Report Criteria, you may want to warn the user when the End Date is before the Start Date but get the wrong result. In this application we are using the date format dd/mm/yyyy as set… Read More »
To change the default properties for controls in forms and reports using VBA you can use the code below. For example, if you decide to change the default font or font size in your application, rather than manually opening each form and changing the defaults you can loop throught the AllForms collection, open each form… Read More »
Developing applicaitons requires a bit of thought, and experience. Here is one scenario and the solution. This sample application looks at how to allocate Items (Fixtures and Fittings) into the Rooms of a soon to be constructed Hotel. The intent being to compile purchase orders, and eventually distribute the physical items to their intended locations.… Read More »
If you add, or edit, records in a Form then any Combo or List box based on that form’s Datasource is no longer up to date. I’ve seen many attempts to handle this and most are very clunky, others difficult to maintain. What we should be doing is requerying all the Lists in our Application when,… Read More »