RunApp action

J

Jasper Recto

What I'm trying to accomplish is this: I am setting up a workstation out
on our plant floor. It will be completely locked down. The user will see a
Access prompt asking for a part number. That part number will be linked to
a Word document that opens after they enter the part.

What I have done is created a form that ask for a part number. Then I
created a macro that uses RunApp to open Microsoft word. That macro is
bound to the field as an event on exit. It opens Microsoft Word with no
problem. My question is, how can I get access to open the file the user has
just been prompted for? I would like to create a variable the I could put
at the end of the RunApp command line but is that possible. I do not want
the user to use Word to search for the file. I just want the file they
entered to open.

Any ideas would be greatly appreciated.

Thanks for your help!!!

Jasper Recto
 
M

Marty

There's actually an easier way. If you want to use the
approch you suggested, there's certainly a way you could
write this in VBA however I would create REPORTS using the
Word documents in question. What you would do is simply
open a Report in Design View. Click Insert > Object.
Click "Create From File", Click browse to find and select
the Word file, then click the Link check box and OK to
complete. Then using the Event (say, On Change) you can
have the appropriate REPORT display. And, because it's a
linked Document, any changes in the Word Document will be
reflected in the REPORT.

Marty
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top