Here's the problem: I am working on a database (I am not a programmer, I am just doing it for learning, and this is for a non-profit), where each record would have a PhotoLog sub form. The PhotoLog subform would have information on several photos (that are linked and not embedded) for each of the records in the main database. The main database would be changing hands, and each time the location of the photo folder may be changing. So, the folder location would have to be updated.
I am trying to do the following:
1. The photos for each record in the subform can be browsed. the file name is separated from the browsed path and then concatenated to a photo folder location. A thumbnail is displayed through an image frame, and another field stores a hyperlink (which when clicked would display the photo in a default photo viewing program).
2. There is an update parameter query that allows the user to set (the first time the database is used) and/or update (when the database is populated, changes hands, the location of the photo folder changes, and the new user resets the folder).
I cannot get it to work. a) The folder location cannot be set, if there arent any records; b) The thumnails are not displaying properly. If the folder path is removed, and the form has a simple browse and display, it would still not work.
I can use any help that I can get. I am attaching the a scaled down version of the database with only the subform, parameter update query and tables. It is probably too much to ask for in forum, but again, I have learned a lot from this forum and can still learn some more.
Thanks.
I am trying to do the following:
1. The photos for each record in the subform can be browsed. the file name is separated from the browsed path and then concatenated to a photo folder location. A thumbnail is displayed through an image frame, and another field stores a hyperlink (which when clicked would display the photo in a default photo viewing program).
2. There is an update parameter query that allows the user to set (the first time the database is used) and/or update (when the database is populated, changes hands, the location of the photo folder changes, and the new user resets the folder).
I cannot get it to work. a) The folder location cannot be set, if there arent any records; b) The thumnails are not displaying properly. If the folder path is removed, and the form has a simple browse and display, it would still not work.
I can use any help that I can get. I am attaching the a scaled down version of the database with only the subform, parameter update query and tables. It is probably too much to ask for in forum, but again, I have learned a lot from this forum and can still learn some more.
Thanks.
Last edited:
