Search results

  1. C

    Append Query with Key Violation

    Thanks I was able to get everything resolved and working perfectly
  2. C

    Append Query with Key Violation

    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...
  3. C

    Append Query with Key Violation

    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...
  4. C

    Append Query with Key Violation

    That is correct and I can't figure out why...
  5. C

    Append Query with Key Violation

    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...
  6. C

    Append Query with Key Violation

    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...
  7. C

    Runtime Error 3075 Debug stops on DoCmd.RunSQL SQL

    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...
  8. C

    Runtime Error 3075 Debug stops on DoCmd.RunSQL SQL

    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...
  9. C

    Runtime Error 3075 Debug stops on DoCmd.RunSQL SQL

    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...
  10. C

    Runtime Error 3075 Debug stops on DoCmd.RunSQL SQL

    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.
  11. C

    Runtime Error 3075 Debug stops on DoCmd.RunSQL SQL

    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...
  12. C

    Importing Excel Spreadsheet into subform

    ok here are the files can't seem to get it to work right. Thanks for the assistance.
  13. C

    Importing Excel Spreadsheet into subform

    Yes that would work removing prior then replacing with new. I'll upload a sample of the database and spreadsheets I use.
  14. C

    Hello From California USA

    Hi Whittier it's about 15 miles east of Los Angeles
  15. C

    Importing Excel Spreadsheet into subform

    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...
  16. C

    Importing Excel Spreadsheet into subform

    Hi, Yes I know a form is just a window to the table. I need to update the table in the subform and maintain the data and refresh the data or append with new data as necessary. I have 300 projects; and each data download from our work system db only provides a single download for each project to...
  17. C

    Importing Excel Spreadsheet into subform

    I'm currently working on a subform that I need to upload data from a spreadsheet. I'm getting my data from one of our work data systems that i'm able to download a spreadsheet for each project I have in my database. Each spreadsheet is unique to each of my projects. I've searched online and have...
  18. C

    Hello From California USA

    Hi, I'm basically a novice without any formal training in Access although I have made several databases. I generally copy and modify when possible. I work for a large Aircraft company and i'm currently building a database to manage projects. Glad to be here! Chuck
Top Bottom