Hello all,
Some of you may have seen this post in the accessforums.net queries thread, but figured I would expand to see what you folks could come up with.
I have run into a wall in writing the final piece of my DB. This DB is a photo archive that is linked to mapping software. The issue that I have is in creating the final table that the mapping software needs to read in order to display a correct layer that includes file path links to the associated images.
The final table does not really follow standard Access DB rules for a table since it forces multiple sets of images into the same record row. Here is the basics for my DB:
Table: Photo_File (stores the Unique_ID and file base for each entry)
Table: Project (Stores the Unique_ID, project name, and project area)
Table: Spatial (Stores the Unique_ID, UTM coordinates (2), LAT/LON, R2Veg_Loc (specific to the map layer), and Stand_Num (forest stand))
Queries: Photo_Link Query (creates the table Photo_Link and builds the file paths to the images)
I have 2 other queries that I am trying to rid myself of since they only lead to problems with duplication. Hence VBA coding. BUT, I am not a VBA officionado, so I am asking for some serious help.
I need to write VBA code that accomplishes this:
The final table should look something like this:
[Easting_UTM][Northing_UTM][R2veg_Loc][Stand_Num][Photo_Year][IMG_North][IMG_East][IMG_South][IMG_West][Photo_Year2][IMG_North2][IMG_East2][IMG_South2][IMG_West2][.....
Let me know if I need to post the sample DB.
I need to get this done ASAP.
Thanks,
Adam
Some of you may have seen this post in the accessforums.net queries thread, but figured I would expand to see what you folks could come up with.
I have run into a wall in writing the final piece of my DB. This DB is a photo archive that is linked to mapping software. The issue that I have is in creating the final table that the mapping software needs to read in order to display a correct layer that includes file path links to the associated images.
The final table does not really follow standard Access DB rules for a table since it forces multiple sets of images into the same record row. Here is the basics for my DB:
Table: Photo_File (stores the Unique_ID and file base for each entry)
Table: Project (Stores the Unique_ID, project name, and project area)
Table: Spatial (Stores the Unique_ID, UTM coordinates (2), LAT/LON, R2Veg_Loc (specific to the map layer), and Stand_Num (forest stand))
Queries: Photo_Link Query (creates the table Photo_Link and builds the file paths to the images)
I have 2 other queries that I am trying to rid myself of since they only lead to problems with duplication. Hence VBA coding. BUT, I am not a VBA officionado, so I am asking for some serious help.
I need to write VBA code that accomplishes this:
- Searches the Photo_Link table for Easting_UTM AND Northing_UTM coordinates.
- Writes the values into a new table.
- Writes the values of the location, stand, photo year and image paths into the same row.
- THEN, matches other records with the same coordinate set and writes the second (third, fourth, etc) photo year and image paths into the same row.
- Loops through until end of records.
The final table should look something like this:
[Easting_UTM][Northing_UTM][R2veg_Loc][Stand_Num][Photo_Year][IMG_North][IMG_East][IMG_South][IMG_West][Photo_Year2][IMG_North2][IMG_East2][IMG_South2][IMG_West2][.....
Let me know if I need to post the sample DB.
I need to get this done ASAP.
Thanks,
Adam