Differences accdb and accde

  • Thread starter Thread starter domenico
  • Start date Start date
D

domenico

I have strange problemm

I have a form with record source tbltableA

I have a button to send email with form field

my flow is

' force save form

If Me.Dirty Then
RunCommand acCmdSaveRecord
End If


' DELAY 1 second
' and then read record before save

sql = "SELECT * FROM tbTableA " & _
"WHERE CodA='" & Me.CodA & "' AND " & _
"CodB='" & Me.CodB & "'

Set db = CurrentDb

Set rs = db.OpenRecordset(sql)

......

with .accdb works good but i create .accde not works.
but if I put delay 1 seconds before read recordset all works !!

Sorry for my english

Thanks Very much
Domenico
 
hi Domenico,

my flow is

' force save form

If Me.Dirty Then
RunCommand acCmdSaveRecord
End If
Click to expand...
Instead of RunCommand use

If Me.Dirty Then
Me.Dirty = False
End If

This will trigger the save action.
' and then read record before save
sql = "SELECT * FROM tbTableA " & _
"WHERE CodA='" & Me.CodA & "' AND " & _
"CodB='" & Me.CodB & "'
Click to expand...
Does your forms record source point to tbTableA?
with .accdb works good but i create .accde not works.
but if I put delay 1 seconds before read recordset all works !!
Click to expand...
So you don't retrieve any data without the delay? Strange.
Is this table a local one or a linked table?
Sorry for my english
Click to expand...
It's okay.


mfG
--> stefan <--
 
Back
Top