Answer Questions

• Jack Shoeman Loosing Reference to Common Objects (i.s. VBA)

  Even though I have the VBA reference checked in VB I am not able to access the methods therin unless I actually key the VBA object first Anyone know why this may be happening Simple fix: add the line "Imports VBA" at the top of your file. Adding a reference allows you to access the methods but you would still need to fully qualify them Adding the imports statement allows you to avoid hav ...Show All

• web_monkey2k go to next line?

  I have a script that will automatically send an email. The problem is an outlook security warning window that pops up. It waits 5 secs and then asks you to click yes. I want to use sendkeys to get rid of the warning box, but the script will not go to the next step until item.send is finished. Below is the portion of the code. Is there anything I can add to the objMail.send line to get it to go to the next step even before the message ha ...Show All

• howard dierking - MSFT 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, Derek Smyth wrote: 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. If you mean a textbox , you would use ...Show All

• Laschek Cannot close all instances of excel after calling excel workbook in Access Code

  Somehow, another instance of excel is loading when I refer to elements in my code. Such that when I ask for another display of the excel sheet the first global range is exceeded. You should probably see the code. If you want I can send it to you for comment. Is there an ABSOLUTE way of shutting down ALL instances of excel at the end of code execution Thank you, supermsd hi i am also facing the same p ...Show All

• Kasim Husaini Business Scorecard Manager 2005 - Deploying to Reporting Services

  After deploying a scorecard to Reporting Services, RS reports that "ScorecardDPE" is not installed or configured properly. After uninstalling and reinstalling, the following error messages are observed in the RS log file: - ScorecardDPE does not implement iExtension or System.Data.iDbConnection - An attempt has been made to use a data extension 'ScorecardDPE ' that is not registered for this report server. Report Services 2005 is installed. ...Show All

• Zou Kok Man Help with the application-defined or object defined error

    I am fairly new to programming I have a command button 1 in the spreadsheet however I keep getting an error message application-defined or object defined error.  I am not sure what this error means. What I want to do is set ninterval, rbedradius and xinterval to cell values shown below. I want to use a for loop and apply calculations. Later (not yet coded) want to put a condition on the third column of formulation. How d ...Show All

• DotNETKans - 2005 Working with Visio Legend through VBA or Macro

  I have to put a legend on a floor plan drawing that colors the space shape (rooms) based on a department given in the shape's custom properties. I add a legend using "Plan->color by values..." menu option, which gives me a legend correctly denoting the spaces and shape counts for each department. However, there is a need for the color of the shape for each department to be a specific color. The only way I know to do this is to edi ...Show All

• Nanda Motikane Merging another document into a merge doc based on merge field data

  Hi all. Post #1, and only because I have a challenge (well, I'm feeling challenged!) and this looks like the best place to post. I have a merge document with several fields drawn from an Excel database. One field is like a key field, and I want to use this key to compile a path and filename, and then insert the document with this compiled path into the final merged document, for each record (different document for each record). Example: |====rec ...Show All

• RoccoM how can i set password to the design view button for forms, reports and modules?

  how can i set password to the design view button for forms, reports and modules in MS Access 2000 This has to be made in order to prevent users accessing code. I do not want to make a mde. Thanks Hi, You would have to create user workgroups for the database and specify which users aren't allowed to open which forms, etc.  There a bit to setting up user workgroups so your best going to the he ...Show All

• Eric12345 jump to other slides of a ppt by selecting slide number from a combobox

  can anyone tell me how jump to other slides of a ppt by selecting slide number from a combobox how will u first additems to the combobox and then how will you switch to the slide number selected in that combobox thanks in advance amzzz plz someone tell me this...a bit urgent thanks amzzz Hey thanks for trying atleast!! I wasnt hoping anybody would respond.....but thanks Actua ...Show All

• Muthu.R Need Phone Number for Empower Program Included Support

  When I signed up for the Empower ISV program, I was told that I would get the following... * One MSDN(r) Universal Subscription with up to five (5) user licenses for development and testing. * Comprehensive access to the Microsoft software you need to build and fully test applications and XML Web services. * Continuous access to new product releases and public betas. * 10 Free Advisory Service Hours per year * Up to five (5) internal use softw ...Show All

• Marcel Andrade UTC Dates

  Help! I need to convert long integer UTC dates to actual formatted dates.  Is there anything in Excel that can be used to accomplish this Thank you! Shawn. Per one of our support engineers: I found that Excel does not have a built-in function for this. However, UTC date has fixed format and we can refer to the following article to see how to convert it. UTC date format Converting WMI Dates to a Stand ...Show All

• Xinwei Hong Why not just SV?

  Dear Microsoft, We've been a certified partner for more than a year and member of the ISV competency. But why don't you just call it an SV I mean, of course, we're independent.  Or if not we're owned by someone else.  Or is the "Independent" simply what I suspect just an other way of saying "not Microsoft" So I suggest switching from ISV to just SV or "Software company" or something to that effect.  (Then at least you wouldn't be ...Show All

• dddkkk RTM - Q3 or late Q4 ?

    Frank Boyne wrote: If...your eventual product user is willing to run on a beta version of the 2.0 Framework Ah, that's the whole crux of the problem! I'd be willing to, but getting customers to agree to that is a completely different matter . Thanks. Are there any indications of whether VS2005 will ship in Q3 2005 or late Q4 Whilst probable dates used to be "late summer" (september-ish ), r ...Show All

• DragonDayz Import CSV Files into SQL Server 2000 Table from VB Net

  Hi Guys. I'm doing a web application to import data into a SQL Server Table from VB Net 2002. Anybody do know how do it . Thanks. WERM Hi, You might want to post this question to one of the Visual Basic forums ( http://forums.microsoft.com/MSDN/default.aspx ForumGroupID=10&SiteID=1 ). -brenda (ISV Buddy Team) You want to use ADO.NET objects. You'll need to import the objects in the System.Data.SqlClient name ...Show All