Results 1 to 28 of 28

Thread: [RESOLVED] how to add & save pic to access with vb 6

Threaded View

  1. #1

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Resolved [RESOLVED] how to add & save pic to access with vb 6

    hello
    i did a project in vb 6 with customers
    and i cannot figure out how to add & save picture to access.
    i search the web but no luck
    hope you pro guys can help me
    this is the code for the saving customers.
    ****************************************

    Dim NewID As Long
    NewID = NextID("ID", "Customers")
    CN.Execute "INSERT INTO Customers (ID, FullName, Address, DateBirth, Facebook, Email, Phone, Cellular, HairColour, Oxygen) VALUES (" & _
    NewID & ", '" & _
    RplS(Txt(1).Text) & "', '" & _
    RplS(Txt(2).Text) & "', #" & _
    MyDate(PckBirth.Value) & "#, '" & _
    RplS(Txt(4).Text) & "', '" & _
    RplS(Txt(5).Text) & "', '" & _
    RplS(Txt(6).Text) & "', '" & _
    RplS(Txt(7).Text) & "', '" & _
    RplS(Txt(8).Text) & "', '" & _
    CmbOxygen.Text & "')"

    Set Itm = LsVw.ListItems.Add(, , Txt(1).Text)
    Itm.Tag = NewID
    Itm.Bold = True
    Itm.SubItems(1) = Txt(2).Text
    Itm.SubItems(2) = Format(PckBirth.Value, "dd/mm/yyyy")
    Itm.SubItems(3) = Txt(4).Text
    Itm.SubItems(4) = Txt(5).Text
    Itm.SubItems(5) = Txt(6).Text
    Itm.SubItems(6) = Txt(7).Text
    Itm.SubItems(7) = Txt(8).Text
    Itm.SubItems(8) = CmbOxygen.Text
    Itm.EnsureVisible
    Itm.Selected = True
    StBar.Panels(2) = Format(LsVw.ListItems.Count, "#,###0")

    If ChkRepeat.Value Then
    ClearDetails
    Txt(1).SetFocus
    Exit Sub
    End If
    TmrClose.Enabled = True
    *******************************
    im using a toolbar for this
    tnx in advanced
    Last edited by salsa31; Jan 2nd, 2012 at 10:36 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width