Hello fellows
I have this problem. I'm making this DB with three different types of personnel and I 've got to have a photo of each one of them. So I made a table for each type of personnel and a table where their photos will be stored. The photo storage table will have three columns.
1. An autonumber column with a certan format for the autonumbering
2. A column containg the unique identification number of each person of any type of personnel.
3. The column where the photos will be stored as links to a specific folder where the images will be stored.
My camera is used with remote access from my computer so I can configure the path and the filenames of the images stored. So I will have the images have file names with the same format as the autonumbering of the first column.
So what I'm asking is this:
I need code for a button that when clicked will write in the images storage table the link with the image file name which is exactly the same as the autonumber of the first column.
And a second question though not so important. I know that by mail merging I can print multiple reports of the same format using the data from a table or a query with MS Publisher. Does anyone know how can I automate this procedure?e.g If I have a form from a query and I want to print the data of this query; how can I do this through a Publisher publication and not by making the report from scratch in Access?
I would love to hear from you.
Ovidius
P.S The first question is the most significant. But an answer in the second would help me a lot. Thnk you all in advance.
I have this problem. I'm making this DB with three different types of personnel and I 've got to have a photo of each one of them. So I made a table for each type of personnel and a table where their photos will be stored. The photo storage table will have three columns.
1. An autonumber column with a certan format for the autonumbering
2. A column containg the unique identification number of each person of any type of personnel.
3. The column where the photos will be stored as links to a specific folder where the images will be stored.
My camera is used with remote access from my computer so I can configure the path and the filenames of the images stored. So I will have the images have file names with the same format as the autonumbering of the first column.
So what I'm asking is this:
I need code for a button that when clicked will write in the images storage table the link with the image file name which is exactly the same as the autonumber of the first column.
And a second question though not so important. I know that by mail merging I can print multiple reports of the same format using the data from a table or a query with MS Publisher. Does anyone know how can I automate this procedure?e.g If I have a form from a query and I want to print the data of this query; how can I do this through a Publisher publication and not by making the report from scratch in Access?
I would love to hear from you.
Ovidius
P.S The first question is the most significant. But an answer in the second would help me a lot. Thnk you all in advance.
Last edited:
