Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by oops4me

  1. oops4me

    Sharing CD-Writer

    i am working in network. on server CD-Writer(Samsung, internal) is attached. Can it is possible to share the cd-writer, so that i can burn the cd using nero burning s/w from my pc. if possible please tell me the procedure.
  2. oops4me

    sending email through Vb

    thanx to all of you for helping me. can u give me the code. how to use cdo. but i don't want third party mailing s/w(like MS Outlook/ outlook express) to send my mails. i want a code through which i can directly send mails through vb. also can any one give me code which will connect to smtp...
  3. oops4me

    Drop-down on Datagrid

    hello, see following link http://www.codeguru.com/forum/printthread.php?t=25922
  4. oops4me

    sending email through Vb

    hello, i got one code for sending mails through vb. th code is as follows Option Explicit Private nConnected As Boolean 'Private WithEvents Winsock1 As Winsock Private ptRetCode As Boolean Public Event Status(txtStatus As String) Sub SendBrainDead(txtServer As String, szEmailFrom As String...
  5. oops4me

    Date Problem in query

    thanx SQLBill i have give complete value i.e. storing in that field,like DOB >= '2005-10-05 00:00:00.000' then it is showing me the result. now i got the solution. thanx to all for helping me.
  6. oops4me

    Date Problem in query

    thanx to all of you for helping me yes i am using MSSQl server 2000. but when i am using '2005-10-05' then it doesn't show me any record. i am giving this query at MSSQL server query analyser. just tell me how i should give the query.
  7. oops4me

    Date Problem in query

    thanx for heping me for dob i ve take datatype as datetime. i ve tried DOB = '2005-10-05' but it is giving me error as it is not a character datatype. so please give me solution to check with datetime datatype. Ajay
  8. oops4me

    Date Problem in query

    hello, I have written following query select * from Candidate_Mst where Cand_fname='dsdsdsdhh' and Cand_lname='dsssgfg' and cand_email1= 'sdsfg' and DOB=2005-10-05 please tell me how to take check the date field in Mssql server. Because if i ve written query select * from Candidate_Mst...
  9. oops4me

    Overwrite the file

    hello thanx for your help. please tell me how to use filesystemobject in VB. it is giving me error at line where i ve written Dim fso As FileSystemObject as "user defined type not defined " we have to select any reference library?
  10. oops4me

    Overwrite the file

    Hello, I am copying the file from source path to destination path using FileSource="C:\abc.doc" FileDest="C:\c1.doc" FileSystem.FileCopy FileSource, FileDest first time it works fine as there is no file c1.doc but if i use it for overwriting file then it is giving me error as permission denied...
  11. oops4me

    Query writing Error in VB

    thanx for ur help.
  12. oops4me

    Query writing Error in VB

    Hello, I have written following query in Vb dim str11 as string str11="select case a.Company_id when 0 then '' Else: a.Comp_name end , case b.Desig_id when 0 then '' Else: b.Desig_name end , case c.Industry_id when 0 then '' Else: c.Ind_name end , case d.Function_id when 0 then '' Else...
  13. oops4me

    Query problem

    Hello, i got the solution. i ve added one record to each table where id =0 & its corresponding name=' '. so it is giving me the result as i required. like as follows comp_id |comp_name 0 | thanks for ur help
  14. oops4me

    Query problem

    hello, you are helping me lot, but the given code is not working. it is giving me output same as i was getting i.e. nothing. it is showing only column names if i use 0 as id value but not the required result. If i use any other value i.e. other than 0 like 1 then it is showing me proper...
  15. oops4me

    Query problem

    hello, thanks for ur help, but i am not getting ur answer.pls explain more Ajay

Part and Inventory Search

Back
Top