Newsgroup: it.comp.appl.access
Titolo: report access 2000 in formato pdf

E' possibile trasformare un report di access2000 in formato pdf e inviarlo 
come allegato ad un e-mail ?
se si come posso inserirlo in un'applicazione in modo che l'utente possa 
selezionarlo ?
Ho già fatto eperimenti con Pdf Creator ma vorrei rendere automatico il 
processo come posso fare ?
grazie
-- 
Galbiati Sergio
e-mail  
gal...@aliceposta.it
 

 ha scritto nel messaggio 
news:jDcid.258502$35.12...@news4.tin.it...

Ciao,
hai lanciato il faqquone!!! Scherzo ;o)
Se leggi nei vari post precedenti di questi ultimi 1\2\3 anni circa troverai 
tutti gli help a te necessari.
Il discorso della generazione del pdf da report è stato gi a trattato sotto 
diversi aspetti, quindi credo potrai avvalerti di molteplici soluzioni.
Buona giornata,
-- 
strano...mavero
L'universo è cambiamento; la nostra vita è il risultato dei nostri pensieri.
Marco Aurelio 

 grazie
Ciao,
io uso A97 ed ho implementato, grazie anche agli aiuti del NG, il seguente
codice che si attiva sulla pressione di un tasto:
Private Sub SalvaOrdine_Click()
    Dim strPathDoc As String
    Dim Predefinita As String
    Dim strReport As String
    Dim stCriteriCollegamento As String
    Dim strFileName As String
 
    On Error GoTo Err_Stampa_Click
 
    strPathDoc = PathCorrente & "\OrdiniStampati\"
    Predefinita = Nz(GetDefaultPrinter, "")
    strReport = "StampaOrdiniProduzione"
    stCriteriCollegamento = "IDOrdine = Forms!OrdiniProduzione!IDOrdine"
    strFileName = "Order n° " & Forms!OrdiniProduzione!IDOrdine & ".pdf"
    gstrCallingForm = Me.name
    SetDefaultPrinter "Acrobat PDFWriter"
    Call SaveReportAsPDF(strReport, strPathDoc & strFileName,
stCriteriCollegamento)
    SetDefaultPrinter (Predefinita)
 
Exit_Stampa_Click:
    Exit Sub
Err_Stampa_Click:
    MsgBox Err.Description
    Resume Exit_Stampa_Click
 
