Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JohnnyG23

    Selecting one option from multiple tables

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

    Selecting one option from multiple tables

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

    Selecting one option from multiple 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...
  4. JohnnyG23

    Macro to replace rows sequentially

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

    Macro to replace rows sequentially

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

    Macro to replace rows sequentially

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

    Comparing sequential values

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

    Query recognizing blank cells troubles

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

    Query recognizing blank cells troubles

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

    Query recognizing blank cells troubles

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

    Query recognizing blank cells troubles

    Awesome. Thanks so much PHV. Problem solved.
  12. JohnnyG23

    Query recognizing blank cells troubles

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

    Query recognizing blank cells troubles

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

    Query recognizing blank cells troubles

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

    Delete query with linked excel and access table

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

    Delete query with linked excel and access table

    Ok, I think I just figured it out. All I did was change INNER JOIN to LEFT JOIN and it removed the 200ish employees I needed. Thanks anyways though.
  17. JohnnyG23

    Delete query with linked excel and access table

    I didn't see an edit button anywhere and I thought I would mention that a TechID consists of something like R01234567. They will always start with R and have eight numbers after that R. The TechID is also the primary key. Thanks.
  18. JohnnyG23

    Delete query with linked excel and access table

    Ok, I have an Access table that is updated with changes from a linked Excel document. This table contains employment information so if there is a change in the system I will have a new employee table emailed and I will overwrite the old one. Now, what I need help with is the delete query. If an...
  19. JohnnyG23

    Appending an access table with linked excel document

    Ok, something very wierd happens with Access query editor. I was working in the Design view and it has the base table as Employees and then updates the CURRENT table, which is what I wanted. So, I looked at the SQL view and it has Employees table set to equal the CURRENT table, which PHV says...
  20. JohnnyG23

    Appending an access table with linked excel document

    Ok, tried out what you said and I'm still getting that error. Whenever I swap to Datasheet view it has quite a bit of info in there. It looks like everything in there should be updated so I think it's going to update correctly I just don't understand why it gives me that error. I am using "_"...

Part and Inventory Search

Back
Top