Private Sub funktiesknop_Click()
On Error GoTo Err_funktiesknop_Click
Dim DocName As String
Dim LinkCriteria As String
DocName = “Funkties”
DoCmd.OpenForm DocName, , , LinkCriteria
Exit_funktiesknop_Click:
Exit Sub
Err_funktiesknop_Click:
MsgBox Error$
Resume Exit_funktiesknop_Click
End Sub
Private Sub Knop129_Click()
On Error GoTo Err_Knop129_Click
DoCmd.GoToRecord , , A_FIRST
Exit_Knop129_Click:
Exit Sub
Err_Knop129_Click:
MsgBox Error$
Resume Exit_Knop129_Click
End Sub
Private Sub Knop145_Click()
On Error GoTo Err_Knop145_Click
DoCmd.GoToRecord , , A_FIRST
Exit_Knop145_Click:
Exit Sub
Err_Knop145_Click:
MsgBox Error$
Resume Exit_Knop145_Click
End Sub
Private Sub Knop169_Click()
On Error GoTo Err_Knop169_Click
Dim DocName As String
DocName = “leverancier lijst”
DoCmd.OpenReport DocName, A_NORMAL
Exit_Knop169_Click:
Exit Sub
Err_Knop169_Click:
MsgBox Error$
Resume Exit_Knop169_Click
End Sub
Private Sub Kontaktpersonen_Word_Click()
On Error GoTo Err_Kontaktpersonen_Word_Click
Dim DocName As String
Dim LinkCriteria As String
DocName = “Kontaktpersonen (oud)”
LinkCriteria = " = Forms!!"
DoCmd.OpenForm DocName, , , LinkCriteria
Exit_Kontaktpersonen_Word_Click:
Exit Sub
Err_Kontaktpersonen_Word_Click:
MsgBox Error$
Resume Exit_Kontaktpersonen_Word_Click
End Sub
Private Sub Leverancierslijst_Click()
On Error GoTo Err_Leverancierslijst_Click
Dim DocName As String
DocName = “leverancier lijst”
DoCmd.OpenReport DocName, A_PREVIEW
Exit_Leverancierslijst_Click:
Exit Sub
Err_Leverancierslijst_Click:
MsgBox Error$
Resume Exit_Leverancierslijst_Click
End Sub
Private Sub Nieuw_knop_Click()
On Error GoTo Err_Nieuw_knop_Click
DoCmd.GoToRecord , , A_NEWREC
Exit_Nieuw_knop_Click:
Exit Sub
Err_Nieuw_knop_Click:
MsgBox Error$
Resume Exit_Nieuw_knop_Click
End Sub
Private Sub Ongedaan_knop_Click()
On Error GoTo Err_Ongedaan_knop_Click
DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_UNDOFIELD, , A_MENU_VER20
Exit_Ongedaan_knop_Click:
Exit Sub
Err_Ongedaan_knop_Click:
MsgBox Error$
Resume Exit_Ongedaan_knop_Click
End Sub
Private Sub Opslaan_knop_Click()
On Error GoTo Err_Opslaan_knop_Click
DoCmd.DoMenuItem A_FORMBAR, A_FILE, A_SAVERECORD, , A_MENU_VER20
Exit_Opslaan_knop_Click:
Exit Sub
Err_Opslaan_knop_Click:
MsgBox Error$
Resume Exit_Opslaan_knop_Click
End Sub
Private Sub Sluiten_knop_Click()
On Error GoTo Err_Sluiten_knop_Click
DoCmd.Close
Exit_Sluiten_knop_Click:
Exit Sub
Err_Sluiten_knop_Click:
MsgBox Error$
Resume Exit_Sluiten_knop_Click
End Sub
Private Sub Tiltelknop_Click()
On Error GoTo Err_Tiltelknop_Click
Dim DocName As String
Dim LinkCriteria As String
DocName = “titel”
DoCmd.OpenForm DocName, , , LinkCriteria
Exit_Tiltelknop_Click:
Exit Sub
Err_Tiltelknop_Click:
MsgBox Error$
Resume Exit_Tiltelknop_Click
End Sub
Private Sub Verwijder_knop_Click()
On Error GoTo Err_verwijder_knop_Click
DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_SELECTRECORD_V2, , A_MENU_VER20
DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_DELETE_V2, , A_MENU_VER20
Exit_verwijder_knop_Click:
Exit Sub
Err_verwijder_knop_Click:
MsgBox Error$
Resume Exit_verwijder_knop_Click
End Sub
Private Sub Volgende_knop_Click()
On Error GoTo Err_Volgende_knop_Click
DoCmd.GoToRecord , , A_NEXT
Exit_Volgende_knop_Click:
Exit Sub
Err_Volgende_knop_Click:
MsgBox Error$
Resume Exit_Volgende_knop_Click
End Sub
Private Sub Vorige_knop_Click()
On Error GoTo Err_Vorige_knop_Click
DoCmd.GoToRecord , , A_PREVIOUS
Exit_Vorige_knop_Click:
Exit Sub
Err_Vorige_knop_Click:
MsgBox Error$
Resume Exit_Vorige_knop_Click
End Sub
Private Sub Knop204_Click()
On Error GoTo Err_Knop204_Click
Dim stDocName As String
stDocName = “Projectleider per postcode”
DoCmd.OpenReport stDocName, acPreview
Exit_Knop204_Click:
Exit Sub
Err_Knop204_Click:
MsgBox Err.Description
Resume Exit_Knop204_Click
End Sub
Private Sub Telefoonnummer_algemeen_DblClick(Cancel As Integer)
Set ctiCallControl = CreateObject(“CTIBridge.CallControl”)
If Telefoonnummer_algemeen.Value <> “” Then
ctiCallControl.Dial “0” + Telefoonnummer_algemeen.Value
End If
End Sub
Public Sub NUMLOCK_UIT()
SendKeysNUMLOCK , -1
End Sub
***********
Formulier DIALOOG RELATIES IK HEB 1e SUB TOEGEVOEGD, MAAR DEZE HELPT NIET
Private Sub Form_LostFocus()
SendKeys “NUMLOCK”, True
End Sub
Private Sub Knop0_Click()
On Error GoTo Err_Knop0_Click
DoCmd.GoToRecord , , A_FIRST
Exit_Knop0_Click:
Exit Sub
Err_Knop0_Click:
MsgBox Error$
Resume Exit_Knop0_Click
End Sub