I need some help with this form “frmAddSheetNo” In the dbLine Data Base. I tried to copy and paste the information that had been entered for adding Sheets and spools in the
“db Projectdb_1_30_06” but it keeps giving me error messages asking for “Dim db As DAO.Database” and I do not know what this means.
Then I need to be able to filter the latest revision in my “qryProjectLines” because sometime engineering will reissue the same drawing to 2 or 3 times as in
Project Name -“Pemex KU-A2 Booster “
Unit “A”
Line Num ber “1600”
Then I have tried to get my form to show a list base on selection. Beginning with selecting the ProjectPD to show all Lines in a list associated with that PD Number. Then I would like to use that list to generate another list to show Lines with Sheet Numbers and then by clicking on an object in that list show Sheet and spool numbers.
But to begin with whenever I change the text box to a list box it looses the child link. And it goes down hill from there
If it possible I really would grateful for any help with this.
Thanks Chuck
“db Projectdb_1_30_06” but it keeps giving me error messages asking for “Dim db As DAO.Database” and I do not know what this means.
Then I need to be able to filter the latest revision in my “qryProjectLines” because sometime engineering will reissue the same drawing to 2 or 3 times as in
Project Name -“Pemex KU-A2 Booster “
Unit “A”
Line Num ber “1600”
Then I have tried to get my form to show a list base on selection. Beginning with selecting the ProjectPD to show all Lines in a list associated with that PD Number. Then I would like to use that list to generate another list to show Lines with Sheet Numbers and then by clicking on an object in that list show Sheet and spool numbers.
But to begin with whenever I change the text box to a list box it looses the child link. And it goes down hill from there
If it possible I really would grateful for any help with this.
Thanks Chuck
