A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

automatically fill in complete name



 
 
Thread Tools Display Modes
  #1  
Old September 6th, 2006, 12:53 AM posted to microsoft.public.access.gettingstarted
ldvogt
external usenet poster
 
Posts: 1
Default automatically fill in complete name

I want to have Access auto fill in the complete city name when I begin to
type in the first few letters of the name
  #2  
Old September 6th, 2006, 01:02 AM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default automatically fill in complete name

Where do you propose Access would obtain that information?

Are you planning on limiting the cities to a certain geographic region, or
are you looking for a list of every city in the world?

How will you resolve duplicate city names? I believe "Aberdeen" and
"Paris" show up in more than one area of the world...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"ldvogt" wrote in message
...
I want to have Access auto fill in the complete city name when I begin to
type in the first few letters of the name



  #3  
Old September 6th, 2006, 01:59 PM posted to microsoft.public.access.gettingstarted
Klatuu
external usenet poster
 
Posts: 7,074
Default automatically fill in complete name

Are you saying there is a Paris other than Paris, Texas?

"Jeff Boyce" wrote:

Where do you propose Access would obtain that information?

Are you planning on limiting the cities to a certain geographic region, or
are you looking for a list of every city in the world?

How will you resolve duplicate city names? I believe "Aberdeen" and
"Paris" show up in more than one area of the world...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"ldvogt" wrote in message
...
I want to have Access auto fill in the complete city name when I begin to
type in the first few letters of the name




  #4  
Old September 6th, 2006, 04:02 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default automatically fill in complete name

I've wondered what part of the world you frequent...g

Jeff

"Klatuu" wrote in message
...
Are you saying there is a Paris other than Paris, Texas?

"Jeff Boyce" wrote:

Where do you propose Access would obtain that information?

Are you planning on limiting the cities to a certain geographic region,
or
are you looking for a list of every city in the world?

How will you resolve duplicate city names? I believe "Aberdeen" and
"Paris" show up in more than one area of the world...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"ldvogt" wrote in message
...
I want to have Access auto fill in the complete city name when I begin
to
type in the first few letters of the name






  #5  
Old September 6th, 2006, 04:10 PM posted to microsoft.public.access.gettingstarted
Klatuu
external usenet poster
 
Posts: 7,074
Default automatically fill in complete name

Fort Worth, Texas (136 miles Sout East of Paris)

"Jeff Boyce" wrote:

I've wondered what part of the world you frequent...g

Jeff

"Klatuu" wrote in message
...
Are you saying there is a Paris other than Paris, Texas?

"Jeff Boyce" wrote:

Where do you propose Access would obtain that information?

Are you planning on limiting the cities to a certain geographic region,
or
are you looking for a list of every city in the world?

How will you resolve duplicate city names? I believe "Aberdeen" and
"Paris" show up in more than one area of the world...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"ldvogt" wrote in message
...
I want to have Access auto fill in the complete city name when I begin
to
type in the first few letters of the name






  #6  
Old September 6th, 2006, 05:03 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default automatically fill in complete name

I hail from the Pacific NorthWet (USA).

Jeff

"Klatuu" wrote in message
...
Fort Worth, Texas (136 miles Sout East of Paris)

"Jeff Boyce" wrote:

I've wondered what part of the world you frequent...g

Jeff

"Klatuu" wrote in message
...
Are you saying there is a Paris other than Paris, Texas?

"Jeff Boyce" wrote:

Where do you propose Access would obtain that information?

Are you planning on limiting the cities to a certain geographic
region,
or
are you looking for a list of every city in the world?

How will you resolve duplicate city names? I believe "Aberdeen" and
"Paris" show up in more than one area of the world...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"ldvogt" wrote in message
...
I want to have Access auto fill in the complete city name when I
begin
to
type in the first few letters of the name








  #7  
Old September 6th, 2006, 05:16 PM posted to microsoft.public.access.gettingstarted
Klatuu
external usenet poster
 
Posts: 7,074
Default automatically fill in complete name

I was born in Portland. My Dad was from Texas, My Mom from NE Portland.
Moved back to Texas at age 3 (I have a function to calculate that), did my
last year of High School at Madison in Portland. 1961-62
Moved to Portland in 92, then to Salem in 96, Back to Texas 1/2002

