Exactly when I close the import form to run the query it's not passing the FK TCTODataID for the data to associate it with the BingoUpdate form to which it goes. As in what Member EBS17 stated I did have a default 0 set. Once I removed that. It appended to the table and the key violation went...
Ok BingoUploadID is there so the ImportExcelTemp doesn't have a key since it's importing data from a spreadsheet. When I append to BingoUpload table I'm only transferring the 4 columns. It's only temp data then I delete the data. The only time I have the key violation is with the FK TCTODataID...
Ok Sorry for the confusion without pics.
Let me reexplain: The "ImportExcelTemp" Table is an import from excel using the "ImportExcelSpreadsheet" Form. When I Close the form (VBA Shown) it runs the Append Query "TempBingoTransfer (SQL Shown) to move the data from"ImportExcelTemp" table to the...
I'm appending to a new table and I get a key violation. It's not the data from the source table nor is it the destination table to same columns. I created the destination table from the source so everything matches. If I do not include any referential links where each table stand alone...
Thanks I like this approach and would be a lot simpler. I'm not sure how to put it or where for a single text box; I can do it with the Dcount as you can see in the pic but that requires a separate query with Dcount in the Control source (=DCount("*","TestRM")). So to get the count for the...
Yes I have done this in other areas but I prefer not to clutter up with a tremendous of queries. This is my first time using SQL in VBA to manage a query function. So the obvious isn't so obvious to me at this point. I'm just testing with a simple query which is the basis where the rest are...
I would agree as I've done that many times but in this case I can't call the OpenQuery since eventually I just need the record count from the query. I need to repeat this about 60 times with variations to get proper status counts. I'm just stepping thru it to make sure everything is working...
I took out the comma after the ON and still does the same thing. Just as a side note I can't call the OpenQuery since eventually I just need the record count from the query. I need to repeat this about 60 times with variations to get proper status counts.
Unable to figure out why i'm getting a Run-time error 3075. The VBA Message box pops up with the Blue section listed and in the VBA editor the RED item is highlighted in yellow. The SQL is from an existing query that works fine. Currently i'm just using a command button (temporarily) to display...
I'll try to keep this simple so it doesn't confuse you so you can better understand. The data system where I get the download from provides status with completions for each Aircraft that the project is performed. As they get done completion dates are added. Periodically as needed I look up that...