UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How Do I Create A Custom Combo To Perform The Same Task As Access Textfiler?, Access 2003    
 
   
freespiritcheris...
post Oct 12 2019, 09:00 PM
Post#1



Posts: 158
Joined: 19-October 04



Access has this wonderful Textfilter built into it. Because my requirement is to filter more than one name at a time, I use this feature. However, I have to keep typing the string in everytime on every variation. A combo attached to a text table of the various strings will speed up the filtering process. This is attached and as usual I have no idea what the correct syntax would be to attach it. Would a kindly Pro Code Warrior do something with this skeletal offering so that I can see..?

Many thanks in advance.
freesp

Attached File(s)
Attached File  testgname.zip ( 27.56K )Number of downloads: 7
Attached File  TF.JPG ( 231.1K )Number of downloads: 16
Attached File  re_create.JPG ( 93.7K )Number of downloads: 19
 
Go to the top of the page
 
GroverParkGeorge
post Oct 12 2019, 09:36 PM
Post#2


UA Admin
Posts: 36,561
Joined: 20-June 02
From: Newcastle, WA


You'll need to use a multi-select list box, not a combo box, to support multiple selected values for the filter.


--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
MadPiet
post Oct 12 2019, 10:03 PM
Post#3



Posts: 3,403
Joined: 27-February 09



http://www.theaccessweb.com/reports/rpt0005.htm

Loop over the collection like the article shows, and use IN(<value list>)
Go to the top of the page
 
GroverParkGeorge
post Oct 12 2019, 10:12 PM
Post#4


UA Admin
Posts: 36,561
Joined: 20-June 02
From: Newcastle, WA


Here's one potential approach. I'm sure there are others that would work as well.
Attached File  testgname_MultiFilter.zip ( 26.32K )Number of downloads: 6

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
MadPiet
post Oct 12 2019, 11:58 PM
Post#5



Posts: 3,403
Joined: 27-February 09



Not 100% sure what your end goal is... What exactly are you trying to filter? A control? A form? A report?

Here's an example filtering a report.
This post has been edited by MadPiet: Oct 13 2019, 12:10 AM
Attached File(s)
Attached File  testgname_MultiFilter__1_.zip ( 37.43K )Number of downloads: 8
 
Go to the top of the page
 
Phil_cattivocara...
post Oct 13 2019, 02:04 AM
Post#6



Posts: 368
Joined: 2-April 18



QUOTE (freespiritcherishes)
Access has this wonderful Textfilter built into it.
Would you like to have that (and much more) in every form or report at runtime? Try this:
[MsAccess] Gestione Filtri Ordinamento
(Managing filters and order)
Yes, the usual Italian developer, @Alex. Here is the link he posts:
https://1drv.ms/u/s!ALe2sGzrs4WCh2Y
and here is a brief translation
QUOTE
A short Tutorial is attached to it.
On the probability of bugs and anomalies, I thank you right away for reporting.
The tutorial (pdf file) has italian explanations but the user interface is really easy.
I know that project because I helped him testing it in "insane user mode": I tried to be as fool as I could (and I did it very well, it's natural for me to be fool?) and it covers almost all situations.
Be careful: you write under A2003 section, your image is not that version and @Alex's file needs A2007 or above (he developed using Office365 and I tried in A2016 too, both 32bit)If anybody needs to know something more, understanding-translating italian too, I am here or I can ask to @Alex if you prefer.

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
arnelgp
post Oct 13 2019, 03:48 AM
Post#7



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


multiple search with partial search sample.
Attached File(s)
Attached File  testgname.zip ( 26.3K )Number of downloads: 2
 

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
freespiritcheris...
post Oct 13 2019, 06:41 AM
Post#8



Posts: 158
Joined: 19-October 04



Wow..!! You're all like an Army :-)) Thank you for the examples, they are so helpful. They differ slightly but all perform the task as needed, but I was hoping to limit the amount of typing, using arnelgp's brilliant sample as I have probs with my hands if I type too much. I wanted to limit the amount of typing in the search box which is why I had included the makeshift 'lkupstrings' table. Can 'lkupstrings' be used as the source of the multi-select listbox to filter the gnames? ...to be fair, the tables don't have a direct relationship, I was just hoping a combo/list box would do similar to accesses textfilter just using search strings, if that makes any sense. compute.gif
This post has been edited by freespiritcherishes: Oct 13 2019, 06:44 AM
Attached File(s)
Attached File  pref.jpg ( 136.88K )Number of downloads: 8
 
Go to the top of the page
 
arnelgp
post Oct 13 2019, 07:33 AM
Post#9



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


try form gname2.
Attached File(s)
Attached File  testgname.zip ( 32.24K )Number of downloads: 6
 

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
freespiritcheris...
post Oct 13 2019, 08:03 PM
Post#10



Posts: 158
Joined: 19-October 04



oh my G!!!!!!! arnelgp notworthy.gif notworthy.gif notworthy.gif Thank you so much, that is Perfect!!! Exactly what I needed.. HOW DO YOU DO IT??? I shall examine real close, I'll try to commit to memory, and will practice load, but the little grey cells, as Poirot would say.. are getting 'greyer'!!! Everyone too, you are all so great, thank you arnelgp, thank you so much thumbup.gif pompom.gif
This post has been edited by freespiritcherishes: Oct 13 2019, 08:05 PM
Go to the top of the page
 
arnelgp
post Oct 13 2019, 08:55 PM
Post#11



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


you're welcome!

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    25th January 2020 - 05:41 PM