in
All Tags » VBA (RSS)

Browse by Tags

  • Access Report

    I have two Access tables: tblMembers and tblMemberSelections. tblMembers contains customer information and tblMemberSelections contains the items each customer has ordered. The tables are joined one to many via a memberId primary key field in tblMembers and a memberId field in tblMemberSelections. I...
    Posted to Access (Forum) by microsoft on 05-23-2010

  • Using VBA to check if MS Outlook is already open and open it if it is not.

    There was a similar question that was answered using CDO method. Unfortunately, in our environment and in our project, we must use MS Outlook as the email needs to be amended by the user. But the issue we have is that if Outlook isn't already open, the "error 287: Application-defined or object...
    Posted to Access (Forum) by microsoft on 05-23-2010

  • Replace special characters in VBA

    Hi, I'm writing a bit of code in VBA to convert a table into excel into an HTML formatted table. It's working fine except I need it to pick up certain special characters and replace them with their equivalent HTML notation. The one I'm having trouble with at the moment is the Omega sign....
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • Highlight cells in Range without Conditional Formatting in VBA

    The macro below adds Conditonal Formatting (two conditions) to a range, but I want to just set the colors permanently rather than using the CF. The CF formulas (bottom half of macro) work fine, but I don't know how to convert that into something like: For Each cell In Selection If AA2 <> E2...
    Posted to Excel (Forum) by microsoft on 05-22-2010

  • Locking dropdown once it is selected

    I'm attaching a sample of my spreadsheet to better illustrate what I'm trying to accomplish. Cell H2 of the DataEntry Worksheet is open for editing (This is the only cell in this colum that should be enabled) I want to lock the cell H2 once the user selects the Source. If someone needs to change...
    Posted to Excel (Forum) by microsoft on 05-22-2010

  • Go to Prescedents of Cell summing another sheet - quite possibly impossible

    hi all, i'm finding a particular task very hard to accomplish in Excel VBA. I have a formula in range K6 in a sheet called "Aggregate". the formula resembles "=sum(sheet1!K6, sheet2!K6, sheet3!K6) As the sheet that i'm working on is an aggregate view, i need to achieve the following...
    Posted to Visual Interdev (Forum) by microsoft on 05-22-2010

  • Easy: How can I clear the contents of a ListBox in Access VBA?

    This is kind of crude code, but what I am doing should be a no brainer. It is a no brainer in vb 6.0, but I can't do this in VBA for Access? The math is simple .ListCount - 1, but it doesn't work. All I need to do is clear the items in a list box. My application has an unbbound List Box control...
    Posted to Access (Forum) by microsoft on 05-22-2010

  • 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

  • Is there a way for access to determine if all instances of a given form are closed to run a make-table query

    Every night at 1:35 AM an external program generates a csv text file. In my access database this table is external linked as ttxtCallsign. In my access database the make-table query qmakCallSignttxtTotbl creates tblCallsign which can be used by multiple users via the form F-Selecteervlucht. Since the...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-22-2010

  • Email .doc file from MS Access

    Hi, I've tried to use SendObj() to send word documents (.doc) to my Lotus Notes client without success because SendObj() can only send other type file (xls, txt, rtf). My users will be sending .doc type files using lotus notes client but all info such as email address, header, attached document ...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-22-2010
Page 5 of 298 (2977 items) « First ... < Previous 3 4 5 6 7 Next > ... Last »