homepage Welcome to WebmasterWorld Guest from 54.198.224.121
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
MS Access
Searching and Displaying Records
humpingdan




msg:1580616
 8:48 pm on Jan 30, 2006 (gmt 0)

I have a database of assesment data, i need to be able to search for individual pupils based on a number of seperate criteria, Name, ID, Surname, Grade, etc,

the problem i have is displaying the multiple records,

say for instance i have three pupils with the surname smith, i need to be able to search for smith in a form and display the three smiths, then double click the particular smith i need by comparing the ID;s of the three smiths and launching a form which displays the relevant data on the pupil.

Can anyone help me achieve this?

 

Durham_e




msg:1580617
 11:31 pm on Jan 30, 2006 (gmt 0)
Create form with student table:

Create list box (list0 below)

Criteria in student name field of list0

Like "*" & [Enter Venue Name] & "*"

In double click event of list0

Private Sub List0_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "individual_student_form"

stLinkCriteria = "[student_id]=" & Me![List0]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

humpingdan




msg:1580618
 8:43 am on Jan 31, 2006 (gmt 0)

can anyone break this down a little for me?

Graham




msg:1580619
 12:31 pm on Jan 31, 2006 (gmt 0)

This article shows how to create a list box to help search for records in the database:

[databasedev.co.uk...]

Lilliabeth




msg:1580620
 12:43 pm on Jan 31, 2006 (gmt 0)

Built into Access is 'Filter by Form'.

If this would solve your need, it would save you from doing any work.

Lilliabeth




msg:1580621
 12:44 pm on Jan 31, 2006 (gmt 0)

Sorry, I'll bet the part I missed is that you want to see all 3 Smiths on screen at the same time. Sorry.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved