Recent content by BostjanPerdan

Issue solved using the proposed alternative solution above ... thanks anyway!

Maybe, I have used the wrong expression for what happens, so I will give an example: I have a table with date, product number and number of cycles the product was used at that particular date. Number of cycles is always 1 and two rows are filled in if the product was used twice on the same...

Hi! In my table with data I have sometimes identical rows (i.e. they contain the same data) and when I make a query, Access most likely overwrites the previous entry with the same data, however I do not want to do that as I later count the rows (using a summation) and get a wrong result. How...

Thanks!

Dear all, I would like to know if it is possible to gather data from two different tables in a single column using a query in MS Access? I would like to do a common list of different events based on the time of each event. These are otherwise listed in two different tables as they do not have...

Wow, that was fast. Thanks! Regards, Bostjan

How do I stop code execution when macro goes into a loop without restarting the computer? I know, it’s a combination of two keys but I can’t remember which …

Hi all, First let me explain, what I am trying to do ... I have created a UserForm which I use to load data into a spreadsheet, create charts by selecting names, that are assigned to columns, and move the selected chart (by calculating values in the table) in x or y direction. I have manually...

Hi all! I have created an add-in to share with co-workers. I would like to know, if it is possible to automatically create a new toolbar and a suitable button when the add-in is loaded on the computer? How is this done? How do I run / access the add-in in the first place (I am not sure, I am...

Loomah, I have just done a similar thing. ;-) I have simply added a Do While loop which I repeat 1 million times and it does the job for me. Is there a batter, more elegant solution? Thanks once again to all, who have replied! Cheers, Bostjan

It works! ;-) The only remaining problem is, that I want the delay to last a fraction of a second wich it seams impossible to achieve using the Application.Wait method?! Cheers, Bostjan

Thanks for the reply! I have copied the code into my computer to test it and it works only partially. When I click the button, the counter starts and continues to count when I remove the mouse pointer away from it. I would also like to know, if I can include some sort of delay to slow down the...

It works, thanks! Cheers, Bostjan

Hi all! The Selected property enables me to find out which entries were selected in a multi select ListBox via their index value. Unfortunately this doesn’t do it for me, because I would like to find out the contents (strings) of the selected entries because the number of entries in the ListBox...

Hi! I would like to know, how can I access or find out in code which items were chosen in a MultiSelect ListBox? ListBox.Value won't work in this case. I have already searched the help but I couldn't find anything useful. Cheers, Bostjan