Recent content by andypower

Hi guies Thanks in advance.... I'm using MS SQL 7's DTS Import wizard to import the Data from Excel. Now the problem is, there one col in a excel which contains a some numeric data and Alpha numeric data. now if i imported that excel into the SQL server it is placing NULL values either in...

my self avi i m developing one application in vb 6 and access by using ado library. when i m inserting record in database the date i want to insert is "09/12/2005" but it stores as "12/09/2005". i format that date format command in dd/mm/yyyy way and even i use cdate() function but it wont work...

hi myself avi i m developing application in vb and i want to do email but i dont want to use outlook express and cdont,mapi control so plz suggest me any idea to do this thnx in advance

hi I m running exe on client machine but its database is on server machine.i want the path of my application which is on server.Can anyone help me out?

I m running exe on client machine but its database is on server machine.i want the path of my application which is on server.Can anyone help me out?

Dim myBook As Excel.Workbook Dim exObj As object Set myBook = Workbooks.Open(filename:=StrPath) Set exObj = createObject("excelApplication") exObj.ActiveWorkbook.Worksheets(cnt + 1).Activate (some code) mybook.close set mybook=nothing exobj.usercontrol=false...

hello my self avi developing one industrial related software. here i m using DAO liabrary. i want to transfer some my data in text file. i dont know any thing about file handling in vb. so please some one help me How To Open text file How To Append Data How To check out file all ready exit or...

Hi, Dim myBook As Excel.Workbook Dim exObj As Excel.Application Set myBook = Workbooks.Open(filename:=StrPath) Set exObj = New Excel.Application exObj.ActiveWorkbook.Worksheets(cnt + 1).Activate (some code) mybook.close exobj.activeworkbook.close I have use these...

i m developing one application in vb 6. i used one dynamic array to stored data.to store data i used Redim and Preserve. but after one use i want to use same array in same procedure for other purpose for that i want to clear that array i. i dont want to change its no of columns but i want set...

hello my self avi and i m developing bank application in vb 6 and ms access and ado2.1 i want to find out sum of amount from Receiptvoucher table. but when there r no any record it return NULL and ineed to check that explicitly after executing query. i dont want to check out that explicitly. i...

hello my self avi. i m developing one bank application in vb 6 and ms access and ado i have one table Receiptvoucher. fileds r as follows Transid - double - primary key Name string ReceiptDate Date Amount Currency suppose Mr. Amir has saving A/c in bank. and he deposit daily...

hello i m developing application in vb 6 and sql server 7 i want to retrive sum of amount from my salesvoucher table so my query is select sum(amount) from Salesvoucher whene there r no data in my table then it returns NULL and need to check that . i m checking that in following ways...

i m using vb 6 and sql server 7 i want to find out no of user table[i.e created by user not system table ]in my sql server database. suppose my database name is JewellersData. how to write query for that in vb 6 or in query analizer

i m developing an application in vb 6 and sql server 7 i want to copy some records from Voucher table to another table-AcCashBook. i used insert and select query but i want to use iff condition in select statement plz help me in building this query StrSQL = "Insert Into...

i m developing application in vb 6 and sql server 7. in my Customertable there r almost 700-800 records. i want to add all these records in list box. i use getstring method of ado to get that string in that i pass vbcrlf and also chr(13) function to seperate row but in list box instead of new...