you're welcome, Steve ~ happy to help
have an awesome day,
crystal
free code you can use in your projects
https://msaccessgurus.com/code.htm
On 5/27/2019 3:42 PM, Steve thaw [MS_Access_Professionals] wrote:
Thank you Duane and Crystal. I was anticipating a cryptic and difficult task, but it turned out to be elegantly simple:
?? Dim strUPDATE As String, strINSERT As String
?? Dim RecordsUpdated As Long, RecordsInserted As Long
?? With CurrentDb
????? .Execute strINSERT
????? RecordsInserted = .RecordsAffected
????? .Execute strUPDATE
????? RecordsUpdated = .RecordsAffected
?? End With
Appreciate the help and advice!
Steve
On 5/26/2019 7:47 PM, crystal [MS_Access_Professionals] wrote:
?
? is supposed to be space ...
On 5/26/2019 3:25 PM, crystal [MS_Access_Professionals] wrote:
oops!
with Currentdb
?.execute sSQL
?nNumberRecords = .RecordCount
end with
On 5/26/2019 3:23 PM, crystal wrote:
hi Steve,
adding on to Duane's comment ...
dim nNumberRecords as long _
,sSQL as string
sSQL = "blah blah"
with me.currentdb
?.execute sSQL
?nNumberRecords = .RecordCount
end with
~crystal
On 5/26/2019 1:48 PM, Duane Hookom [MS_Access_Professionals] wrote:
Consider using .Execute in place of the DoCmd. This exposes the RecordsAffected property.
Duane
On May 26, 2019, at 1:04 PM, "Steve thaw5 [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
I am using DoCmd.RunSQL with INSERT INTO and UPDATE action queries. Is
there a way to get the number of records inserted or updated for use in?
a debug.print statement?
Thanks.
Steve
------------------------------------
Posted by: Steve thaw5
------------------------------------
