Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
SELECT MRPCn, Material, [Action code], Right$("0000" & Getalletje([comment]),4) AS Weeknumber, IIf(InStr(1,[comment]," ")=0,"Fout","Goed") AS Expr2
FROM tbl_ZOPS
WHERE (([Action code]="WRITE OFF") AND ((Right$("0000" & Getalletje([comment]),4))<Right$("00" & CStr(Year(Date())),2) & (Right$("00" & CStr(ISOWeekNummer(Date())),2)-12)) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="Goed")) OR (([Action code]="Cancel") AND ((Right$("0000" & Getalletje([comment]),4))<Right$("00" & CStr(Year(Date())),2) & (Right$("00" & CStr(ISOWeekNummer(Date())),2)-10)) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="Goed"));
Function Getalletje(Veld As String)
Dim i As Byte, x As Byte, iWaarde As Long
If Nz(Veld, "") = "" Then GoTo Leeg
i = 1
Do Until IsNumeric(Mid(Veld, i, 1))
If i = Len(Veld) Then
Exit Function
End If
i = i + 1
Loop
Do While IsNumeric(Mid(Veld, i, 1))
iWaarde = iWaarde & Mid(Veld, i, 1)
i = i + 1
Loop
Getalletje = iWaarde
Exit Function
Leeg:
Getalletje = 1
End Function
<IIf(ISOWeekNummer(Date())-52<0;CStr(Right$(((Year(Date())-1));2) & Abs(ISOWeekNummer(Date())-52));Right$("00" & CStr(Year(Date()));2) & Right$("00" & CStr(ISOWeekNummer(Date())-52);2))
<IIf(ISOWeekNummer(Date())-52<0;CStr(Right$(((Year(Date())-1));2) & Abs(ISOWeekNummer(Date())-52));Right$("00" & CStr(Year(Date()));2) & Right$("00" & CStr(ISOWeekNummer(Date())-52);2))
SELECT MRPCn, Material, [Action code], Right$("0000" & Getalletje([comment]),4) AS Weeknumber, IIf(InStr(1,[comment]," ")=0,"Fout","Goed") AS Expr2
FROM tbl_ZOPS
WHERE (([Action code]="WRITE OFF") AND ((Right$("0000" & Getalletje([comment]),4))<Right$("00" & CStr(Year(Date())),2) & (Right$("00" & CStr(ISOWeekNummer(Date())),2)-12)) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="Goed")) OR (([Action code]="Cancel") AND ((Right$("0000" & Getalletje([comment]),4))<Right$("00" & CStr(Year(Date())),2) & (Right$("00" & CStr(ISOWeekNummer(Date())),2)-10)) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="Goed"));
SELECT MRPCn, Material, [Action code], Right$("0000" & Getalletje([comment]),4) AS Weeknumber, IIf(InStr(1,[comment]," ")=0,"Fout","Goed") AS Expr2
FROM tbl_ZOPS
WHERE (
([Action code]="WRITE OFF")
AND (Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNummer(Date())-[Forms]![Formuliernaam]![InvulWaarde]<0;CStr(Right$(((Year(Date())-1));2) & Abs(ISOWeekNummer(Date())-
[Forms]![Formuliernaam]![InvulWaarde]));Right$("00" & CStr(Year(Date()));2) & Right$("00" & CStr(ISOWeekNummer(Date())-[Forms]![Formuliernaam]![InvulWaarde]);2))
AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="Goed") )
SELECT tbl_ZOPS.MRPCn, tbl_ZOPS.Material, tbl_ZOPS.[Action code], Right$("0000" & Getalletje([comment]),4) AS Weeknumber, IIf(ISOWeekNummer(Date())-Forms!Test!InvulVeld<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNummer(Date())-Forms!Test!InvulVeld)),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNummer(Date())-Forms!Test!InvulVeld),2)) AS Expr1
FROM tbl_ZOPS
WHERE (((tbl_ZOPS.[Action code])="WRITE OFF") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNummer(Date())-[B][COLOR="blue"]Nz([Forms]![Test]![InvulVeld],0)[/COLOR][/B]<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNummer(Date())-[B][COLOR="blue"]Nz([Forms]![Test]![InvulVeld],0)[/COLOR][/B])),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNummer(Date())-[B][COLOR="blue"]Nz([Forms]![Test]![InvulVeld],0)[/COLOR][/B]),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="Goed")) OR (((tbl_ZOPS.[Action code])="Cancel") AND ((Right$("0000" & Getalletje([comment]),4))<Right$("00" & CStr(Year(Date())),2) & (Right$("00" & CStr(ISOWeekNummer(Date())),2)-10)) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="Goed"));
SELECT tbl_ZOPS.MRPCn, tbl_ZOPS.Material, tbl_ZOPS.[Action code], Right$("0000" & Getalletje([comment]),4) AS Weeknumber
FROM tbl_ZOPS
WHERE (((tbl_ZOPS.[Action code])="WRITE OFF") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![writeoff],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![writeoff],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![writeoff],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="Goed")) OR (((tbl_ZOPS.[Action code])="Cancel") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![cancel],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![cancel],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![cancel],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="Goed")) OR (((tbl_ZOPS.[Action code])="upgrade") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![upgrade],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![upgrade],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![upgrade],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="sell back") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![sellback],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![sellback],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![sellback],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="review") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![review],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![review],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![review],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="physical scrap") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![physicalscrap],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![physicalscrap],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![physicalscrap],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="usable with requirements") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![usuablewithrequirements],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![usuablewithrequirements],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![usuablewithrequirements],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="incorrect in overplanned") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![incorrectinoverplanned],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![incorrectinoverplanned],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![incorrectinoverplanned],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="max re-out") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![maxre-out],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![maxre-out],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![maxre-out],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="repair") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![repair],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![repair],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![repair],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="refurbish") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![refurbish],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![refurbish],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![refurbish],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="transfer to other plant") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![transfertootherplant],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![transfertootherplant],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![transfertootherplant],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed")) OR (((tbl_ZOPS.[Action code])="partial scrap") AND ((Right$("0000" & Getalletje([comment]),4))<IIf(ISOWeekNumber(Date())-nz([tbl_weekcode]![partialscrap],0)<0,CStr(Right$(((Year(Date())-1)),2) & Abs(ISOWeekNumber(Date())-nz([tbl_weekcode]![partialscrap],0))),Right$("00" & CStr(Year(Date())),2) & Right$("00" & CStr(ISOWeekNumber(Date())-nz([tbl_weekcode]![partialscrap],0)),2))) AND ((IIf(InStr(1,[comment]," ")=0,"Fout","Goed"))="goed"));
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.