Replies

(Edited by HansV to make URL clickable – see Help 19)

The Longitude and Latitude come from the Address product (in our case, we use AFD Postcode, but that only works in the UK and Ireland). There is a product from AFD called ZipAddress (http://www.afd.co.uk/zipaddress.asp?sec=data%5B/url%5D) but it doesn’t look as though that returns the Longitude and Latitude of a Zip Code – but perhaps someone in the US knows of a similar product that does?

I use AFD Postcode’s Common User Interface to submit our equivalent of a ZIP Code, which in turn returns the Long and Lat. This is then saved within a Long and Lat field in my database. Then, I calculate the distance from one Postcode (Zip Code) to the other(s) by using the method described (better than I could re-describe it) here:
http://www.meridianworlddata.com/Distance-Calculation.asp%5B/url%5D

Just having a quick cast around on the Internet, perhaps you could use one of the products shown here? http://www.zipcodeworld.com/developers.htm%5B/url%5D
(I’ve never used them, but I see that the Premium version can provide them).

Hope this helps – and thanks for the tip on the geography of Florida – I’ll know the answer if it comes up in a Pub Quiz!

I use Microsoft MapPoint to do this, displaying it graphically. I only have experience of Microsoft MapPoint Europe, but it does have both Drivetime Zones and Radiuses within it – so it achieves the required results for me.
AFD Postcode in the UK offers a nearest that works on linear distances – I sometimes use that or get the Grid References for the Postcode for each of the possibilities and work out the linear distances based on that. The latter doesn’t work so well, though, because it doesn’t take into account Estuaries or Mountains – which is not so good (but MapPoint does help with this). My geography is not good enough to know if there are many mountains in Florida though – sorry!

Hope this helps a bit.

Hi Hans,

Thank you for your response. I did indeed create a blank database and re-import everything, but I neglected to mention that in the list. I had not seen the specific MSKB article you have suggested, but I had tried that through an alternative MSKB article and that didn’t do it.
Thank you for the link to the thread, I may have to change the code within the database to do that.

Thank you again for your advice.

Regards
Tony

Thanks for the link, Hans, I’ll give it a go.

I have just had a similar dilema as I needed to print the same report for a number of different sort options.

Rather than creating different reports for each instance, I created a different query (sorted according to each specific sort type), calling the same report. This was in Access 2000, so I don’t know if it works in Access 97.

It goes along the lines of:

Dim stCriteria as string
Select Case me![SortOrder]
Case “A”
stCriteria = “Qry: mailed sale date by date”
Case “B”
stCriteria = “Qry: mailed sale date by orderno”
End Select

docmd.openreport “Rpt: os mailing”, acViewPreview, stCriteria

Edited by HansV to make URLs clickable – see Help 19

Hi Luke,
I can recommend both AFD Postcode (http://www.afd.co.uk[/url%5D) and QuickAddress Rapid (http://www.qas.co.uk[/url%5D). Both companies can provide you with Access code examples, keeping development time to a minimum. Both really easy to integrate.

Hope this helps.

Tony

Thanks Drew,

I’ll give that a go!

Are the field(s)/label(s) that you cannot see in the Header or in the Detail? If there are field(s) that are not shown, does it make a difference if you change the tab order so that the one at the top is first? (or is it already?)

This happens to me lots – even when you size it correctly in normal view and save it, it returns to being small. The following have sorted it for me:
1) Go to the design view of the form.
2) Drag out the sides of the form to make them larger (in this case taller)
3) Click on the SAVE button on the tool bar.
4) Shut the form down.
5) Reopen it again – it’s normally fine then.

If that doesn’t work – see if the Auto Resize property of the form is set to Yes. If it is, try No. This last one has applied to me when I am using sub-forms in a way I’m sure I shouldn’t!

Hope that helps

Tony

I’m quite glad it’s not just me being thick … I’ve tried all sorts and cannot seem to get it to work in the way I need. Perhaps it’s not possible (

Thanks FlyerMike, I’ve never been too hot on the error trapping thing, but I understood what you suggested and it worked fine!

Link to post provided by HansV

Hi Charlotte,

I have recently experienced the same sort of problems. Checking the current Jet service pack and ensuring that everyone is using the same helped to resolve this issue for us. See my thread starting post 375761 for full details.

Hope this helps

Link to post provided by HansV

Hi Charlotte,

I have recently experienced the same sort of problems. Checking the current Jet service pack and ensuring that everyone is using the same helped to resolve this issue for us. See my thread starting post 375761 for full details.

Hope this helps

Fixed it! Splitting the database, ensuring that all were on the same Jet level and ensuring the code was compliled did the trick.
Thanks very much to HansV and Charlotte for their assistance.

Fixed it! Splitting the database, ensuring that all were on the same Jet level and ensuring the code was compliled did the trick.
Thanks very much to HansV and Charlotte for their assistance.