predictive address form entries

[antonyx]

i have an address memo field

on the form.. is there a way to display entries already present in certain address fields

eg..

the following address is in the 'pickup address' field and the 'destination address' field

23 High Street, South Kensington

so...

i put a rule on my pickupaddress memo field on my form..

if they type 23.. the rest of the above address appears and offers itself to the field as a sign of good will.. of course the user can just type over it if it happens to be a different address starting with 23..

is this hard to do?

 

[mic907]

I would love to hear about how to do this as well

 

[Luddite Lad]

Why not have a check box, that is checked if the Delivery and Pick Up address are the same? Then You could just run a simple append query to update the Delivery address to match the Pick up address, when the check box is checked.

 

[antonyx]

no.. the pickup and destination will never ever be the same

i mentioned both fields because if in the past.. if mr a got driven from 23 high street to heathrow airport...

and then 2 weeks later he goes from heathrow to 23 high street..

if im typing 23 into the destination.. it would still be beneficial if it searched the pickup field aswell, because that is still an address in the system..

can this predictive text bot be done in access.. it must be able to

 

[pbaldy]

It can be done, but a combo box would be much simpler. It will do that natively.

 

[antonyx]

yes i see...

but using a combo.. if i select the same address ten jobs in a row.. it will still store that address 10 times wont it..

which doesnt seem like an efficient way to store it..

but that is how im doing it right now.. with one job table like so

jobid
pickup
destination
blablabla

but how about if i had three tables instead like..

jobid
jobdate
jobtime

jobid
pickupid
pickupaddress

jobid
destinationid
destinationaddress

what would be really good is if they type into the field.. and a listbox updates and shows the current addresses that match that.. and then they could drag one of the addresses in the listbox into the field...

is that hard?

 

[pbaldy]

The combo wouldn't store data any differently than a textbox would. I actually work for a transportation company and have written reservation/dispatch programs for taxis and limos. The users would shoot me if I wrote something that required them to take their hand off the keyboard and use the mouse to drag an address from a listbox. They are a lot faster if they can just keep their hands on the keyboard.

In my case, I have a "streets" table. The pickup and destination fields on the form are combos that are based on that table (but of course they are bound to their respective fields). The combo filters as the user types, and as soon as they've got enough to have the desired street showing, they just hit enter or tab and they're on to the next field.

We also track the customers, so as soon as we enter their phone or customer number, their info all drops into the form.

 

[antonyx]

We also track the customers, so as soon as we enter their phone or customer number, their info all drops into the form.

the thing is customer a may have been picked up from atleast 5 addresses.. and may have been driven to atleast 5 destinations...

so are you saying that when the passenger is registered on the form.. the combos populate with the previous address from that passenger... thats the only way i can think of that working...

another problem with my system is that sometimes only the postcode will be stored.. sometimes no postcode.. it may be just a hotel name.. and so on.. so ive decided not to separate the address into

1st line.. 2nd line.. town/city.,. etc.. it is for this reason i just use a memo field..

so if i did adopt the updated combo on my job form .. will it work with a memo field.. could that get a bit silly if some addresses are really long?

 

[pbaldy]

Personally I wouldn't use a memo field; I would think you can get everything into the 255 of a text field. Having said that, it could work the same way. I use a customer table to store all that, but you could certainly find the most recent trip for the customer and prepopulate with that data. What you can do is basically limited only by your imagination. Figure out what would work best for your operation, then figure out how to do it.

My wife and I were in London recently, and got a ride from our hotel to Heathrow in a sedan with a driver. I wonder if it was your company?

 

[antonyx]

My wife and I were in London recently, and got a ride from our hotel to Heathrow in a sedan with a driver. I wonder if it was your company?

haha. i doubt it my friend.. there is one thing london has a lot of and that is taxi companies.. add that to the many thousands of un-licensed drivers..

snooping around heathrow airport..

i would have given you a brand spanking new mercedes.. never mind..

 

[pbaldy]

Well, it wasn't a taxi (no meter anyway) and I assume it was licensed. We called them from a courtesy phone in the hotel. It was a nice car too, though I can't remember the model. You're right though; London seemed to have a lot of taxis (and double decker buses). Rome had more scooters though!