Search results

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

Thank you, now is clear. Just a minor modification in the TRANSFORM query, should be like: TRANSFORM Min(Switch([CrosstabHeading]="BeginDate",[STARTING_DATE],[CrosstabHeading]="EndDate",[ENDING_DATE],1,[Owner])) AS Expr2 SELECT qselSubSystems.Subsystem FROM qselSubSystems, tblCrosstabHeading...

As i specified in my post, I exactly followed what DHookom suggested (post 11). In the same post (before post 13) it was mentioned that "If you want a particular order to the columns, I would use a little VBA to modify the SQL of the crosstab to set the crosstab headings based on the max seq...

No need, thanks anyway, i tried to build VBA myself using the SQL you suggested as result (i named "FinalResult"). This is the VBA which will create the final query (FinalResult_rc) I need with values in correct header order: Cheers.

Yes, this is perfect, thank you. Yes, I need the order of the header as below so I would appreciate If you can show me the little VBA you are talking about to obtain it: Cheers.

Hello, they added now another column, the Owner. So each StartDate and EndDate is refer to a owner (see below): And the result should be the follow: I tried to update the PIVOT sentence in the Transform queries, but it does not work (maybe I'm not able enough) could you kindly suggest me...

Thank you all, really appreciate your kindly support. I will give answer to all of you below: To CJ_London : The query, output of the code you provide, it works, and it is exactly what I need in term of query. Then, since my final scope is to have a "physical" query, I will modify the code...

Thanks a lot, first of all. Ok I build the Q1 and Q2 and is clear and work fine. Now, the combined query should be dynamic, not manually because records may change (i.e. more start/end date) so how to write the combined query which will work dynamically in case of record change? Not sure i'm...