/TypeScript/Access - Open form non data entry mode

Access - Open form non data entry mode

Private Sub openRecBtn_Click()
    Dim numID As Long

    numID = InputBox("Please enter the ID : ")

    If DCount("*", "yourTable", "numberID = " & numID) <> 0 Then
        DoCmd.OpenForm "tmpFrmName", WhereCondition:="numberID = " & numID
    Else
        MsgBox "The numberID : " & numID & " does not exist, please try again !"
    End If
End Sub

Source: stackoverflow.com

Similar codes

1 vote118 views1 answer
For in typescript
TypeScript
0 vote198 views1 answer
He .native modifier for v-on is only valid on components but it was used on <a>.
TypeScript
0 vote169 views2 answers
Window.print div
TypeScript
0 vote183 views1 answer
How to check git folder exists or not
TypeScript
0 vote166 views1 answer
Remove dots and commas java
TypeScript
1 vote166 views1 answer
Why does mongoose minimize by default
TypeScript
11 votes173 views2 answers
Tonumber typescript / Number typescript
TypeScript
1 vote199 views2 answers
Check if element exists in array golang
TypeScript
0 vote178 views2 answers
Get only parent child elements beautiful soup
TypeScript
0 vote192 views1 answer
Unknown typescript
TypeScript