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 Mike Lewis 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. ale1981

    How to set altRecipient write permission in AD

    I found it, for anybody else looking to set these objects outside of AD the permissions are under InetOrgPerson objects.
  2. ale1981

    batch file

    The following will tell you what each parameter means in NTBackup.. Click Start->Run and type ntbackup /? and press enter.
  3. ale1981

    How to set altRecipient write permission in AD

    Hi I can not find the altRecipient permission when editing a users Security in AD. I have created an application that allows the user to change email forwarding options without the need for them to have access to AD but the user needs write permissions for altRecipient and deliverAndForward. I...
  4. ale1981

    split string after x characters?

    Looks good strongm, will give it a go ;)
  5. ale1981

    split string after x characters?

    Thanks strongm, will give this a go ;) I think it may be a long time until our company upgrades to Windows 7!
  6. ale1981

    split string after x characters?

    I get what they are both trying to say, but unfortunately I can not modify or add forms to the application I can however modify the VBA that sits behind the current forms which is why I decided on a message box.
  7. ale1981

    split string after x characters?

    As I stated earlier in this thread I required it to be displayed in a message box, not a label, i can not modify the window to add a label and a label does not attract as much attention as a message box.
  8. ale1981

    split string after x characters?

    strongm, That example with a width of 85 works exactly as I would expect using HarleyQuinn's latest changes?
  9. ale1981

    split string after x characters?

    I see what you mean, lucky for me that the line break is going to be after 85 characters. Do you have a fix for any of the above functions to solve the problems you mentioned?
  10. ale1981

    split string after x characters?

    3 great ways to do the same job! I guess the only question is, which is the quickest?!
  11. ale1981

    split string after x characters?

    For anybody else wanting to use this, the function caused an error if the StringIn was less than LineLen so I had to add a little IF clause; Function SplitString(ByVal StringIn As String, _ Optional LineLen As Long = 85) As String Dim BreakAt As Long BreakAt = 0...
  12. ale1981

    split string after x characters?

    Hi Tony Just tested your function and it seems to work perfectly also. Strange that I could not find a function to do this after hours of searching on google and I have 2 working within hours of posting on here! :) Many Thanks!
  13. ale1981

    split string after x characters?

    Thanks MakeItSo, forgot another & " ", but this works great... for i=0 to ubound(wds) buf=buf & wds(i) & " " if len(buf)<85 then msg=msg & wds(i) & " " else msg=msg & vbnewline & wds(i) & " " buf="" 'reset string buffer end if next i Thanks again.
  14. ale1981

    split string after x characters?

    Ok i was wrong! That fixed the no space issue but I have noticed that the word before the new line is inserted is being cut! example if i change the length from 85 to 12; "This is a test line message" because "test" and "message" is in the middle of 12 it gets cut out and doesnt get...
  15. ale1981

    split string after x characters?

    Hi MakeItSo, It kind of works, but when the message is displayed the words have no spaces between them!!
  16. ale1981

    split string after x characters?

    Ok, i have an application where a message is inserted into the database via a web interface, the maximum characters for the database field is 255 characters. I want to display the message (via a message box) in the application. If i pass the whole 255 characters to a message box it does not...
  17. ale1981

    split string after x characters?

    Hi Geoff, The maximum amount if items i would like a string split into is 3. If the no. of characters does happen in the middle of the word i would like the split to occur before the word. I have searched everywhere for a way of doing this in VBA but can not find one!
  18. ale1981

    split string after x characters?

    I would like to split a string if it is over x characters long after x amount of characters, is this possible? for example; string = "this is one long line of text" string1 = "this is one long line" string2 = "of text" the split can not split in the middle of words.
  19. ale1981

    Add VAT % to invoice report

    We have a modified invoice report, is it possible to add the VAT % rate to the report using report writer? Is the VAT % value stored in a table that can be accessed using the report writer? Many Thanks

Part and Inventory Search

Back
Top