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

    Access relationships not preserved in linked tables

    Hello-- I have two linked tables from one database to another. In the database where the tables actually reside the relationship between the two tables works perfectly. In the database that I want a link to the tables in I can't get the relationship to work. They are related in the database...
  2. nateDiggs

    Acces Report Query

    This is what I tried. This is not what I want though because if I do that it displays each record with the individual software titles. All I want it totals information for each software title, not all the records associated with the software title.
  3. nateDiggs

    Acces Report Query

    I have a table that contains software usage records. It has the name of the software package, the computer name with it installed, the budget code that the computer belongs to, and the name of their area. I want a report that does this: Lists each software title with the names of the 4 areas...
  4. nateDiggs

    String contantinations in searches

    hello-- I have a pretty complicated query that I need to run. I have a table containing customer information. In that table there is a column for the customers full name. In a search function I'm designing I want a form to pop up and a user can enter in a last name, a first name, or both...
  5. nateDiggs

    Querying Multiple tables for similar values

    That last suggestion did the trick. Thanks for the responses!
  6. nateDiggs

    Querying Multiple tables for similar values

    SELECT * FROM (tblUniqueUsers INNER JOIN tblBIQueryAdmin ON tblUniqueUsers.UserIDNumber = tblBIQueryAdmin.UserIDNumber) INNER JOIN tblBIQueryUser ON tblUniqueUsers.UserIDNumber = tblBIQueryUser.UserIDNumber WHERE (((tblUniqueUsers.UserIDNumber)=[Please enter a UserIDNumber])); The tables are...
  7. nateDiggs

    Querying Multiple tables for similar values

    It puts all the correct matches into one row, I need each match on a seperate row. Any way to do this?
  8. nateDiggs

    Querying Multiple tables for similar values

    Ok, I understand better now that I've tried it but when I add in the second Inner Join statement I get a syntax error in my from clause.
  9. nateDiggs

    Querying Multiple tables for similar values

    The only problem with that is I want to display the information kept in Table1 and Table2 not the information kept in Users.
  10. nateDiggs

    Querying Multiple tables for similar values

    Hello-- I have an Access database set up with a "Users" with a unique "UserIDNumber." I have several tables that contain records indicating whether the user has a certain piece of software installed. These tables are related to the "Users" table by the "UserIDNumber." I want a user of the...
  11. nateDiggs

    Networking Script

    The issue isn't the phone calls to tech support. Those are received by the help desk. I'm 2nd level. I get a log of a help desk call and then I respond to the user to help trouble shoot the problem. I need to be able to enter the user's user id and get back the computer he is logged into...
  12. nateDiggs

    Networking Script

    not sure, it doesn't really matter though. There are 10,000 computers in my company and I'm not counting on finding and changing the enviornment variables on computers that may not be setup correctly. Although, I don't think this is it because nbtstat won't cache my own computer name and I...
  13. nateDiggs

    Networking Script

    Hello-- I'm trying to write a windows 2000/XP script that will take a user's login name and resolve to the name of the computer the user is logged into. I've used many scripts that I've found that use net send and nbtstat -c commands to find computer names but I find them to be un-reilable...
  14. nateDiggs

    Networking Script

    hello-- I do 2nd level desktop support for a large company and I have a question. We are constantly trying to find computer names based on a user's login ID. Users at my company are authenticated using both acrive directory and novell. We really need a script that will allow you to enter a...

Part and Inventory Search

Back
Top