I have a form based on the query:
SELECT tblCreditGeld.C G_Selected, tblCreditGeld.C G_ClientSelecte d,
tblCreditGeld.C G_ComplexSelect ed, tblCreditGeld.C G_OKGR_ID,
tblCreditGeld.C G_OKGR_IDN, tblCreditGeld.C G_client_n,
tblCreditGeld.C G_COMP_NR, tblCreditGeld.C G_BANKREK_NR,
tblCreditGeld.C G_clientnm, tblCreditGeld.C G_K_MUNT_ISO,
tblCreditGeld.C G_GRV, tblCreditGeld.C G_kcons, tblCreditGeld.C G_unit,
tblCreditGeld.C G_Kode, tblCreditGeld.C G_Perc1,
tblCreditGeld.C G_MPerc1, tblCreditGeld.C G_Grens,
tblCreditGeld.C G_Perc2, tblCreditGeld.C G_MPerc2,
tblCreditGeld.C G_BGrens, tblCreditGeld.C G_CREDITRENTE_4 ,
tblCreditGeld.C G_EFF_PERC_CR_4 , tblCreditGeld.C G_verrt,
tblCreditGeld.C G_CREDITRENTE_T OT, tblCreditGeld.C G_EFF_PERC_CR_T OT,
tblCreditGeld.C G_vertot, tblCreditGeld.C G_CREDITRENTE_4 _C,
tblCreditGeld.C G_EFF_PERC_CR_4 _C, tblCreditGeld.C G_CREDITRENTE_T OT_C,
tblCreditGeld.C G_EFF_PERC_CR_T OT_C, tblCreditGeld.C G_NAAM,
tblCreditGeld.C G_kadv, tblCreditGeld.C G_mar, tblCreditGeld.C G_martot,
tblCreditGeld.C G_kmar, tblCreditGeld.C G_kmartot,
tblCreditGeld.C G_5TON, tblCreditGeld.C G_PORTO,
tblCreditGeld.C G_Freq_Dagafsch r
FROM tblCreditGeld;
The form has a filter:
((CG_OKGR_IDN) = 'A. LEUSCHEL BEHEER B.V.')
The filterproperty is set to 'True' but the filter simply does not
work. If I put this filter in de SQL as a WHERE statement it
works.......... .....
I have tried setting the filter through a module in VBA, in the form
itself, in design mode, in normal mode, even manually but the form
just refuses to filter anything.
There is in de code nothing to find that would set the filter
otherwise, in none of the events of the form nor in any events
connected to any of the controls....... ..........
Any suggestions as to why this form refuses to filter?
I tried compacting and repairing the database as well as importing the
whole shebang in a new database but no
resolve........ ............... ... Only remorse........ .....
Thanks a lot for thinking with me, this problem is somewhat shadowing
the happiness I feel at the birth of my youngest brothers first child
(a beautiful beautiful girl that undoubtedly will be the first female
president of the United States of Europe :p) yesterday....
For those who want to share in my happiness: she is born 7th of march
@ 14:45 GMT +1!!!
Greetings, Happy Henro 3 6750
On 7 Mar 2007 23:48:25 -0800, "Henrootje" <He****@gmail.c omwrote:
Perhaps you could remove all parentheses and try again.
Another test: run the form without filter, then select the field,
right click, filter by selection. Then in the immediate window enter:
?Forms!<yourfor m>.Filter
and see what it produced.
-Tom.
>I have a form based on the query:
SELECT tblCreditGeld.C G_Selected, tblCreditGeld.C G_ClientSelecte d, tblCreditGeld. CG_ComplexSelec ted, tblCreditGeld.C G_OKGR_ID, tblCreditGeld. CG_OKGR_IDN, tblCreditGeld.C G_client_n, tblCreditGeld. CG_COMP_NR, tblCreditGeld.C G_BANKREK_NR, tblCreditGeld. CG_clientnm, tblCreditGeld.C G_K_MUNT_ISO, tblCreditGeld. CG_GRV, tblCreditGeld.C G_kcons, tblCreditGeld.C G_unit, tblCreditGeld. CG_Kode, tblCreditGeld.C G_Perc1, tblCreditGeld. CG_MPerc1, tblCreditGeld.C G_Grens, tblCreditGeld. CG_Perc2, tblCreditGeld.C G_MPerc2, tblCreditGeld. CG_BGrens, tblCreditGeld.C G_CREDITRENTE_4 , tblCreditGeld. CG_EFF_PERC_CR_ 4, tblCreditGeld.C G_verrt, tblCreditGeld. CG_CREDITRENTE_ TOT, tblCreditGeld.C G_EFF_PERC_CR_T OT, tblCreditGeld. CG_vertot, tblCreditGeld.C G_CREDITRENTE_4 _C, tblCreditGeld. CG_EFF_PERC_CR_ 4_C, tblCreditGeld.C G_CREDITRENTE_T OT_C, tblCreditGeld. CG_EFF_PERC_CR_ TOT_C, tblCreditGeld.C G_NAAM, tblCreditGeld. CG_kadv, tblCreditGeld.C G_mar, tblCreditGeld.C G_martot, tblCreditGeld. CG_kmar, tblCreditGeld.C G_kmartot, tblCreditGeld. CG_5TON, tblCreditGeld.C G_PORTO, tblCreditGeld. CG_Freq_Dagafsc hr FROM tblCreditGeld;
The form has a filter: ((CG_OKGR_ID N) = 'A. LEUSCHEL BEHEER B.V.') The filterproperty is set to 'True' but the filter simply does not work. If I put this filter in de SQL as a WHERE statement it works......... ...... I have tried setting the filter through a module in VBA, in the form itself, in design mode, in normal mode, even manually but the form just refuses to filter anything. There is in de code nothing to find that would set the filter otherwise, in none of the events of the form nor in any events connected to any of the controls....... .......... Any suggestions as to why this form refuses to filter? I tried compacting and repairing the database as well as importing the whole shebang in a new database but no resolve....... ............... .... Only remorse........ .....
Thanks a lot for thinking with me, this problem is somewhat shadowing the happiness I feel at the birth of my youngest brothers first child (a beautiful beautiful girl that undoubtedly will be the first female president of the United States of Europe :p) yesterday.... For those who want to share in my happiness: she is born 7th of march @ 14:45 GMT +1!!!
Greetings, Happy Henro
"Henrootje" <He****@gmail.c omwrote in
news:11******** **************@ 8g2000cwh.googl egroups.com:
I have a form based on the query:
The form has a filter:
((CG_OKGR_IDN) = 'A. LEUSCHEL BEHEER B.V.')
The filterproperty is set to 'True' but the filter simply does
not work. If I put this filter in de SQL as a WHERE statement
it works.......... .....
I have tried setting the filter through a module in VBA, in
the form itself, in design mode, in normal mode, even manually
but the form just refuses to filter anything.
There is in de code nothing to find that would set the filter
otherwise, in none of the events of the form nor in any events
connected to any of the controls....... ..........
Any suggestions as to why this form refuses to filter?
I tried compacting and repairing the database as well as
importing the whole shebang in a new database but no
resolve........ ............... ... Only remorse........ .....
Forms also have a property: .FilterOn This must be set True for
the filter to work. You have not mentioned setting this
property. Were you aware of it and what happens if you do set
it?
The .Filter Property should contain an expression which
evaluates the records to include when the filter is on.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
It turned out to be a stupid misspelling in some unused variable being
called somewhere I completely had forgotten...... .
Thus filling the filter of the form with "" AND setting the filterOn
property to true :s
Nice sloppy coding :s
Sorry to bother you but thanks for thinking with me!
On 8 mrt, 23:16, Bob Quintal <rquin...@sPAmp atico.cawrote:
"Henrootje" <Hen...@gmail.c omwrote innews:11****** *************** *@8g2000cwh.goo glegroups.com:
I have a form based on the query:
The form has a filter:
((CG_OKGR_IDN) = 'A. LEUSCHEL BEHEER B.V.')
The filterproperty is set to 'True' but the filter simply does
not work. If I put this filter in de SQL as a WHERE statement
it works.......... .....
I have tried setting the filter through a module in VBA, in
the form itself, in design mode, in normal mode, even manually
but the form just refuses to filter anything.
There is in de code nothing to find that would set the filter
otherwise, in none of the events of the form nor in any events
connected to any of the controls....... ..........
Any suggestions as to why this form refuses to filter?
I tried compacting and repairing the database as well as
importing the whole shebang in a new database but no
resolve........ ............... ... Only remorse........ .....
Forms also have a property: .FilterOn This must be set True for
the filter to work. You have not mentioned setting this
property. Were you aware of it and what happens if you do set
it?
The .Filter Property should contain an expression which
evaluates the records to include when the filter is on.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account fromhttp://www.teranews.co m- Tekst uit oorspronkelijk bericht niet weergeven -
- Tekst uit oorspronkelijk bericht weergeven -
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Richard |
last post by:
Hi,
I have a form based on a table. When I filter the form I want to run a
report based on the same table with the same filter as the form. No problem
until I want to filter a combo box where the text value is on a different
table. The me.filter is then a text instead of the id-number from the lookup
table. This causes the report to prompt for the parameter.
How do I get by this problem? Do I need to create a temporary table? I
rather...
|
by: damjanu |
last post by:
Hi All;
I need little help.
I have a datasheet form.
I allow user to do 'filter by selection'.
My form contains a column with values.
As user changes selections, I want to
calculate totals. I can do this the
first time the form loads.
|
by: Nhmiller |
last post by:
This is directly from Access' Help:
"About designing a query
When you open a query in Design view, or open a form, report, or datasheet and
show the Advanced Filter/Sort window (Advanced Filter/Sort window: A window in
which you can create a filter from scratch. You enter criteria expressions in
the filter design grid to restrict the records in the open form or datasheet to
a subset of records that meet the criteria.), you see the design...
|
by: Simon |
last post by:
Dear reader,
Under Tools>>Options>>Tables/Queries there is a setting possible of "SQL
Server Compatible Syntax (ANSI 92)". The two tick boxes here are
· "This database"
· "Default for new databases"
|
by: Ron S |
last post by:
After days of searching I finally an example that would work with my application, the only problem is after entering all of the code it is not working. Would someone be kind enough to take a look at this...
Exmaple web site: http://allenbrowne.com/ser-62.html
My Code:
'Purpose: This module illustrates how to create a search form, _
where the user can enter as many or few criteria as they wish, _
and results...
| |
by: dee |
last post by:
I'd like to filter by the following criteria:
left(LeadDisposition,3) = "Sit" AND Appt_Date = Text767
I have no idea how to do this. Appreciate help.
|
by: angi35 |
last post by:
Working in Access 2000... I have a form with records for every employee. I'd like to create two command buttons so a user can filter the form for either 'only current' or 'only former' employees. I applied the first filter ( Is Null) and created the first 'apply filter' command button (using the wizard), then cleared the filter, applied the second filter ( Is Not Null), and created the second command button. It changed the first button to...
|
by: Jim Mandala |
last post by:
Using Access 2003 front end; SQL Server 2005 Back end:
I have a complex form that has lots of data fields including about
thirty or so checkboxes storing Yes/No data that I would like my users
to be able to use the Filter by Form functionality with to create a
"Custom" query.
This works perfectly fine when I filter on a text field. Also, this
works perfectly fine for all data with an Access Back end. When I use
boolean data and my SQL...
|
by: GazMathias |
last post by:
Hi Guys,
Acc2003.
I have a form that is misbehaving by suddenly refusing to apply a filter I am passing to it.
In a nutshell, I use a public variable to control the form's behaviour called gstrAction.
I have a listbox on the preceding form containing record summaries that I use to open the new form with two buttons:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |