Answer Questions

• devbit Business Scorecard 2005 Installed - Just cannot connect to Analysis Services database

  Followed the readme for installation step by step. Installed the Server and the Builder on the same machine - db is SQL Server 2005 April CTP.  - Will the Business Scorecard work with the April CTP  - Launched the BS Builder and when trying to connect to a ADOMD.NET datasource, in server specified the <Servername>, the database dropdown always comes blank.....error "could not connect to data source" (Analysis Services is run ...Show All

• Igor Taranov -- MSFT Error in partner program signup form

  I am trying to sign up for the Partner Program, however the first page has several errors: 1. State dropdowns are empty.  This one doesn't seem to be critical. 2. I get "invalid telephone format" no matter how I type my phone number.  This one is a show stopper.  Anyone know how to fix it Thanks very much, jheske@mindspring.com.NOSPAM Hi Mike, In order to troubleshoot this issue, ...Show All

• DagDoug Vb in acces : hide input data

  hello, anybody got an idea how to make text entered in an inputbox become visible as **** thx Hi TnTico, I would have said look for a PasswordChar property of the text box but there doesn't seem to be one. Use the Input Mask property instead. I've just checked and there is a input mask setting for password input. Hi TnTico, Derek Smyth wrote: I would have said look ...Show All

• rikmar Open an excel file

  Hope you will help a beginner .. Here's what I want to do:  In a VBA subroutine, try to open an excel file with a particular name say, P01GAB.xls.  It may not be in the diretory, if not, wait for 10 seconds and try again.  If so, open it and go on to the next thing.  (Eventually, it will be in the directory...)  So, I take it, I need some sort of error trap on the Workbooks.Open command... Thanks much.   ...Show All

• John Samperi Collections of control - evaluating the name of a control that has been "pressed"

  Hi, I have created a form in Excel, upon which is a multipage control, with a set of combo boxes placed on. One combobox is populated by a pre-defined list of text, which upon user selection runs a macro that defines the population of a second combo box.......like a choice - sub-choice set up. The user is able to add and delete pages to their requirements, which also add and deletes the combo boxes on each page, however the user will always be p ...Show All

• RvD unloading a function

  I have a question i am writing a program in Outlook. I have a button on a userform that when I click it I want to unload a function in a module from memory. I thought I could just put this in the click event: Unload Project1.Module_Name.Function_Name However, that just runs the function again. Also, I would like to know, is there any way in vba to say "unload all functions and subroutines" Anyone got any ideas thanks, Dudeman ...Show All

• Scott Stanfield What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• adnan152 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. Yeah, I'd be ver ...Show All

• Elv Help with using Outlook from Access

  I am openning Outlook by calling createobject, which I expected to open a new instance of the application. However it appears to use the one open on my desktop. This means that my quit statement closes my e-mail. How should I amend the below to leave my original e-mail session open Also I will be replacing the debug.print statement with code to work with the attachment to copy data into my database. I am intending to save the file to a tempor ...Show All

• Rajat Dasgupta Newbie - Sending mail via Excel

  Hello everyone, Here's my problem : I'm trying to send a email via VBA in Excel using this code :     Set ol = CreateObject("outlook.application")     Set myItem = ol.CreateItem(olMailItem)     Set myAttachments = myItem.Attachments     myAttachments.Add "c:\SDE.xls"          With myItem        .Subject = "SDE"    ...Show All

• xfx If VB6 support ended, what does that mean for ISV's?

  Started by Bob Walsh at 03-16-2005 11:32 AM. Topic has 1 replies.  03-16-2005, 11:32 AM Bob Walsh Joined on 03-16-2005 Posts 2 If VB6 support ended, what does that mean for ISV's If VB6 support ended, what does that mean for ISV's who sell a VB6-based product 03-18-2005, 5:12 PM Brenda [msdn/isv] Joined on 03-16-2005 Posts 6 Re: If VB6 support ende ...Show All

• James Hague What is the difference between SET and Assigning a value to a variable?

  Hi, Can anybody advise what the difference between SET and assigning a value to a variable Example: Sub NewWorksheet() Dim ws As Worksheet Set ws = Worksheets.Add ws.Name = "New sheet" End Sub =================== Set ws=Worksheets.Add vs. ws.Name="New Sheet" Why not just write ---> ws=Worksheets.Add ----- for the former Regards, Patrick Just to expand o ...Show All

• Barry Bond VBA forms for Excel. Always on top ??

  Hi, it seems that a form is always 'on top', even if  'SHOW MODAL' is set to TRUE. Is there a way to 'send it back' when i click my sheet and then later when i click the form it will be ' on top' again. I tried to work with Z-order but i didn't got that to work. Regards, Michael "userform.show vbModeless" will do the trick Thanks.. but not really what i want. When you crea ...Show All

• TheKell VBA in Office 12

  Could anyone show some information about VBA in Office 12 Does Microsoft support VBA in Office 12 Are there have any new features or improvements Thank you in advance!   I believe that Visual Studio Tools for Office will be replacing VBA in Office 12, but that Microsoft will still support VBA. Here's a few sites that may be of use: http://www.microsoft.com/office/preview/default.mspx http://msdn.microsoft.com/offic ...Show All

• Shibu Shaji Copy and Paste Values

  I cannot figure out how to copy and paste as values using VBA without acually selecting the cells when I paste and using the same code the macro recorder generates when I record a copy and paste as values. What would be the code for copying cells a1:a10 and pasting as values in cells b1:b10 without selecting the cells range("a1:a10).copy Then what This is the acual code, the above post was a tiny bit off ...Show All