Search results

  1. S

    Paging using Datasets and DataAdapters

    To start each Page has a Page Reference in the QueryString in this OG so we test for LESS THAN 0: If Request.QueryString("OG") < 0 Then intPage = 1 Else intPage = Request.QueryString("OG") End If We will later test for Page GREATER THAN PageCount Then declare...
  2. S

    To Store or Not to Store, that is the Question

    I have expressions to concatenate Sizes Size cms: IIf(Not IsNull([Orig Depth]),[Orig Height] & " x " & [Orig Width] & " x " & [Orig Depth],IIf(Not IsNull([Orig Width]),[Orig Height] & " x " & [Orig Width],[Orig Height])) & " cm" This "calculated" value is utilised in so many queries so I...
  3. S

    Internet Explorer 10

    I have just been offerred IE10 via windows Update. It hang - I tried to stop it, that didn't work so forced a Process Termination then my laptop wouldn't shut-down except for removing all power sources. Fortunately I have reliable browsers such as FireFox, Safari and Chrome so I do not need IE...
  4. S

    Things not to put into Your Database

    Images, files, and binary data Your database supports BLOBs so it must be a good idea to shove your files in there right? No it isn't! Hell it isn't even very convenient to use with many DB language bindings. There are a few of problems with storing files in your database: read/write to...
  5. S

    Ads - HighBeam

    It rather annoys me that ads for High Beam appear, this site syndicated copyrighted material without the permission of the owner of the copyright for pecuniary gain i.e. you have to pay to subscribe. To me, this type of operation breaches copyright. Simon
  6. S

    Don't use Datasheets

    Try Continuous Forms instead. They allow Alternative Row Colours and are more flexible to format that the straight-laced grid. The conventional rent and subform scenario can be resolved by creating a query bottom up and the Parent information in the Header/Footer and the subform data in the...
  7. S

    Rudy Bitmaps

    Gripe! Went is Microsoft going to ditch those those awful bitmaps. I have managed to place images on the Buttons within my Menu system. Then I thought I try a Form with Tabs and very lo and behold they don't support anything but bitmaps and then to add insult to injury, on the tabs it grays...
  8. S

    html5 Width / Height as a Percentage

    I noticed that it you use width="100%" or height="100%", or any percentage, this will no longer validate. html5 should support html4 but in this case it doesn't. Instead you have to use css to declare, in this case, the width as 100% and then on the whatever html or script page width="0" I...
  9. S

    Firefox Browser Speed

    I found this link after installing Firefox 8, it was incredibly slow. I already had the pipelining on but the value is 34 Much better http://www.techradar.com/news/software/applications/8-hacks-to-make-firefox-ridiculously-fast-468317 Simon
  10. S

    Alternative to ADODB Recordset

    Is there a better solution to ADODB Recordset. I've had my fill DataAdapters and Datagrids I just want the records and I'm perfectly capable of doing the rest from there but using Recordcounts Absolutepositions Paging and Divs. Simon
  11. S

    IE / Firefox Back

    I noticed that in firefox if you hit the Back Arrow a message appears: To display this page, Firefox must send information that will repeat any action. In both FireFox and IE nought happens and you have to use the Forum Tab to return to the Home Page. Simon
  12. S

    The Ashes

    You can't predict the tenacity of the Aussies particularly when they are one down in the series. It always seems simplitic to put the Third Test down to a poor performance of the England. Lets give credit to a fine performance to the Aussies. Simon
  13. S

    DateAdd

    I was wondering how to do DateAdd in Vba, here my unsuccessful attempt: Function DayofWeekLookup() Dim MyControl As Control Set MyControl = Screen.ActiveControl With CodeContextObject Dim IntervalType As String Dim StartDate As Date IntervalType = "d"...
  14. S

    Ie9 Beta 32bit Problems

    I just tried installing ie9 beta on Windows Vista 32bit and it would not load a single page, one would describe as a bit of a show-stopper. There seems to be an issue with Explorer Add-ons. Ironically, I had to use Firefox to try and fix the problem. Lets hope there will be a betta version...
  15. S

    Hosting with Access Databases

    I am quite impressed with Easyspace and hosting a Access based web site using ASP.Net. Good price, great response from the site. http://www.trevorsutton.com/ The only thing you have to work out are the file locations and connection strings. I have a little asp file to collect that...
  16. S

    XML Position using Param

    I'm trying to look at Items using Asp.Net and XML. The idea is goto a selected record and allow Prev and Next Buttons. The Asp page calls: ... Originals.aspx?Param1=10 I can get XML to accept: <xsl:if test="position()=10"> But not: <xsl:if test="position()=$Param1"> Its the...
  17. S

    Outputting XML into Html

    Whilst I managed to create html output from a XML file all I'm left with underneath is java. The problem I have is that if a Search Engine is going to thoroughly evaulate the worth of a page, whilst there is visible content, the underlying content is valueless. What I want to do is collect the...
  18. S

    Access 2007 Horizontal / Vertical spacing

    Does this still exist, its about the only thing I can't find! Simon
  19. S

    A little puzzle?

    In the UK under certain circumstances you can use the Retail Margin VAT Scheme. There are several ways to apply this scheme, the first, the VAT is calculated on your Gross Profit and you apply this rate as your effective rate of VAT. The second, and the one I use, is per transaction, the...
  20. S

    Mail Server

    We have currently installed a SonicWall Email Security Device. This is a really excellent solution. The handling of spam, phishing and Directory Harvest Attacks has been impressive. 85% of emails are rejected some 190,000 email. On an annual basis we estimate that 600,000 emails will be...
Top Bottom