Search results

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

I really appreciate your support and thanks for this. Actually, I have only SharePoint and i never used in all my past years' experience. I went through the code step by step, but it seems the problem is that it doesn't care about the contain of the CSV file, or better, data are not filled in...

Thank you. Unfortunately, although this procedure creates an empty file (only first raw of the file is filled with many random characters). So probably there is something not correct.

Good morning, everyone. I'm little on trouble and i need your kindly suggestion wherever is possible. This is the scenario: I have a database which has some tables linked to some csv files located in my C drive (specifically C:\Local). Up to now all good. The original csv files are daily...

Thanks for the answer but not idea what you mean, appreciate if you clarify it. Mainly what i need is a msaccess VBA function to do it. Cheers

Good afternoon, everyone. Reading in the messages, I understand that to bypass the issue refer to the Excel importing procedure in Access (who checks the first 20 rows to decide the field type in the target table) is to use a CSV file. Actually, I'm not in the condition to ask to the user to...