by using the following code u will be able to add data from first_name: dim Cn as new adodb.connection dim rs as new adodb.recordset dim str as string cn.Open "DSN-NAME", "UID", "PWD" Set rS.ActiveConnection = cn str_State = "Select DISTINCT FIELD-NAME from TABLE-NAME" rs.Open str, cn, adOpenStatic, adLockReadOnly For j = 1 To rs.RecordCount cmbo1.AddItem rs.Fields(0).Value rs.MoveNext Next If rs.State = 1 Then rs.Close Set rs = Nothing End If If cn.State = 1 Then cn.Close Set cn = Nothing End If

Add this following line into Command button click event or in LostFocus Event of TextBox: SaveSetting "ApplicationName", "Section", "Key" Add this line in form Load Event: TextBox = GetSetting("ApplicationName", "Section", "Key")

Hi, I am wiriting a program in visual basic for reading pdf file. I am able to open pdf file but i am loosing all bold,italic,underline text. it appears as a simple text. Is there any dll or ocx by which i can open a pdf file with all underline,italic,bold text? Thanks in Advance, Syed Saba

Yor are right i am looking for the same thing

Actullay i want to use winzip in my visual basic program and through that i want to zip or unzip html files. so i want to know how i can use winzip in my vb program through coding.

Hi, I want to write a program in vb by which the user can zip or unzip the selected files without opening winzip. How i can do that in vb. if any of you have any idea or source code please tell me. Thanks Syed Saba

Hi, In my current project i am using datagrid to display record from the employee table It consist of four feild. EmpName joiningdate Department Designation John 14/12/90 10 Clerk Smith 10/01/85 20 Programmer Smith 11/05/95 20 Programmer I need to know what column a user has selected and and the complete data of that row. e.g. if a user select Smith then how i can take his joining date from the data grid. ename=datagrid.text //giving me the name of the employee rownum=datagrid.row // giving the selected row number colnum=datagrid.col // giving the selected col number Thanks in advance

hi, can anybody tell that how i can open pdf file through vb or vb.net for reading Thanks in advance

Hi, I had developed one message system by using winsok in vb .now I want to run my application into system tray and when any message is revieved at that time that application will flash on the screen. can any body help? if possible give me code pls. Thanks in advance

check this avg(cast(field as int))

Hi, I had develope one project in vb 6.0 and sql server 7.0 now making the setup file through Package and Deployement wizard. I want to add the DATABASE and the DSN into the 'setup.exe' so that when i install the package the database and the DSN will automatically stored in the system. Is there any way to do it? if Yes? please send me the 'logic' or 'steps'or 'code' Thanks

Thanks let me check it out

Hi, I am using sql server 7.0 in that i am having a table of 3 feild i.e. empName, Logindate, HoursWorked select * from tablename Result: empName LoginDate HoursWorked ------- ------------ ------------ Amit 06/03/04 13:44:45 Amit 06/04/04 14:44:45 now i want the sum of the field "HoursWorked" Can any body help? Actually im taking 'LoginTime' and 'LogoutTime' Datatype 'DateTime' from "login" table and subtraction of this two field is strored in field 'TimeDiffrence' datatype varchar Query i m using is "convert(varchar(8),(logoutTime-loginTime),14)Timediffrence" now i want the sum of the field "Timediffrence"

Actually im taking 'LoginTime' and 'LogoutTime' Datatype 'DateTime' from "login" table and subtraction of this two field is strored in field 'TimeDiffrence' datatype varchar Query i m using is "convert(varchar(8),(logoutTime-loginTime),14)Timediffrence" now i want the sum of the field "Timediffrence"

Hi, I am using sql server 7.0 in that i am having a table of 3 feild i.e. empName, Logindate, HoursWorked select * from tablename Result: empName LoginDate HoursWorked ------- ------------ ------------ Amit 06/03/04 13:44:45 Amit 06/04/04 14:44:45 now i want the sum of the field "HoursWorked" Can any body help?

When iam extracting a date from SQL Svr 7 and i want it to be in a specific format, isn't there a SQL command that will do the formatting? system date '2004-06-09 13:43:41.363' i want this date in 'mm\dd\yy' format If so, could you give me the syntax and the associated style codes. Thanks syed saba

iam developing a website in ASP and iam totally new to asp.iam having two frames in my first frame which is my default page iam having four listboxes which is dynamicaly related to each other .now i want to pass the selected value from the fourth list box to another combobox which is in another frame now can you just help me?how to go about it?