Gary B's Q&A profile

• Microsoft ISV Community Center Forums VBA in EXCEL - Connect to SQL Server

  I am a new programmer try to write some VBA codes in excel to get data out from the Sql server database. When I try to compile the codes, it said "compile error: user defined typed not defined" for the following sentences Dim dbsCurrent As Database Dim qdfPassThrough As QueryDef Dim qdfLocal As QueryDef Dim rstTopFive As Recordset Dim strMessage As String What I need to define for Database,recordset or QueryDef Please help! ...Show All

• Software Development for Windows Vista How to access <Activity Reference...> in DesignerHostingApplication

  Hi, I'm trying to reference another activity from the property grid with the DesignerHostingApplication from Lab 10. When I click on <Activity Reference...> I get tge following error: The service 'System.ComponentModel.Design.IDesignerHost' must be installed for this operation to succed... What do I need to do to get the Activity Reference dialog Hi Might be a nasty question but could you give ...Show All

• Visual Studio Team System Team Build fails on 'Initializing build' step

  No matter what I try I can't seem to get any build (for any of our team projects) to make it past the 'Initializing build' step. The build report states that the build failed with no further info as to the reason.  Additionally, there is no build log created. We are using VS 2005 RTM with Team Foundation Beta 3 Refresh. Scenario:  $/TestProject is mapped to "C:\Team Projects\Test Project When I use the Build Type wizar ...Show All

• Visual Studio Team System Performance Wizard doesn't instrument non-web project

  I'm having issues profiling with the Performance Explorer. I have my Web project, and 4 DLLs which are used by it. I create a new performance session with the web project as the main target. Then, in the performance explorer, I click on Targets and add all of the projects for the DLLs, but when I run and collect the information, there is nothing about the DLLs. How do I get these instrumented Thank you. Kevin ...Show All

• Visual Basic vb and outlook

  Hi I have made an extra butto witch apears when the rightmouse button is klicked, it apears when I press it in mail and my agenda, but I only want it to apear in my mail becouse tis an button to archive mail so my question is is it possible that the button only apears when an e-mail message is selected As you are proposing to use Outlooks internal VB which I'm fairly sure is VBA and not VB.Net - these ...Show All

• SQL Server Open the subreport in an new window .

  hi can any one tell me whether a sub report can be opened in an new window. thanks for the reply .i have tried this but it is not opening in an new window , this is what i have written http://localhost/ReportServer %2fCapacityReport%2fSub1&rs:Command=Render&rc:LinkTarget=_blank&WORKCENTER=PAINT%20&STARTDATE=8/18/2005&DAILY_WEEKLY_MONTHLY=DAILY&rs%3aParameterLanguage=&rc%3aParameters=Collapsed . can you give me an ...Show All

• Visual Basic Blair Allen Stark

  Here is the problem I am working on. It asks me to use the method CalculateCharges, but I don't fully understand how to do this or how it works. I would be grateful for any input. Lab Problem III A parking garage charges a $2.00 minimum fee to park for up to three hours. The garage charges an additional $0.50 per hour for each hour or part thereof in excess of three hours. The maximum charge for any given 24-hour period ...Show All

• Visual Studio Team System work items not associated with build

  How should work items get associated with builds, because it is not working for me. When I check in a changeset, I click the Work Items button and select my work item and the drop down box says associate. After the build completes, my changeset appears in the Associated Changesets portion of the build report butI have 0 associated work items. If I open the changeset I can see that the work item is associated with changeset, but the build ...Show All

• SQL Server Database Mirroring : How to find the TCP port being used for mirroring?

  Hi, I am interested in finding the TCP port which has been setup on a principal/witness/mirror server. I have queried the  sys.database_mirroring_endpoints and sys.endpoints system views but nowhere does it specify the TCP port. I think the only way to find out is to go to one of the mirrored databases and to right click properties-->Mirroring. I think this is ugly way to find out the TCP port, so if anyones ...Show All

• Visual Studio Express Editions Where are the registration benefits

  Have just installed and registerd VB Express. I received an email with a link to the registrations benefits page ( http://go.microsoft.com/fwlink/ LinkId=52054 ). This link leads however to Microsoft Connect, not the registration benefits page. The link given in the Express Registration FAQ  is the same incorrect link. Judging from this forum, this seems to be quite common. has anyone got a working link to the page Chee ...Show All

• Visual C# Provide strings to localize in a text file

  I am actualy testing C# in VS2005 and i compare fonctionalities with C++ that i used in VC2003. I found that in a C# project, there is no property pages for files like in a C++ project. I used the property page in C++ project to perform custom build : compile a text file to resource using ResGen and then add this to the assembly just setting the Linker corresponding option. It seems not to be possible in a C# project because ResGen.exe is not r ...Show All

• Visual Studio Failed PLK on release :(

  I've followed VS SDk docs and install PLK for my package. Then I've test it on my dev. machine with /noVSIP flag, it loads my package succesfuly. But when I doploy it to a machine that VS SDK did not installed, it fails. On log files, VS telling me that bad PLK :( What's wrong with my PLK This is usually a 1-character difference between what you entered into the web form and what you entered into your package. If you saved the mail and ...Show All

• Windows Forms Print txt File in Printer

  Hi, Does anyone knows who to print a txt file direct on a printer using "Generic / Text Only" Driver  !  tks.    The .NET Framework QuickStart Tutorials have a SimplePrinting project that you can check out underneath of  ...Show All

• SQL Server Back to Parent Report button not visible

  When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed thanks, lance The "back to parent" functionality in the HTML report viewer is achieved by clicking the ...Show All

• .NET Development Why do I get a SecurityException when running from the network?

  Hi,   I 'm writing an EXE file using C#.  In my EXE, I'm trying to get access to Environment variables.  Everything is working fine locally.  I have the statement "Environment.GetEnvironmentVariable("TEMP")" which works on my local machine.   As soon as I transfer the program to a networked drive, everytime I run the application it spits out the following error message: --- BEGIN SNIP --- Unhandled Exception: System.Type ...Show All