Windows 7 64bit 
Access 2007
I work for a wholesale textbook distributor that buys used books. Some of these books are in pretty bad condition and need to be rebound by an outside company for us. I setup a database that will help me formulate a list of books that I am going to send to this rebinding company. The process of formulating this list requires the following steps:
1. I need to sort the books into various categories established by this rebinding company.
A. There are 5 categories numbered 1, 2, 3, 4, 5.
2. After sorting the books I need to find out if the books have any value to us for resale.
A. I have a table in my database of all the books with value to us (Table Called Adopted Titles)
B. I have a query setup that asks me to first enter a category, after entering the category I have a popup ask me to enter a book SKU number
C. If the book is listed in my table (Adopted Titles) the query appends the following information to a separate table (Scan Table) for me (ISBN, Author, Title, Edition, Copyright Year, etc)
I keep running into a problem with Access giving me an error message
"Microsoft Office Access set 1 field(s) to Null due to a type conversion failure, and it didn't add 0 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations.
Do you want to run the acation query anyway?
To ignore the error(s) and run the query, click Yes.
For an explanation of the causes of the violations, click help."
If I click Yes I can see the book information is appened to my scan table, if the book is listed in my adopted titles table however its not appending the category number (1, 2, 3, 4, or 5) that I entered.
I attached some pictures to this that shows how my database is setup and how my tables are joined in my query. As you look my primary key is called CA, that is basically a sku number or my companies system assigned number that is unique for every item we sell.
Please help!
Reply With Quote
