Recent content by fra

I finally killed the silly 21time repetition by removing the function as a field value and replacing it with an identical function triggered by "OnApplyFilter", writing the value directly into the text field. Now each click on a checkbox results in 1 (one!) update of the field, it is fast as...

No, there isn't. The form has an event at opening (reset all checkboxes to default True), the checkboxes have events on_click as described and that's it. The form functions exactly as designed and very fast, too. In fact, other than the bottom line showing "calculation running..." (or similar, I...

Hi, In my Access 2010 database there is a form with a large number of checkboxes enabling me to select/deselect certain record details. Each click on one of the checkboxes triggers a VBA routine setting true/false values in one of several tables linked to the main table. A query over all...

Jiri, Season's Greetings to you too! As it is not my code, I don't feel the urge to fight for it. You are right in pointing out that your code needs fewer iterations, which could be an issue when computing vast numbers of conversions in one batch. Also, mathematically, the beauty is definitively...

Jiri, Here is an even shorter (and more elegant?) solution to Roman Numeral conversion which I found some time ago somewhere in the depths of Access Newsgroups: Public Function RomanNumeral(ByVal aValue As Long) As String Dim i& Dim varArabic As Variant, varRoman As Variant Dim strResult...

Michael, beautiful - I can now directly call the desktop icon and open the program as designed! Thank you very much! Fritz

No, in the extended properties of the desktop link icon, I can select "run as administrator" and I do not have to do anything else but double-click the icon. Fritz

Thank you, Michael. Shell "runas /user:administrator ""C:\Program Files (x86)\.......exe""" produces a cmd-window prompting to input the administrator password. This appears to be one way of doing it, but in an even more inconvenient manner than the dirty solution (minimize Access, double-click...

Hi, I need to start an (open source) program from Access 10. Unfortunately, this program only opens and runs when "started as administrator" - no problem with the desktop link, where I can add this feature. In Access, however, the standard program call (Shell("...exe",1)) fails. Is there a...

Nanscombe, thank you very much - it works perfectly! Fritz

Nanscombe, many thanks - it works perfectly! Fritz

Hi, This thread has made a wish come true: For the first time I have managed to successfully add a file path selected from a browser window to a table's field! One slight inconvenience remains - the code presented opens the file browser at the location of the database: "Set fd =...