The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Low Priority · Version Standard

ReplyMon 18 Dec 2006, 13:17Delegate Mark said...

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)?

For upcoming training course dates see: Pricing & availability

ReplyTue 19 Dec 2006, 09:38 Edited on Tue 19 Dec 2006, 14:26Trainer David said...

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

ReplyWed 20 Dec 2006, 19:52Delegate Mark said...

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 articles

· How To Find Good Access Database Courses In London
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Learn The Secrets Of Customising An Autonumber Primary Key In Access
· Understanding The Components Of Access
· How To Make Access 2010 Databases Compatible With Access 2007

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

I have a form in an access database which often needss searching to see if records have been previously entered. I have been using the Find function but I would like it to filter the cases so that the relevant ones can be displayed.

I know that you can..

» Forum post: Searching fields in forms

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions