Newsgroup: it.comp.appl.access
Titolo: form e completamento controlli

salve a tutti...ho una tabella Anagrafe ed una Enti.
la tabella Enti č composta da 3 campi, Descrizione, Indirizzo e Cap...
da una Form faccio la scelta dell'ente tramite (Descrizione) che č una
combo.
ma come faccio a far apparire nei rispettivi controlli anche l'indirizzo
ed il cap, chiaramente in controlli diversi ???
grazie


Casella combinata/di riepilogo - Accesso all'ennesima colonna
www.donkarl.com/it?FAQ4.15
-- 
HTH
Karl
*********
Access FAQ: 
www.donkarl.com/it


1. Quandro crei la combo seleziona tutti i campi (ente, indirizzo e cap) che
ti servono dalla tabella Enti e chiamala ad esempio cboEnti (per dare il
nome alla cbo fai click col destro, scegli Proprietà e scrivi il nome su
"Nome elemento").
2. Crea 2 caselle di testo accanto alla combo. Chiamale ad esempio
txtIndirizzo e txtCap.
3. Vai su Proprietà di txtIndirizzo e alla voce "Origine controllo" scrivi:
=cboEnti.Column(1)
4. Vai su proprietà di txtCap e in "Origine controllo" scrivi :
=cboEnti.Column(2)
L'effetto dovrebbe essere che quando scegli un ente dalla cboEnti, nelle
caselle di testo dovrebbe essere riportato automaticamente il relativo
indirizzo e cap.
In pratica la cboEnti ha tre colonne. La prima è quella del codice, la
seconda quella dell'indirizzo e la terza il cap. La numerazione delle
colonne inizia da zero. Non facciamo altro che visualizzare le tre colonne.
L'unico requisito è che quando crei la combo ti porti dietro tutti i dati
che poi vuoi visualizzare.
Facci sapere se funziona.
Simona

show that prosecutions have taken place of 'sly brothels,'
    competing with the 'regular professed brothels.'
    "It is to be hoped that this Blue-book will, with facts now
    being published in various parts of Europe and in America, draw
    attention to the necessity of a new movement (supplementary to the
    great movement now on foot for the suppression of the 'White Slave
    Trade'), for the suppression of the 'Yellow Slave Trade,' which is
    becoming almost world-wide in character."
As the supply of girls both in Singapore and Hong Kong comes very
largely from Canton, let us first describe the conditions we found
there. Our Journal of February 14th, 1894, reads as follows:
    "We went in company with a missionary and a native, both of
    whom could talk both English and Chinese, and visited some
    'flower-boats' on the river. Many of these boats are quite
    pretentious, with their rich wood-carving, fine furniture,
    and gaudy display of tinsel. There were whole streets of
    them,--floating houses moored together; we walked along the length
    of the street on one side, stepping from the bow of one boat to
    the next, the bows of the boats constituting front verandahs. We
    called at almost every place, but a description of one will do for
    all. First, as we entered, was a couch for opium smoking; just
    beyond this a reception room, very gaudy, with dozens of hanging
    lamps, and at one end a shrine for the gods, and offerings before
    it. In a room back of the reception room, and also upstairs,
    there were girls in large numbers. A hard-featured old woman came
    forward from the back room, who, our interpreter said, was as good
    a specimen as we could possibly have seen of an old brothel-keeper
    of Canton, one who had been in the business for many years of
    buying or otherwise obtainin

of slavery, were not the
Queen's proclamation against slavery, and the many other enactments of
the same sort, enforced? Listen, and we will tell why. These officials
believed _vice was necessary_, and as there was no class of "fallen
women," in our understanding of the term, the Oriental prostitute
being a literal slave, then _slavery was necessary_ when it ministered
to the vices of men. Hence the Government-registered brothels were
filled with women slaves. As to the unregistered brothels, the
"protected woman" protected that, and also the nursery of purchased
and stolen children being brought up and trained for the slave market,
excepting those children which, as we have seen, were being trained in
the registered houses. If an officer attempted to enter the house of
a "protected woman," he was told: "This is not a brothel. This is the
private family residence of Mr. So and So," mentioning the name of
some foreigner. Thus the foreigners who kept Chinese mistresses
furnished, in effect, that protection to slavery that led the Chinese
to go forward so boldly in their business of buying and kidnaping
children. Even when women were brought into court for keeping
unregistered brothels, and although they were keeping them, yet if
they could show that they were "protected women," they had a fair show
of being acquitted.
Legislative enactments directed to the object of making the practice
of vice healthy for men are called, in popular language, "Contagious
Diseases Acts," because that was the first name given them. But of
late years all such laws have met with such bitter opposition, that,
like an old criminal, the measures seek to hide themselves under all
sorts of _aliases_. Mrs. Josephine Butler describes such legislation
in general in the following simple, lucid manner:
    "By this law, policemen,--not the local police, but special
    Government police, in plain cl

under one roof of several different establishments,
    consisting of the pocket-mothers and their purchases, the
    pocket-mothers for the most part being the body-servants of their
    charges, and administering to their daily wants, though in reality
    their mistresses and their absolute owners."
The document scarcely needs comment. It illustrates the fact that one
may have most ideal laws, but laws never operate automatically, and in
the absence of any desire to "let the oppressed go free," but rather
an eager desire to hold them in subjection to the base propensities of
profligate men, as all the State documents representing the situation
tend to show, there is small proof that the "Women and Girls'
Protective Ordinance of 1889" has had any appreciable effect in
altering the slave conditions at Hong Kong. The same old notorious
inspector, John Lee, who, Governor Hennessy thought, ought to have
been prosecuted for manslaughter, after he hounded those native women
to their death, was Chief Inspector of Brothels at Hong Kong in 1894,
when we made investigations in that Colony, and personally interviewed
many of these slave girls, and heard their stories.
The most recent official documents relating to the matter have been
commented upon in _The Shield_ (organ of the British Committee of the
International Purity Federation), in its issue dated London, June,
1906, as follows:
    "One of the most important parliamentary papers of recent years on
    our question has just been issued in response to questions put in
    the House of Commons by Mr. Henry J. Wilson, M.P., on March 8th
    last. The title is, 'Further Correspondence relating to Measures
 

 Simona
--------
ciao Simona... scusa il doppio post... ti ho risposto nell'altro...
Bye