Hi, I recently ran into a strange error with getting an Id from a DAO.Recordset.The back-end is a sql-express 2014 database.
The high level logic being:
I used this construct (after rs.AddNew and rs.Update):
The high level logic being:
- make a pdf (access report)
- store the path in a table and get the DocId
- send out a mail to the party contact with the pdf as attachment
I used this construct (after rs.AddNew and rs.Update):
rs.Move 0, rs.LastModified
vDocId = rs!Id
and changed it tovDocId = rs!Id
rs.Bookmark = rs.LastModified
vDocId = rs!Id
I wonder if there is any functional difference. ThanksvDocId = rs!Id