Search results

This is the code that is working. Thank you. Private Sub cmdUpdate_Click() Dim strSQL As String strSQL = "UPDATE Students SET Students.UpdateWorkshop = -1 " strSQL = strSQL & "WHERE Students.[ID] IN " strSQL = strSQL & "(SELECT TOP " & CLng(Me.Textbox1) & " [ID] FROM Students As S " ' select...

June 7, I want you to know that your new code works, but it only checks the very 1st box . Making progress! Thank you

This is the latest SQL statement UPDATE Students SET Students.UpdateWorkshop = -1 WHERE Students.[ID] IN (SELECT TOP 5 [ID] FROM Students As S WHERE ([S.UpdateWorkshop]=false) AND ([S.Workshop]=Null) AND ([S.Major] In ('BADM', 'PBA')) AND ([S.Session]='1'));UPDATE Students SET...

I had a feeling that UpdateWorkshop checkbox value should be true or -1 or 0 Here is the result from the Immediate window for debug.print strSQL UPDATE Students SET Students.UpdateWorkshop = -1 WHERE Students.[ID] IN (SELECT TOP 5 [ID] FROM Students As S WHERE ([S.UpdateWorkshop]=false)...

I will work on building a sample DB.

Yes, I agree. I need a sample DB. I will try again to build one. I will also review my data. I closed the other thread. It was getting too LONG>

Current error message: Run Time Error 3464: Data Type Mismatch in criteria expression. My questions are below Module1 code A value is entered in the Textbox1 (on a subform) and a button run this code and fails due to Run Time Error 3464: Data Type Mismatch in criteria expression Private Sub...

I want to thank each coder that has been assisting me. This underlying thread is not solved but I marking this thread solved. I will be opening new thread with details of the current direction of this issue. Again, thank you

Here is the database documentation for the students table

Please send me the link with the instructions for prepping a DB for uploading. I ran across a few days ago and now I can't find it :(

Access 2016. As I am working in Access 2016 MS Visual Basic for Applications soI am not sure where my references window is. Here is my workspace showing the Function fExecuteQuery.... below is the same space for the for the cmdUpdate code.

You called it right. There were two modules with the same code. Now when I trigger Module1 fExecuteQuery....., results in a compile error. user-defined type not defined (these lines are highlighted when the error message dialog appears). Function fExecuteQuery(strQuery As String, _...

let me know if this will not work for you.

I will have to remove objects next as I already did compact it. I will read the instructions for prepping files and uploading to this forum

File is too large to upload. Can you access it from here? https://uoregon-my.sharepoint.com/:u:/r/personal/mreniff_uoregon_edu/Documents/Access%20Forum-%20micron/2020%20Introducktion%20MASTER.zip?csf=1&e=9beepn

Give me a few minutes to make a stripped down version

Give me a few minutes to make a stripped down version

Thank you for being so patient with me. I followed your instructions. I pasted the code from http://www.accessmvp.com/thedbguy/codes.php?title=execqry and saved it as Module1. My code is a follows: Private Sub cmdUpdate_Click() Dim strSQL As String strSQL = "UPDATE Students SET...

Thank you. I am grateful for your help, but this is just too far passed my skills level. I will continue with the original code