如何从MS Access打开外部程序 [英] How to Open an External Program from MS Access
问题描述
各位大家好，
我有一个数据库，其中包含一组与每条记录相关的文件，其中包含有关它们的相关信息。当这些文件是xls或doc文件时，我将它们存储为超链接没有问题，并且在点击时让MA打开它们，让我们说一个表单上的命令按钮。
但是，有一种特定的文件类型，属于信号处理的私人软件。因此，将文件（实际上是文件夹）存储为超链接是不够的。我想知道是否存在与其他标准程序类似的可能性，通过单击命令按钮打开程序，并打开每个主题的文件夹，可以将其存储为附加文件 （？）。考虑到使用上述程序绘制信号并对其进行评估，此函数将用于可视化目的。
我想提前感谢任何建议或线索这个。此外，如果有人知道不可能做这样的事情，我会告知警告，不要浪费时间尝试编程。
再次感谢！
Hello everybody,
I have a database with a set of files related to each record containing relevant information about them. When these files are xls or doc files, I have no problem to store them as an hyperlink and make MA opening them when clicking, let''s say a command button on a form.
However, there is an specific file type, which belongs to a ''private'' software of signal processing. So, storing the file (which is actualy a folder) as an hyperlink is not enough. I was wondering if there is the posibility, similary as done with other standard programs, to open than program by clicking a command button and make it open the file-folder of each subject, which could be stored probably as ''Attached Files''(?). This function would be used with visualization purposes, given the facility of use of the mentioned program to plot signals and assess them.
I would like to thank in advance any suggestion or clue for doing this. Also, if somebody knows that it is impossible to do such thing, I will appreaciate the warning not to waste the time trying to program it.
Thanks again!
推荐答案
首先，您可以使用SHELL命令运行其他程序，例如：
First off you can use the SHELL command to run other programs for example:
让我们在这里谈谈Windows。
通常，文件会自动从链接打开，因为文件类型已经与特定应用程序关联（在Windows中）灰。但这对文件夹来说是不可能的，因为它们通常不包含文件类型。如果软件可以与特定文件类型（可能是文件夹中的一个文件）相关联，那么通过将软件与该文件类型相关联并将链接更改为文件夹中的特定文件，而不是文件夹本身。
如果那不可能那么 Shell 命令将是你最好的选择（正如Smiley的帖子所述）＃ 2）。
Let''s talk Windows for a second here.
Normally, files are opened automatically from a link because the file type has been associated (in Windows) with a particular application. This is not possible with folders though, as they typically don''t include file types. If the software can be associated with a particular file type (One of the files in the folder possibly) then this could be achieved most easily by associating the software with that file type and changing the link to the particular file within the folder, rather than the folder itself.
If that''s not possible then the Shell command would be your best option (as already covered in Smiley''s post #2).
首先感谢你们的建议。
我在第一次尝试应用NeoPa的建议，似乎更简单。我不得不说该程序非常密集。它打开名为''name.slp''的文件夹，所以我试图找到文件夹内部，文件具有相同的扩展名，并使用该文件作为超链接，但它不起作用。
所以我切换到TheSmileyCoder给出的选项。实际上，我可以打开程序，但在尝试打开特定文件夹时，它会给我一个错误，指示我正在尝试打开的文件夹有错误。但是，如果我直接从程序中打开相同的文件夹，它就会起作用，证明没有这样的错误。
所以，任务已经解决了一半。现在我想知道在程序文件中我可以找到哪个是使用Shell函数打开文件夹的方式。我试图填写文档，但它都与用户指导的信号处理任务有关。你们有谁知道在哪里可以找到这种信息？或者，程序是否可能如此关闭以至于不允许Windows访问其内部功能？
再次非常感谢您！
First of all thanks to both for your suggestions.
I tried in first instance to apply the suggestion of NeoPa, as seemed simpler.I have to say that the program is quite hermetic. It opens folders named as ''name.slp'', so I tried to find inside the folder, the file having the same extension and use that file as hyperlink but it didn''t work.
So I switched to the option given by TheSmileyCoder. In effect, I''m able to open the program, but it gives me an error when trying to open an specific folder, indicating, that the folder I''m trying to open has an error. However, if I open the same folder directly from the program, it works, evidencing that there is not such error.
So, the task is half-solved. Now I was wondering where in the program files I could find which is the way of opening the folder with the Shell function. I tried to chech the documentation, but it is all related to user-directed tasks of signal processing. Does any of you have a clue of where to find this kind of information? Or, could it be possible that a program is so closed so as not to allow Windows to access its internal functions?
Thank you very much in advance again!
这篇关于如何从MS Access打开外部程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
