Solved Autocorrect or auto complete List

[ahmedrashed3210]

Hello Everyone
I have short airports-codes
I want it autocorrect or auto complete if i write it in the filed
Example :
When I write (R) Dxb-Par-Cai > auto complete to > : Round trip Dubai-Paris-Cairo


I have one method as photos but should be added one by one , is any idea or better solution ?

 

[mike60smart]

Where would plan to use this feature ?

 

[Pat Hartman]

The conversion is not magic. You have to create a table that converts the airport codes to a city name. Then use dLookup() to do the conversion. Include (R) in the list as Round trip and (O) as one way (if that is the code you are using).

Use InStr() to find the space character and then use split() to split the rese using - as the delimiter.

 

[arnelgp]

you can use Combobox?
see this demo and type "(R" (without the quote) on the combobox.

 

[ahmedrashed3210]

you can use Combobox?
see this demo and type "(R" (without the quote) on the combobox.

how i add the full list and make it as my vedio

 

[Saphirah]

I would assume you need someting like this? Take a look at the vba code in the form.

 

[Pat Hartman]

arnel has the right idea but by putting the entire string in one combo, you will have way too many entries to manage? You will have the two city variations and the three city variations like Cairo, Athens, Dubai and Cairo, Dubai, Athens and Athens, Cairo, Dubai, and on and on and then there are the four city trips. AND all the return variations as well. My suggestion is to just make a table of the airport codes and their cities. That means you to THREE lookups to convert the string.

OR just use three combos or four and pick an airport code from each and print it out with the city names.

It is not clear where you need to use this so I just built a form to show the concept

 

[ahmedrashed3210]

arnel has the right idea but by putting the entire string in one combo, you will have way too many entries to manage? You will have the two city variations and the three city variations like Cairo, Athens, Dubai and Cairo, Dubai, Athens and Athens, Cairo, Dubai, and on and on and then there are the four city trips. AND all the return variations as well. My suggestion is to just make a table of the airport codes and their cities. That means you to THREE lookups to convert the string.

OR just use three combos or four and pick an airport code from each and print it out with the city names.

thank you so much for your help

It is not clear where you need to use this so I just built a form to show the concept

 

[ahmedrashed3210]

I would assume you need someting like this? Take a look at the vba code in the form.

thank you so much for your help

 

[Pat Hartman]

Items picked from combos are not editible because you may see the text string but it is the ID field that is bound.

I can't tell what you are trying to do by the picture. Looks like you are trying to make text strings and I'm not sure why. Why would you not jus use Dated On as the caption for the data field that holds the date?

 

[ahmedrashed3210]

Editable need because I want to use this for invoice description

 

[mike60smart]

Why do you have a Form with x amount of Blank Records?

The Form looks like you have Repeating Groups ie Name 1 to Name 18, T No 1 to T No 18 etc...

Would you be able to upload your database?

 

[ahmedrashed3210]

Why do you have a Form with x amount of Blank Records?

Because this is data entry form, some invoices(record) have only one or 2 tickets
and some invoices(record) as a group that contains 15 tickets in the same invoice(record)

I am a beginner in ms accsess and i want to upgrade this database

if you have any idea to upgrade it will be great and many thanks

this my other post

https://www.access-programmers.co.uk/forums/threads/any-idea-to-upgrade-this-form.320270/

The Form looks like you have Repeating Groups ie Name 1 to Name 18, T No 1 to T No 18 etc...

Would you be able to upload your database?

sure in attachment

 

[mike60smart]

Unable to open the attachment.
Did you have the database Open when you zipped it?
You need to close the database and then zip it.

 

[ahmedrashed3210]

Unable to open the attachment.
Did you have the database Open when you zipped it?
You need to close the database and then zip it.

please check

 

[ahmedrashed3210]

Other version but without any records data

 

[mike60smart]

Well it certainly needs a lot of work to sort out.

You have 1 table "TKT" which contains fields that need to be normalised.

Can you explain the business process for us?

 

[mike60smart]

Other version but without any records data

What do the field names "N/F" & "S/F" represent?

 

[ahmedrashed3210]

 

[mike60smart]

I believe the attached screenshot shows a more normalised View of your Data.