Search results

I need a little guidance here. I need to add to this VBA a means by which to deal with a third possible matching CoordID and its related data (Photo_Year, and image links (4)). This VBA as is works just fine for combining 2 records, I just need to get it up to a third: Option Compare Database...

Okay....got this in....but....it gives me an error "Compile Error: Do without Loop"....what do I need to add to it? Also...still waiting for an answer to my previous question...need to delete a table before a new one can be created...How to? Option Compare Database Option Explicit Private...

Anyone with a solution?

LOL...we meet again....Thanks...will give it a go and let you know how it works. :D BTW...how do I get it to delete an existing table first? ie the Coords table that needs to be built before appending to it?

Issue resolved for the most part...a bit different than I had planned...but it works.

Hey there.... I would like to automate a series of queries that update various output tables for my DB. But, I am not exactly what you would term a VBA programmer. I could use a bit of help in writing the code to get things running. Could someone (or several someones) give me a chunk of...

I already have a form for the data entry. So, I could add an update button to the form, but would rather have the DB update automatically as soon as the form is closed to avoid forgetullness. I would gladly breakdown the data further, but I am limited by the parameters set by the department...

Whew!!.....managed to get everything working....all the way to the end. Now I just have to see how the final table displays on my map and then run it through a few times to make sure it doesn't break. Then I need to "mash" all the queries into one simple update Module/Script...whatever. You...

Okay...finally got everything to display correctly. But my queries for each direction are in different tables now....how do I write the code so that they are all in the same one?

Just had a thought...I notice that this is an append query...the issue that I see is that this will cause a lot of duplicate data since all of the queries will have to be run anytime that more data is added to the DB. I am trying to avoid duplication at all costs. Especially since one the...

Okay...can get it to work for the most part. But it won't bring in the year....I just get a NULL field. INSERT INTO Photos ( CoordID, PhotoYear, PhotoDirection, Path ) SELECT Coords.CoordID, Source.PhotoYear, "North" AS Expr1, Source.North FROM Source INNER JOIN Coords ON (Source.Stand =...

Okay...looked over the DB you sent. Still having issues with getting the tblPhotos to populate with anything other than the North photos. How do I need to enter the parameters for East, South and West? So far all i get is errors. And I noticed that your source table is completely empty...why?

I don't have a column with "Direction", all I have is the image paths, coordID, and photoID. What is it that I am not seeing here? How do I get the "Direction"?:(

I seem to be having a major issue with the first query that you gave me. I can't get the query to combine the year and direction together. I'm not entirely sure what I am doing wrong. Code Snippet for Directions: SELECT CoordID, North AS PhotoYear&" "&North, East AS PhotoYear&" "&East, ...

Okay....I am making a bit of headway...but the issue I am having is with the Photos table. The PhotoPath as you have it is what my IMG_North, IMG_East...etc are. I do not have a PhotoDirection separate from that, and to have that in my table, I think, is very redundant. Maybe if I can look at...

Okay....I have a SELECT DISTINCT * query that can populate a new table with just the unique coordinate sets (plus location and stand). How do I get it to add the PK within the SQL? As for the tblPhotos....I'm not entirely sure how to get to that structure from what I have. I apologize if...

Okay...I think I can see where you are trying to going with this. But, how exactly am I supposed to do a coordID as a primary (or foreign) key, when there isn't one to begin with....and the coordinates are entered every time with the new photos? The real DB as it stands right this minute...

The values come from the second matching row with the same coordinates. i.e. Row #2> Photo_Year = Photo_Year2, IMG_North = IMG_North2, etc. The first four fields (Easting, Northing, Location, Stand) are what is common to both rows (green), but the Easting and Northing are the key to...

Attached is a snapshot of what I have to combine...notice the Photo_Year difference....for the same coordinates....

LOL...yeah...problem is no funding....otherwise this would have been shipped off to a contractor to do. I know that the Photo_Year2 field (or any of the IMG_*2 fields) do not exist in the Photo_Link table....I am attempting to insert those values into the new table based upon matching...