I would like to link objects in a specific module to an existing database in Microsoft Access. I have written some dxl that does what I want based on the current object, but In order to use it I have to run it from the drop down menu in the module. This is not acceptable. What I want is a way to select an object and "follow a link" to Microsoft Access from that object. I realize that external links do not work in this manner (right?), but that's the closest wording I know to explain what I'm looking for. The options that I am considering right now are as follows:
Add an entry to the right-click context menu for that module. I have two issues with this:
- I do not have write permissions to the folder on my hard drive where I would need to place the additional dxl code to populate the menu
- Would this solution work for everyone that opens the module, or just me?
- Add a text attribute that says something like "click here to open database" and apply a trigger to it. The issue I have with this option is that I cannot apply a double click trigger to a single attribute (as far as I can tell - please tell me if I'm wrong!), so the user would have to forfeit the ability to double click on an attribute to edit it...right?
- Add some other type of external link to each object. I have no idea what that would entail
As you can see, none of these options seem altogether acceptable. Does anyone have any ideas as to how I might accomplish my goal? Any ideas are welcome!