/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

0 vote136 views1 answer
Ggplots in r
TypeScript
0 vote132 views1 answer
Object is possibly 'null'. 20 *ngIf="!signupForm.get('email').valid && signupForm.get('email')!.touched "
TypeScript
0 vote143 views1 answer
Difference known_hosts authorized_keys
TypeScript
0 vote139 views1 answer
Communication between components in angular
TypeScript
1 vote129 views2 answers
Typescript global variable
TypeScript
20 votes160 views5 answers
Flatten a list of lists python
TypeScript
18 votes132 views3 answers
Enum to number typescript
TypeScript
0 vote136 views1 answer
Subscription' is deprecated
TypeScript
5 votes142 views3 answers
CountDocuments mongoose
TypeScript
3 votes129 views1 answer
How to make s3 bucet objects publicj
TypeScript