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!

  • Congratulations dencom 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: jeffwest1
  • Content: Threads
  • Order by date
  1. jeffwest1

    VBA to create a chart from selected data

    I have a series of scorecards type sheets that I want to chart the data from. While I could do each one in turn, I can have up to 20 seperate sheets, with 20 measures on each sheet. I have half found an answer to this but wondered if someone can help with the rest I want to select a row using...
  2. jeffwest1

    Java Script Logfile

    Does anyone have any code that will set up a simple logfile of persons entering an inital page on a intranet site, i just need to write the network id, Time and date into a text file. I only want to do this for a short time to enable me to find an rouge network user...
  3. jeffwest1

    Map Point 2010 ODBC

    I want to connect Mappoint to an odbc that already exists on my machine, it is a sybase server not SQL so i can't use the Map Point SQL free add in. Has anyone managed to do this?? I know i can link my database via Access into mappoint, but i do'nt really want to do this if i can help it...
  4. jeffwest1

    Get Saved date from spreadsheet

    I can't seem to find a piece of VBA code that will give me the last saved date of the workbook so that i can show this in a cell of a sheet, anyone know of anything that would work?? -------------------------------- Luke: But tell me why I can't... Yoda: No, no, there is no why. Nothing more...
  5. jeffwest1

    Excel Linked sheets

    I have a number of spreadsheets that are linked to a series of data sheets. Every so often for no reason these sheets lose the links, although the sheets do not move, just get updated with data. Despite clicking on 'Don't display the error and update links' on the edit links box, and also...
  6. jeffwest1

    2007 Linked spreadsheets

    I have a number of spreadsheets that are linked to a series of data sheets. Every so often for no reason these sheets lose the links, although the sheets do not move, just get updated with data. Despite clicking on 'Don't display the error and update links' on the edit links box, and also...
  7. jeffwest1

    Create a Random list

    In a table i have a list of names and address's, each of these has a unique client ID, and each of these clients is allocated a caseload advisor. In order to do a caseload audit, i have been asked to create a report with 6 random client no for each of the advisors. I can't seem to get the...
  8. jeffwest1

    Check for file in folder then execute code

    I am sure that it is listed here somewhere but I cannot find it. I would like to have a program running in the background that will be checking the contents of a folder, once a file exists with a certain name, the following will happen. A) Create text file with names and update dates of all...
  9. jeffwest1

    Only Choose desired Rows and Columns

    I have the below spreadsheet: Advisor Type Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar A Barrett NEET 25 25 25 25 25 25 25 25 25 25 25 25 A Barrett In Learning 15 15 15 15 15 15 15 15 15 15 15 15 A Barrett Not Known 26 26 26 26 26 26 26 26 26 26 26 26 A Barrett YP JWT 29 29 29 29 29 29 29...
  10. jeffwest1

    Multi sheet population

    I have used VBA in Excel, but not for a while, so excuse the rather long winded question. I have a crystal report that quite happly will export out the data I need into excel, this data contains a single entry for a number of users, each with a unique number. I want to add the data into...
  11. jeffwest1

    Beginner Question

    I have used VBScript in Excel, but not for a while, so excuse the rather long winded question. I have a crystal report that quite happly will export out the data I need into excel, this data contains a single entry for a number of users, each with a unique number. I want to add the data into...
  12. jeffwest1

    Problem with stored proc

    I have some code that runs ok in a demo version of my database, but always seems to go wrong when i try to recreate it on the live server. It always gives me an error of 'error at line 22 syntax error near '=' Below is part of the code with the 'error' line noted, anybody got any ideas...
  13. jeffwest1

    update one row with multiple values

    I may have missed it, or i am just being stupid. I have a crystal report that I want to add some data to via SQL, everytime I run some code I get more than one result per person, this is correct as that is the way the data is layered, poor db design, but as i didn't build it i cant be to blame...

Part and Inventory Search

Back
Top