Tag Archives: MS Access

Conditional Formatting – Incorrect Date Comparison of Unbound Date Controls

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 »

Record Selecting in Multi User Applications

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 »