Loki1982's Q&A profile

• Microsoft ISV Community Center Forums obtain data of next 10 days

  Hi all, i need your help again. Now, my problem is, i have two columns of data. one of the columns is 1 to 100 and another column is data corresponding to column 1, which is shown below, and a userform which has a combo box with values from 1 to 100. data: 1 => d 2 => f 3 => t 4 =>s 5 => n 6 =>k 7 =>o 8 =>w 9 =>x 10 =>b 11 =>jo 12 =>yt 13 =>cv 14 =>ad . . . let say i have a combo box with values 1 to 100, when i choose one of the value in the combo box, i need a macro that can show me all the data of the following 10 days in another excel sheet. Can this be done Thanks a lot!! :) Hi, I still don't understand your meaning by moving the code to the user form. I tri ...Show All

• Visual Studio Express Editions error apawning cmd.exe

  hi! I am facing an error in C++ express edition. I have already followed the following solution, but failed to overcome the same: In the Options go into Projects and Solutions -> VC++ Directories page and place this rows: $(SystemRoot)\System32 $(SystemRoot) $(SystemRoot)\System32\wbem Please let me know the permanent solution. Regards, hello Re: error apawning cmd.exe I am going to mark this thread as answered since you have not followed up with any further information on your problem as requested for over a week - I assume you solved the problem yourself or one of the suggestions in this thread helped you solved the problem. If you have a solution you could post it so others can find it. If you do not h ...Show All

• Microsoft ISV Community Center Forums last Modified date in Excel spreadsheet

  Hello Can anyone help me read details about a current workbook. Bascally everytime an excel spreadsheet is opened I want to saved the last modified date to say Sheet1.range("A1") Thank you in advance. can this be done with a UDF instead i've this so far: Function FileSavedTime(w As Workbook) As Date FileSavedTime = w.BuiltinDocumentProperties("Last Save Time") End Function ...Show All

• Internet Explorer Development Please help !!! - Javascript OnChange events are not fired

  Hi All, have one strange problem. Scenario: 1) Server with MS CRM 3.0 and some custom client-side scripts applied to CRM elements (OnChange, OnLoad handl;ers etc.) 2) PC A with IE7 installed 3) PC B with IE6 installed 4) PC C with IE7 installed Problem is, that some (not all!) JavaScript events are just not fired on PC A and PC B. At the same time, same code form same server are running perfectly well on PC C! OnLoad events are working everywhere. OnChange - almost never on PC A and PC B. I tried to make every change I could think of in IE security settings - it didn't help. During making chaotic changes to IE settings on PC A I managed to make events fire normally - but when I closed IE window and re-opened it - every problem returned bac ...Show All

• SQL Server How can I use the Variables in SQL Execute SQL task?

  I define a package variables "varOutTable" and "varFromTable". and I insert a SQL Execute SQL Task into Control Flow my sql command is "Select * into @[User::varOutTable] from @[User::varFromTable]" but the task failed, it seems that sql task can't get the varOutTable and varFromTable How can I use the Variables in SQL Execute SQL task thanks!!   agentf1 wrote: Will this work for a select count(*) Why not   A select count(*) would work just like a select * does....  So yes, it would work. ...Show All

• SQL Server Slow query when run in multiple threads

  Hi, I'm trying to stress test my web application, but when I get high load, the queries that used to take 10-20 ms starts taking 500 - 2000+ ms. Or to put it another way, when i run them single threaded i can do about 43000 a minute, when they are run in paralell it drops to about 2500 a minute. What can i do about this There are severeal queries thats affected, but here is one example: update [user] with (ROWLOCK XLOCK) set timestamp = getdate() where userid = 1'' btw: im running sql server 2005 sp 1. The stress test is run on 3 machines total (web, sql and client) the client is simulation 400 users, cliking a page as soon as the last one is loaded, ie there will always be 400 page requests. Hmmm.. w ...Show All

• Visual Studio Team System BUG: Checkin of binary file not detecting a difference... no way to force it???

  I have a binary file under version control. It's .dat file which is the a BCP output of a table from a database. We have hundreds of these TFVC and have not had problems until now. We have added something like 9 new rows to the table. We checked out the .dat file, BCP'd the data out generating a new .dat file over the top of the old one. The date stamp is updated, the file's bigger and if I restore that .dat into my local DB the new data is there... I know the file is updated. However, when we go to check this file in, TFS doesn't detect a difference and so it undoes the checkout. A) This seems like a bug. The binary file is clearly different. B) How can I force the check-in. I want to ignore the diff. check and just get the file int ...Show All

