Recent content by LeoM

As far i understood (because is the first time i'm forced to use it), the only way to use a BE in a SharePoint is to create a local link to the Sharepoint (in OneDrive) then create a virtual disk. In this way my FE can use the BE tables.

Yes, it was my next question on what happen when PC is off. No, this is not feasible because there are many impacts on this: - I will go home in the afternoon, and people may work night shift so no access to my pc - I may be on leave (so pc off) So, the answer is yes, database should be...

ok so the users they will connect to my pc trough the Network? finding the shared folder under my pc number/name ?

Sorry not clear. Do you mean I should share a folder physically located in my PC or in my OneDrive or where?

Thank you to everyone first of all and I fully agree but when you don't have any other alternative (because this is the reality) i believe you should follow what the company allow you. All around the world i always usually used a network drive to store the BE. In the country where i'm now, the...

Great, good idea, i used to check the string but not with Debug.Print but directly in the execution so it was not visible if correct or not. Thanks a lot, problem solved.

Goodmorning everyone. I'm actually mapping a virtual drive connecting to a share folder which all users have already accessed. I'm, using the following simple code which work perfect for one user (C020411): Dim objShell As Object Set objShell = CreateObject("WScript.Shell") objShell.Run...

Thank you all, really great solution and information. Although all the solutions either gives me alternatives and/or lesson learns, the solution proposed by "arnelgp" solve 100% my problem, is exactly what i need. In this way I'm always sure that, even if someone use a file located in a "local"...

Hi, thanks for the answer/suggestion and sorry if i was confused. You are righ, in my explanation i forgot to say that, once i move the file, i should update the link (with the new one). Just to summarize: 1. I have a sub form (the source is a table with 2 fields: ID and LINKED_DOC (which is...

Hi, thanks for the answer/suggestion and sorry if i was confused. You are righ, in my explanation i forgot to say that, once i move the file, i should update the link (with the new one). Just to summarize: 1. I have a sub form (the source is a table with 2 fields: ID and LINKED_DOC (which is...

Good morning, everyone. I have a form which I use to store some selected files (any type) in a table. In the form there is a button which allow me to open "Explorer" and select the file, the code i use in the "Click" event is the following: Me.LinkName.SetFocus RunCommand acCmdInsertHyperlink...

I tested the script but, as also the one suggested by Gasman, the imported file has only "STRANGE" characters in the first raw. Attached the 2 files (original and the one I obtained but the script). Cheers

Thank you, for the answer. Yes, correct, i don't have access to Sharepoint list and i have to copy from Sharepoint document library to local folder. And yes the library is synced so probably could be link trough VBA but i really don't know how to do. I tried to get the link from one of the file...

Thank you, i will check once i can reach the website, since is blocked in the office :-)

I used Type 1 (Binary), changing to Type 2 (text) gives error to the line "stream.Write httpRequest.responseBody" with the following message: Runtime error 3219 - Operation is not allowed in this context. Cheers