Recent content by admessing

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