Hello,
You can use this routine:
---------------------------
Sub cmdSaveFct()
On Error GoTo cmdSaveFctError
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
cmdSaveFctExit:
Exit Sub
cmdSaveFctError:
MsgBox Err.description
Resume cmdSaveFctExit
End Sub
---------------------------
Philippe Lang
-----Message d'origine-----
De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] De la part de Aaron Spike
Envoyé : mercredi, 18. février 2004 20:39
À : Fred Parkinson; pgsql-odbc@postgresql.org
Objet : Re: [ODBC] Force commit in M$ Access?
On 18 Feb 2004 at 10:41, Fred Parkinson wrote:
> Does anyone know if it is possible, when using an Access bound form
> against a postgresql table, to force changes to commit?
This is probably a bad idea but
SendKeys "+{ENTER}"
might just work.
Pressing Shift+Enter in a form is supposed to commit changes to the current record. I'm not sure if there is a cleaner
VBAhook into that functionality.
Aaron Spike
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match