Recent content by JamesPower4

Many thanks to both of you for your help. It will take me some thinking to assimilate The_Doc_Man's tutorial, but his explanation makes sense. I do have error handling in my procedures, but it's certainly possible that the code in those handlers isn't correct, or that I'm not fixing the error...

This has been driving me crazy. It occurs in different contexts, but here's an example. I have a subform, and in the subform's module I declare a dictionary object to keep track of some information: Private colFlaggedNodes As Scripting.Dictionary In the subform's load event I set a...

Hi! Thanks for getting back to me so quickly. In the interest of brevity I posed my question as building a hyperlink, but the problem occurs elsewhere as well. Here's an example of a failed attempt to build the hyperlink in a control (txtLink) that's set to be a hyperlink and bound to a...

Hello: I have been having great difficulty generating an Excel range subaddress in Access that includes the worksheet name and range's cell address(es). I would like to use this string as a subaddress in the hyperlink. The worksheets have spaces in their names, so the subaddress should look...