/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 vote143 views2 answers
Linux bash scripts tutorial
TypeScript
0 vote140 views1 answer
File_exists in wordpress
TypeScript
0 vote72 views4 answers
Error: The method assertThat(T, Matcher<? super T>) in the type MatcherAssert is not applicable for the arguments (List<String>, Matcher<Iterable<Integer>>)
TypeScript
1 vote116 views1 answer
How to check when a number varibal = nan in ts
TypeScript
0 vote109 views1 answer
Does casting have a higher precedence than dots java
TypeScript
0 vote115 views2 answers
How to set value to readonly property in typescript
TypeScript
0 vote112 views1 answer
Typescript type array of interface
TypeScript
0 vote114 views1 answer
Error TS2304: Cannot find name 'beforeEach'.
TypeScript
21 votes147 views6 answers
Ngclass angular
TypeScript
0 vote105 views1 answer
Cannot find name 'modalRef'
TypeScript