Newsgroup: it.comp.appl.access
Titolo: correlare 2 tabelle... mi spiego

ciao a tutti...
non conosco access ma vorrei crearmi un piccolo db per agevolare il mio 
lavoro....
quindi vorrei chiedervi un aiuto su come fare avendo una tabella ENTI in 
cui vi è il campo
descrizione (combo)-(già popolata con 250 Enti), indirizzo e Cap.
ed una Tabella ANAGRAFE in cui vi è il campo Cognome, Nome, data visita, 
ed un campo APERTO si/no
ed un CHIUSO si/no.
il primo problema che vorrei risolvere e che quando inseriso l'Ente 
compaia ina automatico anche l'indirizzo ed il Cap e questo ora non 
avviene...
per altri problemi posterei in seguito...
grazie e ciao

 ha scritto nel messaggio 
news:v71lj.223628$%k.35...@twister2.libero.it...

Scusa, non si capisce. Inserisci dove? in una combobox di un form o ......?
Simona 

 ......?
---------
grazie Simona per avermi risposto... e scusa se non sono riuscito a 
spiegarmi...
in sostanza ho una tabella Anagrafica ed una Enti, poi ho creato 
automaticamente una Form e vorrei
che alla scelta dell'ente (cmb in maschera) si porti dietro anche 
l'indirizzo ed il cap presente in tabella Enti...
per ora questo è il problema...
Ciao

Scusate, nel mesaggio precedente č finita anche la funzione Dlookup che non 
c'entra niente con il problema di GM
Simona 

 ha scritto nel messaggio 
news:4797a668$0$17945$4faf...@reader1.news.tin.it...


as these have acquired a foothold in the United States
more than once, but have been driven out again. They are proposed
every year almost, at some State Legislature, and often have been
proposed at several different legislatures during a single year. They
are in operation, to some extent at least, under the United States
flag at Hawaii, in the Philippines, and at Porto Rico. The enforcement
of the Acts must depend to a large extent upon the co-operation of the
male fornicator with the police and officers of the law, and places
good women and girls terribly in the power of malicious or designing
libertines.
It appears from official records, that in Hong Kong, during six months
in 1886-7, out of 139 women denounced by British soldiers and sailors
as having communicated contagion, 102 were on examination found free
from disease, and only 37 to be diseased; and during a similar
period in 1887-8, out of 103 women that were denounced, 101 were on
examination found free from disease and only two diseased. We can
judge 

her face and neck were covered with blood. She was moving as
if in great pain. I sent for the ambulance at once, and by this time
the whole street was aroused." The two women, Tai Yau and the old
servant, had fallen through a smoke-hole in the roof.
Tai Yau had a fractured jaw and left thigh, besides internal injuries.
She lived but ten days. The verdict rendered in each of these cases
was nearly the same. That of Tai Yau's calamity reads in part:
    "Mok Tai-Yau, on the morning of the 17th of October, in the year
    aforesaid, being on the roof of a house, known as 44, Peel Street,
    Victoria, and having fled there in consequence of the entry of an
    Inspector of Brothels into the house known as 42, Peel Street,
    where she lived, accidentally and by misfortune fell down an open
    area, known as a smoke-hole, unto the granite pavement beneath,
    and by means thereof did receive mortal bruises, fractures and
    contusions, of which she died.... The jury aforesaid are further
    of opinion that Inspector Lee, the aforesaid Inspector of
    Brothels, exceeded his powers by entering the house, No. 42,
    Peel 

