Fred Parkinson (f...@abag.ca.gov)

This is a resend, pardon if it went already; I got no copy so I suspect it never went.

Thanks for your reply.

There is no real code involved in the issue. My main form, fMain, has a subform, fStudent. When the user picks a student from a drop-down list on fMain, fMain sends the subform fStudent the id of the selected student. Upon receiving the student id, the subform makes that student record the record displayed for editing by using the code 'Me.RecordsetClone.FindFirst "student_id = " & cstr(id)' followed by (if no error) 'Me.Bookmark = Me.RecordsetClone.Bookmark'

This part works as desired. I have stepped through the problem and found that this code is not run when the problem occurs, thus is not causing the subform to move unexpectedly to the undesired record.

If the user then chooses to edit the (tabbed control displayed) student data by using the Windows operating system functions ctrl-c, ctrl-v or ctrl-x, the form unexpectedly jumps to a new record before the ctrl-? function acts, and the action is then applied to the new, unexpected record!

As for when it started happening, that is unclear, but probably not too long ago. At first the users thought they were making a mistake, that they were in error somehow, and didn't bring it to my attention until yesterday.

Clearly I need to find out if something was changed in the recent past: upgrade to server, or to workstations (tech support has the habit of making changes without telling anyone). One of the techs thinks that a Win XP Office 2002 - Office 2007 compatibility upgrade was done recently on the workstations, so I will pursue that as well as whatever else I or others can think of.

Thank you for considering my problem.

Fred


>>> Andrei Kovalevski <andyk@commandprompt.com> 02/21/2008 1:07 AM >>>
Hello,

It's hard to understand your problem. When did your problem appear? Show
us your ODBC + PostgreSQL relative code.

Thanks for your reply.

There is no real code involved in the issue. My main form, fMain, has a subform, fStudent. When the user picks a student from a drop-down list on fMain, fMain sends the subform fStudent the id of the selected student. Upon receiving the student id, the subform makes that student record the record displayed for editing by using the code 'Me.RecordsetClone.FindFirst "student_id = " & cstr(id)' followed by (if no error) 'Me.Bookmark = Me.RecordsetClone.Bookmark'

This part works as desired. I have stepped through the problem and found that this code is not run when the problem occurs, thus is not causing the subform to move unexpectedly to the undesired record.

If the user then chooses to edit the (tabbed control displayed) student data by using the Windows operating system functions ctrl-c, ctrl-v or ctrl-x, the form unexpectedly jumps to a new record before the ctrl-? function acts, and the action is then applied to the new, unexpected record!

As for when it started happening, that is unclear, but probably not too long ago. At first the users thought they were making a mistake, that they were in error somehow, and didn't bring it to my attention until yesterday.

Clearly I need to find out if something was changed in the recent past: upgrade to server, or to workstations (tech support has the habit of making changes without telling anyone). One of the techs thinks that a Win XP Office 2002 - Office 2007 compatibility upgrade was done recently on the workstations, so I will pursue that as well as whatever else I or others can think of.

Thank you for considering my problem.

Fred


>>> Andrei Kovalevski <andyk@commandprompt.com> 02/21/2008 1:07 AM >>>
Hello,

It's hard to understand your problem. When did your problem appear? Show
us your ODBC + PostgreSQL relative code.

I tried 8.01.02 to replace my old one, but the problem persists.

I will keep trying newer versions, but I thought I might post a description=
of the problem in the meantime in case someone has seen it or has suggesti=
ons.

In my app. I have a subform which has a tab control with student informatio=
n, and the form source is table tStudents, a postgres table.

This form is embeded in another form, fMain.

Odd thing is, if I do a Ctrl-V to paste text into a text box on the tab, th=
e form moves to a new record and pastes the data there instead of to the or=
iginal record that was displayed!  The form has moved to the new record bef=
ore the 'before update' event of the text box has fired.

This happens if I paste into a box on either tab page.  You don't notice it=
at first because all the rest of the boxes continue to display the data of=
 the original record, until you click on another tab.  Then all the boxes s=
how the new unwanted record, and there the pasted data is.

Ctrl-X (cut) has the same problem.  Things look good at first, then you not=
ice that you removed data from a different record that the form has moved t=
o!

It doesn't happen when I copy all the postgres data into a local access tab=
le and then use it as the record source instead of the postgres table.  Thi=
s is what makes me think it may be an odbc driver issue.

Ctrl-V and Ctrl-X are windows functions (I'm on Win XP Professional, not su=
re which SP) so concievably Win is part of the problem.  I will set up a bo=
x with an earlier version of XP and see what happens.

This app has been running smoothly for years, and through several updates t=
o the backend postgres database.

Thanks in advance for any help, if I solve it I will post a solution.

Fred

the download page gave me http://www.postgresql.org/ftp/odbc/ with lots of =
drivers, pardon my previous mailing.

Fred

I have started having odd problems in communication between postgres and MS=
 Access using odbc, so to start with I want to update the odbc driver.  cur=
rently I am using odbc ver 7.03.02.00 (has been working well for a long tim=
e).

My postgresql version is 8.1.8

http://www.postgresql.org/download/ only links to mODBC_Installer(beta_00.9=
9.121).msi, which appears to be a beta odbc driver and gave me problems imm=
ediately after installing (a lot of "Another user changed the data, [copy t=
o clipboard], [discard]..." type of stuff).

Is there another, non-beta odbc driver available for my version of postgres?

Thanks in advance for any help.

Fred