Recent content by eatraas

No, indeed I can not provide any links because this is confidential. It seems that we will have to choose another path, away from Access.

No, as I understand Is will be formatting an URL and calling this URL which will change, in this case, the status of the order. Af first the token must be set up to be able to do that.

IHi, in this case yes! Erwin

Hi, thank you. The clients want to use this because it will give us access to their Sharepoint environment. We need to change a certain property of the orders we get from them. Now it is a manual action, logging in and doing a number of things to change the property of the order. This is very...

Hello, Has anyone used MSAL ( Microsoft Authentication Library) from ACCESS? Some starters would be nice. Searching on google did not reveal much. I need to implement this for a client. Regards Erwin

That should be simple indeed, is the form of encryption important? in this case AES256. Regards Erwin

Hello, I'm puzzled. My client is changing some settings on their SQL servers, each connection should be encrypted. Can this be done with ODBC or should I use another type of connection? Please assist. Thanks in advance. Erwin

I'm glad you are willing to help but I will not be able to share this database, it is a database of a client of mine. It is also rather big and connected to an internal SQL database.

Hi, not that I'm aware of, it is a spreadsheet-like form connected via a field on the parent form. Loading the forms show the correct data, just after entering new data is shows another completely unrelated record.

Hi, we have some nested forms, on the lowest level adding a record goes well but just as it saves another record is shown. Reloading the form shows the correct records. Any idea what could be causing this? Regards Erwin

is solved in an other way, the sheel program was making a new files and this was taking some time: I solved it by creating a loop which checks if the file is existing, and exits the loop when the file exists , like draait = False Dim FilePath As String FilePath = "c:\tmp\somefile.pdf" Set FSO...

Yes, i tried it but is not working, if you read the article it is also not working for this person, i'm geeting the same error

but that code does not wait until the process is done, just kills an existing process. I want to wait.

this : Function IsProcessRunning(process As String) Dim objList As Object Set objList = GetObject("winmgmts:") _ .ExecQuery("select * from win32_process where name='" & process & "'") If objList.Count > 0 Then IsProcessRunning = True Else IsProcessRunning = False End If End Function

MF is an own utility which combines a number of files into one pdf, yes at that moment it is running. Could be anything of course, like notepad.exe.