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!

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

Search results for query: *

  1. andypower

    importing Null values while importing data in SQL server

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

    How To Format date in vb6.0 and Access

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

    how to do email from vb without using outlook express

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

    how to find application Path running from server

    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?
  5. andypower

    How do I find user name by using IP or machine name?

    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?
  6. andypower

    How to close Excel In Visual Basic

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

    how to append data in text file in vb 6 by using dao

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

    How to close Excel In Visual Basic

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

    how to clear dynamic array

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

    how to check null in query if i use access

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

    how to build this query

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

    how to check out null in select statement

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

    how to find out no of user tables in u r database

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

    how to use IIf In Select / Insert Ststement

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

    how to format this string

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

    How To Write This Crytical query

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

    how can i format fields in select statement

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

    how can i add array data directly in listbox or combobox

    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 = ""...
  19. andypower

    how cani build this critical query

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

    how can i build this query

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

Part and Inventory Search

Back
Top