Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

get Query From Button Pressing

Hello,
Trying to do the following
When I tyoe in some string in the textbox, and press search, it should show the filtered query results. It not refreshing when I am pressing the button. Please assist
Thank you
R
finalTestPlease.zip
0
Rayne
Asked:
Rayne
  • 11
  • 4
1 Solution
 
RayneAuthor Commented:
check form1 Thank you
0
 
mbizupCommented:
It looks like the out put is correct to me - its showing ALL records that contain your search string in the ship name.

If you want to show DISTINCT results, change your query's SQL view to:

SELECT DISTINCT tblSource.[Ship Name]
FROM tblSource
WHERE (((tblSource.[Ship Name]) Like "*" & [Forms]![Form1]![myShipName] & "*"));

Open in new window


If that doesnt help, please let us know what is wrong with the output and what your expected results are.
0
 
RayneAuthor Commented:
Hello,

Double click on Form1
Entered “Jones”
Clicked “Search” button
Results shows Everything!! All 66 records

I am not sure if that’s filtering correctly by “Jones”


If I enter in Jones, it should pull all the rows that has jones in that field
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
Rey Obrero (Capricorn1)Commented:
ttest this


open the form Form1 and type a value in the textbox, then click on the button
finalTestPlease.accdb
0
 
RayneAuthor Commented:
you need to zip it and attach...i am getting all wierd values in the browser when I open it
0
 
RayneAuthor Commented:
no need to zip, got it
0
 
Rey Obrero (Capricorn1)Commented:
better use this one
finalTestPleaseRev.accdb
0
 
RayneAuthor Commented:
This works Great, Can you explain me the steps, Capricorn. I am touching access after 5 years. Thank you
0
 
Rey Obrero (Capricorn1)Commented:
see the codes in the click event of the button.

what steps you want to know?
0
 
RayneAuthor Commented:
How did you set up the  subFrom “frmSource” – the steps
Thank you
0
 
RayneAuthor Commented:
how does the sbuform looks up values from the main form ? like setting the data
0
 
RayneAuthor Commented:
filtered data
0
 
RayneAuthor Commented:
I see this for it but not sure what means
showIt.png
0
 
Rey Obrero (Capricorn1)Commented:
<How did you set up the  subFrom “frmSource” – the steps >

select the table then Create Form > datasheet
save the form

the filtering is done by the codes in the click event of the button
0
 
RayneAuthor Commented:
Perfection to the Ultimate

Thanks Capricorn :)
0
 
RayneAuthor Commented:
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 11
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now