Search results

Okay, I see I'm not the only one with this problem. Thank you all for your help! I think I'll try to find a workaround, or I might just close the frontend.

Hello everyone, I am currently working with a SQL Server backend that is connected to a Microsoft Access frontend. The frontend dynamically creates tables and queries as needed, so these objects are typically not stored permanently. I set it up this way to ensure that not all users share the...

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...

Okay, I understand what you mean haha; it seems a bit unconventional, but I get it, i explain. I want to create a completely secure ACCDE copy of the current database with a single button click and distribute it. I've set up everything in this form, which is exclusively for me (the developer) to...

Okay, it seems like a better solution for sure, but I'm still encountering the error on the second click. However, I've found a workaround for this error buuut the Problem is still there: Dim FlexName As String FlexName = "rbbBlank" & Now() Dim XML As String XML =...

Yes, of course. The objective is to create a completely secure ACCDE file, and as you'll see, this is the final step. I've copied over all the relevant elements to ensure the form functions correctly. However, the bug is still present.