From: | "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch> |
---|---|
To: | "Aaron Spike" <sauron(at)mlc-wels(dot)edu>, "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Force commit in M$ Access? |
Date: | 2004-02-19 07:08:02 |
Message-ID: | 6C0CF58A187DA5479245E0830AF84F420AFBFF@poweredge.attiksystem.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas PINTO | 2004-02-20 15:21:04 | ODBC driver |
Previous Message | Aaron Spike | 2004-02-18 19:39:29 | Re: Force commit in M$ Access? |