access+vba+courses+london - geographic locations and logisti

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+vba+courses+london - Geographic locations and logistics

access+vba+courses+london - Geographic locations and logistics

resolvedResolved · Low Priority · Version Standard

Mark has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Geographic locations and logistics

I have set up a database with records for each site visit (including address)and have a field for region to help operations staff group sites. However I am on my third revision of defining regions, and sites on borders between regions may not get placed in the best 'bundle' so started to think about another field to indicate next nearest region.

Is there an add on facility to effectively give the access database a lookup, or alternatively a purpose made logistics programme which will somehow take in data from our database, and preferably not too expensive (hundreds preferred to thousands)?

Edited on Tue 19 Dec 2006, 14:26

RE: Geographic locations and logistics

Hi Mark

I believe you are after an application to add on to your database so that it will perform an address lookup and find the next closest site. If this is what you are looking for, then you basically want a system like Argos or B&Q on their website to find the closest store to a given address. I do not personally know how much a system such as this costs, but I do know that a company called QAS specialise in this sort of program.

Thier web address is : www.qas.co.uk

Hope this helps

David

RE: Geographic locations and logistics

QAS say they support any database. My question was about what you know of what is available so solved, and thank you very much.


 

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips


Server loaded in 0.07 secs.