1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118
|
'-----------------------------------------------------------
' Check if datum of dtafrais are already sent
'-----------------------------------------------------------
Public Function Application_envoi_frais()
Dim dbs As Database
Dim rds As Recordset
Dim strsql As String
Dim strFichier As String
Dim mystr As String
Dim mystrT As String
Dim mydate As Date
Dim MyTime
mydate = Date
MyTime = Time
mystrT = Format(MyTime, "h_m_s")
mystr = Format(mydate, " ddmmyyyy")
strFichier = "u:\frais\document" & "_" & mystr & "_" & mystrT & ".csv"
strsql = "SELECT * FROM dtaFrais WHERE (((DateDiff('d',[incidentdate],Now()))>=1)and flag= no);"
Set dbs = CurrentDb
Set rds = dbs.OpenRecordset(strsql, dbOpenSnapshot)
''' Stop if the record doesn't exist anymore
If rds.EOF And rds.BOF Then
rds.Close
Set rds = Nothing
dbs.Close
Set dbs = Nothing
Exit Function
Else
DoCmd.OutputTo acOutputQuery, "qdfsend", acFormatXLS, strFichier
'DoCmd.TransferText acExportDelim, "qdfsend.xls", "qdfsend", strFichier, False
'elimine le message d'avertissement de l'update
DoCmd.SetWarnings False
'execute l'update sous certaines conditions
DoCmd.RunSQL "UPDATE dtaFrais SET dtaFrais.flag = Yes WHERE (((DateDiff('d',[incidentdate],Now()))>=1) And flag=No);"
End If
''' Open the recordset
'Set dbs = CurrentDb
'Set rdsfiles = dbs.OpenRecordset(strsql, dbOpenSnapshot)
Set rds = Nothing
'close and reset
dbs.Close
Set dbs = Nothing
End Function
'-----------------------------------------------------------
' Check if datum of dtafiles are already sent for GED
'-----------------------------------------------------------
Public Function Application_envoi_ged()
Dim dbs As Database
Dim rds As Recordset
Dim strsql As String
Dim strFichier As String
Dim mystr As String
Dim mydate As Date
mydate = Date
mystr = Format(mydate, " ddmmyyyy")
strFichier = "u:\ged\documentged" & "_" & mystr & "_" & Time & ".csv"
strsql = "SELECT * FROM dtafiles WHERE ( (((DateDiff('d',[interestsdate1],Now()))>=1) And flag1=No)or (((DateDiff('d',[interestsdate2],Now()))>=1) And flag2=No) or(((DateDiff('d',[interestsdate3],Now()))>=1) And flag3=No)or (((DateDiff('d',[interestsdate4],Now()))>=1) And flag4=No));"
Set dbs = CurrentDb
Set rds = dbs.OpenRecordset(strsql, dbOpenSnapshot)
''' Stop if the record doesn't exist anymore
If rds.EOF And rds.BOF Then
rds.Close
Set rds = Nothing
dbs.Close
Set dbs = Nothing
Exit Function
Else
DoCmd.TransferText acExportDelim, "", "qdfsendged", strFichier, True
'elimine le message d'avertissement de l'update
DoCmd.SetWarnings False
'execute l'update sous certaines conditions
DoCmd.RunSQL "UPDATE dtaFiles SET dtaFiles.flag1 = Yes WHERE (((DateDiff('d',[interestsdate1],Now()))>=1) And flag1=No);"
DoCmd.RunSQL "UPDATE dtaFiles SET dtaFiles.flag2 = Yes WHERE (((DateDiff('d',[interestsdate2],Now()))>=1) And flag2=No);"
DoCmd.RunSQL "UPDATE dtaFiles SET dtaFiles.flag3 = Yes WHERE (((DateDiff('d',[interestsdate3],Now()))>=1) And flag3=No);"
DoCmd.RunSQL "UPDATE dtaFiles SET dtaFiles.flag4 = Yes WHERE (((DateDiff('d',[interestsdate4],Now()))>=1) And flag4=No);"
End If
''' Open the recordset
'Set dbs = CurrentDb
'Set rdsfiles = dbs.OpenRecordset(strsql, dbOpenSnapshot)
Set rds = Nothing
'close and reset
dbs.Close
Set dbs = Nothing
End Function |
Partager