Search results

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

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

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

Hello Folks, i have got the following Problem, i want to load a ribbon with vba that disabels the option button for my frontend. When i load it manually it works perfect but it doesn't work in vba. I get the error 32610: (Name of my DB) cannot load customization 'option'. This customization...

Hello there, I am happy to join this Forum. I worked with MS Acces for a halb year now and recently started using SQL Server as Backend for my main Company Database. I like programming and i am a litte perfectionist :) Cheers Simon