Search results

Guessing because you haven't included what the error message is or on which line. Place a breakpoint on the lines where you're creating the query and check the values of the variables that you're concatenating to make sure the values are what you are expecting.

Even if the Access database is on a network drive you don't need to use an external connection to connect back to itself.

Downloaded it, I'll give it a look to see if there is anything that jumps out at me. EDIT: Give this a try, I just switched it from creating a new connection to instead just using the currentdb object to write the data. Function WRITE_DATA() 'Dim conn As Object ' ADO Connection Object...

Can you post the database?

Why is the code for submit_btn_Click() using a new connection to connect to and write the data? It calls class_fld_Change() so they're in the same database and the latter is using the CurrentDB object to read the data saved from the ParametersTbl. Why not use CurrentDB during the submit_btn code?

Thanks for the tip @Gasman

Using what I read in an article titled "Count Unique and Distinct Values in Excel [With Examples]" I created a pivot table with the count of distinct items in my list. Then sorted that by count in descending order. Now just make another area where you link to the first 10 cells of this pivot...