Robin
When you run this SQL (i.e., the query), do you see all the (expected)
records?
Regards
Jeff Boyce
Microsoft Office/Access MVP
This is what is under SQL view. Is that what you need?
SELECT MasterList.ID, MasterList.CaseNumber, MasterList.PeopleOnCase,
MasterList.Status, MasterList.NA, MasterList.LastName,
MasterList.FirstName,
MasterList.DOB, MasterList.DAY, MasterList.Month, MasterList.Address,
MasterList.ZIP, ZIPCODE.CITY, ZIPCODE.STATE, MasterList.REF,
MasterList.Field15, MasterList.Salutation, MasterList.Phone,
MasterList.SEX,
MasterList.SSNumber, [LastName] & ", " & [FirstName] AS Fullname
FROM MasterList LEFT JOIN ZIPCODE ON MasterList.ZIP = ZIPCODE.ZIP
ORDER BY MasterList.LastName;
:
Robin
How is the form connected to the table? Is there a query that reads
the
table and "feeds" the form? If so, please post the SQL statement of
that
query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Okay, not too many city and state entries are filled out on the
table.
I
went
through on the form (in datasheet view) and added all city and
state
entries
about a week ago that were missing so I thought all of the changes
were
made
and saved to the table. I also added one of the out of state
entries
into
the
table (just now). The table accepted it but it doesn't show up in
the
Form.
Where do I have to make those changes for them to take effect
throughout.
:
Again, you described what shows "in the form in datasheet view",
not
what
is
actually stored in the table.
What's in the table on those records that aren't showing
correctly in
the
forms/labels?
Regards
Jeff Boyce
Microsoft Office/Access MVP
The city and state both show up in the form in datasheet view
and
design
view, however, when I try to print the mailing labels the city
and
state
are
not showing up in the print preview nor printing. However,
there are
a
few
records that actually show the city and state. What confuses me
about
the
whole input mask thing is it's not only one certain city that's
not
showing
up. For instance, the city "Baltimore, MD" automatically shows
up
when
adding
info to the form but it's a luck of the draw if it actually
will
show
up
to
be printed. Even if I manually enter the city and state it
doesn't
necessarily show up. Also, with the two records that have out
of
state
info,
I can enter all info about the client except for the city and
state.
When
I
try to enter the city and state for out of state, it just beeps
with
each
keystroke but nothing on the screen.
Thanks,
Robin
:
Robin
"mailing labels" and "input mask" relate to reports and forms.
It all starts with the data. What data is showing up in the
underlying
table(s)? Are the underlying records actually missing the
data for
the
records you describe, or is it an issue with what gets
displayed
via
forms
and reports?
Regards
Jeff Boyce
Microsoft Office/Access MVP
I am working with a database left from the previous admin and
for
some
reason
the city won't show up on mailing labels. I'm guessing there
was
an
imput
mask and that's why although I'm not quite sure. How do I
(or can
I)
remove
the input mask. Also, in a couple of the records, I can't
even
enter
a
city
and state. In these two particular records, the states are
Texas
and
Georgia
(I am in Maryland where the vast majority of our clients are
from).
Another
reason I'm thinking it's the input mask. Any help is greatly
appreciated.
Haven't worked with Access in about 4 years.