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 TouchToneTommy 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: *

  • Users: JohnnyG23
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. JohnnyG23

    Appending an access table with linked excel document

    Ok, what I have is a linked excel document and a table in access I want to append the contents of the table to. From what I have read it would be easiest to use queries to do this. I am not very fluent in access so I am not sure if queries are the best thing to do. So far all I have code wise is...

Part and Inventory Search

Back
Top