Running & Setting Up Queries - Page 1058

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 / Thread Starter	Last Post	Replies	Views
Keeping the "First" Duplicate Record, Delete Subsequent by jgraves I am using Access 2002. I have a project that uses the "Find Duplicates" query to display duplicate records in a table, using "Part Number" as the field that...	November 16th, 2006 02:37 PM by Roger Carlson	2	61
key violation by John i have a one-to-many relationship between 2 tables. i am needing to develop a query that will SUM all the records of one field on the 'many' side of...	May 17th, 2006 12:11 AM by John	2	72
Key violation and lock violation stop delete query!! by DowningDevelopments hello moto I have a table called receipts that hold values for receipts for money transactions and is connected to different tables that hold records for...	August 4th, 2005 11:07 AM by DowningDevelopments	2	141
Key Violation Error by Chezter Hi All, I have an Access table called tblUnits that holds information about each subject offered by my organisation. In excel, I have a table with the...	September 11th, 2008 01:55 PM by Golfinray	1	95
Key Violation Error in Append query by troy I am running or trying to run an append query and receive a key violation error. Here is my query.. One example of my QBE Qry 1 Oblig1 primary key...	April 26th, 2006 12:41 AM by KARL DEWEY	1	78
Key Violation Error on an Append Query by BC I am having a problem running an append query that sends the data in an Access database table to a SQL Server using a linked table. When I activate the query...	December 3rd, 2004 02:27 PM by Brendan Reynolds	6	409
key violation in append query by Helen Martin I have table A, table B and table C table A contains contact information with a long integer primary key called contactID as the first field.. table b...	March 1st, 2007 08:41 PM by Helen Martin	2	93
Key violation on Append Query by JimS Transaction table has ONE key field...Autonumber called TransID. No other fields are marked as "No duplicates". I'm inserting some transactions from a linked...	April 20th, 2007 03:56 PM by JimS	1	84
key violation on append query by Ian I am including an append query to copy the Unique Key from a form to another table for reference in certain circumstances. I have an append query that...	February 4th, 2007 09:02 PM by Ian	3	83
Key Violation, No Primary Key by JustMe Hi, My append query will not append ALL of my records, due to key violations. I had a multi-field primary, but during experimenting, I took it off. I STILL...	December 13th, 2006 03:51 PM by Van T. Dinh	6	51
key violations by NayNay32 When I append records from my form, I get a key violation error. I do not have a primary key, and the allow zero length fields are set to no. The Invoice#...	August 15th, 2006 12:39 AM by Jerry Whittle	7	65
key violations by NayNay32 I am having a problem appending my query from my form. I do not have a primary key in the table and all of the fields have no selected in the allow zero...	August 30th, 2006 09:33 PM by JohnTheTemp	2	55
key violations by Lisa I am trying to append info from a 2003 database into a 2007 database and have received the Key violation error. My first question is, what is a key violation...	May 22nd, 2009 06:18 PM by Lisa	4	108
Key Violations in Append Queries by troy I am trying to append rows in a history query to my tables and I get the big old key Violations error. It is the same old 3 that keep comming up and they dont...	April 20th, 2006 04:26 PM by troy	5	92
key violations in append query: please help by Patrick Stubbin I am trying to append a variable number of records from one table in one database to a second table. One example has three records to be appended, the first...	January 6th, 2006 12:30 AM by Patrick Stubbin	1	76
Key Violations My Wits End by [email protected] I have an append query that worked perfectly up until an hour ago when I decided to fiddle with the primary key of the destination table and now I am...	January 23rd, 2008 03:58 AM by Ken Snell \(MVP\)	7	114
Key violations on Append query - no indexes on table by Carl Rapson I've searched through the forum for related posts, but I haven't seen one with this particular situation. I'm attempting to append records from one table to...	March 24th, 2009 02:43 PM by Carl Rapson	8	115
key? by Carlos Santos What record should i set my primary key to ?	February 23rd, 2010 01:33 AM by John W. Vinson	2	215
keyboard letters by keyboard letters don't work when i type a letter it dosent work another letter comes up. the pound sign does not work instead this comes up #please help	September 25th, 2005 12:43 PM by Allen Browne	1	105
keyword query by Natalie I'm creating an inventory database with a field named "item description". I want to create a query that can search for keywords in this field and output a...	September 12th, 2006 10:37 PM by Natalie	2	49

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed