Search results for query: *

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

I have created a chart which shows two bars. one bar show new items in this month and the other shows closed items this month. the chart is created by joining 2 queries: SELECT Null,Sum([CountOfCall_ID]) AS [SumOfCountOfCall_ID] FROM [Dashboard_New_calls_this_month] union SELECT...

Thanks PHV that works great. I really appreciate your help!

I want to filter all records which start with a number. i use the following code to filter fields starting with a specific letter: Me.[customers subform].Form.Filter = "company Like 'A*'" Me.[customers subform].Form.FilterOn = True how can I use this code to filter on company names starting...

Hello all, What methods are there to imrpove video performance on a terminal server or citrix server? viewing some websites with flash or large graphics result in very poor performance. does it help to upgrade the video adapter in the server? any advice is greatly appreciated!

Thanks for pointing that out remou!