If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deleting a record from a Query
Hi
I'm very new to Access and I was wondering how do you delete a record from a query result? Every time I try to do so it gives me the following error "Deleting data in a linked table is not supported by this ISAM" . I've run a Query to get all records that contain a segment of text, but now I need to further "prune" the records. I can't do another filter or query as there are no particular words that I want to keep or get rid of. I need to evaluate each record one by one. I know I can save a query, but can I save the query results as a table and then further manipulate them? Thank-you very much in advance for your help |
#2
|
|||
|
|||
Deleting a record from a Query
I don't understand the first part of your problem but you can create a table
from your query. You need to change your 'select query' to an 'append query'. When you click Run ! it will ask you if you want to append to an existing table or a new one. Let me know if you need more help with this. Alison "Christine" wrote: Hi I'm very new to Access and I was wondering how do you delete a record from a query result? Every time I try to do so it gives me the following error "Deleting data in a linked table is not supported by this ISAM" . I've run a Query to get all records that contain a segment of text, but now I need to further "prune" the records. I can't do another filter or query as there are no particular words that I want to keep or get rid of. I need to evaluate each record one by one. I know I can save a query, but can I save the query results as a table and then further manipulate them? Thank-you very much in advance for your help |
#3
|
|||
|
|||
Deleting a record from a Query
From the error description it sounds like you might be linking to non-Access
data such as Excel or a text file, in which case you won't be able to delete rows in the source from within Access. One thing you could do is 'mark' the records as deleted, but not actually delete them. To do this create a local table with a column or columns which match the primary key of the linked table (or any column or combination of columns which identify a row uniquely). Make sure these column or columns in the new table are defined as its primary key. Give this other table one more column of Boolean (Yes/No) data type called something like Deleted. Make its Display Control a check box in its properties sheet in table design. You can then join your query to this table in another query in which you return all columns from the existing table and just the deleted column from the new table. You can then check those you want to mark as deleted. When you want to see the rows from the existing table without those marked for deleted you just join the existing table to the new table in a query and set the criterion for the Deleted column to False. Ken Sheridan Stafford, England "Christine" wrote: Hi I'm very new to Access and I was wondering how do you delete a record from a query result? Every time I try to do so it gives me the following error "Deleting data in a linked table is not supported by this ISAM" . I've run a Query to get all records that contain a segment of text, but now I need to further "prune" the records. I can't do another filter or query as there are no particular words that I want to keep or get rid of. I need to evaluate each record one by one. I know I can save a query, but can I save the query results as a table and then further manipulate them? Thank-you very much in advance for your help |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error when running Query, but not Report | Blaze | Running & Setting Up Queries | 29 | September 9th, 2005 05:40 AM |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
How to get a field on a form to reflect a certain record of a query? | General Discussion | 0 | December 11th, 2004 12:56 AM | |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM |