Newsgroup: it.comp.appl.access
Titolo: maschera su tabella

Posso 'istruire' una maschera, in apertura, a prendere solo i record di 
una tabella che hanno un campo vuoto?
Ho provato, nelle proprieta' della maschera, a scrivere (Proprietà, 
Filtro) la seguente cosa
[nomecampo]=IsNull
ma - come immaginavo - nulla è successo.


prova con:
isnull([nometuocampo])
-- 
Ciao
Geppo 

geppo ha scritto:

Non funziona, nel senso che mi da' sempre tutti i record.

 Non funziona, nel senso che mi da' sempre tutti i record.
ma la proprietą della form "Consenti filtri" č impostata a SI?
-- 
Ciao
Geppo 

 
Si, ho provato anche a togliere e rimettere le parentesi (sia mai...) ma 
non funzia.
Mi sa che non è la strada giusta...
M.

 M.
Allora:
Nometuocampo=isnull(nometuocamo)
mo adda funziona
-- 
Ciao
Geppo 

 
No, non ne vuole sapere.
Vabe'...


allora prova ad usare l'evento load della form:
private sub form_load()
filter = "NometuoCampo= isnull(NomeTuoCampo)"
filteron = true
end sub
Se anche cosi non va, allora c'è qualcosa che non hai detto.
-- 
Ciao
Geppo 

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 the foreigner, and
the rearing of them for that object. The "protected women," being of
the Tanka tribe, were well situated for this purpose, for they had
many relations of kindred and friendship all up and down the Canton
river, and the business of the preparation of slave girls for the
foreigners and for foreign markets (as the trade expanded) gradually
extended backwards up the Canton river, until many of its boats were
almost given over to it. "Flower-boats" were probably never unknown to
this river, but, besides their use as brothels, they became stocked
with little girls under training for vice, under the incitement of an
ever-growing slave trade. These little girls were bought, stolen or
enticed from the mainland by these rive

that Chinese immigration has increased 50 per cent in the last ten
    years is looked upon as an unmitigated blessing. The magnitude of
    the Singapore labour trade will be understood when it is known
    that the number of Chinese who came to this port last year, either
    as genuine immigrants or for transshipment to other ports, was
    122,029, which is actually more than the entire Chinese population
    of the town. In connection with the immigration of this multitude
    of men and women, speaking many dialects of a language which is
    wholly unknown to the officials of the British Government in the
    Straits, with the exception of perhaps half a dozen persons, it
    cannot be wondered at that many abuses arise, and the suspicion
    has gained ground and is frequently given expression to, in the
    public press and elsewhere, that many of the immigrants do not
    come to Singapore of their free will. Moreover, it cannot be
    denied that the circumstances under which the Chinese come to
    Singapore and are forwarded to their destination lend colour to
    this suspicion, so that it may fairly be inquired whether the
    efforts made by the Government of the Straits Settlements to
    control the Chinese coolie traffic and to prevent a secret form
    of slavery have been attended with any success, or are at all
    adequate to the requirements of the case.
    The Annual Report for the year 1892 on the Chinese Protectorate in
    the Straits Settlements which is the department charged with the
    control of immigration, was published on the 5th of May, 1893, and
    states that of the 122,029 Chinese deck passengers who arrived in
    Singapore from China during the year, 111,164 were males, 6,867
    women and 3,998 children. The circumstances under which the men
    and the women are brought to Singapore are in many respects the
    same, but inasmuch as a large

and what became of those who did not answer to the exceptional test,
and yet were as pure as the rest? They would everyone of them be
consigned to the fate of a brothel slave.
One informer, "with the assistance of public money, 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 

geppo ha scritto:

Adesso va fin troppo! Mi appare una maschera completamente binaca, vuota 
da ogni singolo dato.
Bo, se vuoi/puoi ti mando un pezzettino del db in mail privata - se me 
la giri all'indirizzo che vedi - e son curioso di vedere se si riesce!!
M.

 M.
-- 
ac
y-1=x

 la giri all'indirizzo che vedi -
fatto
-- 
Ciao
Geppo 

> la giri all'indirizzo che vedi - e son curioso di vedere se si riesce!!
P.S. Mi raccomando un pezzetto solo e piccolo. Geppo sta  a dieta gli 
potrebbe far male  ;<)
-- 
ac
y-1=x