![]() |
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
|
|||
|
Show data from multiple records?
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 |
|
|||
|
Re: Show data from multiple records?
Jackmac wrote:
> 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. |
![]() |
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|