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...
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.
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.
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?
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...
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!
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.
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...
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...
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!
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.
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
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.