Search results for query: *

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

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

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

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

Hi! I get the following message when I try to run my Excel application on some of the computers: “Could not load an object because it is not available on this machine.” A VBE window than opens with a message: “Compile error: Can’t find project or library”. This happens with Date object and mid...

Hi! I would like to prevent the user from saving any changes he or she has made to the Excel workbook. How do I disable the Save Prompt that appears upon closing the workbook? This procedure doesn’t work for me: Private Sub Workbook_Close() ActiveWorkbook.Saved = True End Sub...

Hi! I have a problem with an application I have made in VBA for Excel and hope you will be able to help me out. I have made a small database in Excel with user interface, which is shared between several users in our company. The problem is that not all users use the same version of MS...