Re: Force commit in M$ Access?

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(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part de Aaron Spike
Envoyé : mercredi, 18. février 2004 20:39
À : Fred Parkinson; pgsql-odbc(at)postgresql(dot)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 VBA hook 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