Re: How do I click a button to pull up a single file within a form

I'll start from the beginning.

I've created 3 forms. One for entering employee data, one for entering
client data and one for entering order information. All 3 are databases in
Access.

The user will enter the oder information for the employee's job. Once the
order is inputed, the user needs to be able to look up the order and send
this order (would not like to have the client information shown to the
employee) to the employee.

I've created the order form with tabs. Will that make things more
difficult? or can I print certain tabs?

Thanks




"Douglas J. Steele" wrote:

Yeah, clear as mud <g>.

What are these files: plain text, or something else?

I'm not sure how feasible it's going to be to "print that file only omitting
2 fields" from within Access.

As to exporting the file to Word, you'll probably be best off writing a
module that Automates Word, and import it into Word through that module.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Rachelle" <Rachelle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ADA90E45-512B-4CD1-A3E9-C1859A82BB62@xxxxxxxxxxxxxxxx
I have created forms for entering client info, employee info and work order
info. In the work oder info there will be many files.

I'd like to create a page where the user can type in a file number from
the
work order and print that file only omitting 2 fields

Is that as clear as mud??

and can I export that file to Microsoft word?

Thanks

"Douglas J. Steele" wrote:

Not quite sure what you mean by accessing a file from another form. Are
you
talking about a physical file that's outside of your database, or do you
mean a data row that's displayed on the other form (which means that it's
in
a table in your database)?

If the former, you can invoke the standard Windows File Open dialog using
the code from http://www.mvps.org/access/api/api0001.htm at "The Access
Web".

If the latter, you'll need to give a better explanation of what you're
trying to do.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Rachelle" <Rachelle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1D06C102-4B57-48C5-A1B3-67EC00129F26@xxxxxxxxxxxxxxxx
I'd like to create a form so I can access a single file from another
form
by
typing in the file number






.

Loading