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 Wanet Telecoms Ltd 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. SarahMH

    Create view in SQL 2000 db from 2008 Managment Studio

    I am using query analyzer in 2000 and Management Studio in 2008. To get round the issue I have create the view in my .asp webpage but I would like to know if it is possible for future reference/ Thank you
  2. SarahMH

    Create view in SQL 2000 db from 2008 Managment Studio

    Hi I am trying to create a view in my SQL 2000 database from a table of data that is constantly being updated on a a SQL 2008 database. Is it possible? and if it is how do I reference them? I am brand new to Management Studio and SQL 2008 (training scheduled for April!) so any info would be...
  3. SarahMH

    Pivot Table View Required in (sql 2000)

    Hi My intention was to create a view but I don't think you cannot declare in a view - so I created a stored procedure which will run daily initially truncating the table then inserting the data from the base table. I am creating a webpage that will enable the user to update the value in the...
  4. SarahMH

    Pivot Table View Required in (sql 2000)

    Thank you so very much Markros!! My sql was soooooo much more complicated and didn't work. Is there any chance that the headings can dynamically be the date?
  5. SarahMH

    Pivot Table View Required in (sql 2000)

    I have to try and create a view on transact sql (2000) The view needs to show the values of the past 5 days data by metric. Example of what i require Metrics Today -4 Today -3 Today -2 Today-1 today 1 A&E Attendances Value Value Value Value Value 10 AvgLos 30 WARD Value Value Value...
  6. SarahMH

    Using opensource 'tablefilter.js' how do I order alphanumberic filters

    Hi Below is an example I have quickly whipped up - it is difficult because we are behind a firewall so I have supplied the html. The jscript is the file linked in my previous thread. The data is a test data sample. thanks Example: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0...
  7. SarahMH

    Using opensource 'tablefilter.js' how do I order alphanumberic filters

    Thank you for your suggestion, as I stated above I am a real beginner when it comes to javascript programming. The include file is used in all our applications and I would like to be able to program the file so that it orders the table drop down filter lists alphanumberically (ascending or...
  8. SarahMH

    Using opensource 'tablefilter.js' how do I order alphanumberic filters

    Hi Within my web application I have included the open source javascript file: 'tablefilter.js', which enables filtering on the table however, the drop down filter lists are not in any order making it difficult for the user. Does anyone know how I can get the filter lists to display in...
  9. SarahMH

    Capture record id from table array within hyperlink address

    Thank you so very much foxbox!!! It works perfectly.
  10. SarahMH

    Capture record id from table array within hyperlink address

    ...GetReport(chosenview) 'response.Write chosenview sViews = chosenview dim i, i2, intCounter,sArray,sText,strColor intCounter = 0 sSql = "SELECT * from dbo.[" & sViews & "]" 'response.write sSql 'response.End objRs.Open sSql, objConn, 3,3'adOpenStatic, adLockReadOnly, adCmdText strColor =...
  11. SarahMH

    Capture on save event to disable onbeforeunload event

    Thank so much feherke - I have done it by just removing the 'window.' and it works !!
  12. SarahMH

    Capture on save event to disable onbeforeunload event

    My Save function is in vbscript so doesn't recognise the { -please suggest?
  13. SarahMH

    Capture on save event to disable onbeforeunload event

    Can anyone help - on the edit screen I need to prompt the user if they try to exit without clicking the save button. The save button validates the data and if ok submits the form calling another .asp page which writes the data to a sql database. I have used the 'onbeforeunload' javascript...
  14. SarahMH

    onbeforeunload capture if save button has been clicked

    Can anyone help - on the edit screen I need to prompt the user if they try to exit without clicking the save button. The save button validates the data and if ok submits the form calling another .asp page which writes the data to a sql database. I have used the 'onbeforeunload' javascript...
  15. SarahMH

    Divide a Text Address Field in an Access Table

    Can anyone help. Within a table I have an address field which has 3 parts of an address split by a comma e.g. 132 Sunny Ave,Barns,Chester. This data needs to be split in an automated manner to enable a report which displays the address as 3 separate fields - Address1 Address2 and Address3...
  16. SarahMH

    Automatically Email an excel workbook as an attachment

    Thanks I'm still on 2000, but I didn't think there was. Thank you for your help!
  17. SarahMH

    Automatically Email an excel workbook as an attachment

    Thanks I am managing to send the email but I was wondering if there is any way of turning off the message box that pops up asking if you wish to send the automated email?
  18. SarahMH

    Automatically Email an excel workbook as an attachment

    Thanks, I did have a look but couldn't find it - obviously didn't look hard enough! I have sorted it myself though - thanks anyway
  19. SarahMH

    Automatically Email an excel workbook as an attachment

    Hi I am still a beginner and know that this is proberably really simple but does anyone have sample code that will enable me to email a specific workbook to a specific person and c.c. to four other people - but running the code in another worksheet. Many thanks in advance
  20. SarahMH

    Produce a dropdown box in excel listing access tables

    ...= "SELECT MSysObjects.Name " SqlStr = SqlStr & "FROM MSysObjects " SqlStr = SqlStr & "WHERE (((MSysObjects.Name) Like " & Quotes & "ipdcwait at *final" & Quotes & "Or (MSysObjects.Name) Like " & Quotes & "OPWAIT * final" & Quotes & ") AND ((MSysObjects.Type)=1));" Set cnt = New...

Part and Inventory Search

Back
Top