Recent content by isladogs

  1. isladogs

    Getting UK postcode using address

    Hi Vlad Code looks good but I get an error with the line Dim MyDict as Dictionary I've tried various workarounds such as Dim MyDict ... Set MyDict=CreateObject("Scripting.Dictionary") but then get error 424 on the GetElementbyID line Late here and about to sign off so no time to investigate...
  2. isladogs

    Solved The Integer Overflow Issue

    Access will always assume the most appropriate number datatype based on the values supplied. This is (usually) sensible as it ensures the smallest possible number of bytes are used. So 32767 is treated as integer and 1 as byte. Summing those will be treated as integer resulting in an overflow...
  3. isladogs

    Solved The Integer Overflow Issue

    Agree with previous responses. What you describe isn't bizarre behaviour at all. This does not create an error as the conversion is done before the sum nLong = CLng(32767) + 1
  4. isladogs

    Getting UK postcode using address

    @Gasman Thanks for the link in post #3. That seems to be a new service as it wasn't available when I was working on this a couple of years ago. I see that it provides up to 50 free searches a day and seems to work well, For small scale use, it would be a Good choice Whilst it wouldn't be easy...
  5. isladogs

    I'm new (and still shiny)

    Hi Joe Belated welcome to AWF. You now have another website hit as I've just had a look at your site. I will send you a comment about some of the items in the next day or so. If you intend to be an AWF regular, you could add a link to your website in your signature line...as I do below
  6. isladogs

    Getting UK postcode using address

    Hi I know where Belarus is...but still can't pronounce your username😀 My evaluation version contains the full feature set. The free version does not. As it took me several months to develop the code for the full version, do forgive me for being unwilling to provide the code you want for free...
  7. isladogs

    Getting UK postcode using address

    Hi and welcome to AWF. I've absolutely no idea how to pronounce your user name. Where are you from? For info I moved your thread from Sample databases which is a moderated area and not intended for questions. The UK postcodes and address databases are available under licence from the Royal...
  8. isladogs

    Solved The Integer Overflow Issue

    For info I've now deleted the other duplicate thread.
  9. isladogs

    Continous form, beeping sound while mouse scrolling

    The latest technology isn't necessarily the best. 😉 Anyway, I tested it in Access 365. No beep. As I'm unable to replicate your problem, I can only suggest you try the following in turn in case these help: 1. Disable Feedback with sound setting in Access options client settings 2. Change your...
  10. isladogs

    The Slightly Obscure Music Discussion And Quizzy Thread

    Problem with attachment in post #459
  11. isladogs

    Solved Hobby Horse?

    Ah... But I can reverse your edits...😉 Anyway, see this thread from 2008. https://www.access-programmers.co.uk/forums/threads/any-hobbys-or-interest-other-than-access.141574/ The final page includes one of our most loved members redefining what a room-mate and indeed a football means. 😏
  12. isladogs

    Date format filter

    For info, I've moved this thread to the Excel forum
  13. isladogs

    Move from M.acc 2010 to 2007

    You will certainly lose features like that, but converting to MDB then back to ACCDB in 2007 has always worked for me. Another thing you need to be aware of are APIs. If you are running 64-bit A2010 these will need modifying as A2007 is only available in 32-bit
  14. isladogs

    Move from M.acc 2010 to 2007

    Unless you use A2010 specific features, your application may well work in A2007. Certainly worth trying. If you have version specific references, those may need fixing. If that fails, another approach would be to save as MDB IN 2010, then open in 2007 and resave as ACCDB.
  15. isladogs

    The Slightly Obscure Music Discussion And Quizzy Thread

    Hooray. Said it was easy.
Top Bottom