Search results

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

Having much more experience in PHP, a web based solution was also my prefered solution, but unfortunately the desicion is not entirely mine. The users will only run forms whish will produce reports in Access and Excel. they will not have the ability to change data in the database. @bloating...

I see. The users for the tool prefer to copy the complete database to their notebook and then run the forms whenever they like, wherever they like. I did consider splitting the database into a front end and a back end, but decided not to do so after some consideration. The users will download...

I'm starting to doubt whether I understood you well the first time... By local you mean that the table is stored in the same database as the one in which all the modules, forms and tables are stored, right? Because creating a second database to store the temp tables into seems to me just as well...

You are right there. If it slows down the pocess significantly, limiting the functionality is a valid choice. The table is local. When looking for temporary tables options in Access I did read about creating a whole temporary database and storing temporary tables in there. I can see its...

I really don't like user limitations when they are only technique based. In my opinion programmers should strive to give users maximum functionality, independent of the hassle they have to go through to achieve that~ I worked it out through the use of temporary tables and looping through the...

That is a pitty. More and more I see that VBA does not like arrays. Thanks for the reply vbInet, you have been very helpfull for me so far.

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

Yes. Although this is not something for which I forsee that it will happen often, I like to have form being capable of handling all possibillities. The listbox query rowsource will produce almost 10000 records. Thus, theoretically it should be possible for the user to select any number betweer 1...

I have build a dual listbox module class where selected items are moved from one listbox to the other one after clicking a button. The selected item vlaues are stored in an array. A property of the class holds a string of the vlaues which have been selected, and thus should show up in the...

I have been away for a couple of days, sorry for teh late reply. The options presented above concerned the getrows method, which will only will work for the entire query rowsource of the listbox. It will obviously not work for just the selected items. So to convert the selected items into an...

I see, the GetRows solution is what i need indeed to get all the items of the listbox in an array. however, I really would like to convert only the selected items into an array as well. Is it possible to convert the Listbox.ItemsSelected into an array without looping through them? Also, what...

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

Aye, Now that I try it again it seems to be working correctly... I thought I had tested it properly, but apparently I had not. My appolopies for wasting your time.

The following is a representation of my code: Option Compare Database Option Explicit Public clsClass As New CClass Public Function InitiatePublicVars() clsClass.Name = "Name" clsClass.Source = "Source" End Function Private Sub Form_Open(Cancel As Integer) InitiatePublicVars End...

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

I completely agree with your last statement. However, to be able to choose the right skinning method, you need to know more than one method. The Eval function seems like what I was looking for indeed. Thanks for your help and patience :)

Well logic usually comes from experience. And my experience in VBA is 5 weeks old now :) To be honest my specific issue was solved by Mr. B's suggestion, as it was about form controls. However, I can imagine coming into a situation where I would like to do operations on a string variable by...

I see. Is there an easy way to find out what collection an object is part of?

Thanks a lot for your quick reply Mr. B. I tried your suggestion and it works great. However, this will work for form objects, but what if it is an object which isn't a control of a form?