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.
Private Sub Report_Close()
If FisLoaded("SelectieMaken") Then
Forms!SelectieMaken.Form.Visible = True
Else
DoCmd.OpenForm "SelectieMaken"
End If
End Sub
Option Compare Database
Option Explicit
Function fIsLoaded(ByVal strFormName As String) As Integer
'Returns a 0 if form is not open or a -1 if Open
If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> 0 Then
If Forms(strFormName).CurrentView <> 0 Then
fIsLoaded = True
End If
End If
End Function
Function Test()
Dim strSQL As String
On Error Resume Next
strSQL = "CREATE TABLE Rooms(" _
& "room_nbr CHAR(2) NOT NULL PRIMARY KEY, room_size INTEGER NOT NULL)"
''DoCmd.RunSQL strSQL
''strSQL = "INSERT INTO Rooms" _
& "VALUES ('r1', 70),('r2', 40),('r3', 50),('r4', 85),('r5', 30),('r6', 65),('r7', 55);"
strSQL = "INSERT INTO Rooms (room_nbr, room_size)" & vbCrLf _
& "SELECT ('r1', 70) " & vbCrLf _
& "Union Select ('r2', 40) " & vbCrLf _
& "Union Select ('r3', 50) " & vbCrLf _
& "Union Select ('r4', 85) " & vbCrLf _
& "Union Select ('r5', 30) " & vbCrLf _
& "Union Select ('r6', 65) " & vbCrLf _
& "Union Select ('r7', 55);"
Dim tmp
tmp = InputBox("", "", strSQL)
DoCmd.RunSQL strSQL
strSQL = "CREATE TABLE Classes(" _
& "class_nbr CHAR(2) NOT NULL PRIMARY KEY, class_size INTEGER NOT NULL)"
DoCmd.RunSQL strSQL
strSQL = "INSERT INTO Classes" _
& "VALUES ('c1', 80),('c2', 70),('c3', 65),('c4', 55),('c5', 50),('c6', 40);"
DoCmd.RunSQL strSQL
End Function
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.