| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel with Access
I have built an Access Database that is "managed" through Excel. I have code that updates/refreshes data in the database. One last step I can't figure out is if there is code I can write where I can delete 1 record in a table. I can't link the table to Excel, because I need to maintain a primary key. I have code that updates and creates, but I can't figure out how to delete. Can anyone help me out?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel with Access
Shin
If you're using ADO, you can use the Delete method of the Recordset object. Check it out in help. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Shin" wrote in message ... I have built an Access Database that is "managed" through Excel. I have code that updates/refreshes data in the database. One last step I can't figure out is if there is code I can write where I can delete 1 record in a table. I can't link the table to Excel, because I need to maintain a primary key. I have code that updates and creates, but I can't figure out how to delete. Can anyone help me out? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
| Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
| export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
| How to access ACCESS from Excel! | Excel Programming | |||
![Shin[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
