Connecting Tech Pros Worldwide Help | Site Map

Show data from multiple records?

  #1  
Old August 2nd, 2008, 12:05 AM
Jackmac
Guest
 
Posts: n/a
Hi there,

Hopefully an easy one for someone. I'm writing a small app (Visual Studio
2008) which will take an existing access database we have and show it in a
form I'm writing. The fields have say customer and their files info. Record
1 could have customer name, the file box number, contents of file box. As
they are big boxes, the 'file box number' field contains duplicates - Box
123 contains 35 different files. I want, when the user clicks the 'file box
number' button on the interface I'm writing to show the data in the
'contents of file box' in a list view. It would sort of like a filter to
show data 'if 'contents of file box' = 'file box number'. That make sense?
Roughly, when they click Box 123, the listview box (if that's the control to
use) would show 35 entries. Any help very much appreciated.

TIA

Jack


  #2  
Old August 2nd, 2008, 02:25 AM
Jason Keats
Guest
 
Posts: n/a

re: Show data from multiple records?


Jackmac wrote:
Quote:
Hi there,
>
Hopefully an easy one for someone. I'm writing a small app (Visual Studio
2008) which will take an existing access database we have and show it in a
form I'm writing. The fields have say customer and their files info. Record
1 could have customer name, the file box number, contents of file box. As
they are big boxes, the 'file box number' field contains duplicates - Box
123 contains 35 different files. I want, when the user clicks the 'file box
number' button on the interface I'm writing to show the data in the
'contents of file box' in a list view. It would sort of like a filter to
show data 'if 'contents of file box' = 'file box number'. That make sense?
Roughly, when they click Box 123, the listview box (if that's the control to
use) would show 35 entries. Any help very much appreciated.
This group is for Visual Basic up to VB6.

If you're interested in later versions of Visual Basic, then use a
dotnet group, such as: microsoft.public.dotnet.languages.vb


Also try:
http://msdn.microsoft.com/en-us/library/aa187917.aspx
http://msdn.microsoft.com/en-au/beginner/default.aspx

The "Forms over Data Video Series" here
http://msdn.microsoft.com/en-us/vbas...=topsectionimg
is probably what you want.
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Viewing data from multiple tables Sumith76 answers 1 November 30th, 2007 03:27 PM
Producing a List from Multiple Records NeoPa insights 0 May 1st, 2007 12:05 AM
How to Combine Data from multiple tables or sources? Mark Welch answers 8 July 19th, 2006 09:25 PM
populating textfield from multiple records Sidney Linkers answers 3 November 12th, 2005 02:48 PM