• .NET Development Memory Issues

  Hello all, I've been trying to profile my ASP.NET application on my application server. I set up 2 counters for aspnet_wp process namely '#bytes in all heaps' and 'process:private bytes'. According to a documentation that i read, '#bytes in all heaps' should be less that 'process: private bytes'. However the '#bytes in all heaps' was far greater than that of the 'process: private bytes'. I'm lead to believe that this indicates a memory leak somewhere. Now, the problem is that i've got 15 ASP.NET applications running on that server and i need to find which application(s) are causing the problem. Please i'll need help on which counters to set up that will enable me pin point the rouge application. Thanks Emeka. ...Show All

• Visual C# Getting Image Source URL

  Hey everybody, I'm trying to drag-and-drop an image from a web page to my application. What I wanna do is to get the image source url.. When I drag an image to my app. I got the image itself or the target link (if the image is a link HREF).. How can I get the source url of the image.. For example, in the upper-left side of this forums there is a "msdnR" image.. When I drag and drop it to my app, I got as a result the image itself and the target of the image ( http://msdn.microsoft.com ).. What I want from my app to do, is to give me the location of the image itself, in this example, I wanna get http://forums.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif as a result.. Can you help me ...Show All

• Windows Forms Spare Row at the botton of the DGV

  Hi All Whenever I bind Data to the DGV control, there always seems to be a small grey area at the bottom of the control that I can't get rid off, no matter how carefully I size the control at design time. I am using the AutoSizeMode property of the right hand column to ensure there is no 'spare space' horizontally when the control/form is resized, but I can't find any similair property to get rid of the spare vertical space. I thought it may be due to the control leaving room for a user to add a new row of data, or for scroll bars, but whatever I seem to do, theres always a small bit of space after by rows. I have now set the background colour of the grid from the dark grey default to something less in your face, but this is only a w ...Show All

• Visual Studio 2008 (Pre-release) Adding New Data Source: Exception has been thrown...

  Trying to add an Access db (mdb) as a new Data Source in an Orcas project (DecCTP). At the end of the wizard when clicking OK, the wizard gives the following error: "Exception has been thrown by the target of invocation" Configuration: Vista, 2007 Office, Orcas Dec CTP Any suggestions Thanks, Lex Hello Lexite, Do you have Visual Studio 2005 installed on the same machine also If you do, then this is a known issue that will be addressed in Beta 1. All CTPs before Beta 1 will probably have this issue. I believe there's no problem on other versions of Windows. Or you can try uninstalling Visual Studio 2005 from your Vista machine and installing CTP. Thanks! ...Show All

• Visual FoxPro Font Size Randomly Changing

  Has anyone experienced a problem in a FoxPro 9 application, where the font size of some controls on a form change It could happen going from form1 to form2, or form3 to form2.  The size changes from 9 to 8, 12, or 18. There doesn't seem to be a pattern, and it could happen today day and not happen for several days later. I have never heard or seen such a thing! I also don't think that VFP implements self-programmed changes. So this must be something to do with the environment - Themes Maybe some wierd set up in the windows IDE configuration for "active" and "inactive" windows But without a little more detail it is hard to guess ...Show All

• .NET Development DataAdapter.Update

  I've got two rows added to my datatable that I need to commit to the database. I begin a transaction on my connection and attempt to update both rows as one transaction to the database. My first record is successful, but my second row fails due to a business logic error raised in the stored procedure. The transaction, therefore gets rolled back and neither record gets commited to the database (perfect). My first successful row has now changed status from "Added" to "Unchanged"(why). So, now I rectify my second row in order to rectify the business logic error and my second row has remained as an "Added" row (perfect). Now I begin the transaction and only my second row gets commited to the database and not my fi ...Show All

• Visual Studio Express Editions Calculate Emailaddress from multiple textboxes.

  Hi, I'm totally new to programming in VB but you have to start somewhere! It's so cool! What I'm trying to archieve for now is creating an emailaddress based on various input textboxes: FirstName, MiddleName, LastName. The emailaddress should be calculated like this: <1st letter of FirstName>.<MiddleName>.<LastName>@company.com If a user has no MiddleName there shouldn't be an extra dot! The EmailAddress textbox should be generated as you type the FirstName, MiddleName and LastName textboxes. I'm also looking for some tips for input validation. It should only be possible to use alphabetical characters. An additional Initials textbox should only use alphabetical characters and dots e.g. T.K.B. All help ...Show All

• Software Development for Windows Vista Difference between Vista versions.

  Hi, What are the difference/use between the following vista versions Windows Vista HOMEBASICN Windows Vista BUSINESSN Windows Vista STARTER Thanks in advance !!! Regards, dotnetsekar. Kinda old to reply but I am given those versions when using the 64 bit ver of vista, but I guess it is pointless since I don't have a key for them. ...Show All