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...
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...
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.
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...
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.
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.