i have got a problem. iam having forms which has 70 controls like txtbx,combo,etc..while saving data i have to write validation code for all the controls which is tiresome..
so i decided to a function in which i loop through each and every control and if i found empty i will genrate a msg that a box is empty.. the function i working
public function empty(frm as form)as boolean
dim ctrl as control
for each ctrl in frm
if type of ctrl is text box and ctrl.text="" then
msgbox" txt box empty"
but the problem is iam having so much controls i want the focus to set the control to help the end user
after genrating the msg. so i want to return control name or some method by which i can set focus to it
so please help me out. iam counting alot on your expertness than you you do on yours
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library. This article will introduce you to the SC library a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…