Recent content by JohnnyG23

Never mind. Guess I was just looking in the wrong place. http://www.tek-tips.com/faqs.cfm?fid=855

I tried that an it only let me select one Table to pull values from and I need it to pull values from three tables.

Ok, so I have three tables: CURRENT, Employees(linked), and School(Linked). Currently all three have an address but because of disputes the addresses vary. I was hoping to setup some kind of form were a user can select one of the address and that choice will be written into the CURRENT table...

Oh, right sorry about that. I just noticed in my first post I put cell instead of column. Ok, well I fixed it and it works now. Thanks so much for the help.

Wow, thanks. I appreciate that. The line: a2 = Split(a1(1), ")") is returning a run-time error '9', subscript out of range. I'm not really sure what my subscript is so I have no idea on which value to change. I'm guessing it deals with the value a1, not too sure though. Any idea which part of...

Hello, I have an excel workbook with some messed up values. I am trying to replace the number in the parenthesis with a value, starting at one and continuing until the data stops. The data is as follows from Cells B, C, and D on Rows 3, 4, 5, and 6: A1A'SP (311)'!I1 A1A'SP (311)'!C49...

Hello, I currently have a table that is full of copier information. What I am trying to do is figure out if there is a ten percent difference in BW copies over a months time. Currently the table looks like this. CopiersID Month Year BWCount 5 9 2008 7871155 5 10...

Ok, turns out all I needed to do was add OR (([Employees].Preferred_Name)<>([CURRENT].Preffered_Name)) to the end of my WHERE statement and all seems fine now.

I tried editing the ((Trim([Employees].PREFERRED_NAME & ""))<>"")) line, but no luck there. I also tried adding (Employees.Preferred_Name <> CURRENT.Preffered_Name) I realize that may not be the best or correct line to add but SQL isn't my native language so I'm slowly learning it as I go...

Alright, after doing some other things and testing this it doesn't want to change a preferred name if one already exists in both fields. Is there anyway to fix this? Thanks

Awesome. Thanks so much PHV. Problem solved.

Oh wow. That made things look much better. Is there any way to modify that so that it will ignore display equal blank cells in both Employees and in CURRENT. -Quick reference- CURRENT = Preffered Employees = Preferred Like, when I do Datasheet view for the select query, which is almost...

GingerR, I agree with you on the two databases part but that's how my boss wanted it so I can't really argue it. I'm sorry it was hard to understand but it's kind of hard to explain without seeing it all in person so I tried to explain as best I could. But, I think you are right in finding the...

I need some help on a query. What I am trying to do is have the query look at Employees and find all the preferred names that are not in the CURRENT table and update the CURRENT table. My problem right now is that all of the fields that need to be updated in CURRENT are just blank so the query...

I appreciate it though. I have never used a delete query so the syntax is very foreign to me, especially the WHERE and FROM parts of it. Does my correction work fine or would your code be a more proper method of doing it? Thanks.