Searching a Specific Record from DB !!
-
Hi, I am Developing a software using VB6.0 as Frontend and MSAccess as Backend. I have used ADODC component and ODBC connection string to connect to DB. I am looking for a code to SEARCH THE DB for a specific record in a specific field and then DISPLAY THE SAME RECORD in the corresponding objects in the Frontend. For e.g:- Suppose, if I gave criteria as Resolution Number = 143162216 using a TextBox, then the code should search the entire table under the column named 'Resolution_Number' and if that No. is found, then the whole information regarding that Resolution Number is displayed at the frontend application (VB6.0) in that specific object,e.g:- for 'User Name' I have used a TextBox, then the 'Name' in the table should be displayed in that TextBox, for 'Type Of User' I have used a ListBox, then the 'User Type' from the table must be displayed in that ListBox. I tried the 'Find' property of the 'RecordSet' object, but it did not worked properly. Also i tried the assignment operator(=) to assign the value of the field in the table to the corresponding object (Textbox, ListBox,etc.), but that also didn't worked. Awaiting for help.
Thanx & Regards. Success is not a Destination, ... But a Journey !!
-
Hi, I am Developing a software using VB6.0 as Frontend and MSAccess as Backend. I have used ADODC component and ODBC connection string to connect to DB. I am looking for a code to SEARCH THE DB for a specific record in a specific field and then DISPLAY THE SAME RECORD in the corresponding objects in the Frontend. For e.g:- Suppose, if I gave criteria as Resolution Number = 143162216 using a TextBox, then the code should search the entire table under the column named 'Resolution_Number' and if that No. is found, then the whole information regarding that Resolution Number is displayed at the frontend application (VB6.0) in that specific object,e.g:- for 'User Name' I have used a TextBox, then the 'Name' in the table should be displayed in that TextBox, for 'Type Of User' I have used a ListBox, then the 'User Type' from the table must be displayed in that ListBox. I tried the 'Find' property of the 'RecordSet' object, but it did not worked properly. Also i tried the assignment operator(=) to assign the value of the field in the table to the corresponding object (Textbox, ListBox,etc.), but that also didn't worked. Awaiting for help.
Thanx & Regards. Success is not a Destination, ... But a Journey !!
Thank you - that is truly the most annoying post ever. Why are you using VB6 ? Do you have no choice, or do you just hate yourself ? It sounds to me like you're asking how to write basic SQL.
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 )
-
Thank you - that is truly the most annoying post ever. Why are you using VB6 ? Do you have no choice, or do you just hate yourself ? It sounds to me like you're asking how to write basic SQL.
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 )
If u don't know the ans then Plz mind ur own business... OK... If u can't help others then Plz don't try to annoy them at least... Is it clear??
Thanx & Regards. Success is not a Destination, ... But a Journey !!
-
If u don't know the ans then Plz mind ur own business... OK... If u can't help others then Plz don't try to annoy them at least... Is it clear??
Thanx & Regards. Success is not a Destination, ... But a Journey !!
Vikrant Badhai wrote:
If u can't help others then Plz don't try to annoy them at least... Is it clear??
Well, you are the one who is making the posts that are so annoying to look at, that I didn't read it all. And, you're using VB6, so I don't see how anything could be more annoying than that. (edit) Now I have read it all and I was right. You're asking how to do a basic SQL query. You just aren't providing enough info that anyone can really offer much more help than what I already did, which is to tell you that you need to write an SQL query to get the data you need.
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 )
-
If u don't know the ans then Plz mind ur own business... OK... If u can't help others then Plz don't try to annoy them at least... Is it clear??
Thanx & Regards. Success is not a Destination, ... But a Journey !!
He did help you by telling to use SQL. Very BASIC SQL.
-
Thank you - that is truly the most annoying post ever. Why are you using VB6 ? Do you have no choice, or do you just hate yourself ? It sounds to me like you're asking how to write basic SQL.
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 )
-
It's dead, not supported anymore, no updates, and you have to write everything from scratch that you would find quite easy to do using the .NET Framework in FAR less code.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
AndrewVos wrote:
Whats wrong with VB6?
Not much, the real problem is with the monkeys that use it. :-D
Jeremy Falcon Oatmeal Engine[^]
-
Hi, I am Developing a software using VB6.0 as Frontend and MSAccess as Backend. I have used ADODC component and ODBC connection string to connect to DB. I am looking for a code to SEARCH THE DB for a specific record in a specific field and then DISPLAY THE SAME RECORD in the corresponding objects in the Frontend. For e.g:- Suppose, if I gave criteria as Resolution Number = 143162216 using a TextBox, then the code should search the entire table under the column named 'Resolution_Number' and if that No. is found, then the whole information regarding that Resolution Number is displayed at the frontend application (VB6.0) in that specific object,e.g:- for 'User Name' I have used a TextBox, then the 'Name' in the table should be displayed in that TextBox, for 'Type Of User' I have used a ListBox, then the 'User Type' from the table must be displayed in that ListBox. I tried the 'Find' property of the 'RecordSet' object, but it did not worked properly. Also i tried the assignment operator(=) to assign the value of the field in the table to the corresponding object (Textbox, ListBox,etc.), but that also didn't worked. Awaiting for help.
Thanx & Regards. Success is not a Destination, ... But a Journey !!
Why do you use bold text and caps in that manner? :suss: When I do that, it's because i want to annoy the person i'm writing to. Do you want to annoy us? All of us? 'Cause this is a public board, compadre - when you post, you're addressing each and every one of the readers. And addressing us in this way is a sure way to make new enemies. :^)
But who is the king of all of these folks?
-
Hi, I am Developing a software using VB6.0 as Frontend and MSAccess as Backend. I have used ADODC component and ODBC connection string to connect to DB. I am looking for a code to SEARCH THE DB for a specific record in a specific field and then DISPLAY THE SAME RECORD in the corresponding objects in the Frontend. For e.g:- Suppose, if I gave criteria as Resolution Number = 143162216 using a TextBox, then the code should search the entire table under the column named 'Resolution_Number' and if that No. is found, then the whole information regarding that Resolution Number is displayed at the frontend application (VB6.0) in that specific object,e.g:- for 'User Name' I have used a TextBox, then the 'Name' in the table should be displayed in that TextBox, for 'Type Of User' I have used a ListBox, then the 'User Type' from the table must be displayed in that ListBox. I tried the 'Find' property of the 'RecordSet' object, but it did not worked properly. Also i tried the assignment operator(=) to assign the value of the field in the table to the corresponding object (Textbox, ListBox,etc.), but that also didn't worked. Awaiting for help.
Thanx & Regards. Success is not a Destination, ... But a Journey !!
Vikrant Badhai wrote:
Awaiting for help.
Get yourself a book on SQL and use Google for ADO. That Find method is only going to work on a result set AFTER the DB was queried (this may make a difference depending on how the recordset was created). Most of this should be covered in just about any beginner's text. Also, VB6 is dying (a lot is still in use as old code). If you have to use VB, you may wanna look into VB.NET instead.
Jeremy Falcon Oatmeal Engine[^]
-
-
Thank you - that is truly the most annoying post ever. Why are you using VB6 ? Do you have no choice, or do you just hate yourself ? It sounds to me like you're asking how to write basic SQL.
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 )
Why are you using VB6 ? Because that's the only development product supported by Microsoft. And they have planned to support it till 3020. That's worth learning VB6.0. If you haven't started learning it,I can say your future is at stake! :sigh:
OK,. what country just started work for the day ? The ASP.NET forum is flooded with retarded questions. -Christian Graus Best wishes to Rexx[^]
-
Hi, I am Developing a software using VB6.0 as Frontend and MSAccess as Backend. I have used ADODC component and ODBC connection string to connect to DB. I am looking for a code to SEARCH THE DB for a specific record in a specific field and then DISPLAY THE SAME RECORD in the corresponding objects in the Frontend. For e.g:- Suppose, if I gave criteria as Resolution Number = 143162216 using a TextBox, then the code should search the entire table under the column named 'Resolution_Number' and if that No. is found, then the whole information regarding that Resolution Number is displayed at the frontend application (VB6.0) in that specific object,e.g:- for 'User Name' I have used a TextBox, then the 'Name' in the table should be displayed in that TextBox, for 'Type Of User' I have used a ListBox, then the 'User Type' from the table must be displayed in that ListBox. I tried the 'Find' property of the 'RecordSet' object, but it did not worked properly. Also i tried the assignment operator(=) to assign the value of the field in the table to the corresponding object (Textbox, ListBox,etc.), but that also didn't worked. Awaiting for help.
Thanx & Regards. Success is not a Destination, ... But a Journey !!
Vikrant Badhai wrote:
I am Developing a software using VB6.0 as Frontend and MSAccess as Backend.
why? VB6 is dead and no longer supported by Microsoft, and Access is better replaced by SQL Server 2005 Express. You really should update your skill set top more upto the moment tools and technology :-D
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
VB6 is no longer supported. Moving up to VB.NET is Microsoft's intentions these days.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
Vikrant Badhai wrote:
Awaiting for help.
Get yourself a book on SQL and use Google for ADO. That Find method is only going to work on a result set AFTER the DB was queried (this may make a difference depending on how the recordset was created). Most of this should be covered in just about any beginner's text. Also, VB6 is dying (a lot is still in use as old code). If you have to use VB, you may wanna look into VB.NET instead.
Jeremy Falcon Oatmeal Engine[^]
Jeremy Falcon wrote:
VB6 is dying
Can someone put it out of its misery?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
It's dead, not supported anymore, no updates, and you have to write everything from scratch that you would find quite easy to do using the .NET Framework in FAR less code.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007The major problem is that i have a low config computer. It does not support .NET and SQL. It becomes too heavy if i install .NET. that's why i am using VB 6.0 and Access.and i know i'll be able to convert it into .NET project afterwards, but till then i have to use VB 6.0 and Access.
Thanx & Regards. Success is not a Destination, ... But a Journey !!
-
Why do you use bold text and caps in that manner? :suss: When I do that, it's because i want to annoy the person i'm writing to. Do you want to annoy us? All of us? 'Cause this is a public board, compadre - when you post, you're addressing each and every one of the readers. And addressing us in this way is a sure way to make new enemies. :^)
But who is the king of all of these folks?
i don't want to annoy anyone. i am using bold text to show the importance of that sentence. for e.g:- i use bold text for the name of a textbox object, so that all should be able to recognise that it is the name of the textbox. i think all of u misunderstood me. And another major problem is that i have a low config computer. It does not support .NET and SQL. It becomes too heavy if i install .NET. that's why i am using VB 6.0 and Access.and i know i'll be able to convert it into .NET project afterwards, but till then i have to use VB 6.0 and Access.
Thanx & Regards. Success is not a Destination, ... But a Journey !!