M
Martin
Here, I want to express my most grateful thanks to you, especially to
Mr.Douglas J. Steele , Mr. John Wison , Sir Ofer and those who are helping
people round here.
I have spend a whole day thinking about this problem, ask many "specialist"
and post in a lot of bbs. Yet, it really a tough problem. And I am really
sorry about my posting many pieces of same kind questions in this newsgroup,
so so sorry
Without your help, I am hopeless to work this problem out! You guys are
warm-hearted, very kind persons. Especially, Mr. Douglas wrote me a lot of
valuable informations, through these informations I finally find out a great
way to solve the problem. Look through the things you and you and you wrote
me today, I am quite moved.
If, in the future, I grow up my ACCESS power as you do, I will also act like
you guys to help other persons, kindly and warm-heartedly.
My Best Regards to you all
Martin.
That VBA sentence is as follows. It solved the problem of inquery "*" and
can be efficiently used in the multi-combo complex inquiry:
------------------------------------
[Forms]![abb].Filter = " dealerA like " & Chr$(34) & jxsjc & Chr$(34) & "
And dealerB like " & Chr$(34) & zydjc & Chr$(34) & " and dealerC Like " &
Chr$(34) & ywxt & Chr$(34)
-------------------------------------
Mr.Douglas J. Steele , Mr. John Wison , Sir Ofer and those who are helping
people round here.
I have spend a whole day thinking about this problem, ask many "specialist"
and post in a lot of bbs. Yet, it really a tough problem. And I am really
sorry about my posting many pieces of same kind questions in this newsgroup,
so so sorry
Without your help, I am hopeless to work this problem out! You guys
arewarm-hearted, very kind persons. Especially, Mr. Douglas wrote me a lot of
valuable informations, through these informations I finally find out a great
way to solve the problem. Look through the things you and you and you wrote
me today, I am quite moved.
If, in the future, I grow up my ACCESS power as you do, I will also act like
you guys to help other persons, kindly and warm-heartedly.
My Best Regards to you all
Martin.
That VBA sentence is as follows. It solved the problem of inquery "*" and
can be efficiently used in the multi-combo complex inquiry:
------------------------------------
[Forms]![abb].Filter = " dealerA like " & Chr$(34) & jxsjc & Chr$(34) & "
And dealerB like " & Chr$(34) & zydjc & Chr$(34) & " and dealerC Like " &
Chr$(34) & ywxt & Chr$(34)
-------------------------------------