Numbers won't display in my address labels

[Jen_ConfusedAboutAccess]

Every time I create labels from my Query it omits all numbers (street
numbers; apartment numbers and zip codes). The street numbers are in the same
field as the street but it just omits the numbers. Some apartment numbers
have a letter as well and it only displays the letter not the number. The
zip code is in a field all by itself and it doesn't display anthing. Can
anybody explain what I'm doing wrong and how to fix it?

Thanks so much for your help!

 

[KARL DEWEY]

Post the SQL of your query. Open the query in design view, click on menu
VIEW - SQL View, highlight all, copy, and paste in a post.

 

[John Spencer]

ANSWERED in you other post.
OW. One from the archives. This was a problem on earlier versions of Access.
The fix was


The only solution we have seen so far to this problem was found and
published by "Guylaine" back in January 2003. It is quoted as follows:


The fix is quite simple but still strange ...


For some reason the registry key 1025 is set to ON (concerning arabic
language) and the arabic language is not taken care of ...


You either turn it OFF :
Key : HKEY_USERS\<<user
identity>>\Software\Microsoft\Office\9.0\Common\LanguageRessources\1025
(As to be done for every user on the machine)


or install the arabic language (good for everyone):
Control Panel
Regional settings
General tab
Check the arabic language
Accept and reboot


I found it on Microsoft French site KB469516:
http://support.microsoft.com/default.aspx?scid=http://www.microsoft.c...
kb/france/articles/F19/5/16.asp


If you have the problem I'm sure you can read french !!


Take care


Guylaine


END OF QUOTED MATERIAL

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Jen_ConfusedAboutAccess]

Thanks for telling me how to do the SQL...here it is:

SELECT [Eric Roger's Professional Contact List].Prefix, [Eric Roger's
Professional Contact List].[First Name], [Eric Roger's Professional Contact
List].[Last Name], [Eric Roger's Professional Contact List].Address1, [Eric
Roger's Professional Contact List].Address2, [Eric Roger's Professional
Contact List].City, [Eric Roger's Professional Contact
List].[State/Province], [Eric Roger's Professional Contact List].[Zip
Code/Postal Code], [Eric Roger's Professional Contact List].RefContactType
FROM [Eric Roger's Professional Contact List]
WHERE ((([Eric Roger's Professional Contact
List].RefContactType)="Recruitment Soiree Guest"));

I have the French version of Microsoft Office 2000 and Windows XP Home
version 2002.

Any help would be greatly appreciated!

Jennifer

 

[Jen_ConfusedAboutAccess]

Thank you so much for your reply. I tried to follow the instructions but I
wasn't successful in making a change. I'm not sure if it's because of the
program versions. I have the French version of Microsoft Office 2000 and
Windows XP Home
version 2002. The regional settings is different in Windows XP Home...I went
back to the original document on the French Microsoft site but there was no
additional information posted there. I have to print these labels out
tomorrow and now I'm wondering what I'm going to do? I certainly don't have
the time to manually type them in since I have over 1000 to do!

I didn't try this version because I don't know where to do this?
You either turn it OFF :

Key : HKEY_USERS\<<user
identity>>\Software\Microsoft\Office\9.0\Common\LanguageRessources\1025
(As to be done for every user on the machine)

If you have time to help me, I would really appreciate it...I'm so frustrated!

Thanks,
Jennifer

 

[John W. Vinson]

I didn't try this version because I don't know where to do this?
You either turn it OFF :

It needs to be done in the Windows registry file. THIS IS VERY VERY DANGEROUS!
Editing the Registry is like changing a tire on a car at 100 kph on the
highway. If you do not know how to back up or edit the registry, find someone
who does to help.

If you want to risk it anyway... Close Access and all other Office
applictions. Select Start... Run on the start button; type Regedit in the run
window. Select File... Export and export the registry to a file, and note
where you saved it; this is a backup which might save your computer from utter
destruction.

Navigate down through the (enormous) registry tree; open HKEY_USERS, and then
dig down following the path. You'll need to do so several times, once for each
user defined to Windows. Under the user identity (a cryptic text string)
there'll be a subfolder Software, under that a subfolder microsoft and so on.