End Sub
Note:
1. Nel mio DB mi serviva per salvare un ordine di produzione;
2. Ho installato il driver PDF della Adobe;
3. In un modulo ho inserito il seguente codice per cambiare/ripristinare
la stampante di default (GetDefaultPrinter e SetDefaultPrinter):
Declare Function GetProfileSection& Lib "kernel32" Alias
"GetProfileSectionA" (ByVal lpAppName As String, ByVal lpReturnedString As
String, ByVal nSize As Long)
Declare Function GetProfileString& Lib "kernel32" Alias
"GetProfileStringA" (ByVal lpAppName As String, ByVal lpKeyName As String,
ByVal lpDefault As String, ByVal lpReturnedString As String, ByVal nSize
As Long)
Declare Function WriteProfileString& Lib "kernel32" Alias
"WriteProfileStringA" (ByVal lpszSection As String, ByVal lpszKeyName As
String, ByVal lpszString As String)
Public DefaultPrinter As String
Public Function SostCar(s As String, c1 As String, c2 As String) As String
'sostituisce un carattere con un altro in una stringa (solo prima
occorrenza)
Dim pos As Integer
pos = InStr(1, s, c1)
If pos > 0 Then Mid(s, pos) = c2
SostCar = s
End Function
Public Sub SetDefaultPrinter(s As String)
'imposta la stampante passata come argomento a predefinita
On Error GoTo Esci
Dim x As Long
If IsNull(s) Or s = "" Then Exit Sub
x = WriteProfileString("windows", "device", vbNullString)
DoEvents
x = WriteProfileString("windows", "device", s)
DoEvents
Esci:
End Sub
Public Sub ResetDefaultPrinter()
'reimposta a predefinita la stampante memorizzata nella var globale
SetDefaultPrinter (DefaultPrinter)
End Sub
Public Function GetDefaultPrinter() As String
'ritorna il nome della stampante predefinita
Dim x As Integer
Dim buffer As String
buffer = Space$(255)
x = GetProfileString("windows", "device", "?", buffer, 255)
GetDefaultPrinter = Left$(buffer, x)
End Function
4. In un altro modulo ho inserito il seguente codice per salvare il file
in formato PDF (SaveReportAsPDF):
Public Const REG_SZ As Long = 1
   Public Const REG_DWORD As Long = 4
   Public Const HKEY_CLASSES_ROOT = &H80000000
   Public Const HKEY_CURRENT_USER = &H80000001
   Public Const HKEY_LOCAL_MACHINE = &H80000002
   Public Const HKEY_USERS = &H80000003
   Public Const ERROR_NONE = 0
   Public Const ERROR_BADDB = 1
   Public Const ERROR_BADKEY = 2
   Public Const ERROR_CANTOPEN = 3
   Public Const ERROR_CANTREAD = 4
   Public Const ERROR_CANTWRITE = 5
   Public Const ERROR_OUTOFMEMORY = 6
   Public Const ERROR_ARENA_TRASHED = 7
   Public Const ERROR_ACCESS_DENIED = 8
   Public Const ERROR_INVALID_PARAMETERS = 87
   Public Const ERROR_NO_MORE_ITEMS = 259
   Public Const KEY_QUERY_VALUE = &H1
   Public Const KEY_SET_VALUE = &H2
   Public Const KEY_ALL_ACCESS = &H3F
   Public Const REG_OPTION_NON_VOLATILE = 0
   Declare Function RegCloseKey Lib "advapi32.dll" _
   (ByVal hKey As Long) As Long
   Declare Function RegCreateKeyEx Lib "advapi32.dll" Alias _
   "RegCreateKeyExA" (ByVal hKey As Long, ByVal lpSubKey As String, _
   ByVal Reserved As Long, ByVal lpClass As String, ByVal dwOptions _
   As Long, ByVal samDesired As Long, ByVal lpSecurityAttributes _
   As Long, phkResult As Long, lpdwDisposition As Long) As Long
   Declare Function RegOpenKeyEx Lib "advapi32.dll" Alias _
   "RegOpenKeyExA" (ByVal hKey As Long, ByVal lpSubKey As String, _
   ByVal ulOptions As Long, ByVal samDesired As Long, phkResult As _
   Long) As Long
   Declare Function RegQueryValueExString Lib "advapi32.dll" Alias _
   "RegQueryValueExA" (ByVal hKey As Long, ByVal lpValueName As _
   String, ByVal lpReserved As Long, lpType As Long, ByVal lpData _
   As String, lpcbData As Long) As Long
   Declare Function RegQueryValueExLong Lib "advapi32.dll" Alias _
   "RegQueryValueExA" (ByVal hKey As Long, ByVal lpValueName As _
   String, ByVal lpReserved As Long, lpType As Long, lpData As _
   Long, lpcbData As Long) As Long
   Declare Function RegQueryValueExNULL Lib "advapi32.dll" Alias _
   "RegQueryValueExA" (ByVal hKey As Long, ByVal lpValueName As _
   String, ByVal lpReserved As Long, lpType As Long, ByVal lpData _
   As Long, lpcbData As Long) As Long
   Declare Function RegSetValueExString Lib "advapi32.dll" Alias _
   "RegSetValueExA" (ByVal hKey As Long, ByVal lpValueName As String, _
   ByVal Reserved As Long, ByVal dwType As Long, ByVal lpValue As _
   String, ByVal cbData As Long) As Long
   Declare Function RegSetValueExLong Lib "advapi32.dll" Alias _
   "RegSetValueExA" (ByVal hKey As Long, ByVal lpValueName As String, _
   ByVal Reserved As Long, ByVal dwType As Long, lpValue As Long, _
   ByVal cbData As Long) As Long
'**********************************************************
Public Sub SaveReportAsPDF(strReportName As String, strPath As String,
stCriteriCollegamento As String)
    Dim strOldDefault As String
    strOldDefault =
QueryKey("Software\Microsoft\WindowsNT\CurrentVersion\Windows", "Device")
    SetKeyValue "Software\Microsoft\Windows NT\CurrentVersion\Windows",
"Device", "Acrobat PDFWriter", REG_SZ
    SetKeyValue "Software\Adobe\Acrobat PDFWriter", "PDFFilename",
strPath, REG_SZ
    SetKeyValue "Software\Adobe\Acrobat PDFWriter", "bExecViewer", 0,
