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?
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
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 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?
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...
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!
Hello all,
I have created a form with two combo boxes, one is named "customers" the other "reported_by".
I have created a query named "list_callers_by_company" which is populated by the folowing code in the row source
SELECT "*" as z from [list_callers_by_company] union select...
Hello all,
I have created a form with two combo boxes, one is named "customers" the other "reported_by".
I have created a query named "list_callers_by_company" which is populated by the folowing code in the row source
SELECT "*" as z from [list_callers_by_company] union select...
Hello all,
I have a number field which contains a number which represents an amount of minutes (it's not a time field).
I want this number to be rounded off up to the nearest quarter so if the field contains the number 10 it should be rounded off up to 15 and if the number if 125 it should be...
I want to install and use the Crystal reports activeX viewer but I have not been able to find any good documentation on it. Does anyone have a good manual?
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.