Database Access 2002

[Jimmyz]

Hi There,

i have a Question about an Access Database for Adresses. I habe to
fill in a lot of PLZ and Phone Numbers.

i there a possibility to configure the form, that:

- the form looks up relevant additions, like autocomplete?


And a Disconnect always from the Server, because the database isn't
local


Thank you in advance

Jimmyz

 

[Danny Lesandrini]

Jimmyz

First, Access forms will expose autocomplete only for combo boxes, and then only
if you enable it. There is none of the cool auto-fill text boxes like you might see
on web pages such as Netflix. (unless you program it yourself from scratch)

I'm not sure what a PLZ is.

What you can do is to autocomplete based on a selection. For example, I have an
app where users add contacts for companies. The contact's address and phone
might match the company, and might be different. Users have requested that once
a company is selected, the app lookup the company's address & main phone and
plunk them into the contact's address/phone fields. The user will edit them if
they are incorrect.

Is this what you need? If not, what fields are you talking about and from where
will the options for "auto complete" come from?

 

[Jimmyz]

PLZ = Postal Codes or Post Box ok i've heard, that this is a
feature of Access 07

Thx

 

[Jimmyz]

Again hi ;-)

Thank you first for your answer...

I have a lot of Adresses, which are on Cards.So i have to fill them in
the required fields like

Lastname......Name
Street ....PLZ ( ;-) )
Phone No........Email

So what would be great is, that everytime i am giving up to write
again and again the same City Name.
Great would be if possible, that the database Field City, PLZ,
Phoneno will suggest the last entered entries.

So that ih habe not to write it again by typing


But i have no doubt if this would be possible ;-)

Thank You much for your time

 

[Danny J. Lesandrini]

Actually, it is possible, if you make your controls combo boxes instead of text boxes.
You'll probably want to set the Limit To List to False and do a requery of the list each
time a new value is added, but that would give you auto-complete.

 

[Jimmyz]

Actually, it is possible, if you make your controls combo boxes instead of text boxes.
You'll probably want to set the Limit To List to False and do a requery of the list each
time a new value is added, but that would give you auto-complete.

Dear Mr. Lesandrini,

thank you for the fast and effective answer.All works fine now.

Thank You

Jim