Maximizing Connectivity & Productivity

Archive for June 2012

MS Access – Validate controls on form

Use this code on the BeforeUpdate event. Name your controls so that the user will know which box they must complete. For each ctl in frm.controls If isnull(ctl.value) then Msgbox “Please enter ” & ctl.Name ctl.Name.Setfocus Cancel=true Exit Sub End if Next If there is any control […]

Read more

Access 2010 Error – MS Access not working

Whenever there is a code error, no matter how small – you may not be given a chance to correct it if you switch to another form or move to another object. MS Access 2010 abruptly pops up a box with the error MS Access Not Working […]

Read more
Page 2 of 212
Mississauga, ON, Canada 905.607.3500