[MS_AccessPros] recordsaffected property

 

Greetings all, it's been a long time since i have written in this group, Tit's terence/buffalome90210, I am using ms access 2007, on a xp platform and always get a zero result for the recordsaffected property, what am i doing wromg ?

 

terence

 

 

 

Dim lngRowsInserted As Long

Set db = CurrentDb()

mysql = "Insert into tbl_employee_payment select * from sheet_pay"

CurrentDb.Execute mysql, dbFailOnError
       
' the below 3 lines should work - but they always return zero instead
MsgBox (CurrentDb.RecordsAffected)

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___