Im struggling to get this to create a message for the user.
I have an import spec that imports my data to a holding table, checks that the data isn't already in the main table then adds if not.
Regardless of whether the data is or isn't in my Main table, I am getting MsgBox "Imported" as my result.
I shall endeavour to study DCount but maybe you guys can shed a quick beacon of light on this for me?
I have an import spec that imports my data to a holding table, checks that the data isn't already in the main table then adds if not.
Code:
Private Sub Command0_Click()
DoCmd.RunSavedImportExport "Import-AllocatedCash"
' I now have a query based on a joined query between the Main table and qryImportCount
Dim RecCount As Long
RecCount = DCount("*", "qryImportCount")
If ReCount > 0 Then
MsgBox " Not Imported"
Else
MsgBox " Imported"
DoCmd.OpenQuery "apdImportToAllocatedCash"
End If
End SubRegardless of whether the data is or isn't in my Main table, I am getting MsgBox "Imported" as my result.
I shall endeavour to study DCount but maybe you guys can shed a quick beacon of light on this for me?
