Hi,
My database has a option for attaching files to it which contain information about the specific record.
The information about the files is stored in a table called 'tblFiles', the filenames that are used make reference the primary key from the main table where data is stored 'tblAR'.
For example a file name would be 'P11.doc' or 'O11.pdf' the letter at the front defines the type of document it is within the database on tblFiles and the number on the end is the AR Number which is the primary key in the main table 'tblAR' the AR number is also recorded in tblFiles but the field is not a primary key, the file name is primary key in this table.
What I want to do is have a button on one my forms that you can click to print the form showing the current record and also have an option to print the attached documents.
I have looked at the example that is talked about in http://www.access-programmers.co.uk/forums/showthread.php?p=378313#post378313
But can't find anyway of making this happen with the example.
Hoping that someone can help me with this.
Cheers,
Ryan
My database has a option for attaching files to it which contain information about the specific record.
The information about the files is stored in a table called 'tblFiles', the filenames that are used make reference the primary key from the main table where data is stored 'tblAR'.
For example a file name would be 'P11.doc' or 'O11.pdf' the letter at the front defines the type of document it is within the database on tblFiles and the number on the end is the AR Number which is the primary key in the main table 'tblAR' the AR number is also recorded in tblFiles but the field is not a primary key, the file name is primary key in this table.
What I want to do is have a button on one my forms that you can click to print the form showing the current record and also have an option to print the attached documents.
I have looked at the example that is talked about in http://www.access-programmers.co.uk/forums/showthread.php?p=378313#post378313
But can't find anyway of making this happen with the example.
Hoping that someone can help me with this.
Cheers,
Ryan
