Đang Thực Hiện

7573 access database modification

I have created a very basic Access database with 11 simple fields in a simple form where I'm storing a list of sites I'm visiting, gathering URL, email, city, province, name. FIRST THING: I have a field that I need to have Auto Completed. I'm looking for houses in provinces in my country. So, I have a field for the name of the province. I would need this province to be related to a list of the 50 provinces of my country (I'd provide you with this list). But I do not want to have a dropdown, I would like that as I type the name of the province, it would be autocompleted. I would select the best match. SECOND THING: I have a field for the name of a house. I would like to have this field auto completed as well. You know, there are hundreds of names that I'll be entering on this form, some of these names will be similar to more than 1 province. Imagine this situatio: I have 2000 names, I find a site with 200 names, I do not want to check the whole list visually to see if the new names are already in my database. So, I would need that the name of the house is autocompleted, if I start writting the name of the house and it does not appear, I know it's not in my data base. THIRD THING: same autocomplete for email and URL. The thing for these 3 fields, name, email and URL is that many times I'll be pasting into the Access's forms. Can we get an alert when this happens, so I'll know it's duplicated. I look forward to your PM. Regards

Kỹ năng: Bất kì công việc gì, Microsoft Access

Xem thêm: writting sites, country name, best writting, auto alert, microsoft access database modification, imagine form, access database, access d, country dropdown city, autocomplete select, modification form, email writting, list name gathering, email database country, forms modification, microsoft access check, dropdown city list, access database check, city list dropdown, dropdown autocomplete, country city database, data modification, related database, alert database, database country

Về Bên Thuê:
( 138 nhận xét ) San Bartolome de Geneto, Spain

Mã Dự Án: #1758442

Đã trao cho:

davebritton

I have over 10 years MS Access / VBA development experience and I can provide you with a first class solution.

$10 USD trong 1 ngày
(0 Đánh Giá)
0.0