Fantastic!! After a deep analysis of the program, finally it worked perfectly! Thank you very much once again!
It's time to move to the next topic in MS Access...
DamePique
Last Activity: Jan 1 '12, 12:18 PM
Joined: Nov 8 '11
Location:
-
Well, I essentially need to know how to generate a CMD file (is that a txt file to be executed?) and how to make it execute from a Command Button in MS Access.
I will try to explain what I want to do so maybe you can give me a hand (again). Basically when pushing the command button [View File] in a report, Windows should:
1. Open the Program: Open ProF Software (which can be located in a different directory according to the...Leave a comment:
-
First of all, thanks to the 3 of you for your quick and useful answers, and sorry for the lack of feedback for a time, but I had to stop the project for several days. However I'm back.
Well, nico, the users are precisely the ones demanding a 'graphic' interface in order to facilitate the Population Design. So I don't think that solution will fullfill their expectations. Usually they do it manually, but they're handling hundreds and...Leave a comment:
-
Sorry for the delay in the communication, for several reasons I had to stop for a moment with the database. Well, as you predicted, NeoPa, using SendKeys() is not the most efficient solution for what I wanted to do (opening an external program from MS Access).
The fact is that this solution worked perfectly in my PC, but when I tried to use the Database in another PC, it didn't work. Simply, Windows (I guess) was not performing the...Leave a comment:
-
How to implement a form to retrieve variables to customize a query
Hello everybody,
I would like my Database to be able to perform a Poblational Design. That is, I have a population stored in a table, which is characterized by a number of variables (Age, Gender, Height, Heart Rate...) (at all it makes more than 30 variables).
So I would like to allow the user to select a subpopulation according to the desired criteria.
Let's say, the user want to select a subpopulation... -
I was afraid it was not a very elegant solution, even if it worked :S
Well, I'm pretty new at Databases and VBA, but let me think in your suggestion, understand what you mean and try to implement it. I will report the results here.
Thanks once again for your help. You can't imagine how easy things can become when having the apropiate support!Leave a comment:
-
Fantastic, I think I don't need to contact the Technical Support. I found a reasonable solution using the function:
'SendKeys'
That way, I can work directly from the program GUI by reproducing my movements to open the given folder.
Thanks again!Leave a comment:
-
Dear NeoPa,
I think the problem is not on the Shell Function code-line, but in the permission level the program gives to Windows in order to make it run(I don't know if these are the correct technical terms to define what I mean, but I hope you can understand it). Actually, when trying to open its files using Windows Commands such as 'Open with > Program' same error as with the execution of the Shell Function in MS Access is reported,...Leave a comment:
-
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...Leave a comment:
-
How to Open an External Program from MS Access
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... -
Thanks ADezii it worked perfectly! You really did my working-day!Leave a comment:
-
Dear ADezii
I'm pretty new in this field, so the question I'd make will probably sound evident or even stupid to you.
I'm currently building a medical database containing medical files from patients. So the post you wrote about creating a hyperlink in a form would be really helpful to me in order to alleviate the tedious work of selecting the hyperlink one by one directly on the table.
I think I'm able to adapt...Leave a comment:
No activity results to display
Leave a comment: