Click here to Skip to main content
15,902,189 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralVB Pin
BOREC13-Dec-07 10:02
BOREC13-Dec-07 10:02 
GeneralRe: VB Pin
Dave Kreskowiak13-Dec-07 10:20
mveDave Kreskowiak13-Dec-07 10:20 
GeneralRe: VB Pin
Christian Graus13-Dec-07 11:35
protectorChristian Graus13-Dec-07 11:35 
GeneralDeserved reply, and sincere apology... Pin
BOREC13-Dec-07 12:58
BOREC13-Dec-07 12:58 
GeneralCODE Pin
BOREC13-Dec-07 9:40
BOREC13-Dec-07 9:40 
GeneralRe: CODE Pin
Christian Graus13-Dec-07 11:30
protectorChristian Graus13-Dec-07 11:30 
GeneralCODE Pin
BOREC13-Dec-07 13:12
BOREC13-Dec-07 13:12 
GeneralRe: CODE Pin
Christian Graus13-Dec-07 13:22
protectorChristian Graus13-Dec-07 13:22 
BOREC wrote:
Don't get upset please cause I don't want anyone to get a stroke or diarea or something like that...


LOL - I'm not even remotely upset.

BOREC wrote:
I hopped you could correct it a bit and added some comments. Whell


Well, I'm saying that you need instead to do things the right way, write some SQL that requests the data you want from the DB. I gave you the SQL in my first reply, or at least an approximation of what it should be.

The way I would write a method that views one record at a time would depend on the data set. If it was not huge, I'd read it all from the DB and just step over it with my buttons. I'd still not look for records in memory, I'd still write SQL and let the DB do that for me. I'd use my existing functionality then to step over the matches, as my collection would only contain records that match.

http://www.developerfusion.co.uk/forums/p/28135/104686/#104686[^] has a reply showing how to do a dynamic search in Access with VB.NET. It was the first hit when I googled 'vb.net search access database', it looks like a good place to start.
Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

GeneralFOUND CODE Pin
BOREC13-Dec-07 13:57
BOREC13-Dec-07 13:57 
GeneralRe: FOUND CODE Pin
Christian Graus13-Dec-07 16:12
protectorChristian Graus13-Dec-07 16:12 
QuestionWeb Exception ! Pin
AliAmjad13-Dec-07 6:51
AliAmjad13-Dec-07 6:51 
GeneralRe: Web Exception ! Pin
Dave Kreskowiak13-Dec-07 7:16
mveDave Kreskowiak13-Dec-07 7:16 
GeneralRe: Web Exception ! Pin
AliAmjad13-Dec-07 8:04
AliAmjad13-Dec-07 8:04 
GeneralRe: Web Exception ! Pin
Dave Kreskowiak13-Dec-07 8:19
mveDave Kreskowiak13-Dec-07 8:19 
QuestionHow Send email with VB 2005 ? Pin
Orlando_Herrera13-Dec-07 6:02
Orlando_Herrera13-Dec-07 6:02 
AnswerRe: How Send email with VB 2005 ? Pin
Dave Kreskowiak13-Dec-07 6:56
mveDave Kreskowiak13-Dec-07 6:56 
QuestionUnable to load dll on computers which do not have Visual Studio installed Pin
Member 408492813-Dec-07 5:35
Member 408492813-Dec-07 5:35 
GeneralRe: Unable to load dll on computers which do not have Visual Studio installed Pin
Dave Kreskowiak13-Dec-07 6:53
mveDave Kreskowiak13-Dec-07 6:53 
QuestionRe: Unable to load dll on computers which do not have Visual Studio installed Pin
Member 408492813-Dec-07 8:58
Member 408492813-Dec-07 8:58 
GeneralRe: Unable to load dll on computers which do not have Visual Studio installed Pin
Dave Kreskowiak14-Dec-07 0:54
mveDave Kreskowiak14-Dec-07 0:54 
GeneralRe: Unable to load dll on computers which do not have Visual Studio installed Pin
Member 408492814-Dec-07 9:36
Member 408492814-Dec-07 9:36 
GeneralFlie dll Pin
ra_shieru13-Dec-07 4:58
ra_shieru13-Dec-07 4:58 
GeneralRe: Flie dll Pin
Dave Kreskowiak13-Dec-07 6:48
mveDave Kreskowiak13-Dec-07 6:48 
QuestionOptional Array in function not working in COM class?!? Pin
djdjoko13-Dec-07 4:22
djdjoko13-Dec-07 4:22 
AnswerRe: Optional Array in function not working in COM class?!? Pin
Dave Kreskowiak13-Dec-07 6:46
mveDave Kreskowiak13-Dec-07 6:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.