User Profile

Collapse

Profile Sidebar

Collapse
yaad
yaad
Last Activity: Dec 31 '07, 09:35 AM
Joined: Dec 31 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • yaad
    replied to DTS from SQL2000 to MS Access
    Go to Import and Export (DTS) wizard through strat menu which is always placed with sql200.
    First thing you should remember is you have to give two thingd.;
    1 datbase source (From what to copy)
    2 Destination (where to copy)

    Using DTS you can copy tables from access to acess,sql,notep ad and so on....In same way from other database to other or same.

    Step first.
    Give the data source of dastination....
    See more | Go to post

    Leave a comment:


  • yaad
    replied to Last four digits need to display in VB 6
    As you have already said you want to check of 6 digit to 13 so this code does not check that but checks to show XXX

    [CODE=vb]
    A = Text1.Text
    LENA = Len(A)
    C = Right(A, 4)
    For I = 1 To LENA - 4
    D = D & "x"
    Next
    E = D & C
    Label1.Caption = E
    [/CODE]
    See more | Go to post
    Last edited by Killer42; Jan 1 '08, 12:39 PM.

    Leave a comment:


  • If you want to use multiple check boxes then first be sure you are using a control array. After that while inserting data take this reference.

    If you have 11 controls then

    Let check box name be check1
    [CODE=vb]
    For I = 0 To 10
    STRA = STRA & "'" & Check1(I).Capti on & "'" & ","
    Next
    STRA = Mid(STRA, 1, Len(STRA) - 1)
    STRSQL = "INSERT...
    See more | Go to post
    Last edited by Killer42; Dec 31 '07, 08:35 AM.

    Leave a comment:

No activity results to display
Show More
Working...