Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
Go Back  Xtreme Visual Basic Talk > > > Accessing SubdataSheets in Access through VB .NET


Reply
 
Thread Tools Display Modes
  #21  
Old 06-17-2004, 12:36 PM
Stacey244 Stacey244 is offline
Regular
 
Join Date: Jun 2004
Location: Michigan
Posts: 74
Default


Ok ya I get what you're saying. I do know that it will be the first record always because thats the way that I have it set up. I search for the matno and that returns a table of 26. I suppose I need to switch the SQL statement. Is there a way to narrow down a recordset after you get one from a database? So if I return all those records and then do another search for all but the first one.. is that even possible? To do a rs1.open() statement and search through a previous rs.open statement?
__________________
~Stacey~

All the world's a stage and all the men and women merely players...
Reply With Quote
  #22  
Old 06-18-2004, 07:20 AM
MKoslof's Avatar
MKoslofAccessing SubdataSheets in Access through VB .NET MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

Since we are still talking COM ADO technologies (you should really start learning native .Net data access methods ). What you could do is initially limit your results via a query. Then, you can do a .Find method to look for a specific value within the returned results. But this is typically not needed. I suggest you restructure your tables. Do you have any unique identifiers or primary keys. Basically, restrict your records to ONLY the records you want to see in the first place. That is your "best" option.
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
  #23  
Old 06-18-2004, 12:21 PM
Stacey244 Stacey244 is offline
Regular
 
Join Date: Jun 2004
Location: Michigan
Posts: 74
Default

Quote:
Originally Posted by MKoslof
Since we are still talking COM ADO technologies (you should really start learning native .Net data access methods ). What you could do is initially limit your results via a query. Then, you can do a .Find method to look for a specific value within the returned results. But this is typically not needed. I suggest you restructure your tables. Do you have any unique identifiers or primary keys. Basically, restrict your records to ONLY the records you want to see in the first place. That is your "best" option.
Haha ya I know I need to crack down. I'm on a time limit and I'm being lazy. Sorry about that. I didn't want to have to redo the way the database is set up but I might have to. Thanks for all your help.
__________________
~Stacey~

All the world's a stage and all the men and women merely players...
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
 
Accessing SubdataSheets in Access through VB .NET
Accessing SubdataSheets in Access through VB .NET
 
-->