Hot Solutions

My question is how to get my system to a state to reinstall VS 2010 .
Recently I installed the beta version of VS 11 along side VS 2010 and SQl server 2012(yes i had 2012 sql server running and working prior to installation of VS 11) after using...

I need to read this XML from a SQL table - what's the best way of doing this?

I don't have a table definition to populate at the moment so some indication on how to read different nodes and levels in the XML would be good.  So far I have tried...

Running Windows XP SP3 on VMware Player v4.0.2 b591240
Ubuntu 10.04
Windows Installer v4.5.6001.22159

Question: Can you tell me how to Uninstall the Windows Installer manually using the Registry, so I can then do a clean reinstall of it?
...

How do I get the employee list from below XML

<?xml version="1.0" encoding="utf-8"?>
<Employee>
  <Some_XML_1 />
  <Some_XML_2 />
  <EmployeeList>
    <id>1</id>
    <name>abc</name>
  </EmployeeList>
  <EmployeeList>
    <id>2</id>
...

Experts,

I am looking for some VBA that calculates a date by adding business days. The form will contain a input box for the starting date that the user would enter along with a blank box for the number of business days that they want to add...

My code compiles.
However the referenced control is null.

Button MyControl = (Button)this.FindControl("cmdC1Clip");
MyControl.BorderColor = System.Drawing.Color.Red;

BorderColor property cannot be set because MyControl is null.
...

Hi,

do you know if TFS 2010 work against SQL SERVER 2012?

Thanks,

I am new to using a Microsoft Volume Licensing Agreement and have yet to install my first program. In the past, I have used MSDN and downloaded installation files with the authorization key also downloadable. In this case, I just get the ID, and...

Experts!

Please help on me on understanding the pros and cons of having File-maker as UI and MS SQL in the backend for data storage.


The problems I see is with table links and joins in SQL wont work as well?

We already have MS SQL...

trying to run a VB app (version 6) and getting error "Component MSCOMCT2.OCX or one of its dependencies not correctly registered: a file is missing or invaled. "

I downloaded the MSCOMCT2.OCX file and placed in: C:\Windows\System32

when...

We are needing a Query to pull information from our Database so we can submit the information in a Text format to the Bank.

I've got most of it figured out, but the one part I can't figure out is, where the Check Number is say 5 digits long...

I need to learn Visual FoxPro because I need it for my job
I found 2 resources from the web
http://www.garfieldhudson.com/FreeVideos.aspx
http://www.hentzenwerke.com/buy/zbuy.htm#26

However, I am not sure if any better resources that I...

I need help on seting up a RUNONCE event. I have a windows 7 image. the imag has office 2007 Compress on a .rar and winrar app located under users\public\documents. I been trying to create a onload that will call the batch file bellow to have the...

We have upgraded TFS 2008 server to TFS 2010 server . We are facing the issue in connectivity for users using VS 2008. Users with rights of TFS Admistrator and Project Collection admistartors are able to connect.

Simple users which are just...

Dear Experts

I am downloading all the hotfix offline I am not using Windows Update, and I do not want to use it

I can not install KB968930 the extension is .msu a msg box appears
"Windows cannot open the file:"
"File:...

Is there a difference if a variable is dimentioned as:
Global gstrUserID   vs  strUserID
when declared at the top of a module (not a form or report module)?  I want the variable to be used throughout the application.

Sandra

on http://msdn.microsoft.com/en-us/vstudio/ff520697 is says:
Visual Studio 2010 Load Test Feature Pack: MSDN subscribers with Visual Studio Ultimate are provided a license key to generate UNLIMITED virtual users without having to purchase the...

I have an Infopath 2010 form with several sections. In each section, the person doing data entry must input several numbers (text boxes field1, field,2, field3, etc.). This can't be a Repeating Table. At the end of the section, I created a...

Hi All,

I need to zip subfolders which resides under the parent folders which
are 201003,201004,201005(for each month).
Under the parent folder.example 201003->Titles->then many sub folders
for each day of the month,I need to use...

hi guys
I'm looking batch file with will update polocies in domain envoriment and restart pc at prompt (after updateng polocies)
my batch file is now

"Echo Yes|gpupdate.exe /force"  BUT user still have click Y and enter and i want this be...

I type text into shapes in Visio drawings derived from Templates. Now I want to add automation,  by importing text automatically from various third party XMLs. Can I and ought I import the data fields of the 3rd party into MSOffice XML derived...

I am programming in Visual Studio 2008 using vb.net.

I have a web program that contains pages with many fields.  I have the following code that converts enter to tab, but only works in i.e.  This app must also work in Mozilla Firefox and...

