RaunLGoode
Registered User.
- Local time
- Yesterday, 18:24
- Joined
- Feb 18, 2004
- Messages
- 122
I can take information from an Excel worksheet and import it into Access by specifying a path to an existing table and using DBS.AddNew to add a new record. I update the table DBS.Update and save the Primary key value to a variable which I return to the worksheet and add as a record number. intRecNum
I want to update the Access table periodically. I would like to go back to the Access Table from Excel ues the intRecNum value to pull up the specific record. I have looked for the info on Access Objects & Properties, but haven't found anything that works.
I think I need to replace DBS.AddNew something to point to an existing Record.... like DBS.ModifyRecord ?
I was thinking it would be something like :
DBS.Open "tblTest", ADOC, adOpenKeyset,
...
and then FindRecord.intRecNum (intRecNum being the Primary Key value I returned to Excel when I created the record.
I would like to know what command I would use to replace the DBS.AddNew and I would like to know the Object.Property I would use to access a specific Record in my table.
With my humble thanks,
I want to update the Access table periodically. I would like to go back to the Access Table from Excel ues the intRecNum value to pull up the specific record. I have looked for the info on Access Objects & Properties, but haven't found anything that works.
I think I need to replace DBS.AddNew something to point to an existing Record.... like DBS.ModifyRecord ?
I was thinking it would be something like :
DBS.Open "tblTest", ADOC, adOpenKeyset,
...
and then FindRecord.intRecNum (intRecNum being the Primary Key value I returned to Excel when I created the record.
I would like to know what command I would use to replace the DBS.AddNew and I would like to know the Object.Property I would use to access a specific Record in my table.
With my humble thanks,