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 Chriss Miller 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: *

  1. snakehips2000

    Entity Framework, MVC, ASP.NET, ASP.NET Core etc… etc

    I'm looking to develop a basic website to administer a sports league. I'm an experienced SQL Server database developer but am new to web development. I wish to make full use of my database skills in manipulating data so will be preferring to use the efficiency of pre-compiled stored procedures...
  2. snakehips2000

    Manipulating SQL Server 2008 Objects in VBA via SQLDMO/SMO

    I use Access 2003. For many years I was able to dynamically manipulate the structure of objects in my network SQL Server 2000/2005 databases (i.e. tables, views, stored procedures etc.) by creating a reference to the SQL Server DMO object library (Tools, References). The network SQL Server...
  3. snakehips2000

    Object Variables and Multiple Users Simultaneously Same Script

    There's probably something basic I'm missing here but, if my ASP page contains the following: <% rsProducts.Close Set rsProducts = Nothing objConnection.Close Set objConnection = Nothing %> If User 1 runs the page and, whilst executing and having set the recordset and connection object...
  4. snakehips2000

    Execute .sql file from ADO

    I'm looking to execute a SQL Server script which I've saved as a .sql file, from Excel VBA, and export the results into another Excel workbook via ADO. Could someone please supply a simple example? It's the referencing of the .sql file which I can't get my head around. Presumably, I also need...
  5. snakehips2000

    Find First Weekday (Mon) From Week Number

    I picked up the following two functions as a means of determining a date from a week number in Excel VBA. Unfortunately, when used together, they return the same date for both week 53 of 2010 and week 1 of 2011 (3 Jan). Does anyone have anything more reliable please? Thanks. Public Function...
  6. snakehips2000

    Creating/amending Oracle stored procedures via VBA

    I know there is the SQL-DMO object library which allows all objects on a SQL Server to be manipulated, i.e. databases, tables, views, stored procedures etc., but is there an equivalent reference within VBA for the objects in an Oracle database? I'm particularly interested in changing the...
  7. snakehips2000

    sp_OAMethod - ExecuteWithResults

    Im trying to create a formatted Excel spreadsheet with the results of a T-SQL query. However, I'm getting an error when using the following code which seems to be in generic use on several forums. Can anyone tell me where my syntax is wrong? I have the necessary permissions for executing...
  8. snakehips2000

    Dynamically Declare Variable in T-SQL

    Can someone please tell me why this doesn't work? declare @sql varchar(100) SET @sql='DECLARE @myvar int' EXEC(@sql) SET @myvar=5 SELECT @myvar Thanks
  9. snakehips2000

    createElement('SELECT') not working

    Maybe I'm missing something in how this javascript statement is meant to work but I can't get a (blank) select box to display when I load a page. Any advice appreciated: <%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"...
  10. snakehips2000

    Problem Linking Access Tables to Sharepoint Lists

    Our company has an intranet which I'm told is based on an evaluation version of Sharepoint (unsure as to how long ago). Although I have access to the design/content interface of the intranet, I currently don't have any access to the Sharepoint platform behind it. The problem lies in an Aceess...
  11. snakehips2000

    Passing String As An Array

    I've got problems with the following JavaScript code. Although the array is seemingly created, I'm unable to access the individual elements (in this case, the first one 'uno'). Instead the browser displays the whole array, i.e. 'uno', 'dos', 'tres'. When I replace "document.writeln(arr2[0]);"...
  12. snakehips2000

    DIVs inside another DIV

    Can someone please tell me why this doesn't work? <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style> #maindiv { position...
  13. snakehips2000

    Delete the active CommandBar Button

    I need a way to allow a user to click on a commandbar button (listing a series of 'favourite' forms) and for Access VBA to delete that button programmatically. I quickly realised that the problem was probably due me trying to delete the button from the function contained within the "OnAction"...
  14. snakehips2000

    CDO for Windows 2000 No Longer Working

    I have a basic online email submission form on my site which has been working without problem for over a year. Now, it suddenly doesn't work. In an attempt to locate the problem, I've tried including a Response.Write line in my code to ensure the form values for the To, From, Subject and...
  15. snakehips2000

    Regenerate stylesheet with all styles listed alphabetically?

    I'm a newbie to CSS and, having read the various preferences which some people have for grouping their styles, was wondering if there is a CSS editor which will automatically re-create a stylesheet containing styles in no particular order and simply re-list them alphabetically. I currently work...
  16. snakehips2000

    Dragging mouse over HTML text within DIV tag

    I've got a text highlighting ptoblem (see simple example below). When viewing the page and I try to drag my mouse (right to left or vice-versa) over some static text within a DIV tag, the text highlights either from the start of the paragraph to the mouse-point or from the mouse-point to the...
  17. snakehips2000

    XML Browser Validation Error

    I have the undermentioned snippet of XMLcode in the BODY section of my web page. When I run a browser validation check in Dreamweaver MX 2004 I get the following messages: "The xml tag is not supported (Mozilla 1.0)" and "The datafld attribute of the Span tag is not supported. (Internet...
  18. snakehips2000

    Creating a hyperlink in XML/XSL

    Could someone please give me a very example of the syntax for displaying a hyperlink in HTML for a URL value stored in an XML/XSL document. I've looked for answers on this forum without success - maybe the answer's so obvious! Thanks.
  19. snakehips2000

    Creating buttons from Symbol versus Component

    Why, when I add actionscript to a button created from a symbol, do I have to apply the code to the "On Release" event of the button to get it to work? Creating an event listener on the main timeline just ignores my code. Here's the example I'm using ... I have a button created from two graphic...
  20. snakehips2000

    Dynamic HTML from text file

    I'm dynamically populating a Flash text box from a text file. Usiong LoadVars, the data populates fine but I can't get it to format correctly using the external CSS stipulated in the text file. Here are the simple contents of my text file: content=<link href="../Main.css" rel="stylesheet"...

Part and Inventory Search

Back
Top