Recent content by isladogs

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

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

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

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

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

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

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

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

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

Problem with attachment in post #459

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

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

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

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.

Hooray. Said it was easy.