It is a long one which presents itself to everyone who has studied
    the slavery and the slave-trade question. Besides this long
    argumentative answer, one question must be answered:--Is it right
    to do or sanction wrong that good may come?"
    "A very long time has elapsed since I received your letter
    forwarding that dispatch [containing the request of the Secretary
    of State for the Chief Justice to state his views as to Dr.
    Eitel's representations], in June last; but the delay has been
    advantageous, as it has enabled me to obtain a memorandum on the
    subject by Mr. Francis, barrister here, and for a year Acting
    Puisne Judge ... I write on this subject from an experience in
    Hong Kong since early in 1861; Mr. Francis from a very extensive
    experience in both China proper and in this Colony since some
    years previously." He then enters into history to show that "Mr.
    Francis of necessity studied ... the whole law on the subject of
    slavery or bondage in every form here."
Mr. Francis first reviews all the legislative measures existent at
Hong Kong concerning slavery, in the clearest manner possible, leaving
no doubts in the mind of any fair-minded person that laws were not
wanting to put down slavery:
    First: Hong Kong, being a Crown Colony, "the power of the
    Sovereign in respect of legislation is absolute."
    Second: The proclamation of Sir Charles Elliott, of tolerance
    of native customs was "pending Her Majesty's pleasure," and no
    longer.
    Third: Her Majesty's pleasure was declared at Hong Kong: (a) By
    the Proclamation of 1845; (b) "By Ordinance 6 of 1845, 2 of 1846,
    and 12 of 1873, by the combined operation of which the law of

inmate, and visit our private
    hospitals daily.' Here, again, it may be asked what are the
    precise relations of the acting Colonial surgeon to 'our private
    hospitals?' It is satisfactory to know that inquiries are being
    made by our Parliamentary friends in regard to this peculiar, if
    not suspicious, circumstance.
    "Mr. Chamberlain, with all the foregoing facts before his eyes,
    says on page 21: 'I am glad to find that the Protector of Chinese
    and the acting Colonial surgeon have, so far, been able to give
    such a satisfactory report of the working of the ordinance.'
    "At Hong Kong, 'the keepers of Chinese and Japanese brothels
    frequented by Europeans have retained private practitioners as
    their medical advisers, and a small private lock-hospital has been
    instituted for Japanese women.' This followed on 33 prosecutions
    instituted by the police in respect of 89 complaints made by
    soldiers and sailors of the British forces. Page 35 and elsewhere
    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 Februar

and in the
interests of justice," according to the Commission's report, sinned
with a child of fifteen in order to get her name on the register.
Inspector Horton bargained for the deflowering of a virgin of 15, "in
the interests of justice," with the owner of the slave child. The
child as well as the owner were then taken to the Lock Hospital, where
the latter was proved to be a virgin. A Chinese informer consorted
with a girl named Tai-Yau "against her will, which led to his being
rewarded, and to her being fined one hundred dollars." She was unable
to pay the fine, and sold her little boy in part payment for it, in
order to escape a life of prostitution.
But need we go into further painful details? There are hundreds more
of such cases of cruel wrong on record, and God alone knows how many
thousands of cases there are that have never been put on record. We
only aim to give a case here and there in illustration of the many
forms of cruelty practiced upon innocent women in order to force them
into prostitution, and to demonstrate that brothel slavery at Hong
Kong cannot truthfully be represented as the outcome of Chinese
customs which foreign officials have found difficulty in altering.
But why should Americans be called upon to acquaint themselves with
such loathsome details? In order that Americans may have some just
conception of their duty toward the large number of these poor,
unhappy slaves who have been brought from Hong Kong to their own
country.
CHAPTER 5.
HOUNDED TO DEATH.
Sir John Pope Hennessy went to Hong Kong as Governor of the Colony in
the early Spring of 1877. In the following October a tragedy occurred,
which drew his attention to the administration of the Registrar
General, and he set himself to the task of trying to right some of the
wrongs of the Chinese women.
The case last mentioned in the pre

 Simona
--------------
ciao Simona... fatto esattamente quanto dici ma purtroppo nei controlli
Indirizzo e Cap esce #Nome?
come mai ???
Ciao 

 ha scritto nel messaggio 
news:%HZlj.232829$U01.1...@twister1.libero.it...


 non so se sono stata chiara,
-------------
ciao... sei stata chiarissima... cmq io facevo anche io la creazione 
guidata
e mi procurava l'errore detto...
e cmq la cmb funziona solo per la descrizione ente... e vedo tutte e 3 
le colonne
nella combo... č normale ??
Ciao 

 ha scritto nel messaggio 
news:4798ab49$0$37200$4faf...@reader3.news.tin.it...


 e mi procurava l'errore detto...
Perché nella casella di testo non fai riferimento al nome giusto della 
combo. Quando fai la creazione guidata di controlli sul form lui dà dei nome 
standard. Ad esempio se è la prima casella combinata gli dà il nome 
CasellaCombinata0, se è la seconda la chiama CasellaCombinata1, ecc. Così 
con tutti gli altri controlli che metti sulla maschera: la prima casella di 
testo la chiama Testo1, poi Testo2, ecc.
Quando nella casella di testo vuoi visualizzare qualcosa che è in una 
colonna della casella combinata devi usare la seguente sintassi in Origine 
controllo: =NomeCasellaCombinata.column(colonna da visualizzare)
Se era la prima casella combinata e lasci il nome che gli dà lui, nelle due 
caselle di testo dovresti scrivere =CasellaCombinata0.column(1)
=CasellaCombinata0.column(2)
Io personalmente preferisco dare nomi più significativi ai controlli sulle 
maschere.
Per vedere i nomi e per cambiarli fai click con il pulsante dx sul controllo 
(ad es. sulla combo) e guarda "Nome elemento".
Simona 

 Simona
---------------------->
non ci crederete ho provato molte volte ma non funziona...
andiamo nel dettaglio..
la tabella si chiama ENTI
in maschera ho creato la combo includendo i 3 campi della tabella ENTI
ossia descrizione_ente  --- indirizzo  - Cap
nome elemento della combo = CBOENTE
nome elemento della casella di testo = testo1  (Indirizzo)
nome elemento della casella di testo = testo2  ( CAP)
origine controllo di Testo1 ==[CBOENTE].Column(1)
origine controllo di Testo2 ==[CBOENTE].Column(2)
il risultato è che ora nel controllo Testo1 visualizzo la descrizione 
ente
come nella combo
è inspiegabile ??
Ciao e grazie della pazienza...


Allora prova con:
origine controllo di Testo1 ==[CBOENTE].Column(2)
origine controllo di Testo2 ==[CBOENTE].Column(3)
Un po' d'impegno :-)
-- 
Ciao
Geppo

 Un po' d'impegno :-)
