• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

I can not seem to display all the records in the page that matches the search.

in the attached database there is a search form "frmSearch" and a results form "frmDetailMainInfo" and when I enter a search I expect all the results be displayed and I cannot seem to find the issue.

Anyone can assist to get this resolved would be appreciated..



SRTS--2-.zip
0
TonyEF
Asked:
TonyEF
  • 7
  • 7
  • 5
1 Solution
 
kdart301Commented:
Hi,

What was your search, exactly. I ran the search based on street = Main and "any part" and got 3 records, which is correct.


Ken
0
 
TonyEFAuthor Commented:
the search I did is the same and it does return the records, however the three records does not dipaly in the results form at the sametime.. you have to select one at a time in the reluts form..

0
 
kdart301Commented:
TonyEF,

If I understand you correctly, you want to see all the records in the result form one after another, you will need to make it a continous form not single.


Hope this helps


Ken
0
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.

 
kdart301Commented:
TonyEF,

Take a look at the form in here and let me know if this is what you wanted.


Ken


SRTS--3-.zip
0
 
TonyEFAuthor Commented:
I try that and when I change it to continous all the record from the table display... if you change it and search for the street name of "Saint" you will notice that all the records displays and I only have one records that matches the search..
0
 
TonyEFAuthor Commented:
It still not working.. Like I mention about, if you search for "Saint" for the street name you will see that the resutls forms displays the other records as well...
0
 
Rey Obrero (Capricorn1)Commented:
try this one


SRTS--2-.accdb
0
 
TonyEFAuthor Commented:
capricorn1
its not working, if you search by streetname and enter "Saint", no results come up, however there is one record in the table and when you search for "main", finds the three records but does not displays them all in the results page..
0
 
Rey Obrero (Capricorn1)Commented:
because, that  record is not part of records returned by the query that you created as the record source of the form.

try changing the record source of the form to tblMainInfo
0
 
kdart301Commented:
TonyEF,

capricorn1 is correct, the result form is based on the relationship with the attachement table and only the records that have the matching id's. Your are using the main table id for the attachment and the id for the tblmaininfo.


Ken
0
 
kdart301Commented:

sorry,

If you remove the attachment table from the forms source, the search form works. There is no main table if in the attachement table for the streetname like "Saint".


Ken
0
 
TonyEFAuthor Commented:
I understand, but I need to have that other table to display the data associated to both records. But I added an associated record to the other table and the record come up, but when you search for main only one record is displayed and I want to have all the records displayed in the results form.
0
 
Rey Obrero (Capricorn1)Commented:
Your form is a single form. Change the view to continuous form or data sheet.
In the current view, you will see the count of records displayed below the form
0
 
kdart301Commented:
If the results are correct then make the result form Continous to view all of the detail records and make the form larger.

Ken
0
 
Rey Obrero (Capricorn1)Commented:
TonyEF,
 i don't mind splitting the points with somebody, but not in this case,
i gave you all the working solution.
you split the points to a comment that was just a repetition of what i posted.
0
 
kdart301Commented:
In this case I agree, even though I gave the continuous form part up front, I was too late posting on the important part.

0
 
TonyEFAuthor Commented:
no idea how to rectify the issue Capricorn1 and my apologies..
0
 
Rey Obrero (Capricorn1)Commented:
click on Request Attention above and ask to reopen the thread.
0
 
TonyEFAuthor Commented:
my apologies for the confusion...
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 7
  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now