Can you help me out is it possible to display some images stored in m.acess to my vb6 form using ado.. ???
and also after i have managed to complete my data base how can i transform it into a form and print it.
here is sum codes i have researched... pls check ..
CODE
******Code Example ********
ÿ ÿ Dim AppAccess As Access.Application
ÿ ÿ Dim DatabaseName As String
ÿ ÿ Set AppAccess = New Access.Application
ÿ ÿ On Error GoTo ErrorPrinting
ÿ ÿ
ÿ ÿ DatabaseName = App.Path + "\Millwood4.mdb"
ÿ ÿ AppAccess.OpenCurrentDatabase (DatabaseName)
ÿ ÿ AppAccess.DoCmd.OpenReport "Invoice", acViewNormal
ÿ ÿ AppAccess.CloseCurrentDatabase
ÿ ÿ Set AppAccess = Nothing
ÿ ÿ Screen.MousePointer = vbDefault
ÿ ÿ Exit Sub
ÿ ÿ
ErrorPrinting:
ÿ ÿ MsgBox "Error printing HortiInvoice: " & CStr(Err.Number) & Err.Description, _
ÿ ÿ ÿ ÿ vbInformation, "Error"
ÿ ÿ Err.Clear
ÿ ÿ Exit Sub
End Sub
' ***********END OF CODE EXAMPLE ***********
tnx
12 Jan, 2008 - 05:59 AM
| 