Answer Questions

• Luis D. Rojas VS2005: Any more CTP or RC builds to come?

  VS Release Team, I've searched these forums and have even researched a number of blogs, but I haven't been able to find out when the next VS2005 drops will be. I'm currently using the July CTP for VS2005 Pro, and am tracking a number of issues with my current development project that I'm hoping will be resolved in future RTM builds, either within Visual Studio itself (e.g., Forms designer), or as a result to fixes in the Framework. Could somebod ...Show All

• JoeSchmoe007 Assign range to array

  I am trying to assign a range to an array, but I keep getting a "Subscript out of range" error. I am using the following code sample. Dim Asset As Variant Dim LinesPerAsset As Variant Asset = Worksheets("Asset_Corr").Range("B5:AY5").Value LinesPerAsset = Worksheets("Asset_Corr").Range("B57:AY57").Value This is supposed to fill a 1 by 50 array according to what literature I can find. ...Show All

• Sinisa Catic Problems compiling an MDB to an MDE

  Hi all, I have a front end/back end split 2002-2003 file format mde which I have been using for 3 years, and tweeking every now and again. All of a sudden I can not compile the development mdb file into an mde file, and keep getting the same error message saying that I "probably have too many forms". The error msg mentions problems associated with 500+ forms, but I have nowhere near that many. (Linked Tables:33, Tables:2, Delete ...Show All

• Mbauser Copying and pasting between spreadsheets

  I have an Excel Macro which copies from a Source spreadsheet and pastes on the working copy. The Source spreadsheet is the result of a report gleaned from a non Microsoft database. Usually all works as expected. The problem comes when one of the items in the working copy does not appear in the Source copy. (If no activity occured, instead of displaying a zero, that particular item is excluded from the output. Since the procedure is copying an ...Show All

• gsquaredb Custom file description keywords: read/write in VBA via API

  In Windows Explorer, I can select a file, go to properties, and under 'summary', I can input keywords into the description, for use later when searching for the file. I would like to be able to read/write these file keywords via VBA. I assume I need to access the Windows API, but more than that, not sure what library etc. I would need to use. Can anyone advise me how do to this            & ...Show All

• Demian Schnaidman SQL Server 2005 Resourse Kit exception

  Hi, When i try to view any of the webcasts by clicking "play", i get the following Visual Studio just in time debugger error: An unhandled win32 exception occured in iexplore.exe[4624]. I can also see the following error in the winnt application error log. I am running winxp with sp2. Event Type: Error Event Source: Application Hang Event Category: (101) Event ID: 1002 Date:  25/08/2005 Time:  7:08:50 ...Show All

• Herr Vorragend How do you find out the Windows User Name from VBA

  We log onto our network with a three letter user name e.g. ADG. Can I return the user name of the person opening my Access Database with VBA I want to customise the options available to the user without using the security features built into Access. Hi Access isn't my strong suite, but isn't there something like ... Application.CurrentUser that gives you the information you need Peter Mo ...Show All

• JongAm Park Word Macro Runtime Error

  Hi all, I'm a complete newbie when it comes to VBA but I've been tasked with writing a macro for a Word form. The form will be linked to on a web page and has two buttons at the bottom, Accept or Decline. Basically what the boss wants to happen is that when either button is clicked the form gets attached to an email and automatically sent. At the same time a message box appears telling the applicant "thanks" and after they click ...Show All

• Dogu After_Save Event???

  Hi to all. I have a problem. For some sheets, I set to invisible before save. Now, I need set to visible the sheets after save, but there aren`t a After_Save Event... How can I solve my problem Any idea Thanks & Regards. With SaveAsUi value...Can I determine if the SaveAs dialog is shown Can I get the file path Sorry, but this is my first project with VBA Thanks I dont understand how can I capture ...Show All

• kentsoftwareromaniatim macro that hides rows - excel

  hi, i was wondering if there was a way to write a macro that will automatically hide a row based on a value in a cell in excel say, if the sum of a selection of cells = 0, i want to hide the row all together. is there a way to do that thanks. anthony hi Hiding rows is quite simple, the below hides row 1 is A1 is 0, you can also choose to hide the Rows/Columns in a range in a similar way With ActiveSh ...Show All

• stigb Clear Excel object

  How can I clear Excel object propperly I am using C# reading a worksheet, however, when I closed my C# app, the excel.exe is still running (can see this in the Windows task manager's processes). thx a lot Yuelin Call Excel's Quit method... here a console app that loads Excel, displays it, waits for a key press, and the exits Excel. Make sure you tidy up your memory by setting the Excel variable t ...Show All

• Michel Jongbloed vba5.0 doesn't work on dual core computer with Windows2003 system

  We have tested at Dell dual core computer(PRECISION 670 and OPTIPLEX 620). If we uses Windows XP, it works well. But it doesn't work at Windows2003, even can't work when disable one CPU and disable Hyper-threading. The VBA initialization succeed, but the application crashs at call CallMacro function. I don't know what's the matter with it. Update to VBA6.X seems not easy and also not sure if it can work. O ...Show All

• Ian Mellors Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

  I'm trying to install BSM 2005 into a Win/2003 Server running SQL Server 2005 (everything) and the Web Service won't install because it reports the following: Failed Microsoft OLE DB Provider for OLAP Service (MSOLAP) 2000 SP4 (8.00.2039) as well, the Alerts won't install because of the message: Failed Microsoft SQL Server 200 Notification Services 2.0 SP1 Engine Components I understood that this version was compatible with SQL 2005. Any idea ho ...Show All

• Graham P Is Partner program open for non-consulting/non-ISV companies?

  We're a company that is building a web based product to be offered as an online service. Our platform is all Microsoft based using the latest .Net technologies. My question is whether our company is suitable as a Microsoft Partner I'm having difficulty identifying the best Competency for us as a company. Any insights are most welcome. Regards, Neil Thanks for the responses, I put a call through to the Partner Program Service ...Show All

• kmitty 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