Hello experts,
I am using visual studio 2008, to print out a label.  I am replacing a spread sheet that is currently printing the label.  The problem is, in the print properties of the spread sheet, it is set to center on page horizontally.  How...

Hi,

I'm trying to build an SSIS BIDS project that was developed by a different user but keep getting this error when trying to build the project.

Error      1      System.UnauthorizedAccessException: Access to the path...

Hi

I have an application compiled with Visual C++ 6.0 which I am trying to run on a newly configured Win7 Pro computer (32bit)

I am getting a failure "The program can't start because MSVCR100D.dll is missing..."

First I  tried running...

I have a report that successfully opens in test.  However, when I switch it to production, it bombs.

The actual Crystal Report points to the development server.  However, in production I thought this call would redirect it to the correct...

Can Java, php or others modern languages consume WCF services? Is it much different from consuming ASMX services?

I'm writing a few sample C programs from my class book. This particular one is on page 175, from the book entitled "C Programming for Scientists and Engineers". I've already created the two files and put them in the same directory as the...

I have the below VBScript that works for one database, but what woudl be the best approach to loop through about 10 databases?  Or do I have to create 10 different scripts and call each one by one in the Scheduler?

Option Explicit

dim...

Converting a VB.NET application from VS2003 to VS2010, all the while maintaining the Crystal Reports forms within it.  Having problems finding any help resource on resolving a namespace conflict.  Can not find anything to help with converting the...

Hello,

Can I have code that will allow me to copy only the past month of created files to a new location.   Any help is appreciated.  

I tried this but this seems to be anything beyond a month.