--------
scusa Geppo... anche se non lo avevo scritto avevo già provato...
i controlli facendo questa modifica non producono niente...
porco diavolo... dove sbaglio ???


Dunque riepilogando:
proprietà casella combinata:
Tipo Origine Riga: Tabella/query
Origine riga: Select enti.descrizione_ente, enti.indirizzo, enti.cap from 
enti order by enti.descrizioni
Numero Colonne = 2
Colonna Associata= 1
Proprietà text1:
Origine controllo = =CasellaCombinata.column(1)
Proprietà text2:
origine Controllo = =CasellaCombinata(2)
-- 
Ciao
Geppo 

 Tipo Origine Riga: Tabella/query
Ok...entrando in dettaglio io ho nella combo:
Origine Riga =SELECT ENTI.id, ENTI.Descrizione_ENTE FROM ENTI ORDER BY 
[Descrizione_ENTE];
Nome elemento = CBOENTE
Origine Controllo = Descrizione_Ente
mentre in casella Testo1
Nome elemento = testo1
Origine controllo=CBOENTE.Column(1)
e la stessa cosa in Testo2  solo che vi è
CBOENTE.Column(2)
ho provato a variare ma senza successo...
---
ho quasi quasi l'intenzione di mollare...
Ciao

 Ciao
No, non devi mollare perchè' poi ti rendi conto che in realta' è solo una 
sciocchezza, poi diventa tutto piu' facile.
-- 
Ciao
Geppo 

 una sciocchezza, poi diventa tutto piu' facile.
-------------
hai ragione in effetti l'errore stava nel non aver immesso le tre
colonne..
ora tutto ok....ma ho un altro dubbio... è normale che nella combo
descrizione_enti mi compaiono tutte le colonne ???
Ciao e grazie


Se non vuoi vedere le tre colonne basta inserire rispettivamente nella 
proprietà della combo "Larghezza Colonne"
0 cm; 0 cm; 2 cm
ad esempio cosi vedi solo la terza colonna
-- 
Ciao
Geppo

 ad esempio cosi vedi solo la terza colonna
---------------
ok... ti ringrazio dell'aiuto...
Ciao