Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Search field question
Started 1 month, 3 weeks ago by benz1984
Hello, I have a search field in my database so I can searh my records by social security number. Well after the search is finished, it obviously it displays the record I searched for. Well, it seems to place a "filter" on the databse and in order for me to display all records again i have to close out of the form and reopen it again. So it displays record 1 of 1000 instead of 1 of 1 after ...
Site: dBforums - Database Support Community  dBforums - Database Support Community - site profile
Forum: Microsoft Access  Microsoft Access - forum profile
Total authors: 6 authors
Total thread posts: 13 posts
Thread activity: no new posts during last week
Domain info for: dbforums.com

Other posts in this thread:

benz1984 Registered User replied 1 month, 3 weeks ago
Hello, I have a search field in my database so I can searh my records by social security number. Well after the search is finished, it obviously it displays the record I searched for. Well, it seems to place a "filter" on the databse and in order for me to display all records again i have to close out of the form and reopen it again. So it displays record 1 of 1000 instead of 1 of 1 after ...
Size: 671 bytes
Customize:  Customize "<b>Reply 1</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

Sinndho replied 1 month, 3 weeks ago
You can do this in VBA: Code: Me.Filter = "" Me.FilterOn = False
Size: 369 bytes
Customize:  Customize "<b>Reply 2</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

Sinndho Registered User replied 1 month, 3 weeks ago
You can do this in VBA: Code: Me.Filter = "" Me.FilterOn = False
Size: 369 bytes
Customize:  Customize "<b>Reply 3</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

benz1984 replied 1 month, 3 weeks ago
Do you mean add this in the on click event of a command button? Thanks!
Size: 72 bytes
Customize:  Customize "<b>Reply 4</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

benz1984 Registered User replied 1 month, 3 weeks ago
Do you mean add this in the on click event of a command button? Thanks!
Size: 72 bytes
Customize:  Customize "<b>Reply 5</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

Sinndho replied 1 month, 3 weeks ago
Yes that's it: Code: Private Sub Button_RemoveFilter_Click() Me.Filter = "" Me.FilterOn = False End Sub Be aware that this triggers a Current event in the form.
Size: 474 bytes
Customize:  Customize "<b>Reply 6</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

Sinndho Registered User replied 1 month, 3 weeks ago
Yes that's it: Code: Private Sub Button_RemoveFilter_Click() Me.Filter = "" Me.FilterOn = False End Sub Be aware that this triggers a Current event in the form.
Size: 474 bytes
Customize:  Customize "<b>Reply 7</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

benz1984 Registered User replied 1 month, 3 weeks ago
hello, this did not work unfortunately. basically i have a search field with this code. If Not IsNull(Me!FSS) Then Me.RecordSource = "Select * from [Claim Tracking System] where [Social Security] = '" & Forms![Claims Tracking System]!FSS & "'" End If when it searches it obviously brings up what i searched for and if it does not find anything it leaves a black record and ...
Size: 1,033 bytes
Customize:  Customize "<b>Reply 8</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

benz1984 replied 1 month, 3 weeks ago
hello, this did not work unfortunately. basically i have a search field with this code. If Not IsNull(Me!FSS) Then Me.RecordSource = "Select * from [Claim Tracking System] where [Social Security] = '" & Forms![Claims Tracking System]!FSS & "'" End If when it searches it obviously brings up what i searched for and if it does not find anything it leaves a black record and ...
Size: 1,033 bytes
Customize:  Customize "<b>Reply 9</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

pbaldy Registered User replied 1 month, 3 weeks ago
Me.RecordSource = "Select * from [Claim Tracking System]"
Size: 67 bytes
Customize:  Customize "<b>Reply 10</b>: Search field question :: Microsoft Access :: dBforums - Database Support Community"

 

Top contributing authors

Name
Posts
benz1984
4
user's latest post:
Search field question
Published (2009-11-19 09:12:00)
Awesome it worked. I knew it was going to be as simple as that just couldn't pin it. Thanks!
benz1984 Registered User
3
user's latest post:
Search field question
Published (2009-11-13 13:40:00)
hello, this did not work unfortunately. basically i have a search field with this code. If Not IsNull(Me!FSS) Then Me.RecordSource = &quot;Select * from [Claim Tracking System] where [Social Security] = '&quot; &amp; Forms![Claims Tracking System]!FSS &amp; &quot;'&quot; End If when it searches it obviously brings up what i searched for and if it does not find anything it leaves a black record and displays 1...
Sinndho
2
user's latest post:
Search field question
Published (2009-11-12 15:58:00)
Yes that's it: Code: Private Sub Button_RemoveFilter_Click() Me.Filter = &quot;&quot; Me.FilterOn = False End Sub Be aware that this triggers a Current event in the form.
Sinndho Registered User
2
user's latest post:
Search field question
Published (2009-11-12 15:58:00)
Yes that's it: Code: Private Sub Button_RemoveFilter_Click() Me.Filter = &quot;&quot; Me.FilterOn = False End Sub Be aware that this triggers a Current event in the form.
pbaldy Registered User
1
user's latest post:
Search field question
Published (2009-11-13 14:19:00)
Me.RecordSource = &quot;Select * from [Claim Tracking System]&quot;
pbaldy
1
user's latest post:
Search field question
Published (2009-11-13 14:19:00)
Me.RecordSource = &quot;Select * from [Claim Tracking System]&quot;

