Hi All,
Im working on a ADP database but cannnot get the Dcount() to work.
This is the existing vb
-----------------------------------------------------------------------------
If DCount("[filename]", "w_imp_import_history", "[filename]=forms!frm_import!txt_filename") Then
Beep
MsgBox "Error Filename Duplication!" & _
vbCrLf & _
vbCrLf & _
"The filename [" & txt_fileName & "] has already been imported!", vbCritical, "File Duplication"
----------------------------------------------------------------------------
When I try and run this throu an ADP it wont run
anyone got an idea on how to get around this???
thanks
Im working on a ADP database but cannnot get the Dcount() to work.
This is the existing vb
-----------------------------------------------------------------------------
If DCount("[filename]", "w_imp_import_history", "[filename]=forms!frm_import!txt_filename") Then
Beep
MsgBox "Error Filename Duplication!" & _
vbCrLf & _
vbCrLf & _
"The filename [" & txt_fileName & "] has already been imported!", vbCritical, "File Duplication"
----------------------------------------------------------------------------
When I try and run this throu an ADP it wont run
anyone got an idea on how to get around this???
thanks