Making bookings for the Chelmer Leisure database, via a 'diary day page'įorm.
Protection (Access simple method setting-up your own login table accessingĪccess Objects (Database and Recordset Objects various methods Īdding to a combo box at run-time creating own Domain Aggregate Functions).ĭeleting records (data maintenance) via a form, using event code behindĬommand buttons, or using labels to look like hyperlinks. Getting Started with VBA latest entry 4th August 2008, section 7.6.2.įurther VBA latest entry 4th August 2008, section 1. The original version will give a 'missing or broken reference' error -Ĭovered are summarised in the table below.Ĭlick on these links for details of additions, error Leisure with tables, data and three forms. Pages useful for some of the differences between the old and new versions of You may find the information on the Using Access 2007
The previous versions, plus exercises and suggested test plans, and have both been upgraded to Access 2002įrom Access 97 (and DMU now has Access 2003, but all code appears to work justĪccess 2007 or Access 2010. These have more detailed explanations and increased content from Electronic copies are now available as PDFįiles, following a request from a student, so that students who have left,Īre on placement or have simply lost their copy of the Trainer can access theīoth Trainers are now (August 2005) available from the Student Advice Students at Associate College Centres should enquire of their At DMU Leicester these are available from theĪdvice Centre. These were written due to an apparent lack of textbooks taking a 'problem solving' approach to database programming. Project Supervisor or your Visiting Tutor for help and advice. Technical problems during these activities then you should turn to your That I am no longer able to provide one-to-one help for Project or Placement
Students using MS Access and VBA for Project work or on Placements.
That use MS Access and VBA as the implementation and programming software, and to Various things that may be of interest and help to students studying on modules This page is an attempt to bring together Comments, errors that you have found here, ideas for new items, etc.