Recent content by JohnnyBGood

Any suggestions? Even if you think it doesn't require a query. Thanks

Hi, I have a single table (it's a BOM Requirement table). So I have one column (field) of the table labeled BaseID. I have multiple BaseIDs and and they each have multiple Records. I want to be able to take all the records for a BaseID (say 100 or so) and I want to copy only certain...

Thanks guys. All points well taken and will be pondered. I think I like Pat's recommendation and will try to convince the powers that be. :eek:

I am trying to create a form for a table that is linked to an Excel spreadsheet. The table already has legacy data in it, and my boss wants me to design this form so that rows can be added to this data in Excel. It's in Excel because there are various manipulations they want to do to the data...

The database is our ERP (Enterprise Resource Planning) system... I cannot post any of that and can't even fake it up.... It is a large database consisting of many tables. This particular table has foreign keys to several other tables.....

Yes, it is a foreign key as it is Indexed.. It seems like a difficult task to have to do as quoted though..... especially on this our ERP database

It's not part of a key... see attached for properties. And Sandbox is our test database ;)

Hi, The datatype for PART_ID is text. The Sql for Select query is: SELECT SYSADM_REQUIREMENT_Sandbox.PART_ID FROM SYSADM_REQUIREMENT_Sandbox WHERE (((SYSADM_REQUIREMENT_Sandbox.PART_ID)="56402") AND ((SYSADM_REQUIREMENT_Sandbox.WORKORDER_TYPE)="M") AND...

Hi, I was wondering why my Update query is saying 0 records will be updated. I started with a Select Query as in Pict1.jpg attached. This returned a couple of hundred records. I converted the query to an Update Query and added a Part_Id in the Update to field so that I can essentially "find...

Hi again, I think I have finally figured it out. It was violating some foreign keys. There are a few in this table. Those foreign keys required columns to be null or existing items in those foreign key tables.... I had 0's in some of them, causing the problem. Now it appended with no...

This is our ERP (Enterprise Resource Planning) database. I am not sure how I would post a sample of that and also there are confidentiality issues. I am not even sure that this Primary key is the issue... all I know is I get the typical key violations error and is states the 6 records have not...

So those 7 keys is a composite Primary key made up of 7 columns. I tried doing an import table from Excel and setting the same 7 columns as a composite primary key... and I still get the key violations error.

Hi, If you look at Pic1.jpg I attached before, there are 7 fields with a key beside them, that is what I meant by 7 primary keys. Pics doesn't have any keys, that is my import from Excel that I want to append to the table in Pic1. Pic3 shows the Excel important in Table View mode. Field 1 is...

Any further advice on my last post from anyone?

Okay, I thought of a possible easier workaround (for me anyway) I created an Excel spreadsheet that lists the rows I want to append into my database and then I linked my Sheet to create an access table. Now my main database has 7 primary keys and I can't append due to key violations. Ie. no...