Deepfreeze
Jun 13th, 2000, 04:10 AM
Hi,
I'm trying to add a new record to an Access 2000 DB (which I did not build, nor do I really want to change), only I can't add info to certain fields. Some of these fields have been set up to have certain values, i.e., when viewing the DB in Access, a pull-down menu comes up when I try to alter that field. Is there any way I can update these fields through my VB program and keep the same format as the DB was set to do? To update the other fields, I'm using this type of procedure:
recordset.AddNew
recordset.Fields("whatever") = value
recordset.Update
This is the error I get when trying to enter the same value as what was in the Access pulldown menu to one of these fields:
Run-time Error '3265':
ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.
Any help would be appreciated. Thanks!
Deepfreeze
I'm trying to add a new record to an Access 2000 DB (which I did not build, nor do I really want to change), only I can't add info to certain fields. Some of these fields have been set up to have certain values, i.e., when viewing the DB in Access, a pull-down menu comes up when I try to alter that field. Is there any way I can update these fields through my VB program and keep the same format as the DB was set to do? To update the other fields, I'm using this type of procedure:
recordset.AddNew
recordset.Fields("whatever") = value
recordset.Update
This is the error I get when trying to enter the same value as what was in the Access pulldown menu to one of these fields:
Run-time Error '3265':
ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.
Any help would be appreciated. Thanks!
Deepfreeze