Search results for query: *

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

Hi! How can I achieve that a certain procedure repeats several times when holding a button? That is, if I click the button with a mouse I want the procedure to repeat once but, if I hold the button for a longer time I want it to repeat itself several times depending on the length of the time, I...

The code works even too good and won't let me save itself ... is there a way around this? What I would like to do, is just disable the save prompt and still be able to save the changes. I tried to use the Before_Close event but it didn't do the trick for me? Cheers, Bostjan

It works! Thank you both ... this forum is great! Cheers, Bostjan

PHV, Thank you for reminding me ... you post has been most helpfull! Cheers, Bostjan

Unfortunately, neither solution works. ;-( I get the following message in both cases: “Compile error: Procedure declaration does not match description of event or procedure having the same name.” Could someone please give me a working example either with Before_Save or Before_Close event...