Search results for query: *

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?

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

my self avi developing accounting application in VB6 and Access for traders. i have 2 tables AccountTable And Accounthead Table Fields r AccountTable - Accountcode Double [AutoIncremented i.e max value of in table] Accountname String Accounthead - PrimaryGroup...

hello myself avi developing application in vb and access i want to fomrat the fields in select statement i.e i want to control digits after decimal pt. in select statement. plwase read following e.g. carefully and help me. i have Salesvoucher Table in my database in which there is one field...

hello my self avi i m working in vb and sqlserver in my customermaster table there is more than 10000 reocrds and when i m going to insert that all records in listbox or combobox it takes too much time to load individual record. how can i directly add all recorts my code sample StrSql = ""...

i am developing a bank application in vb 6 and sql server. i have 2 tables. one is LoanPayment and Other is LoanReceived when bank gives any loan to customer it is saved in LoanPayment Table with its name and deal no{deal no changes from customer to customer i.e suppose Mr. XYZ has taken 3 loans...

my self avinash i m developing one application in vb 6 and sql server 7 i have one table name - Salesvoucher which has fields like voucherno,voucherdate,debitto,creditto,amount. i want to show all my voucher records in ascending order by date. when i display it i used some button to navigate...

hello myself avi i am working in vb 6 and using ado library i have some problem regarding array redimension. i used array which is return from ado's getrows method. it is 2 dimensional array. my first query returns me total 76 records i.e my array ubound=76 and i want to add second queries...

hi my self andy, i am developing one application in vb 6 and sqlserver 7 as back end. i write one insert query for inserting one record. there is one voucherdate fied. to which i am passing my date value as a parameter. bu when i execute that query it stores 01/01/1999 instead of my pass data...