Newsgroup: it.comp.appl.access
Titolo: POSTARE FUNZIONE IN CAMPO MASCHERA PER RICHIAMARE

Salve a tutti,
sto impazzendo per creare questo tipo di funzione, spero di spiegarmi 
decentemente:
Sto provando a creare un REGISTRO PER LE FATTURE VENDITA E ACQUISTO PER IL 
RIEPILOGO TRIMESTRALE DELL'IVA
nella tabella A ci sono 2 campi CODICE IVA e ALIQUOTA
nella tabella B nel campo COD IVA con la ricerca guidata visualizzo i campi 
della tabella A in 2 colonne per visualizzare però solo il valore del CODICE 
IVA
dalla tabella B ho creato una maschera e nel campo ALIQUOTA inserire una 
funzione che mi recuperi il valore corrispondente alla RIGA in base alla 
selezione fatta nel campo COD IVA
vi faccio un es:
se nel campo COD IVA inserico, scegliendo dall'elenco, ART 15, essendo la 
sua aliquota corrispondente 15, il valore 15 vorrei si inserisse in 
automatico nel campo ALIQUOTA
In pratica vorrei succedesse un po' quello che fa la STAMPA UNIONE che 
dandole un valore, compila tutti gli altri campi in automatico...
Spero tanto potesse aiutarmi, anche se questo volesse dire stravolgere un 
poco la struttura del mio databse che magari è errata per quello che mi 
occorre.
Grazie in anticipo
-- 
Giorgia

 ha scritto nel messaggio 
news:47977503$0$36440$4faf...@reader5.news.tin.it...

Forse non ho ben capito...
su click dell'elenco
Me. Aliquota = me.elenco.column(1)
dove 1 o 2 o n è il numero di colonna che contiene il valore partendo e 
contando le colonne da zero
Se l'elenco contiene Articolo e CodiceIva e a te interessa inserire il 
CodIva nel campo Aliquota, scriverai:
Me.Aliquota = Me.TuoNomeElenco.Column(1)
Ciao, Carlo 

 ha scritto nel messaggio 
news:47977503$0$36440$4faf...@reader5.news.tin.it...

Spero di non essermi perso ma se non ho capito male ti basta nel campo COD 
IVA inserire come origine i campi della tabella A.
A questo punto sull'evento "dopo aggiornamento" mandi i valori delle colonne 
nei rispettivi campi es.
Me.ALIQUOTA = Me.CODIVA.column (1) 'essendo rispettivamente i campi della 
casella combinata CODICE IVA e ALIQUOTA
Ciao
-- 
Roberto da Parma

 ha scritto nel messaggio 
news:fn7ua5$80l$1...@tdi.cu.mi.it...


she must end her life. Would the Mission try to save this
    poor girl? We gladly promised what help we could give, and our
    visitor left as quickly and mysteriously as he came, only leaving
    for our guidance a roughly sketched diagram of alley and house
    where the little captive could be found. There followed much
    planning and plotting. Our staunch friend, Sergeant Ross of the
    Chinatown squad, was summoned and consulted. The place was a
    difficult one to reach, but at last satisfactory plans were made,
    the day and hour set. There were three officers and three Chinese
    girls from the Mission. It was a good-sized rescue party and
    divided into three companies, we guarded well the three exits from
    the low-roofed house on Spofford alley. With Sergeant Ross leading
    and our courageous young interpreter at our side, we stealthily
    ascended the dark, narrow stairs to the second floor, where a
    heavy door barred the way, but for such obstacles our good officer
    was prepared. A few blows of his strong hammer made bolts and bars
    yield. We passed through into a small dark passage. From there
    could be heard on all sides sounds of excitement; light feet
    running hither and thither to places of escape, only to be turned
    back by the sight of our guards, who stood on watch. As we
    cautiously felt our way further in we were met by the baffled and
    angry keeper of the den--a woman, but not worthy the name. She
    fiercely demanded our business--there was no need to tell it,
    for she knew as well as we; but she wished to find some means of
    hindering 

