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

    Excel formula to return string between characters from right

    Hi, I would like to return a string from between two characters using a formula (no VBA). Problem is I have three characters in the string which are the same so I really want to return from the RIGHT e.g. this is how my strings look: "Test_001_This is a Test_24-08-2011.doc" and I wish to...
  2. JGKWORK

    Simple search with drop down menu to choose which column to search on?

    Hi - just getting back in to web development after several years (and the last time I did this it was classic ASP help!). Basically using Microsoft web developer 2010 to do a simple search against a db. I have one textbox and one drop down menu (which will be used to choose which column in the...
  3. JGKWORK

    Formula to return string between chars from right?

    Hi, How do I create a formula to return a string from the following (between the last "\"'s)? \Asbestos\Inspection\001_Dscf0026_2009-09-06.JPG\ I want to return: 001_Dscf0026_2009-09-06.JPG Many thanks.
  4. JGKWORK

    How to hide Terminal Server Printers?

    Hi, Anyone know of a way to hide the printers that are created on Terminal service sessions from terminal service users (other than changing security on each printer as they chop and change a lot)? Basically users are currently able to login and change their printer to print off anywhere in...
  5. JGKWORK

    How to run Veritas backup from a command line?

    Hi, We are running Veeam virtual backup then a Veritas backup. We would like to be able to add a command to the end of the Veeam backup to tell Veritas to run its backup - does anyone know the command to do this please? Many thanks.
  6. JGKWORK

    Script to copy multiple folders based on criteria?

    Hi - been asked to post this here instead of the XP/DOS section, hope I have more luck here? I don't know how to run VBScript so any pointers would be helpful! We are facing a huge task at work to COPY thousands of folders in to a new folder structure. The folders which need transfered are...
  7. JGKWORK

    Script to copy multiple folders based on criteria?

    Hi all, Really could do with some help please. Any way to do a batch file (bearing in mind this is over two network drives) to do the following? Or if anyone knows if fileboss program does this? We are facing a huge task at work to COPY thousands of folders in to a new folder structure. The...
  8. JGKWORK

    Batch file to copy files from relative date from today?

    Hi, Not sure if this is the correct forum for this but I've been tying for hours to figure out a way to write a batch file which simply copies files created say "yesterday" or from the last two days (my choosing) - from one folder to another? Really appreciate any help. Many thanks.
  9. JGKWORK

    SQL server job alerts

    Hi, Little advice - are there any circumstances where an SQL mail alert that a job has failed would NOT work? i.e. where the problem that is causing the job to fail would also cause the email alert to fail also? I ask because I am trying to decide wether or not to setup alerts for either...
  10. JGKWORK

    SQL mail for alerts - start up service account

    Hi, Trying to setup SQL mail on SQL Server 2000 (to alert us if a job fails). I have found a tutorial on this but I just want to know: It says to change the MSSQLServer service to run under the same user account that you are using to send emails. My question is we currently have the startup...
  11. JGKWORK

    Deploying Flash through AD/Group policy not working?

    Hi, Trying to deploy Adobe Flash player 10 MSI through AD/Group policy and nothing is happening. I have setup a test OU with one computer in it, I then apply the policy to this OU. I then go through the group policy console to Computer Configuration | Software Settings | Software...
  12. JGKWORK

    IE crashing for some users - can I delete a specific profile folder?

    Hi, On our network we are always encountering issues where users have trouble running certain applications but when you logon to the same PC as a different user it works. Example: IE7 crashing everytime we click on a specific link but when another user logs on it's fine. Question: Is there a...
  13. JGKWORK

    Outlook prompts for password

    Hi, Please help - our network uses Outlook 2002 and MS exchange. Over the last 12 months we have had around 10 people having the problem that when you start Outlook it prompts you for username, password and domain (these are on PC's and under accounts which were working perfectly). Below is...
  14. JGKWORK

    Newbie - Free SQL builder and SQL dialect questions?

    Hi, hope someone can help? Just started a new job with a company who are using Informix v7.3 on Linux. I have never used Informix or Linux before (mostly GUI products) so as you can imagine it is a big leap for me to use a terminal and pure SQL. What I would like to know is are there any...
  15. JGKWORK

    How to disable form element while still allowing it to work?

    Hi, Can someone show me how to disable form elements so that a user cannot change e.g. text or dropdown options BUT while still allowing the form element data to be submitted? I have tried simply adding "disabled" to the form element but this stops the element from submitting its data...
  16. JGKWORK

    Select active row using VBA in excel??

    Hi, Can someone tell me the VBA code to select the active row in excel? Many thanks.
  17. JGKWORK

    Access VBA: How to skip if no worksheet in linked data source?

    Hi, In Access I have several linked data sources (each are excel spreadsheets). My code performs functions on each linked data source, but sometimes one of the spreadsheets may not have a worksheet at all (so the link will not be able to pull back any data). Question is, how do I write an...
  18. JGKWORK

    How to return the first letter of a worksheet?

    Hi, In excel, how would I return the first letter of a work sheet? E.G. if my sheet is named "Firstsheet" the code would return the letter "F". Many thanks...
  19. JGKWORK

    How to search for date value in column then delete rows below

    Hi and Merry belated Christmas! Just starting to learn VBA (complete begginer). My first task is to (and could someone show me the VBA for this): Select Column A (which is a date column) find the first date in this column which equals 00/01/00 then delete this row and all rows below it...
  20. JGKWORK

    How to switch on argument formula help in Excel 2000?

    Hi, When you edit a formula in Excel (2000) by clicking in the formula bar it sometimes displays help just below (in bold) which tells you the name of each argument and when you click through each, it increases in size slightly to tell you which argument you are now editing. Anyone know how...

Part and Inventory Search

Back
Top