Search results

Okay....if that is the case....how do I adjust the code to insert the "new" Photo_Year (and the other "new" attributes) into the table in the right row?? Please add coments to the code I pasted in my last post so I know where to go and can see what is happening.

Okay....starting to get somewhere, but still a ways off from where I need to be.... I made adjustments based upon your suggestions, as well as a couple from what the error(s) returned. Now I am getting a Run-time error 3265: "Item not found in this collection". The affected line is in red...

Okay...got that commented out and added the Explicit to the top. But, am receiving Run-Time error '6': Overflow on line 56 (red) of the code: Option Compare Database Option Explicit Function Get_DB_Values() 'Get values from a table using a query in VBA. 'Process values row by row. 'Insert...

Okay...fixed that. Now the code does nothing. I am at a loss :confused::confused::confused:

Could you please expand upon this? I'm not sure what exactly you are referring to in your statement.

Okay folks.... I have made a little headway, but am still experiencing issues with my VBA. The good results: It appends a table. I can isolate the unique easting coordinate. The bad results: The northing coordinate is wrong, and the other fields may be wrong too. The second set of images and...

Please Assist Anyone with ideas? I am willing to try anything at this point. If what I ask cannot be done in VBA please tell me. Can it be done via SQL queries, without having duplication? Do I need to restructure the tables/DB? (one note on this...it must remain in the .mdb format so that...

Each Unique_ID links to the same ID in several tables. Spatial locations (map coordinates), Project, and Photo files. The photo paths that get built are essentially hyperlinks that are read by our mapping software. The coordinates put a point on the map...you click the point in the map and a...

Here is my sample DB. The only query remaining is the Photo_Link query, since this is the one that builds the links. I have left out the other 2 since they don't work the way that I want/need. The tables have _MOD appended to the names to denote that this is the test data to build and debug...

I am using Access 2007, but the DB is in 2002-03 format. Yes. I will upload in my next post. The Photo_File table holds the Unique_ID which is linked to the other tables. The file base is the common portion of the file name that applies to 4 photos associated with the record. All data is...

Anyone with thoughts?

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...