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 dencom 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: *

  • Users: rmh3619
  • Content: Threads
  • Order by date
  1. rmh3619

    format text in msgbox

    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?
  2. rmh3619

    convert first character to uppercase

    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
  3. rmh3619

    Calculate response time

    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?
  4. rmh3619

    pass variable to function

    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?
  5. rmh3619

    delay messages with more than X recipients

    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
  6. rmh3619

    for next question

    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
  7. rmh3619

    chart not displayed when values are equal

    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...
  8. rmh3619

    Filter fields starting with a number

    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...
  9. rmh3619

    how to improve video performance

    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!
  10. rmh3619

    populate combo box based on other combo box value

    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...
  11. rmh3619

    query based on selection in combobox

    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...
  12. rmh3619

    round off up to ............

    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...
  13. rmh3619

    ActiveX viewer

    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?

Part and Inventory Search

Back
Top