Debug

[gio25]

Hi



I have made a database with forms, I have one form that the users enters a id and it present the users info. however if a user enters some crazy carcters or something that I don't know, the program present the error window the the end and debug buttons, if the users press the debug button it takes him to the code in VBA, my problem is that if the VBA editor opens the users start to type anything and the make things even worse. My question is there any way to prevent the users from accessing the VBA editor like block the debug button or block the error window at all? and there is a way to create some kind of log so I can see later what was the error?

[jgelpi16]

Error trapping may be a good idea. If you create a button using the dreaded wizard and then go into the event procedure you'll see an example of error trapping. For this scenario you may want to do a lookup in your user table prior to allowing the users entry. A simple DLookup() would do it. (http://techonthenet.com/access/funct...in/dlookup.php). If the DLookup() returns a null value the user has entered an invalid User ID. Tell them they have done so by a simple "IF" statement and then exit the sub prior to executing the rest of the code.