First my code:
do while not rsadd.EOF
on error goto errh:
My problem is this:
the name & surname fields are a unique index on my SQL server table. If that get violated the routine must just go on to the next record.
The first time the error occurs the errorhandler gets invoked, but not again after that. The second time it is a fatal runtime error? Why?
The reason it only works once is that, technically, you're misusing "On Error". On Errror is intended to handle programmatic errors, not to control the flow of the program. When an error occurs, control
Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!
This Article will show you how to validate number with TEdit control,
What's the TEdit control?
TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text.
While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC. I didn't post completely correct code o…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…