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 ?

 

[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.

 

[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

 

[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.