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
|
|||
|
|||
Action queries changing when reopened in design view
Hello,
I am rephrasing/simplifying a question I posted earlier so that somebody might know what's going wrong. I am using two action queries in a form. A delete query and an append query. I originally created the queries as recommended in Access help, the basic form of each query is as follows: Delete query (please imagine this in design view) Field: tbl_dataentry adminstatus date Table: tbl_dataentry tbl_dataentry tbl_dataentry Delete: from where where Criteria: [adminstatus]="decline" [adminstatus]="decline" etc... Append query (please imagine this in design view): Field: Record_ID Date Table: tbl_dataentry tbl_dataentry Sort: Append to: Record_id Date Criteria: [Adminstatus]="accept" [Adminstatus]="accept" etc... However, when I reopen the queries in design view, their design has changed from what I originally created. Instead of listing the criteria ([Adminstatus]="accept" for the append query and [Adminstatus]="deline" for the delete query) under each column of my query design view (as shown in the query) the very last column of the append says "Accept" and "Accept" and "Accept" and the very last column of the delete query says "Decline" and "Decline" and "Decline" in the criteria section (the field section on this last column is the table's name -- tbl_dataentry). I did not add the last column to my queries' design, nor did I delete the criteria sections. I am using these queries in a macro that combines the two queries. I suspect that running the macro with the queries is what altered them, but my queries could just be wrong. Any suggestions? Thank you for your time, Kendra |
#2
|
|||
|
|||
It would help if you posted the SQL statement vice trying to post a
representation of the view. Can you copy and post the SQL of your query? (Possibly unneeded instructions follow) Open the query Select View:Sql from the Menu Select all the text Copy it Paste it into the message Kendra wrote: Hello, I am rephrasing/simplifying a question I posted earlier so that somebody might know what's going wrong. I am using two action queries in a form. A delete query and an append query. I originally created the queries as recommended in Access help, the basic form of each query is as follows: Delete query (please imagine this in design view) Field: tbl_dataentry adminstatus date Table: tbl_dataentry tbl_dataentry tbl_dataentry Delete: from where where Criteria: [adminstatus]="decline" [adminstatus]="decline" etc... Append query (please imagine this in design view): Field: Record_ID Date Table: tbl_dataentry tbl_dataentry Sort: Append to: Record_id Date Criteria: [Adminstatus]="accept" [Adminstatus]="accept" etc... However, when I reopen the queries in design view, their design has changed from what I originally created. Instead of listing the criteria ([Adminstatus]="accept" for the append query and [Adminstatus]="deline" for the delete query) under each column of my query design view (as shown in the query) the very last column of the append says "Accept" and "Accept" and "Accept" and the very last column of the delete query says "Decline" and "Decline" and "Decline" in the criteria section (the field section on this last column is the table's name -- tbl_dataentry). I did not add the last column to my queries' design, nor did I delete the criteria sections. I am using these queries in a macro that combines the two queries. I suspect that running the macro with the queries is what altered them, but my queries could just be wrong. Any suggestions? Thank you for your time, Kendra |
#3
|
|||
|
|||
As John mentioned it would be easier to see the sql, but
in your examples it seems to me that you are typing the fieldname an = sign and then the criteria all in the criteria row. When using the query builder you would generally put just the right side of the expression beneath the appropriate field name. In your case you would put "accept" or "decline" in the [adminstatus] column. Maybe this is what you are doing and I misunderstood your post, but I thought I would mention it just in case. HTH, Ted Allen -----Original Message----- Hello, I am rephrasing/simplifying a question I posted earlier so that somebody might know what's going wrong. I am using two action queries in a form. A delete query and an append query. I originally created the queries as recommended in Access help, the basic form of each query is as follows: Delete query (please imagine this in design view) Field: tbl_dataentry adminstatus date Table: tbl_dataentry tbl_dataentry tbl_dataentry Delete: from where where Criteria: [adminstatus]="decline" [adminstatus]="decline" etc... Append query (please imagine this in design view): Field: Record_ID Date Table: tbl_dataentry tbl_dataentry Sort: Append to: Record_id Date Criteria: [Adminstatus]="accept" [Adminstatus]="accept" etc... However, when I reopen the queries in design view, their design has changed from what I originally created. Instead of listing the criteria ([Adminstatus]="accept" for the append query and [Adminstatus]="deline" for the delete query) under each column of my query design view (as shown in the query) the very last column of the append says "Accept" and "Accept" and "Accept" and the very last column of the delete query says "Decline" and "Decline" and "Decline" in the criteria section (the field section on this last column is the table's name -- tbl_dataentry). I did not add the last column to my queries' design, nor did I delete the criteria sections. I am using these queries in a macro that combines the two queries. I suspect that running the macro with the queries is what altered them, but my queries could just be wrong. Any suggestions? Thank you for your time, Kendra . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't open report in Design View | MSchreiber | Setting Up & Running Reports | 1 | August 30th, 2004 03:32 AM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Changing default view in Word 2003 | Hall | Page Layout | 2 | May 20th, 2004 04:46 PM |
changing the background of normal.dot in layout view | kevin nelson | Page Layout | 2 | April 28th, 2004 03:23 PM |