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@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