M
marc p
I wonder who could help me with this.
I would like an Add Query to be executed only if the
number of registers to add is one. If the query is going
to add more than one register, it means that something is
wrong. In this case, I would like a MsgBox to appear.
Something like:
If (number of registers in AddIntallationSheet) = 1 Then
DoCmd.OpenQuery "AddInstallationSheet"
Else
MsgBox ("Something is wrong..")
End If
What I don't know is how to check that the number of
registers is one or more. Could somebody complete the code?
Thank you
I would like an Add Query to be executed only if the
number of registers to add is one. If the query is going
to add more than one register, it means that something is
wrong. In this case, I would like a MsgBox to appear.
Something like:
If (number of registers in AddIntallationSheet) = 1 Then
DoCmd.OpenQuery "AddInstallationSheet"
Else
MsgBox ("Something is wrong..")
End If
What I don't know is how to check that the number of
registers is one or more. Could somebody complete the code?
Thank you