in
All Tags » VBA » programming (RSS)

Browse by Tags

  • Testing on NaN in VBA

    From un earlier question I've got the code as shown. Reading the file gives no problem, but when field3 is null, I receive 1.#QNAN as a result. When I want to insert this in a SQLServer table the insert fails. How do check for 1.#QNAN? I've tried several soluitions including the solution in an...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-22-2010

  • Cross reference Variable in Excel VBA

    Hi I've written number of routines in Excel VBA and some are now quite large. Is there a utility that I can use to cross reference the variables in my code, so that I can see on which line[s] each variable is used?
    Posted to Miscellaneous (Forum) by microsoft on 05-08-2010

  • Access code for dates

    I hope someone can help me out with this, I am having a problem with dates in access code. What I am trying to do is figure out how to say that if a date selected in a combo box is before the first day of the first month of the current year then it equals the first day of the first month of the current...
    Posted to Visual Interdev (Forum) by microsoft on 04-18-2010

  • Query database form

    I have a TAB control placed on a form. The first TAB is used to find the user's desired record(s). On the first TAB are the following; a COMBO control, and a TEXT BOX control. Using the COMBO control, the user selects the FIELD he/she would like to search. The TEXT BOX allows the user to then put...
    Posted to Access (Forum) by microsoft on 04-10-2010

  • Double-click List Box Item To Open Form

    In advance -- I'm not a great programmer... I'm having trouble with a project. I have two questions. 1) I have items that are being listed in a List Box via a table. I need to be able to open a particular form if any of the List Box rows are double clicked. How can I do it? 2) When that form...
    Posted to Access Forms (Forum) by microsoft on 03-26-2010

  • Type mismatch error when setting row height or column width

    I have a spreadsheet that is fairly large and within it must format some rows and columns (among many, many other things). This is 99% complete and while I was in the midst of testing, it started giving me type mismatch errors when the macro was attempting to manipulate rows and columns. The code for...
    Posted to Excel (Forum) by microsoft on 01-12-2010

  • exstract nodes from xml with vba and put the in table

    Hi i want to get nodes out of a xml file using vba and put them in a access table xml looks like this: ils> FL-4MtName> 228680501uctID> FL-4MLabel> 50ntityAvailable> 5.99tCost> 883120> ails> Please help. I have never worked with xml before. The code i have looks like this: Dim...
    Posted to dBase (Forum) by microsoft on 11-29-2009

  • Excel Macro Automate Date increment with Shortcut key

    I have a excel with a date column. I want my date to autoincrement by specific period (say 7 days) when i press a hot key (say Alt+Y) For example i am on row C, when i press my hot key, my date is incremented by 7 days for that row. If on D i press my hot key, my date is incremented by 7 days...and so...
    Posted to Excel (Forum) by microsoft on 09-07-2009

  • Macro to Sort Rows Based on Column Headings

    TECHNICAL INFORMATION MS Excel 2007 OVERVIEW I have a spreadsheet that has column headings (LastName, Rater...) across the top. The information (specific names) are found across all the rows. I need a macro (buttons) that will sort all the information across the rows, but it MUST lock the rows so the...
    Posted to Excel (Forum) by microsoft on 08-10-2009

  • Problem: Bold line of vba code message

    In the code below an email is sent when a new project task in BCM for Outlook 2007 is created. What I would like is for the last line, Please refer to/update task within BCM for more information/to log changes. to be in bold Also is there the possibility of having it or other text at a different font...
    Posted to Access Coding/Macros (Forum) by microsoft on 06-06-2009
Page 1 of 1 (10 items)