If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
.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 |
#2
|
|||
|
|||
.pdf Storage
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 |
#3
|
|||
|
|||
.pdf Storage
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 |
Thread Tools | |
Display Modes | |
|
|