foreach ($i in Get-ChildItem K:\)
{
   ...

I have the below where I am trying to TRIM the data in the column.  For some reason, when it is downloaded, teh userid always has leading spaces, usually four.  But while the code loops through the column it does not trim the string in the cell. ...

I'm having a problem with regards to Crystal Reports in VB 2010. I am developing a Windows Application and I want to display in crystal report a result from my sql query without the need of connecting it to database through Database Expert --- I...

I am trying to install SQL express server 2008 R2 on windows xp but getting error message saying Acess denied?

I am trying to help someeone with a problem on one of their forms.  the data source for the unbound text box is one of the fields in teh query for the list box.  When teh user changes the list box selection, the items on the form update with the...

Hi there,

I have been searching high and low for a solution to what seems like a standard layout for a navigation pane. I have managed to obtain outlook 'accordion' style navigation panes from around the net.

The one I am currently using...

Hi EE

I am trying to increase a numbe by 1 each time it's used this is the type of number
DEMO00001. It will always have 5 digits sample of other numbers are
CI00001
RD00001
ST00001
I am using the following function

rsjob.Edit
...

How to read the hardware id (motherboard) in vb.net?

Hi!

How do i make a query, that selects alot of fields, and export the data
to a csv-file ?

Hello I added a slideshow in my aspx.net site.
Following this example.

http://www.dotnetcurry.com/ShowArticle.aspx?ID=287
and I have some issues that I need to solve and some  questions
I would like to ask if I need to make it with a...

I used this statement with numbers and had no problem but trying to match text and it does not seam to work.  

 

I have inherited a database with 311 queries.  Is there a way to simply loop through all the queries and have them printed out?  I am trying to "cleanup" this database and am trying to figure out where all the tables are used (or not as about 25%...

I have an ACCESS 2003 database that I am using to open other databases.  This "menu" database only has one form and on that button that open other databases.  However, I am trying to set up the first database and while the "child" database has an...

Hello,

I have around  100 windows 2 K3 and 2K8 servers.  I was wondering if there was a script to remotely connect to the windows servers,  check if lotus domino service was running and than gracefully shutdown domino server.  After the domino...

Hi

I want to find any hardcoded servernames within stored procs or view, the servername is sb22.

can anyone give me a selectstament that will do this, i guess from the master db?

Hi,
I am having a really hard time finding a simple example of creating a view and related changes to model/controller(s) to display a child record <view>.

In other words - I am not trying to accomplish fancy master-detail display and CRUD...

Can the Microsoft.Office.Server.UserProfiles and Microsoft.Office.Server.Audience namespaces be used/referenced using the Foundation version of SharePoint 2010?  I can't find this DLL/namespace on my system.  I am running SharePoint 2010...

I just started at a new company and there are plenty of problems here but one of them is the possiblity that the former Network admin was using MSDN licneses in production. unfortunatly the former Net admin seems to have been the worst record...

Hi EE

I have just installed a new app onto 4 PC's but on two of them I have a strange problem the list box's wont populate they are set up in the usual way linked to eithe a tbl or query. There is absolutely no difference between the 4 pc's....

I am having difficulites installing and running custom VB6 applications on win7 64-bit system.
The application was built and deployed using package and deployment wizard.  It uses win 32 API calls to read an initialization file and logon to an...

I am currently using an query that uses the "like" expression.   Looks like this:

WHERE (((multiple4active.ShortTitle) Like "*" & [Enter a key word or Partial key word] & "*"));

I want to be about to pass a variable for a field name on a...

The Select statement below Ranks the number of Items Sold by Terr for all my sales people (about 1000 Sales People and about 250 per Terr and there are 4 Territorys).

SELECT     Rank  ()  Over   (Partition By Terr Order by  Items desc) as...

I have the following link that is one of 100 links on my web page.

<a onclick="window.open('http://www.link.com,'popup', 'width=800,height=600,resizable=yes,scrollbars=yes'); return false;" href="http://www.link.com">

I'd like to remove...

I have a table with a column named filename. I am trying to delete all of my records that start with a "9-" except not delete records that start with "9-5400". This statement doesn't work:

delete from tblmaster where substring(filename,1,2) =...

Is there a way by using which we can use the Database mail service to send the result of a stored procedure that will be scheduled to run at a specific time each day? If yes, then where can we schedule it and how we can send the result in HTML...

I have a .Net page used for sales analysis which displays a ton of data.

Management determines the page requirements...if up to me, I'd break it into several pages.

The page on the live site takes average of 5.9 seconds to load

Feeding...

Hi:

We wrote some visual basic 2010 code to read data into a DataGridView.

The code runs correctly and data is displayed accurately in the DataGridView.

However, when we wrote extra code to verify the number of rows of the DataGridView,...

hi

using a backup i have created a new database, i want to update any views that reference the old database "ssq".

is there a select statement i can use to select the name of any views that have the old database name "ssq" hardcoded in...

When a page is contained in the Content section of a MasterPage,

string strControlID = "TextBox1" ;

//FindControl(strControlID) returns null.

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master"
AutoEventWireup="true"...

Hello,

Wondering if anyone has a "code" solution on how to distribute COM DLL's compiled with VB such that they can be licensed. Licensing COM objects appears to be VERY different from Licensing an ActiveX object.

To clarify, some examples...

I have a MasterPage, Content, and aspx page within the Content.
I need to find a control using the string ID of the control to be found.


<%@ Page Language="C#" MasterPageFile="~/MasterPage.master"
AutoEventWireup="true"...

I am trying to get the first letter of a first name
What I have is
            Dim trimString = txtFirstName.Text
            Dim stringLength = trimString.Length - 1
            Dim Initial = trimString.Remove(Right, stringLength)
         ...

Hello Experts?

What are set & get properties in vb.net? What are the uses of it? and when do we use it?

(I want your genuine opinion )

Thanks!!!!

Hi EE

I am using the 2010 runtime  and trying to remove the security warning each time I run. I posed a question and LSMConsulting gave me the following web site

http://www.accessribbon.de/en/?Trust_Center:Trusted_Locations

I have...

I imported plain text into MS Word document, and I want to remove all empty lines (see the attached image) in it. What is the best way of achieving this please?
Thanks.
(I once knew how to do it with Regular expressions in MSVS text editor,...

I have a data range on an Excel 2010 worksheet that if the value of a cell, say D15, does NOT equal say, FirstBrk, SendBrk, StartTm, Meet, to delete it.  I have the below, am but not sure how to test the value of the cell for one of several...

Dear Experts,

I have an issue related to the above subject title.

My requirement is that I need to sign a message using the Private Key and verify it's authenticity using the Public Key. And also there's a possibility in the tool that the...

Once again I need help.  How is a better way to write this RS.EOF code?  WHat I need is sort of a loop, but its not looping really because it applies to the next record and different txt control on the form.  Basically it works now but if there...

Is it possible to have an insert statement but using

exec sp_selecttable

Hello,

how can I format/convert a time_t info into a unicode CString?

Ingo

I still can't seem to figure out the correct JOIN syntax.

I have three tables. The main table (ST) contains 100,000 records and includes 1) a NameCode and 2) a NAICSCode.

I want to end up with a table or view that includes all of the TAXIDs...

I have a procedure that when it hits the Selection.Find are, stops and  gives me an Object variable or With block variable not set.  But I am only trying to find the first instance of a parameter passed in.  This is VBA no a form in an Excel 2010...

I have a problem that i'm sure some guru can help with.
I have a piece of software (an add on to AutoCAD0 that links to an Excel file with multiple tabs. I am also creating a database that non cad users can update and search by, this is...

Is there any way to combine two wpf images to one image (VB.NET.net 4.0 wpf-application)?

Or an other solution with CroppedImage / RenderTargetBitmap / using Visuals ...

We want to select all the rows that have an AID = 1 but don't have a matching AID = 2 with the same BID.

select ID, PersonID, AID, BID from [track] order by id

I have a VC++ 6.0 dll that connects to an oracle database using the CDatabase/CRecordset classes.  I am trying to suppress the Oracle/ODBC popup error dialogs when the code is running on a server, since no one is there to click "ok" to dismiss...

Some of our 32 bit apps took years to develop and reach the level tehy have today....
Is it necesary to rebuild everything on 64 bit tools?

Dear All,

I need some help in it trying to resolve the following issue i woul like to sum a colmn bas if another column has a particular value i.e. is Sum(Sales value) if the Special falg = p, the following is the query that i have wrote, it...

Good morning.  I have some old btrieve (version 5.10a) that I'd like to convert to Access 2010.  Is there an easy way to do this?  I know how to create a DSN (if that would be the easiest way to do it) but I don't see an ODBC driver for btrieve. ...

I need a simple VBA function that checks column D and simply returns yes or no if the work MEET exists in the column.  This is in an Excel 2010 worksheet.

Sandra

I have a process taht I want to hesitate for about two seconds before proceeding.  But how would I do that?  That is, Between two lines below, I want the VBA to hestitate before proceeding.

Me.cmdCAR.BackColor = 2858687
'Hesitate here to...

ASP.net 3.5
VS 2008

I have a farly simpel updatepanel that displays a message while a process is run.

This works in my dev environment but not when I deploy to my test server.

The rendered source is here
 

I ran it in IE and got the...

I am troubleshooting an in-house program at work that uses MS SQL.  I don't have much MS SQL experience starting out.

The in-house program is used by many workstations at once to enter in data.  When the data is entered into the program, a...

Hi Guys, i need help.

I have 2 servers where I have installed 2 SQL Server 2005 instance.
On a server I have installed the database.
And on the other I have installed the "Analysis Services"
I need to plan a strategy for migration to SQL...

We clone tons of laptops and using sysprep, Master images get cloned using GHOST and then clients start running sysprep using unattend.xml. As soon as  sysprep finished  and windows restarts some of the clients get message "Windows not activated...

Am I dreaming or didn't Access used to automatically add "End If", "End With", etc. when you entered "If", "With", etc. in VBA?  Is this no longer done or is there a setting I can change that would make it happen again in Access 2010?  Hopefully...

Hi I want convert this to a VB LINQ query please help

SELECT * FROM ProductOptions
LEFT OUTER JOIN TempTable ON ProductOptions.OptionID = TempTable.OptionID
WHERE (TempTable.OptionID IS NULL)

I have a mainform/subform.  On teh subform next to the record is an edit button that does call another form for a particular record and works find. But I want to close this first form in the code, but since it is on the sub-form, it does not...

I have to rebuild a computer with a legitimate product key.  The recovery software is installed on the hard drive that is completely dead.    Are there any online recourses from Microsoft to download replacement OEM media. or other sources?

I am trying to order my recordset by the last 1 or 2 numbers from a value that always starts with a letter.  For example the value is B10, I want to order it by 10.

So what is the syntax for this in ORDER BY?

Here is the sql.  The ORDER BY...

Ok, I can find inforamtion on how to populate a listbox, but after the user has made their selection(s) it is a multiselection lisbox, I cannot find any information on how to record this information into an array so I can loop through and do the...

I have the following code in my method

            MyListViewModel viewModel = new MyListViewModel {
                MyList= repository.MyList
                .Where(m=> alphaFilter == (string)null || m.Title.StartsWith(alphaFilter))

this...

We are currently hosting html websites while using asp to process certain web pages and are thinking of creating php websites.

We are curious and are not sure if php can be supported while still hosting the websites that are already there. We...

I am trying to do something simple here but an hour into it getting frustrated....being fairly new to C# I want to convert the following VB.NET code and cannot seem to do so...

CType(Me.ddlEncryptionAlgorithm.SelectedValue.ToString,...

I have an image button named cmdCKClip.
This statement to change the border color does not work.

cmdCKClip.BorderColor = "Red";

What is the syntax for the correct statement?

Thanks,

I am trying to set a global variable from a form module...then reference the global variable in the criteria of a query grid.   The attached file lays out the 3 steps.   I am failing miserable.  Your expert help would be appreciated.

I would like to lookup different fields for an entity, how would I do that? How many relationships do I define?

e.g.

Plan Entity
PlanName, PlanAccountID, PlanDescription
I would like PlanName, PlanAccountID map into name, AccountID for...

I inherited some very old and messy MFC/C++ code.  It is a dll being called from VB6.  

In a nutshell...

class CMyCollection : public CTypedPtrArray<CObArray, CInformation*>
{
   // "Where" and "Orderby" are SQL.
   VARIANT_BOOL...