Newsgroup: it.comp.appl.access
Titolo: Controllo di campo vuoto

Buon giorno agli amici del NG,
ho un db di Access 2003 le cui tabelle sono trasferite su Sql Server.
Mi aiutate con una riga di codice che mi permetta di viusalizzare un
messaggio nel momento in cui un campo denominato Codice di una
maschera chiamata frmDocumento viene lasciato vuoto al momento
dell'inserimento dati?
grazie per l'aiuto
Leo


Su evento BeforeUpdate della textbox codice, prova ad inserire:
private sub Codice_exit(cancel as integer)
if isnull(codice) or codice = "" then
   msgbox"Compilare la casella "& 
codice.name
, vbcritical, "Attenzione...."
   cancel = true
end if
end sub
-- 
Ciao
Geppo 

 Su evento BeforeUpdate della textbox codice, prova ad inserire:
...su evento "Exit" della textbox 


problema risolto brillantemente
grazie Geppo

every
time she comes into court, but will be kept in deserved obscurity, and
the woman will be tried for a _single_ offense, just as the man is
tried, and not for all the offenses and indiscretions of a life-time.
The penalty for such wrong doing may not be placed at even so high a
figure in the Statute Book as it now stands, while accounted a civil
injury, but the dignity of the trial would give serious lessons
in virtue to the youth. No nation can long exist that does not
incessantly discourage the practice of every sort of offense against
the sanctity of the marriage relation.
But after all, there will be no success in attempting to cope with
Oriental prostitution by means of laws against prostitution and
kindred vices, for the reason that the evil is a far graver one than
this. Innocent children are reared for vice, and at a certain age
thrust into the life through no choice of theirs; and not infrequently
perfectly respectable women of mature years are kidnaped for the vile
service. The effect upon the moral character of a man who resorts to
a _slave_ class of victims to his evil propensities, must be to make
that man a menace to society wherever he goes, through deeds of
violence which he is willing to commit, and accustomed to commit, of
the worst imaginable sort.
And an attack upon the slave _traffic_ alone will never prove
adequate. The history of our country's dealing with negro sla

anything to do with the control or supervision of
brothels under the Ordinance, being apart from the general objects
of police duties, and from the great probability of its leading to
corruption." Let this be told to Mr. May's lasting credit. Whereupon,
on the Registrar General's application, the office of Inspector of
Brothels was created.
We have referred several times to a certain Commission which was
appointed to inquire into the working of the Contagious Diseases
Ordinances of Hong Kong. This Commission was appointed by Governor
Hennessy on November 12th, 1877, and was composed of William Keswick,
unofficial member of the Legislative Council, Thomas Child Hallyer,
Esq., "one of Her Majesty's Counsel for the Colony," and Ernest John
Eitel, M.A., Ph.D., Chinese Interpreter to the Governor. We shall have
frequent cause to quote from this Commission's report, and as it is
the only Commission we shall quote, we shall henceforth speak of it
merely as "the Commission." This report says, concerning inspectors of
brothels: "These posts, although fairly lucrative, do not seem to be
coveted by men of very high class." For instance, we find in a report
dated December 11, 1873, by the captain superintendent of police, Mr.
Dean, and the acting Registrar General, Mr. Tonnochy, that they were
not prepared to recommend anyone for an appointment to a vacancy which
had just occurred, owing to the reluctance of the police inspectors to
accept "the office of Inspector of Brothels." Mr. Creagh says, that
the post is not one "which any of our inspectors would take. They look
down on the post." "They are a class very inferior to those who
would be inspectors with us. I don't believe anyone wis

that he had sold the child." The Governor
concludes: "I did not agree with his view of the law."
The last case was referred back to the Acting Police Magistrate to
know why the woman, Leung A-Luk, was allowed to go unprosecuted. The
Police Magistrate replied: "It appeared to me that 4th defendant
(Leung A-Luk) being a well-to-do woman, and having no children of her
own, had purchased the girl with a view to adopting her." He adds:
"When Acting Superintendent of Police last year, I wished to prosecute
a man for detaining a child ... but as it was shown that the boy had
been sold by his father some months previously, the Attorney General
considered the purchaser was _in loco parentis_, [in the place of a
parent] and could not be purchased."
On the two cases to which the attention of the Governor had been
brought, the Attorney General reported:
    "With the greatest respect for the Chief Justice, I doubt the
    policy of prosecuting the woman he refers to, having regard to the
    fact that the magistrate had dischar

of slavery, replied to the Governor
    "With regard to Sir John Smale's observation, I know that
    difficulties national, social, official and financial beset the
    Government in reference to the special questions I have raised,
    I have only to observe that I have never heard of those
    difficulties. My own impression is that the respectable parts
    of the community, Chinese as well as European, including the
    Government and the police, are fully alive to the brothel and
    domestic servitude systems, and as well informed as Sir John Smale
    himself as to the real facts. One would suppose from the tone
    of his pamphlet that he stood alone in his perception and
    denunciation of evil. But I believe the fact is that the Executive
    and the community generally are quite as anxious is he is to
    insist upon practical precautions necessary to prevent the abuses,
    and to diminish the evils naturally connected with these systems,
    but they look for this to practical securities and not to
    declamation. The obvious line of practical suggestions to take is
    that of careful registration and constant inspection of brothels,
    so that full and frequent opportunity may be given to all persons
    whose freedom may be open to suspicion t