REG_SZ
    DoCmd.OpenReport strReportName, , , stCriteriCollegamento
    SetKeyValue "Software\Microsoft\Windows NT\CurrentVersion\Windows",
"Device", strOldDefault, REG_SZ
End Sub
   Public Function SetValueEx(ByVal hKey As Long, sValueName As String,
lType As Long, vValue As Variant) As Long
       Dim lValue As Long
       Dim sValue As String
       Select Case lType
           Case REG_SZ
               sValue = vValue & Chr$(0)
               SetValueEx = RegSetValueExString(hKey, sValueName, 0&, _
                                              lType, sValue, Len(sValue))
           Case REG_DWORD
               lValue = vValue
               SetValueEx = RegSetValueExLong(hKey, sValueName, 0&, _
   lType, lValue, 4)
           End Select
   End Function
   Function QueryValueEx(ByVal lhKey As Long, ByVal szValueName As _
   String, vValue As Variant) As Long
       Dim cch As Long
       Dim lrc As Long
       Dim lType As Long
       Dim lValue As Long
       Dim sValue As String
       On Error GoTo QueryValueExError
       ' Determine the size and type of data to be read
       lrc = RegQueryValueExNULL(lhKey, szValueName, 0&, lType, 0&, cch)
       If lrc <> ERROR_NONE Then Error 5
       Select Case lType
           ' For strings
           Case REG_SZ:
               sValue = String(cch, 0)
   lrc = RegQueryValueExString(lhKey, szValueName, 0&, lType, _
   sValue, cch)
               If lrc = ERROR_NONE Then
                   vValue = Left$(sValue, cch - 1)
               Else
                   vValue = Empty
               End If
           ' For DWORDS
           Case REG_DWORD:
   lrc = RegQueryValueExLong(lhKey, szValueName, 0&, lType, _
   lValue, cch)
               If lrc = ERROR_NONE Then vValue = lValue
           Case Else
               'all other data types not supported
               lrc = -1
       End Select
QueryValueExExit:
       QueryValueEx = lrc
       Exit Function
QueryValueExError:
       Resume QueryValueExExit
   End Function
Public Function CreateNewKey(sNewKeyName As String, lPredefinedKey As Long)
    Dim hNewKey As Long         ' Handle to the new key
    Dim lRetVal As Long         ' Result of the RegCreateKeyEx function
    lRetVal = RegCreateKeyEx(lPredefinedKey, sNewKeyName, 0&,
vbNullString, REG_OPTION_NON_VOLATILE, KEY_ALL_ACCESS, 0&, hNewKey,
lRetVal)
    RegCloseKey (hNewKey)
End Function
Public Function SetKeyValue(sKeyName As String, sValueName As String,
vValueSetting As Variant, lValueType As Long)
    Dim lRetVal As Long         ' Result of the SetValueEx function
    Dim hKey As Long            ' Handle of open key
    ' Open the specified key
    lRetVal = RegOpenKeyEx(HKEY_CURRENT_USER, sKeyName, 0, KEY_SET_VALUE,
hKey)
    lRetVal = SetValueEx(hKey, sValueName, lValueType, vValueSetting)
    RegCloseKey (hKey)
End Function
Public Function QueryKey(sKeyName As String, sValueName As String)
    Dim lRetVal As Long         ' Result of the API functions
    Dim hKey As Long            ' Handle of opened key
    Dim vValue As Variant       ' Setting of queried value
    lRetVal = RegOpenKeyEx(HKEY_CURRENT_USER, sKeyName, 0,
KEY_QUERY_VALUE, hKey)
    lRetVal = QueryValueEx(hKey, sValueName, vValue)
    QueryKey = vValue
    RegCloseKey (hKey)
End Function
Public Function PathCorrente() As String
   'Autore: Paolo Holzl
   'Restituisce: il percorso completo del database corrente
   PathCorrente = Left(CurrentDb.name, Len(CurrentDb.name) - _
            Len(Dir(CurrentDb.name)))
End Function
5. Per l'invio via e-mail ho adattato il codice postatomi da costabis che,
però, serve per Lotus Notes; credo che per Outlook sia addirittura più
semplice.
Ciao,
DEL_REC
-- 
questo articolo e` stato inviato via web dal servizio gratuito 
http://www.newsland.it/news
 segnala gli abusi ad 
ab...@newsland.it