.pdf Storage

Hi,

I want a form with a subform that views a .pdf file, is it possible? I have
a scan documents in .pdf type I want that it will view under subform.

Let say I have combobox bound to a query [Drawing Number]. I want that when
I choose a certain drawing number it will show in the subform the .pdf
documents related to it. And when I choose another drawing number it will
display another .pdf documents related to it. Example if I choose drawing no.
BC-123456-001 it will displayin the subform the documents related to it. And
when I choose BA-145678-005 it will display the documents on the subfrom
related to it.

How would I start making it, if it is possible? pls. need your suggestions
and ideas.

Lastly how big is Access 2003 is capable of storing data?

thanks for any help, I appreciate

Denver,
Given that the unbound combobox on the main form is
named [cboDrawing Number], and your control in the subform
is named [Drawing Number].

On the subform's properties, make...
Link Child Fields = [Drawing Number]
Link Master Fields = [cboDrawing Number]

Use the AfterUpdate event of the Main form's [cboDrawing Number] to
Requery the subform, whenever the combobox value changes.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Denver" wrote in message
...
Hi,

I want a form with a subform that views a .pdf file, is it possible? I
have
a scan documents in .pdf type I want that it will view under subform.

Let say I have combobox bound to a query [Drawing Number]. I want that
when
I choose a certain drawing number it will show in the subform the .pdf
documents related to it. And when I choose another drawing number it will
display another .pdf documents related to it. Example if I choose drawing
no.
BC-123456-001 it will displayin the subform the documents related to it.
And
when I choose BA-145678-005 it will display the documents on the subfrom
related to it.

How would I start making it, if it is possible? pls. need your suggestions
and ideas.

Lastly how big is Access 2003 is capable of storing data?

thanks for any help, I appreciate

Thanks Al Campagna,

follow question I want to view the scan documents instead a hyperlink in my
subform would it be possible in access 2003.

thanks again

"Al Campagna" wrote:

Denver,
Given that the unbound combobox on the main form is
named [cboDrawing Number], and your control in the subform
is named [Drawing Number].

On the subform's properties, make...
Link Child Fields = [Drawing Number]
Link Master Fields = [cboDrawing Number]

Use the AfterUpdate event of the Main form's [cboDrawing Number] to
Requery the subform, whenever the combobox value changes.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Denver" wrote in message
...
Hi,

I want a form with a subform that views a .pdf file, is it possible? I
have
a scan documents in .pdf type I want that it will view under subform.

Let say I have combobox bound to a query [Drawing Number]. I want that
when
I choose a certain drawing number it will show in the subform the .pdf
documents related to it. And when I choose another drawing number it will
display another .pdf documents related to it. Example if I choose drawing
no.
BC-123456-001 it will displayin the subform the documents related to it.
And
when I choose BA-145678-005 it will display the documents on the subfrom
related to it.

How would I start making it, if it is possible? pls. need your suggestions
and ideas.

Lastly how big is Access 2003 is capable of storing data?

thanks for any help, I appreciate