Search results

  1. J

    Object(s) get set to nothing when an error occurs.

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

    How to generate/create Excel range subaddress in an Access hyperlink field.

    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...
Back
Top Bottom