Recent content by hitech70

Thank you Frothingslosh. Your code worked for me. But I would really appreciate if you can tell me why my code didn't work, or where I made a mistake? And you are right about the "ID", I have a different variable name in my code, but I changed it here for posting the code. Now, I went a step...

This is an MS Access application connecting to SQL sever database through ODBC I have a login where I need to delete records from the table before adding another records t the same table. I get the existing records in a record set and then I loop through and delete them one by one Next, I try...

Thank you for your reply. Yes, sure. But I thought there could a fix for the dcount() limitation or something else

I'm using MS Access to create a form to complete a data entry which store data in a MS SQL Server database, and I connect through ODBC, using SQL Server Native Client 11.0 When using the DCount() function to find out the count of records with certain text, and when the Criteria has a text of...