Autocomplete/ search

[Kingtriton92]

The company I work for has tasked me to create a fairly large data base that can be used by all company employees. I need to make it very user friendly, as most here are computer illiterate. My problem is making the database searchable. I want to make it so that if I can type in the name of a client and have it automaticaly fill in contact name, phone number, address etc. I should warn you that my VBA knowledge is not very strong. In looking at "Access for dummies" it only lists filters and querys as a way to search, these may be effective but are most deffinatly not user friendly. I am using access 2000.
Thanks in advance for any help,
Kingtriton

 

[emanuele]

try this.

try this... designed in italian but just check how it works by reading the codes..

 

[emanuele]

try this one too .. its in english.
this works are not mine but I´ve used the codes as well for my databases.. I am also one of those who just started with access, but I promise you can do a lot if you just put some effort in it and try without giving up. Besides the "gurus" here are always very helpful when you need help. Just post a reply or a new thread and I am sure that they will not let you down if you only show that you are trying hard on your how

 

[emanuele]

one last advice

one last advice... trow away the access for dummies, it does not really help at all. Get I better book, like a developer´s handbook or similar, there you can find what you need, as well as use the search function on this forum and have a look at all the old topics.
good luck.

 

[Oldsoftboss]

Hey, the suppliers Db is one of my creations (with help from this forum)
Glad others have put it to good use.
Regarding books, I bought the Access Bible but have learnt 10 times as much browsing this forum. It's a great place for info.
Dave

 

[Kingtriton92]

Thanks

I am hoping to modify some of this code to work for my application. Thank you very much for your help and sound advice.
Thanks,
Kingtriton