Search results

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

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

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

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

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

Hi. I have an Access 2007 database which is located on a shared disk. De the database is an ACCDE in running environment (renamed to accdr). I created some Module classes and many functions which are used by the forms in the database. The user will be able to make some selections in listboxes...

Hi. I would like to do a Join on a part of an array. My code would look like this: strJoinedVars(1) = Join(strItemsArray(1:1000), ",") strJoinedVars(2) = Join(strItemsArray(1001:2000), ",") strJoinedVars(3) = Join(strItemsArray(2001:3000), ",") Obviously the strItemsArray(2001:3000) bit is...

Hi. I have a listbox which contains a large list of items (RowSource Type: "Table/Query"). I would like to store or remove the selected items in an array with distinct values. Currently I achieve this with the following code: For Each varItem In sourceList.ItemsSelected...

Hi. This question is not only to solve a problem for me, but also to understand some of the VBA logic. In one of my forms I declare a variable as a class (which I have written myself). After that I set some of it's properties in one of my private functions. However, when trying to retrieve...

Hi. I have this (hopefully) easy to solve question which has been bothering me for some time now. I usually work my way around it, but would like to have an actual solution for it. So now and then I need to reference an object whose name is stored in a varaiable. As example, say I have a...