Predmet:Re: Spajanje arhiviranih baza
PreuzmiIzvorni kôd (Visual Basic):Function Transakcije()
Dim Db As Database
Dim Rs1 As Recordset, Rs2 As Recordset, Rs3 As Recordset
Dim IdTransakcije As Integer
Dim SQL1 As String, SQL2 As String, Skladiste As String
SQL1 = "SELECT * FROM tblTransakcije WHERE False<>false"
SQL2 = "SELECT * FROM tblUlazIzlaz WHERE False<>false"
Set Db = CurrentDb()
Set Rs1 = Db.OpenRecordset("Q_Stanje")
Set Rs2 = Db.OpenRecordset(SQL1)
Set Rs3 = Db.OpenRecordset(SQL2)
Do While Not Rs1.EOF
If Skladiste <> Rs1!Skladiste Then
Skladiste = Rs1!Skladiste
Rs2.AddNew
Rs2!Datum = Now()
Rs2!Skladiste = Rs1!Skladiste
Rs2!IDdokumenta = 16
Rs2!BrDokumenta = "n/a"
Rs2!PartnerID = DLookup("PartnerID", "tblPartneri", "Firma ='" & "Skladište " & Rs1!Skladiste & "'")
Rs2!Radninalog = "n/a"
Rs2!OperID = "Operater"
Rs2!StatusTR = 2
IdTransakcije = Rs2!IdTransakcije
Rs2.Update
End If
Rs3.AddNew
Rs3![IdTransakcije] = IdTransakcije
Rs3![Sifra] = Rs1![Sifra]
Rs3![Ulaz] = 0
Rs3![Izlaz] = Rs1![Stanje]
Rs3![Status] = 1
Rs3![DatumU] = Date
Rs3.Update
Rs1.MoveNext
Loop
Rs1.Close
Rs2.Close
Rs3.Close
Set Db = Nothing
End Function
Podrška samo putem foruma, jer samo tako i ostali imaju koristi od toga.