Clive Beaton
asked on
How do I get a shelled program to appear on top of the Access window?
I use Shell "c:\WINDOWS\notepad.exe (etc) to display the contents of a file which works well, but appears behind the Access window. How can I get it to display on top?
Thanks in advance.
Thanks in advance.
Shell("c:\WINDOWS\notepad. exe", vbNormalFocus) - not maximized
Shell("c:\WINDOWS\notepad. exe", vbMaximizedFocus) - maximized
Shell("c:\WINDOWS\notepad.
ASKER
Thanks. How do I create a line to include the path and file name, eg. Application.CurrentProject .path\Even tLog.txt
Application.CurrentProject.path & "\EventLog.txt"
You might need to use the AppActivate statement to make the notepad session active. Hopefully, there is a distinct title bar caption for you to reference.
ASKER
MacroShadow,
Can you please help me with this. The following line of code doesn't find the file.
Shell "c:\WINDOWS\notepad.exe Application.CurrentProject .path & \EventLog.Txt", vbNormalFocus
Thanks.
Can you please help me with this. The following line of code doesn't find the file.
Shell "c:\WINDOWS\notepad.exe Application.CurrentProject
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect. Thank you very much.
Open in new window