Recent content by Spalle

Yes of course :) Credit goes primarily to arnelgp

Okey i got it working, thank you all very much :)

It doesn't have to be this complicated! I have a linked table in the database where the field is an OLE field; there's no need for a server connection here. Do you know of a simpler approach?

Yes, this saves the screenshot. That was the initial step. Now, I need to save this screenshot into a table. How can I accomplish that?

The code is no longer functioning properly, at least not for me. The initial issue arose when the screenshot tool was triggered to open unexpectedly. I managed to address this by incorporating segments from my previous code. However, the second problem persists in the form of an error.

Hello, i want to save a Screenshot to an OLE Field (varbinary on the server). I have come this far: Private Declare PtrSafe Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long) Private Const KEYEVENTF_KEYUP = &H2 Private Const...

Yes that was the Problem, thank you :)

I can show you the code

Alright, I've managed to find a workaround for the error. I believe the issue stemmed from my connection to the database using Microsoft Authentication, whereas my coworkers used a password. To address this, I created a loop that iterates through all tables, deletes them, and then recreates and...

Yes of course, It says: Error while connecting SQLState: S1000 SQLServer Error:0 Microsoft ODBC SQL Server Driver(Cannot generate SSPI Context i think it is this error on english

Hello Everyone, I am currently facing an issue with the ODBC connection to my SQL Server. While it functions perfectly on my personal computer, it encounters difficulties on my coworkers' PCs. They have successfully set up the ODBC connection on their machines, and creating a new database and...

Haha, i will do my best not to go crazy :)

Thank you both very much 😊

I am using the 365 Version of MS Access, but i think the function that i use for making the ACCDE is a old. Are you using this Version aswell?

Yes, I understand now, and it's working perfectly for me. Thank you very much! :) The idea of deleting it is clever as well. My Idea was to created another ribbon in the USysTable that displays the standard and then I just switch back and forth. If you're interested, I'd be happy to help you...