Updateing Record from ODBC

  • Thread starter Thread starter gandalf_at_sonic_dot_net
  • Start date Start date
G

gandalf_at_sonic_dot_net

MySQL 4.0.13
Access 97
MyODBC 2.5.something (old win95 computer)

I just moved a database over to MySQL for my video store. The record
ID's for each video are used to label the videos. Now that MySQL is
handling the autonumber the number does not show up in access unless
you leave the record and then come back. Is there a way (perhaps in
AVB) to update the Video Number field on some event, like modifying
the title?

-Walter Hansen
 
MySQL 4.0.13
Access 97
MyODBC 2.5.something (old win95 computer)

I just moved a database over to MySQL for my video store. The record
ID's for each video are used to label the videos. Now that MySQL is
handling the autonumber the number does not show up in access unless
you leave the record and then come back. Is there a way (perhaps in
AVB) to update the Video Number field on some event, like modifying
the title?

-Walter Hansen
Click to expand...

I believe the autonumber will appear if you force Access to save the
record. If you press Shift+Enter when you've finished filling out the
required fields, that will save the record, or you could put a command
button on the form to save the record. The button could execute the
statement

RunCommand acCmdSaveRecord

I suppose an alternative could be to have AfterUpdate code in the
controls bound to required fields that checks to see if all the required
fields have been completed for a new record, and saves the record at
that time.
 
Back
Top