Search results

Hi, arnelgp, Thanks for the suggestion on SQL statement. I will work on this issue this weekend when I have more time. I’m working every day this week. I work for and essential company due to the coronavirus. And thanks to all the other responders.

Hi, MickJav, Gasman, Cronk, Thank you for your responses today. I’m going to eat dinner and get ready for work tomorrow. Yes, we have the corona virus in Florida USA, and I’m an essential worker. I’ll get back to you guys asap.

Hi, Gasman, I’m sorry, but I don’t see the links you posted to show me how to delete relationships with VBA? Could you send them again?

Hi, Cronk, You may have a good idea! Monday, I will try that on a test database, and I’ll let you know what happens.

Hi, MickJav, The two tables I imported into the users database from external access database contain only NEW data that is then appended via queries to the existing tables in the user database. This is why I can't delete the data in the user database. Maybe I can perform Make-Table-Queries of...

Hi, MickJav, The two tables are imported into this database from another access database where they have relationships, and somehow they come over with relationships by there selves. If you noticed the tables I import have the same names as the ones in the user database, they only have a 1...

Hi, Gasman, I don't want to delete the two unwanted table relationships manually, and then delete the tables. I want to see if the users can delete the two tables using VBA code. They cannot get behind the startup form to do this.

I’m trying to delete two tables that I import into a 2016 Access database regularly to update other program tables in a program using a VBA code behind an “On Click” [Event Procedure] command button in a form that keeps returning a “Run-time error 2387. You can’t delete the table...

Hi, My name is Mike (USA Miami Florida), and I'm a novice MS access program designer. I hope to learn more about designing MS Access databases. I really like creating Access databases.