year had elapsed before a dispatch was returned
from the Home Government disallowing the Ordinance as superfluous,
slavery being already forbidden, and slave-dealing indictable by law.
On the same day, January 24th, 1845, the following proclamation was
made: "Whereas, the Acts of the British Parliament for the abolition
of the slave trade, and for the abolition of slavery, extend by their
own proper force and authority to Hong Kong: This is to apprise all
persons of the same, and to give notice that these Acts will be
enforced by all Her Majesty's officers, civil and military, within
this Colony."
The "foreigners," by which name, according to a custom which prevails
to this day in the East, we shall call persons of British, European or
American birth,--called a native mistress a "protected woman," and her
"protector" set her up in an establishment by herself, apart from
his abode, and here children were born to the foreigner, some to be
educated in missionary schools and elsewhere by their illegitimate
fathers and afterwards become useful men and women, but probably the
majority, more neglected, to become useless and profligate,--if girls,
mistresses to foreigners, or, as the large number of half-castes in
the immoral houses at Hong Kong at the present time demonstrates, to
fall to the lowest depths of degradation.
These "protected women," enriched beyond anything they had even known
before the foreigner came to that part of the world, with the usual
thrift of the Chinese temperament, sought for a way to invest their
earnings, and quite naturally, could think of nothing so profitable
as securing women and girls to meet the demands of the foreigners.
Marriage having always been, to the Oriental mind, scarcely anything
beyond the mere trade in the persons of women, it was but a step from
that attitude of mind to the selling of girls to

would secure an accomplice, called an
informer, or often more than one. The accomplice would enter a native
house plentifully supplied with marked money out of the Secret Service
Fund. This accomplice was often a friend or relative of the family he
called upon. He would often offer them a feast and drinks, and send
to a near-by restaurant and procure them at Government expense. After
feasting and drinking, he would try to induce some woman of the house
to consort with him, showing her a sufficient sum of money to fairly
dazzle her eyes. This he could well afford to do, for the Government
put the money in his hands to offer, and if the woman accepted, it
would not be a loss to the Government, for it would be taken back
again afterwards. Perhaps some poor half-starved creature would yield
to the tempter; perhaps some heathen man would press his wife to
accept the offer, in his greed for the money; perhaps some foolish
young girl would think she had suddenly come into great fortune in
having a man of such great wealth proposing marriage to her. It must
not be forgotten that the poorest people in China often marry in
a manner which is _almost devoid of all ceremony_, and yet it is
considered perfectly right and honorable, and the couple remain
faithful to each other afterwards. It is not unlikely, then, a young
woman might, with the consent of her parents, look upon such a
proposal as this as about to eventuate in real marriage, if it were so
put before her. No such thing as courting ever takes place in China,
previous to marriage. In other cases, doubtless, the informer who had
thus intruded himself for the basest reasons into a native house,
might really find a woman of loose character there. It were certainly
more to the credit of such a woman that she was in hiding, and
preferred it to flaunting her shame in a licensed house of infamy.
What business have Governments hounding down these women, tearing away
their last shred of decency and obliging them if i

to you that this law is not for simple healing, as Christ
    would have us to heal, caring for all, whatever their character
    or whatever their disease. This law is invented to _provide
    beforehand_ that men may be able to sin without bodily injury (if
    that were possible, which it is not). If a burglar, who had broken
    into my house and stolen my goods, were to fall and be hurt, I
    would be glad to get him into a hospital and have him nursed and
    cured; but I would not put a ladder up against my window at night
    and leave the windows open in order that he might steal my goods
    without danger of breaking his neck.
    "You will see clearly, also, the cowardliness and unmanliness of
    this law, inasmuch as it sacrifices women to men, the weak to the
    strong; that it deprives the woman of all that she has in life, of
    liberty, character, law, even of life itself (for it is a process
    of slow murder to which she is subjected), for the supposed
    benefit of men who are mean enough to avail themselves of this
    provision of lust.
    "Besides being grossly unjust, as between men and women, this law
    is a piece of class legislation of an extreme kind. The position
    and wealth of men of the upper classes place the women belonging
    to them above any chance of being accused of prostitution. Ladies
    who ride in carriages through the street at night are in no danger
    of being molested. But what about working women? what about the
    daughters, sisters and wives of working men, out, it may be, on
    an errand of mercy at night? and what, most of all, of that girl
    whose father, mother, friends are dead or far away, who is
    struggling hard, in a hard world, to live uprightly and justly
    by the work of her own hands,--is she in no danger of this law?
    Lonely and friendless, and poor, is she in no danger of a false
    accusation from malice or from error? especially since under t