Related threads on "dBforums - Database Support Community":

AutoPopulate Field Question  dBforums - Database Support Community - site profile Microsoft Access - forum profile AutoPopulate Field Question
AutoPopulate Field Question
Search all tables for a field and then display all...  dBforums - Database Support Community - site profile comp.databases.ms-access - forum profile Search all tables for a field and then display all account if found
Search all tables for a field and then display all account if found
Help: Search form and fill in record for that field  dBforums - Database Support Community - site profile comp.databases.ms-access - forum profile Help: Search form and fill in record for that field
Help: Search form and fill in record for that field
How about search Key word for clob field ?  dBforums - Database Support Community - site profile DB2 - forum profile How about search Key word for clob field ?
How about search Key word for clob field ?
Multiple search parameters on same table field  dBforums - Database Support Community - site profile MySQL - forum profile Multiple search parameters on same table field
Multiple search parameters on same table field
Search from field seperate with comma  dBforums - Database Support Community - site profile MySQL - forum profile Search from field seperate with comma
Search from field seperate with comma
Updating subform from field (Search)  dBforums - Database Support Community - site profile Microsoft Access - forum profile Updating subform from field (Search)
Updating subform from field (Search)
Formula for field character search  dBforums - Database Support Community - site profile Applications & Tools - forum profile Formula for field character search
Formula for field character search
Query Criteria From a form field. Trying to do a contains...  dBforums - Database Support Community - site profile Microsoft Access - forum profile Query Criteria From a form field. Trying to do a contains search. Help Please.
Query Criteria From a form field. Trying to do a contains search. Help Please.
Field Update Question  dBforums - Database Support Community - site profile microsoft.public.access.modulesdaovba - forum profile Field Update Question
Field Update Question

Related threads on other sites:

Safari supports an INPUT field that behaves like a Mac...  Twitter / WhatIveLearned - site profile Enlightened Richard - forum profile Safari supports an INPUT field that behaves like a Mac search field using attributes TYPE="SEARCH" RESULTS="x" and it degrades gracefully. 8:38 AM Apr 8th, 2008 from web
Safari supports an INPUT field that behaves like a Mac search field using attributes TYPE="SEARCH" RESULTS="x" and it degrades gracefully. 8:38 AM Apr 8th, 2008 from web
Fun Safari/iPhone tip: first, tap the search field. Then,...  Twitter / daveymcgav - site profile David McGavern - forum profile Fun Safari/iPhone tip: first, tap the search field. Then, tap to the left of the search field and it'll switch over to the address bar. Yay! 11:22 AM Apr 11th from web
Fun Safari/iPhone tip: first, tap the search field. Then, tap to the left of the search field and it'll switch over to the address bar. Yay! 11:22 AM Apr 11th from web
Making sweet, sweet pythonic love to a search field....  Twitter / camflan - site profile Camron Flanders - forum profile Making sweet, sweet pythonic love to a search field. single field search, chaining capable. 11:28 PM Jul 1st, 2008 from web
Making sweet, sweet pythonic love to a search field. single field search, chaining capable. 11:28 PM Jul 1st, 2008 from web
How to Implementing Advanced Search (Field by Field...  Microsoft TechNet Forums - site profile SharePoint - Search - forum profile How to Implementing Advanced Search (Field by Field Search)?
How to Implementing Advanced Search (Field by Field Search)?
RT @ berndschiffer http://grails.org says The search...  Twitter / Sanitz - site profile Sebastian - forum profile RT @ berndschiffer http://grails.org says The search is over. Obviously true, theres no search field left on the start site :) #grails 1:55 PM Jul 29th from Power Twitter
RT @ berndschiffer http://grails.org says The search is over. Obviously true, theres no search field left on the start site :) #grails 1:55 PM Jul 29th from Power Twitter
Why doesn't pressing tab after launching Yojimbo take me...  Twitter / benkimball - site profile benkimball - forum profile Why doesn't pressing tab after launching Yojimbo take me to the search field? I have to use shift-tab,; search field is *last* in tab order. 12:59 PM Nov 19th from twitterrific
Why doesn't pressing tab after launching Yojimbo take me to the search field? I have to use shift-tab,; search field is *last* in tab order. 12:59 PM Nov 19th from twitterrific
New search field - search by Outlook Sync? (relationship...  SugarCRM Forums - site profile Developers - forum profile New search field - search by Outlook Sync? (relationship not field)
New search field - search by Outlook Sync? (relationship not field)
@ profmikegreene Question #2 go to Samsung...  Twitter / BankerHorsegal - site profile BankerHorsegal - forum profile @ profmikegreene Question #2 go to Samsung homepage-enter widescreen monitors in search field 3:11 PM Apr 16th from web
@ profmikegreene Question #2 go to Samsung homepage-enter widescreen monitors in search field 3:11 PM Apr 16th from web
Question about search field date:  Amazon Web Services Developer Connection - site profile Alexa Web Search - forum profile Question about search field date:
Question about search field date:
Search field only one search field must be enough...  Twitter / yenz - site profile yenz - forum profile Search field only one search field must be enough 11:41 AM May 28th from web
Search field only one search field must be enough 11:41 AM May 28th from web
Thread profile page for "Search field question" on http://www.dbforums.com. This report page is a snippet summary view from a single thread "Search field question", located on the Message Board at http://www.dbforums.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
 1   2   Next »