in
All Tags » VBA (RSS)

Browse by Tags

  • Field value in recordset not updating to variable value

    Hello ~ The following function is intended to update the rs.PAX field to the first numeric character of the (PAX) field value and update to a null field value if the first character is not numeric. By inserting a break point, I'm noticing 'rs.Fields("PAX")' in the line: rs.Fields...
    Posted to Access (Forum) by microsoft on 05-26-2010

  • Powerpoint VBA How to read chart series scheme color

    Is there a way to either (1) get the scheme color used for a barchart series item Fill.Forecolor or (2) get the scheme in use (the scheme color can be pre-determined into an array) or (3) prevent screen updates in Powerpoint when changes are made from Excel through Automation (macro is in Excel making...
    Posted to Powerpoint (Forum) by microsoft on 05-25-2010

  • Access 2007 VBA - hold value in control after on_change event

    Hi Experts, Not sure how to google or ask this question, but here it goes. I have a text box that is populated by a dlookup. When a user changes the value in the text box it becomes empty (on purpose). However, their first keystroke is also lost. I'd like to be able to keep it and put the cursor...
    Posted to Access (Forum) by microsoft on 05-25-2010

  • Crosstab query question

    Is there any way to exclude records from the below cross tab query where AmountChange = 0 Attached is a db with sample data that shows the problem. The query is called 001-QCT-AllCollateral-Change. The expected results of the query are in another query called QS-Expected Outcome from QCT. I don't...
    Posted to Access (Forum) by microsoft on 05-25-2010

  • Compare FileName Data in Access Against FileName on Server

    I am doing a daily import of files from my X:\ into Access. I have a table in Access that logs the file names and paths (e.g. X:\MyFolder\Import\FileName.xls) of files that have been imported. I would like to compare this data list against the names of files that exist in that same folder (e.g. X:\MyFolder...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-25-2010

  • Delete highlighted text (wdYellow)

    Dear Experts: I did some highlighting in a document using different colors (wdYellow and wdBlue). I now would like to delete all words/characters that have been highlighed yellow and leave the blue ones alone. How can I achieve this using a VBA code? Help is much appreciated. Thank you very much in advance...
    Posted to Visual Interdev (Forum) by microsoft on 05-25-2010

  • More Efficient way to Copy and Paste Filtered Data

    The below code is desgiend to copy and paste a data set, while skipping blanks based on the filtered selection ("7"). This method WORKS but it takes a long time as more criteria is selected. Is there a modification that can be done to the code to create a more efficient method to copy and paste...
    Posted to Microsoft Office (Forum) by microsoft on 05-25-2010

  • Text will not display in text box

    I am using Access 2002 and VBA 6.3 I am trying to get text to appear in a text box and a combo box. If I use a Break Point in this Sub after the txt and cmb lines the text appears in both the combo box and the textbox as I want. Without a break point the text does not appear. Is it a timing issue or...
    Posted to Other (Forum) by microsoft on 05-25-2010

  • Can't get SumIf formula to work

    Please take a look at the attached workbook. I can't figure out why the sumif function doesn't work: =SUMIF($F$1:$AV$1,T16,$F$3:$AU$9) Thanks, John
    Posted to Excel (Forum) by microsoft on 05-25-2010

  • Pass text to Outlook as BOLDED text

    Good morning, In an Access event, I am using VBA to open a new email message in MS Outlook. The command automatically populates the BCC field, subject line, and message text. How can I make part of the message text formatted (for example, a different color, or bold)? The DoCmd statement I'm currently...
    Posted to Access (Forum) by microsoft on 05-25-2010
Page 3 of 298 (2977 items) < Previous 1 2 3 4 5 Next > ... Last ยป