Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: shaunk
  • Content: Threads
  • Order by date
  1. shaunk

    VBA to display overflow text vertically on selection

    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...
  2. shaunk

    Web API Routing Not working in Web Site App.

    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...
  3. shaunk

    Long Running Query Issue

    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...
  4. shaunk

    LINQ - Selection Syntax issue

    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...
  5. shaunk

    Recovered Word Document has Changed Hyperlinks in Current Folder

    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...
  6. shaunk

    SQL Server 2005 Setup Issues on Windows 7

    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...
  7. shaunk

    CSS - Block element not behaving as expected

    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...
  8. shaunk

    FIle Locking Issue with Excel

    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...
  9. shaunk

    Install Issues SQL Server Express 2005

    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...
  10. shaunk

    Business Intelligence Design Studio

    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...
  11. shaunk

    Applying Formula with Double Quotes not working

    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) &...
  12. shaunk

    Organisation Chart database

    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...
  13. shaunk

    Linqdatasource - nullable decimal not udating

    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...
  14. shaunk

    Deploying Crystal Reports in Visual Studio 2008

    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...
  15. shaunk

    agnostic date query fromdropdown

    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...
  16. shaunk

    sp_spaceused results question for 2 databases

    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...
  17. shaunk

    Filtering versus Returning to Datasource

    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...
  18. shaunk

    Numeric field of Byte default value

    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...
  19. shaunk

    Login failed for user 'PC\ASPNET'.

    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...
  20. shaunk

    AP.Net Generic Error Routine

    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...

Part and Inventory Search

Back
Top