Recent content by ddsnydersnyder

Thanks Dcrake! That didn't quite work but got me started in the right direction. The change that fixed it was: temp("analyst").Value = analyst

It's a table. Found the issue with #1. During the upgrade to 2007, I also migrated the table from local to Oracle Server. i wonder why it won't let me now... Thanks for your help. Can anyone easily tell why I am having issues with problem #2?

I have two questions. the two questions both pertain to the below Code at the bottom of this post 1) I receive an error 3219 and 'invalid operation' error on the code "temp.AddNew". This worked in 2003, but now fails now that I run in 2007 2) I need some help on the code. The below code...

makes sense - thanks. I try to do the above in my own DB's, but I inherited this one, so changing it now would take a solid week:-( Thanks again!

A little background, I am truly baffled on this one: I have a simple update query with two tables with inner join. I am trying to update a field in one of the tables. After I save the query and reopen it, it does not recognize the field and labels it as "expression1". This field is...