Recent content by Fantast

Hi, I received the advise to create a Linked table in Access, which links to the SharePoint Document Library. There I should be able to see a field "Modified", and the documents should be attached in the table. I have however not been successful in creating such a Linked Table. Any advise would...

Hi. I have a https link to a SharePoint folder where some Excel files reside. I need to download the last modified file in that folder through VBA. The answers I have found by googling assume that I have a network path to the SharePoint folder (\\sites\...\documentsFolder\). However, I only...

Actually Dutch, but I have been to Edinburgh. Unfortunately it wasn't during the Tattoo performances, but still very recommendable ;) I actually started in PHP and MySQL, and I still prefer them any day any time over VBA Access. But this is my company laptop, and we simply have to use the tools...

Aye, good point, should had mentioned the version as well. Office professional plus , Access 2010. OS: Win 7.

Thank you for your suggestion RainLover. Unfortunately it did not work. However, somehow it did make me try something else, which did work. I guessed that maybe it is a shortcoming of Access where a change in the case of the characters was forgotten to be taken into account when updating all...

Hello, I have this weird issue, which is not causing me any errors, but is kind of weird imo. I have a class module which was named CDoubleListbox. The class module is cused inside a form class object in the following way: Public clsRegionLb As New CDoubleListboxToday I decided to change the...

Hi again. I'm posting this answer to my own question as it may help others who struggled with the same issue. I will first give a short summary of the usual way in which it is done, and after that the way you can do this without VBA programming and minimum effort. This is done in Access 2010...

Thank you for the reply Mr B. I have created class modules in the past which handle double list boxes very well, doing what you described and more (select all/deselect all / switch columns). I definetly could use them again for this case. I was just hoping that I could get the job done without...

Hello. I expect the answer to my question is quite easy, however I did not manage to find the answer through searching the forums. I have three tables for which I would like to create a data entry form. The tables will contain the answers to a questionnaire. Table 1: contains text field...

Thank you spikepl. Your reference helped me a lot with understanding the way dates work in Access and solving the problems. The code seems to work fine now, more testing is scheduled for the coming days. Cheers Fantast

Heys. I have an issue with my VBA tool regarding dates. It is an issue which only popped up after the Access Database was distributed to different countries around the world. The date format is different on each of those regions, causing malfunctioning scripts all around. In Eastern Europe they...

I started the projects without custom classes and collections, but at some point the quantity of the code and the repetition in it forced me to change my mind and go for custom classes. Now I'm rewriting great leaps of it before moving on. Thanks for the info, again :)

I see. So that would be the same for all pointer objects, right? So It is not possible to make a copy of a complete class to a second one, unless you copy the value of each property of that class to the other class?

Hi. I have this module class where one of the properties is a collection. At some points I want to be able to do the following to my class: fix the state of collection1 (stor it's content into collection2) do things with collection1 reset collection1 to the value of collection2 The weird...

Well, "winning" is only relative of course. Their choice will make them loose on accessibility convenience, report generation speed, ease of future changes implementation and independency. Of course I would rather build a really good tool and be proud of it, but being restricted like this also...