Recent content by rmh3619

I want to format text in a message box, see code below Msgbox = "this text must be in red" & "this text must be in black" is it possible to use different colors in one msgbox?

thanks fneily!

thanks Remou, that helped!

i have a text box on a form called txtDescription on the after update event i want to convert the first character in the txtDescription field to uppercase. I dont want to use vbProperCase because that will convert all first characters of each word in the field to uppercase thanks in advance

thanks fneily but this does not entirely produce the result i'm looking for. if for instance the registration date was 2 days, 4 hours and 10 minutes ago i want the value in the txtResponse textbox to show 52:10:00

I have two now() values in text boxes (txtDate1 and txtDate2) the first date is the registration date and the second is the start date. i want to calculate the response time (date2 - date1) and have the result in the format hh:mm:ss How can i do this?

I resolved the error my self by declaring the type of variable: Private Sub myButton_Click() Dim myString1 as String Dim myString2 as String Dim myString3 as String myString1 = "this is a test" myString2 = "this is the second test" myString3 = "this is the...

i tried it but i'm getting an error message: ByRef argument type mismatch do you know how to solve it?

thanks aceman1, I really appreciate your help!

i guess i should clarify my question: i want 3 message boxes following each other with message 1 to 3 something like this: Private Sub myButton_Click() myString1 = "this is a test" myString2 = "this is the second test" myString3 = "this is the last test" Call...

Thanks TheAceMan1 but how do i do this with multiple variables? Private Sub myButton_Click() myString1 = "this is a test" myString2 = "this is the second test" myString3 = "this is the last test" Call myMessage(myString) End Sub how will the function look in this case?

i am trying to pass a variable to a function in VBA but i cant get it to work. this is an example of what i'm trying to do: private sub myButton_Click() myString="this is a test" call myMessage end sub function myMessage() msgbox myString end function what am i doing wrong?

Thanks xmsre, thats unfortunately the answer I expected ;-)

Hello All, I was wondering if it is possible in exchange 2003 to delay a message with more than 1000 (for example) recipients. I want to delay the messages till after work hours so bandwidth does not get consumed by large mailings. help is greatly appreciated

I have a table called "customer" with a field "customer_name" i want to execute code for each customer_name in the table. (e.g. msgbox customer_name) how can i do this. i think i should use a for / next statement but I dont know how. Thanks