PacNorthwest is, by far, the most beautiful part of the country (but, it
ain't Texas)

You have to be a Texan to understand.

I also like long walks on the beach, candle light dinners, and blowing up
things with shotguns.

"Jeff Boyce" wrote:

I hail from the Pacific NorthWet (USA).

Jeff

"Klatuu" wrote in message
...
Fort Worth, Texas (136 miles Sout East of Paris)

"Jeff Boyce" wrote:

I've wondered what part of the world you frequent...g

Jeff

"Klatuu" wrote in message
...
Are you saying there is a Paris other than Paris, Texas?

"Jeff Boyce" wrote:

Where do you propose Access would obtain that information?

Are you planning on limiting the cities to a certain geographic
region,
or
are you looking for a list of every city in the world?

How will you resolve duplicate city names? I believe "Aberdeen" and
"Paris" show up in more than one area of the world...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"ldvogt" wrote in message
...
I want to have Access auto fill in the complete city name when I
begin
to
type in the first few letters of the name









  #8  
Old September 6th, 2006, 05:28 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default automatically fill in complete name

Yee haw!

Jeff

"Klatuu" wrote in message
...
I was born in Portland. My Dad was from Texas, My Mom from NE Portland.
Moved back to Texas at age 3 (I have a function to calculate that), did my
last year of High School at Madison in Portland. 1961-62
Moved to Portland in 92, then to Salem in 96, Back to Texas 1/2002

PacNorthwest is, by far, the most beautiful part of the country (but, it
ain't Texas)

You have to be a Texan to understand.

I also like long walks on the beach, candle light dinners, and blowing up
things with shotguns.

"Jeff Boyce" wrote:

I hail from the Pacific NorthWet (USA).

Jeff

"Klatuu" wrote in message
...
Fort Worth, Texas (136 miles Sout East of Paris)

"Jeff Boyce" wrote:

I've wondered what part of the world you frequent...g

Jeff

"Klatuu" wrote in message
...
Are you saying there is a Paris other than Paris, Texas?

"Jeff Boyce" wrote:

Where do you propose Access would obtain that information?

Are you planning on limiting the cities to a certain geographic
region,
or
are you looking for a list of every city in the world?

How will you resolve duplicate city names? I believe "Aberdeen"
and
"Paris" show up in more than one area of the world...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"ldvogt" wrote in message
...
I want to have Access auto fill in the complete city name when I
begin
to
type in the first few letters of the name











  #9  
Old September 6th, 2006, 06:02 PM posted to microsoft.public.access.gettingstarted
Klatuu
external usenet poster
 
Posts: 7,074
Default automatically fill in complete name

Well said.

"Jeff Boyce" wrote:

Yee haw!

Jeff

"Klatuu" wrote in message
...
I was born in Portland. My Dad was from Texas, My Mom from NE Portland.
Moved back to Texas at age 3 (I have a function to calculate that), did my
last year of High School at Madison in Portland. 1961-62
Moved to Portland in 92, then to Salem in 96, Back to Texas 1/2002

PacNorthwest is, by far, the most beautiful part of the country (but, it
ain't Texas)

You have to be a Texan to understand.

I also like long walks on the beach, candle light dinners, and blowing up
things with shotguns.

"Jeff Boyce" wrote:

I hail from the Pacific NorthWet (USA).

Jeff

"Klatuu" wrote in message
...
Fort Worth, Texas (136 miles Sout East of Paris)

"Jeff Boyce" wrote:

I've wondered what part of the world you frequent...g

Jeff

"Klatuu" wrote in message
...
Are you saying there is a Paris other than Paris, Texas?

"Jeff Boyce" wrote:

Where do you propose Access would obtain that information?

Are you planning on limiting the cities to a certain geographic
region,
or
are you looking for a list of every city in the world?

How will you resolve duplicate city names? I believe "Aberdeen"
and
"Paris" show up in more than one area of the world...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"ldvogt" wrote in message
...
I want to have Access auto fill in the complete city name when I
begin
to
type in the first few letters of the name












  #10  
Old September 6th, 2006, 06:25 PM posted to microsoft.public.access.gettingstarted
John Vinson
external usenet poster
 
Posts: 4,033
Default automatically fill in complete name

On Tue, 5 Sep 2006 16:53:02 -0700, ldvogt
wrote:

I want to have Access auto fill in the complete city name when I begin to
type in the first few letters of the name


Use a Combo Box control based on a table of cities.

John W. Vinson[MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.