By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,099 Members | 2,156 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,099 IT Pros & Developers. It's quick & easy.

working with selected records in a datasheet

P: 2
I have a SQL view linked into a ms access application. That view is used in a subform and in datasheet view. I want to select multiple records and click on a button that will delete those selected rows. I need the button because the view has 1 table and a subquery joined in the view and will not allow me to delete from the main table in that view. So, I figured I can select the rows I want to delete and then create a button that will send a passthru command to delete those records from the main table. Can you help?
Oct 24 '13 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 5K+
P: 5,397
"View" tends to make me think of SQLServer or MYSQL... so I need you to clarify a few things:
Are you using just Access?
IF not then what software are you using?
Oct 28 '13 #2

P: 2
I'm using ms access 2007 for front end and SQL Server 2008 for backend.
Oct 28 '13 #3

Expert Mod 10K+
P: 12,366
In certain situations, you can move the subquery to the where clause and that will allow you to delete from the view. But to determine that we would need to see the SQL.
Oct 28 '13 #4

Post your reply

Sign in to post your reply or Sign up for a free account.