PostCode Lookup

[RussG]

I was wondering if anyone had any experience of integrating a product like QuickAddress (QAS) into an Access Database to aid the completion of address details.
Thanks
RussG

 

[Moniker]

Did you even investigate this? I've never heard of QuickAddress, but a quick shot to their website shows that it includes API integration, which in VBA terms, is a reference.

http://www.qas.com/address-software/address-verification-api-integration.htm

 

[RussG]

Yes I had been to the site but was wondering if anyone here had actually done it, any problems/issues, how easy it was etc.

 

[Simon_MT]

Yes, it can be done, I did this a (1994) long time ago but don't ask me how the mechanics works but basically if I remember correctly, it is a matter of mapping QAS fields with your database fields to enable the paste into Access.

Simon

 

[RussG]

Thanks Simon, guess I'll give it a shot then.
RussG

 

[Simon_MT]

If you ask QAS they will certainly help. I'm fairly certain that's where we got the advise. Its a great tool and it is well worth persevering with.

Simon

 

[GaryPanic]

if this still throws you - give me a buzz and i'll send an old b/base over this has the coding in it - you need to put a file in the system file (C per user to make this work and i think also on a network for the actual data.


g