Search results

  1. Guus2005

    Import must be read as-is into a table.

    I allways thought that when i import a table in SQL Server the file was imported as i was presented. File: This is a file in which the sequence is very important. But i am having doubts as to the truth of that statement. And if it is not, how can i make sure that it is? I am using this...
  2. Guus2005

    Fast Code Sample

    .Fields("staStatus") is slow .Fields(0) is slightly faster and apparently set fld = .Fields("staStatus") is very fast. I just reduced a process from 2 hours to 2 minutes. It is a gamechanger!
  3. Guus2005

    Collection.Add doesn't create new item but adds to item1

    Yes, you are right. I should have seen that. Must be getting old... Thanks for the demo_concat.zip file!
  4. Guus2005

    Collection.Add doesn't create new item but adds to item1

    Tried to register on that site to get the Demo_Concat.zip sample database but that didn't work. Bummer.
  5. Guus2005

    Collection.Add doesn't create new item but adds to item1

    Thanks Eberhard, Declaring space for the variables to concatenate in is very nice! I had such a class once but i lost it. I think i will try that solution. I don't speak German but i do speak VBA so that's no problem. And on-topic: Collection.Add should add an item to the collection and not...
  6. Guus2005

    Collection.Add doesn't create new item but adds to item1

    i have to concatenate 200K records into a textfile for further processing. I took 4 hours to process by doing x = a & b & c. I know that there i a much faster way to do this by using clsBuildString. But instead of creating new items in the collection, each add command concatenates to item1...
  7. Guus2005

    Fast Code Sample

    While looking for fast code i found this one sitting in a forgotten directory on my NAS. It has a different way of addressing a field in a recordset. I don't know where i got it from but here it is: tblStatus had 85K records in the sample database. DoitSlow took 1000msec DoitFast took 200msec...
  8. Guus2005

    Collection.Add doesn't create new item but adds to item1

    I have a lot of concatenations to do so i used a class to do that more efficiently. clsBuildString It uses a collection to store every string and then joins everything together. Which should be faster than x = a & b & c. When i debug the code i notice that new items are not created and all...
  9. Guus2005

    Regex question

    thank you all for your input. I'll try it next time at work!
  10. Guus2005

    Regex question

    I have a problem and i want to use REGEX to fix it. Now i have two problems, i know. The solution is simple: Remove all double quotes not directly preceded or directly followed by a semicolon. The problem is that i have 3000 csv files which need to be checked and corrected if the following...
  11. Guus2005

    Fast way to cut a long string

    I don't want to use the mid function because every time you use it the complete string (1500 char) is needed as input and then a string is returned from the 13th character with length of 12 characters. Then for the second i need the from 25th over a length of 200 characters. You can imagine...
  12. Guus2005

    Fast way to cut a long string

    i have a long string of about 1500 characters. i need to cut it in 15 pieces First from 13 length 12 Second from 25 length 200 Third from 290 length 34 Fourth from 450 length 10 Fifth from 460 length 2 etc. I know that there is a way to use mid or mid$ ofcourse i don't want to use the mid...
  13. Guus2005

    Merry Christmas and a Happy New Year in 2023

    Best wishes for 2023!
  14. Guus2005

    Solved Broken references

    I have an application written in Access 2013. Ported to Office 365 64 bit. In that application there is a reference to the Word Library 16. I had some complaints about the application and when i opened the application in Access 2013 i saw that the reference to Word was broken. I added a...
  15. Guus2005

    Adding fields sum

    did you try using Nz? If so, split the problem into smaller pieces. Add a column profit/loss per record and see if there is any result before summing it all together.
  16. Guus2005

    Adding fields sum

    [Total Sales (UGX)] = NULL so the end result is NULL same goes for ![Total Purchase (UGX)]. Use Nz to circumvent this problem Profit/Loss: Sum(Nz([Financial Summary Tbl]![Total Sales (UGX)]) -(Nz([Financial Summary Tbl]![Total Purchase (UGX)]) +Nz([Financial...
  17. Guus2005

    Left Join vs Inner Join

    Hi Pat, never seen a hostile response from you. But here we are. I didn't create the query and yes i know that you should focus on what you want to achieve. I was suprised when the outcome for both joins was the same and i needed an extra arguments to convince the person who wrote the offending...
  18. Guus2005

    Left Join vs Inner Join

    I am going to change the LEFT JOIN to an INNER JOIN. Thanks for all the answers and Colin thanks for the speed comparison tests.
  19. Guus2005

    Left Join vs Inner Join

    If a left join produces the same result as an inner join which is the better choice? Which one is faster?
  20. Guus2005

    Solved DMax and Days between Dates

    sorry, didn't read the whole question... you can join the table with itself and in the join select the values smaller than Date Something like this: select t1.date, t2.date as PrevDate from Table t1 join Table t2 on t1.date < t2.date There should also be a group by involved. This is not a...
Top Bottom