Search results for query: *

Hi, I have a spreadsheet which has a macro in it that updates the spreadsheet. The update macro takes about 3 or 4 minutes to update and save the spreadsheet so I wanted to do the time consuming updates in the background (current thinking was on the server via scheduled tasks). As you can't...

Hi, I am trying to split an Excel file into 4 smaller chunks so that different people can update their own bit rather that a single person having to make all the changes. Therefore, I will still need a Summary Excel file that will collate the 4 different sheets. I can link the Cell data so that...

Hi, I am trying to add a FLASH object into a Powerpoint presentation programmatically. I can do it through powerpoint the application but I need to automate the process. I have searched the libraries within .NET (object viewer) but there is no reference to FLASH or SHOCKWAVE. Anyone done this...

Hi, We have just migrated an application from SQL Server 2000 to SQL Server 2005 and are recording a load of errors as in the subject. Doing a search of the web reveals that this error is not descriptive in any sense, however, here are our specific details: No ASP code changes have been made...

Hi, This seems an odd problem. We have an ASP.NET AJAX UpdatePanel within a UserControl. The UpdatePanel contains a GridView control that binds to a given DataTable to do its work. In order to give the GridView a double-click selection mechanism; the leftmost column is actually created by a...

Hi, I am wondering if there is a way to choose the fields I want to display in the Jobs area of SQL Server 2005 (in SQL Server Agent). On SQL 2000, you could se the jobs at a glance such as Enabled, Runnable, Scheduled etc but 2005 just has the name and Status. Cheers, Woody.

Hi, We are migrating from SQL 2000 to SQL 2005 and I have managed to import the old DTS packages into the new system. I wanted to make sure we could modify the packages and apparently SQL 2005 uses something called Business Intelligence Development Studio. This has now been installed but...

Hi, We have a very large database (around 13GB) and need to migrate it across to a new server. I know that there are a lot of tables in the DB that are redundant and therefore, to reduce size, I wanted to drop some of them. I seem to remember that I was able to (in Enterprise Manager) view the...

Hi, We are creating an application that we wish to use the impersonation items in .NET v2.0. When creating the impersonation on a single page (using windowsidentity), this seems to be fine and the user changes. However, when redirecting to another page, the windowsidentity.getcurrent() reverts...

Hi, We have recently upgraded one of the servers from Windows 2000 to Windows 2003 Server and re-installed the SSL certificate for the site. However, since then, certain users have had horrendous response times from the server whereby other users' response times are fine. There seems to be no...

Hi, I have downloaded and installed V2.0 .NET framework and have read through the notes that came with it. I admit I am a little rusty (not touched .NET for about 12 months) but when I open VS.NET 2003 and look for some of the new controls, I can't find them. One in particular is the Login...

Hi, I am wanting to use an Iframe in a document but wish to automatically set the height of the Iframe to match the content height. I do not want to use scroll bars and although I can guarantee the width can be fixed, I need some way of setting the height to equal the page height of the page to...

Hi, I am wanting to use an Iframe in a document but wish to automatically set the height of the Iframe to match the content height. I do not want to use scroll bars and although I can guarantee the width can be fixed, I need some way of setting the height to equal the page height of the page to...

Hi, We have a problem whereby we wish to send a campaign of emails to relevant people. However, we wish to personalise the email to say "Dear John..." etc. however, ACT! seems to want to use "Dear Contact". You are able to personalise letters so I would assume you can do it with email. Does...

Hi, We develop and host websites for clients. We have had a request from some of them to be able to automatically authenticate when they log in to their computers so that, throughout the day, when they access the application on OUR server, they don't always have to re-enter NT Login...

I am running SQLServer 2000 on XP and trying to connect from similar setups to my machine but getting not found message. My Setup is Windows and SQLServer auth. and also set to allow remote connections... However, I can seemingly connect to every installation in our building but no-one can...

Hi, Is there a way to determine which button was pressed in the Page_Load trigger as the code for the On_Click is run AFTER all usual code is setup but depending on which button is selected, is dependant on the setup required... Cheers, Woody.

Hi, I have an app that has an ASPX form with multiples of a User Control. As part of that User Control, there is a Remove button which I wanted to use to delete the information from the database. However, because all the ASPX stuff is done first and therefore all the User Controls are created...

Excel Gurus, I have an interesting problem whereby a spreadsheet for expenses was created by someone who has since moved on. What they managed to do was to lock a cell to only accept values between a date range. I have tried and looked everywhere to find out how he has done this but to no...

Hi, I have created a UserControl which effectively wants to behave like a button but look different (made up of 3 graphics). The reason for this is that I wish to use the same style of button in various places but obviously with different text so have used a process of using a table/row/cells...