Predictive Text

[mali]

Hi everyone,

Its taking me forever just to update client details on my database using forms, alot of the bank addresses for clients are repetitive, i was wondering when i start to enter a bank name, for example halifax, as soon as i type in a few letters it displays halifax with the addresses in a drop menu.

Is this possible, i only want it to predict information already existant in my database

any help would be gr8

thanks

adios

 

[emcf]

..would using combo boxes be an option for you? have the field in your main table lookup a field in a related table with the names of all the banks stored in it. On your form have a combo box that will allow you to select the revelvant bank.. these boxes do use predictive typing.

 

[Mile-O]

Slight normalisation issue here...maybe

Do you have a table listing all of the banks that can be entered? If not, make that a priority. The same goes for each detail you are repeatedly entering into your database.

Build relationships between your tables.

Then, you can link the bank field on your entry form to the bank table, and make a query at the table level to select the banks into a combobox.

Do you want an example?

 

[mali]

predictive Text

Cheers for your help guys,

an example would be gr8??

 

[mali]

thanks again guys, ive got it to pick up the bank names as soon as i enter the first letter in the form, ive just got to work on the addresses which will probably done in the same way...


thanks

 

[Mile-O]

As I said before you shouldn't have to repeatedly input the address of banks, you should store this in a specific banks table. This way you can give each bank a specific ID and by just choosing the bank you will immediately have access to all of its details.

Here's the example - it's a little limited but you should study the RowSources within it.

 

[mali]

Thanks for that, i understand it more now, cheers

 

[mali]

Predictive Texting

Hello again, ok ive got the predictive text to work, but the only thing im having a problem with is that as soon as i type the bank name in the form it automatically detects bank names beginning with that particular letter which is fine but once the bank name is complete it doesnt automatically update the address fields, how do i get the address fields to update auutomatically as soon as the bank name is completed, the address information is stored in the same table where bank names is being picked up from