Thanx. Sure it is very helpful to me and for all the others who are beginners. Thanx.

Thanx & Regards. Success is not a Destination, ... But a Journey !!

Sorry i didn't get you.

Thanx & Regards. Success is not a Destination, ... But a Journey !!

i don't have MSDN installed.

Thanx & Regards. Success is not a Destination, ... But a Journey !!

i want to use the DateDiff() procedure of VB6.0 but iam getting Run-time error 5: Invalid Procedure call or Argument.i want to know the exact syntax of using DateDiff() procedure.

Thanx & Regards. Success is not a Destination, ... But a Journey !!

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 !!

The 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 !!

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 !!

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 doing a project in VB.net. Iam facing a strange problem while debugging. The problem is that, the execution of program does not stop at any break points, even if all the break points are enabled. B'coz of that I can't carryout the step by step execution of the program.

Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi !! I have a software developed using VB 6.0 and SQL server 2000.During the development stage we gave (hard coded) the server name as "SERVER1".But when I ran the same project on another m/c the DB doesn't get connected.The other m/c is having local SQL server. What will be the problem.Whether I'll have to change the code or the SQL server settings or both. Plz help me out.

Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi, Sorry but I don't know ur name. First I would like to thank u for ur quik response.But I would b requiring some more help.Plz help. I would like to know in wich ini file should I save the database path,Will I need to give additional attributes of the database like USERID,PASSWORD,LOCKTYPE in that file, and How should I execute that file from the application? Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi there , Can anyone tell me what apppath does? Can I give apppath to my database in VB 6.0. If yes, then what will happen if I change my location of the database from one server to another, and what should I do if in future I want to change my path of the database? Plz help me out. Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi, Can anyone tell me the diff. betn. nvarchar & varchar , and int & number datatypes in SQL 2000 Server database. Also I want to change the length of the data field of int datatype from 8 to 10, but I'm not able to change it. Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi, Can anybodyhelp me. While copying files from floppy diskette, I'm getting error message " Cannot copy. Data Error ( Cyclic Redundancy Check ). What is the cause of this error? What should be done if this error occurs? Is the p/b with floppy diskette or Floppy Disk Drive? Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi Chatura, asl plz. Nice signatures. Our football coach also says the same, " All ur mistakes r forgived, but none of the mistake should be repeated. " :) :) Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi, Can u specify whether u r updating ur database after filling the form? I think u need to refresh ur database/report before showing at runtime. Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi Rias, By executing SQL queries u can get the records for each customer individyally. Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi Dave, Thanx for ur response. I tried RefreshReport method, but unfortunately it didn't work. Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi Dave, Thanx for ur response. I tried the RefreshReport method but unfortunately it didn't work. Thanx & Regards. Success is not a Destination, ... But a Journey !!

Hi Campbells, I think u r right. Access has a limited data holding capacity than SQL of not more than 10,000 records per table. Thanx & Regards. Success is not a Destination, ... But a Journey !!