Answer Questions

• neolace Linking Outlook to Excel

  I would like to send an email via Outlook by clicking on a button in a Excel spreadsheet. The mail would contain some of the values in the spreadsheet. I think I know how to send with VBE an email given the server name but it does not go through Outlook. Thanks, Antonio Hi Antonio, Here is a line i wrote, which send an email with the file attached to it. x = the address you want ...Show All

• EricV SubForm - ActiveCell

  Hi - I am using Office 2002 SP3. I have an Access database with a form and a subform - normal, standard stuff, nothing fancy. Is it possible, in code, to find out which cell on the subform is selected by row and column number I think I have the row bit sorted but the column (field) has me beat. Dear Brenda Thanks very much - just what I was looking for. Per our support ...Show All

• wayne_p Detecting Excel Password

  I am looking for VB code that will enable me to open an Excel Workbook and detect whether the worksheet(s) are password protected. Here is some code in C: http://ezinearticles.com/ Automating-MS-Excel-Using-Visual-Studio.NET&id=134815 In VB.NET, you have to add a reference to the Microsoft Excel Object Library; then you can begin writing VB code to drive Excel... Use your Project window, and right-cli ...Show All

• AGPX show vba application

  Hi! Guys.. i am using Excel 2003 with VBA 6.3 and i need when user click in excel file at windows explorer, show my VBA userform and not show excel application, like a executable. Anyone know how Thanks very much!! Joao Carlos Hi Derek Your code resolve immediately my problem. Thanks. Think what your needing to do is place events in the Workbook.Open ev ...Show All

• SK_Rajdev VBA Code to save Excel w Name including cell data

  I need to develop a way to save an Excel spreadsheet to automoatically name the saved xls with the string data from cell B2 (client name), plus the now date and time (using the 12 hour clock). I've tried putting a command button on the template spreadsheet using the code below, and different variations as I find something else under the help section, but everything errors. The B2 spot is always where a client name will be. And the date/time f ...Show All

• jherbst Using KPIUtil, cannot export KPI from SQL Server 2005 Analysis Services to BSM and vice-versa

  I am trying to export KPIs created in Analyysis Services to BSM using KPIUtil. I have KPIUtil installed on my machine which has the following: Windows 2003 with SP1 Microsoft .NET Framework 2.0 Common Language Runtime 2.0 Analysis Management Objects Microsoft Office Business Scorecard Builder 2005 The BSM Server is on a separate machine. The scorecards created using BSM(without KPIUtil) work fine. In the KPIUtil-New Confi ...Show All

• Wa1d0 Suppress Linked View Unique Record Popup

  Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however this can not be relied on, if it happens when the u ...Show All

• jhazucha Suppress Linked View Unique Record Popup

  Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however this can not be relied on, if it happens when the u ...Show All

• charles pratheepan additem issue with populating a combobox

  Hello, I have been working at this for days and am no better off. I could really use some help. I need to populate a combobox with data from a column in an SQL table. I have put together the code below but am having an error at this line: invBegNum.additem rs.Fields.Item("RMDNUMWK").Value Error message: "Object doesn't support this property or method" I'm really a newb but am trying hard to get this.  When I write this line of code to popul ...Show All

• bbull26 Losing primary display on Windows 2003 SE w/ single Radeon display

  I recently setup and configured a new IBM x346 (dual 3.6 GHz, 16 GB RAM, 2 TB DASD) which contains a single analog video output port (builtin, not a video card). However, the display control panel indicates that it believes the video card has two display outputs, both apparently connected through the same port. I tried to utilize the "second" display by extending my desktop, but this caused my monitor to display the second screen and n ...Show All

• Roger Swetnam What version of Team System do EmpowerISV members get?

  Current MSDN Universal subscribers get a free upgrade to their choice of one of the Team editions of Visual Studio 2005 when its released.  What about current EmpowerISV members   And what will future members get   I'm planning on joining the program, but I want to be sure I know what my team will be  getting long-term, especially as it relates to Visual Studio Team System. If you think Emp ...Show All

• MrMunkey Using of APC.IDE.PreventShow property

  I have integrated VBA 6.2 into my application. All works normal, but I have a little problem. To prevent VBA IDE to be shown when VBA runtime error rises, I set APC.IDE.PreventShow property to True, so this successfully overrides error displaying (and stops vba code execution), but doesn't give me any sign of this (in other words I can't catch any event reporting me about the error generated by VBA). Can someone help me to handle to problem Tha ...Show All

• aahd1 SIP (LCS) delivery channel for SQL Notification Services

  Back in version 1.0/1.1 of SNS that was a delivery channel for Exchange Messenger under Exchange 2K. Since the Messenger Server has moved over to LCS 2003/2005 has anyone create the linkage between SNS2.0 and LCS2005 There idea is that the protocol would be sip but that the redirector on LCS would redirect the alert the appropriate device based on the presence information contained in the LCS registrar database. Yes I realize t ...Show All

• DenverQA Documentation on use of Me

  I cannot find any documentation on the use of Me as in "Me.Range("a10:a59").EntireRow.AutoFit". What does the "Me" stand for or where can I find documentation Thanks Hello Joe, In the Visual basic and VBA world Me refers to the current class/object that you are in. When you are in a User Form Me refers to the UserForm (see documentation for UserForm), Same thing for when you ar ...Show All

• van_walraven custom toolbar error

  I built a custom tool bar for my applicatoin. It works ok on PC Excel. But I got an error message on a Mac Excel: Run-time error '-2147483640(-7FFFFFF8)': Method 'FaceId' of object 'CommandBarButton' failed If I comment out the        .FaceId = 642 Then the error message becomes Method 'OnAction' of object 'CommandBarButton' failed The original code in VBA look like this: ..............    Private Sub Cr ...Show All