/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 vote158 views1 answer
Moving data between the request in api
TypeScript
-1 vote155 views2 answers
Hhow to remove elements from java
TypeScript
1 vote181 views1 answer
Explain the concept of Dangling Pointer and Null Pointer with Examples? Provide brief details of the scenarios in which pointer acts as dangling pointer.
TypeScript
0 vote197 views1 answer
No database host was found that meets the requirements for this server.
TypeScript
0 vote159 views1 answer
Ionic 3 angular replacements or alternatives
TypeScript
26 votes163 views4 answers
Typescript type from enum values
TypeScript
7 votes174 views1 answer
Error: "prettier/@typescript-eslint" has been merged into "prettier" in eslint-config-prettier 8.0.0
TypeScript
-1 vote193 views1 answer
Macro fiji bio-formats import options
TypeScript
0 vote171 views1 answer
Get elements in list in another list c#
TypeScript
0 vote171 views1 answer
Aws sts get-caller-identity extract account
TypeScript