I'm using MS Access 2002 SP3 & Visual Basic 6.3 on WinXP Home SP2.
I have a table of condition data (5990 records) that relates to information stored in a proprietary application. The primary key in my table (MyKey) is the same as the key used to find data in the other windows application (C:\Folder\My.exe). So, if I am looking at a record in my table, say with ID = 100, I can view further information and images etc in my application by running:
Expand|Select|Wrap|Line Numbers
- C:\Folder\My.exe -i 100
I can't seem to do this with the Hyperlink field type, as it wont allow the command line parameter (-i 100). Hyperlink will only work to launch the application alone (no parameters).
I can do it perfectly using the OLE field type, inserting a link the the exe file as an 'Package' object, then editing this (right click, Package Object, Edit Package) using the Object Packager pop up window. In the Object Packager I do menu option Edit, Command Line and put in the full "C:\Folder\My.exe -i 100". Then I do File, Update and quit the Object Packager. Now my field displays "Package" and when I double click it, my application is loaded and shows ID 100 perfectly.
Now, how can I use an update query or even a VB script to run though the whole table and build these "Command Line" options in the OLE link field?
Any suggestions?
Thanks in advance, Rishi.