Search results for query: *

I have a series of cells made up of one vertical cell and 6 merged rows each. Each cell can contain quite a large amount of text data. Each cell represents a single day in an appointment scheduling system I have built, based on a tutorial by Randy Austin from Excel Freelancers. I don't wish to...

I have developed an web application in Visual Studio 2013 which uses the development server that comes with VS. I now want to port it to a Website to use IIS running on my PC. I have had a thousand challenges to date, not the least of which is the Global.asax file which registers all the web...

The web application I have built queries a SQL Server 2008 database. My application runs downstream from the main enterprise app and runs only one query on a frequent basis. The DBA's informed me one of my queries had been running for four hours and they were killing it. They later changed the...

I am performing a left join on two data tables (dt_Clients and dt_ConnXclients) using Linq. The problem I have is the select statement, where I am trying to return an array of datarows to populate a data table I have created with columns from both tables (duplicate removed). Dim...

I am on Office 2010. I have several hyperlinks in a document that reference other word documents in the current folder. Autosave is configured to save to the default location i.e. C:\Users\@Username\AppData\Roaming\Microsoft\Word For some reason, Word is closing unexpectedly, restarts, and then...

I have SQL Server 2005 setup executables that I have successfully set up on Windows XP previously. I am now trying to install it to my Windows 7 machine. On firing up setup.exe, I immediately received the message that there was a compatability issue and that I needed to install SQL Server 2005...

I have the following HTML with inline styles. <img src="../Images/ciap_bg_3.JPG" style="float:left" alt="Ciap" /> <p style="background-color:Fuchsia">Here is the first paragraph</p> <p style="background-color:green">Here is the second paragraph</p> A quote from extensive reading on the float...

I have created a network directory for each Manager(47 Managers) and an excel file called 'LaunchPad_Cost_Centres.xls' in each of these directories. I am not sure of the exact mechanism that takes place, but I recently had a file locking issue where the following message was posted for each file...

I have installed SQL Server Express 2005 using an enterpise windows installer package file. I installed it to my PC using a network domain account HEAHS/50013135. After installation, I cannot see HEAHS/50013135 as a Login, but I can see another domain account I have not heard of HEAHS/50007345...

I hope this is the correct forum. I inherited a PC with Visual Studio 2005 already installed, with BIDS buried under Programs --> Microsoft SQL Server 2005 --> SQL Server Business Intelligence Design Studio. I can't tell if SSBIDS was installed with Visual Studio 2005 or installed with SQL...

I am constructing a formula programatically. The formula contains double quotes (for the TEXT function) which I am escapeing with the chr value for double quotes. The build of the formula is this: Dim Man_Ed_Formula As String Man_Ed_Formula = "=DATEVALUE(TEXT(Employees!H2," & Chr(34) &...

I am designing a database to reflect our Organisational chart. The hierachical relationships to model are: The lowest level is an Employee. Many Employees can belong to the next level - Services. Many Services can belong to the next level - Portfolios. Many Portfolios can belong to the next...

I have a Listview with a LinqDataSource. I am allocating a resoure called Bladder Scanners to clinicians on the day selected. The field in the database, 'Allocated_Bladder_Scanner_Id', is tinyint and allows nulls. The 'nullable' property of the field in the dbml is set to allow nulls. In the...

I have done a search for the above and found nothing on tek-tips. I have developed some Crystal Reports as part of an ASP.Net 3.5 web application. I use the simplest of deployment methods by just copying the files to the Production website. The reports are falling over with the message: Could...

I have a dropdown of dates which is a controlparameter(@Provider_Date) used in a sqldatasource query. WHERE (convert(varchar,Provider_Day.Provider_Date,103) = convert(varchar,@Provider_Date,103). The trouble I am having is to craft the dropdown of dates(sorted by date,today plus 10 days...

I have a small script below which uses sp_MSforeachtable and sp_spaceused in combination to return the size in KB's of each user table in the database. I run the script against my development and test databases which have approximately the same number of records in each user table. CREATE TABLE...

I have a standard gridview, with the standard paging and sorting interface enabled. The application holds appointments for three organisational units, with a maximum of 3000 appointment records being returned across all three units. The appointment records are quite small. The choice I am faced...

The Access verison is 2003. I have a table with a numeric field of type byte. I have set it to 'not required' with no default value. I am updating the field from a ASP.Net(VB) webform and am setting the field to 'nothing' if the corresponding webform field is not completed. However, on update...

I am runnng ASP.Net 2.0 on IIS 5.1 on my development PC. I have configured Users/Roles/Access rules through the ASP.Net configuration tool in VWD Express 2005. On entering credentials in the login control, I am receivng the old error: 'Exception Details: System.Data.SqlClient.SqlException...

I am building a generic error routine that I can apply in almost all situations, with the goal being to provide the user with a nicely formatted message instead of a trace dump. I wish to detail the name of the procedure where the error was generated but have been unable to locate any object...