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!

Recent content by jameshopper

  1. jameshopper

    Users/Group Audits

    Hi, I'm looking to find out if there is a relatively easy solution to an audit we are about to complete. Essentially, what is required is a list of all users, the groups they are associates with (bearing in mind it may be more than one) and the folders they have access to (again, bearing in mind...
  2. jameshopper

    Dlookup using nearest value (vlookup true)

    I changed one of the bands descriptions during writing this, which is why one says middle and the other says minimum performance. James
  3. jameshopper

    Dlookup using nearest value (vlookup true)

    Hi, I have worked on and searched long and hard to come up with a solution to the vlookup(true) Excel function in Access. May of the solutions I have found meant using several queries/subqueries to get to the right results. Luckily, I stumbled across this while looking through the built in...
  4. jameshopper

    Transferspreadsheet importing from Excel - Read only

    Hi all, I am trying to get the below piece of code to work, but it keeps hanging whenever one of the spreadsheets is opened by someone else. There is a password on each of the sheets, so I know it's not that thats causing issues as it opens the first few and then as soon as theres a...
  5. jameshopper

    SUMPRODUCT VB CODE

    Thanks, Just managed to work out another solution as well ={SUM(K3:AA3/X!A$2:Q$2)} should have used a tad more lateral thinking before jumping the gun and going for a snazzy function.... Thanks james
  6. jameshopper

    SUMPRODUCT VB CODE

    Hi, I'm trying to find a away to create the opposite function to SUMPRODUCT, ie SUM..DIVISION??, presuming that there isn't one out there already (I haven't managed to find one so far) I figure the best way is to look at the actual coding sat behind the SUMPRODUCT function, if anyone knows it...
  7. jameshopper

    SAS upload/export to Sharepoint

    Hi, I'm trying to output a file to our department Sharepoint site, but am coming up with problems. I have added the sharepoint site into my network places and have tried using the Proc Export function: PROC EXPORT DATA= ruser2.rdu_logout OUTFILE=...
  8. jameshopper

    Crosstab problem

    Hi all, I know this has probably been answered before, but i'm trying to get my head round some of the previous answers. I have a crosstab query linked into a select query. The select query has a parameter criteria in place. Now, this works all well and good when performing the select query on...
  9. jameshopper

    iif(iserror() query

    Hi, i found a problem at work today that i could do with a hand on if possible. I've found a few #error results in a calculated field, which i would like to be blank. Having a background in excel, i know there's a way there of using if(iserror(...., but this doesn't appear to be the same in...
  10. jameshopper

    Duplicate Records on same row

    thanks lupins, does that work if the data is all from the same table
  11. jameshopper

    Duplicate Records on same row

    Hi, wondered if you may be able to help. I'm looking to run a report on a table that i currently have set up. When i run any kind of report, each line on the report is dedicated to one record. What i'd like to do is have numerous records on one line. for example currenlty, the report comes out...
See more

Part and Inventory Search

Back
Top