ACCESS FEED: RE: [MS_AccessPros] Re: Field Input as Text storing as Number in Table

Rabu, 06 Februari 2013

RE: [MS_AccessPros] Re: Field Input as Text storing as Number in Table

Bill-

You need one of these.

http://www.amazon.com/Mr-Bill-Plush-Toy-10/dp/B002P9KOWI

It screams "Oh Nooooo" when you squeeze it.

John

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Wednesday, February 06, 2013 4:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Field Input as Text storing as Number in Table

Jeff -

When I was a restaurant manager a lot of the staff called me "Mr. Bill". I
had to constantly be on the look-out for Mr. Hand.

Bill

--- In MS_Access_Professionals@yahoogroups.com, Jeff Jones wrote:
>
> And besides, it can make Bill feel a lot older than he really is.
> 'Course, "Mr. Bill" might make him feel more flexible, but probably
> not needed either. LOL
>
> ----- Original Message -----
>
>
>
>
>
> Celeste
>
> Please call me "Bill". We aren't formal around here.
>
> Thanks for letting us know you solved the problem. But that still doesn't
explain why the listbox had text when the table had a number. What is the
ControlSource for the listbox?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com , "celesteccp" wrote:
> >
> > Thank you Mr. Mosca.
> >
> > It was an error in the table. The fields were saved as a number when
they were uploaded. I fixed the issue in Excel and then uploaded again.
Thank you for your help.
> >
> > Celeste
> >
> > --- In MS_Access_Professionals@yahoogroups.com , "Bill Mosca" wrote:
> > >
> > > Celeste
> > >
> > > The listbox probably has 2 columns with the number in the first column
and that column having a width of 0. That hides it.
> > >
> > > Find out whatever table the listbox uses as a RowSource. Open the form
in design view and open the properties box. Select the listbox and look at
its RowSource. That will tell you what table or query it is using.
> > >
> > > To show the text in a query just join that table or query to your
other table on the number field. Then drag the name field down to the grid
to display it instead of the number.
> > >
> > >
> > > Regards,
> > > Bill Mosca, Founder - MS_Access_Professionals
> > > http://www.thatlldoit.com Microsoft Office Access MVP
> > > https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-
> > > 64270730881E My nothing-to-do-with-Access blog
> > > http://wrmosca.wordpress.com
> > >
> > >
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com , "celesteccp" wrote:
> > > >
> > > > Hello:
> > > > In a form the user selects a name from a listbox in a field called
"Reviewer". In the form it appears as a text name.
> > > > When I look at the actual table where it is writing to, the name is
stored as a number.
> > > > I selected the table and those fields are "TEXT".
> > > > How do I make them appear as text when I do a query? They are
appearing as a number?
> > > >
> > > > What do I need to fix? (Confused)
> > > >
> > > > Thank you for your help.
> > > >
> > > > Celeste
> > > >
> > >
> >
>
>
>
>
> --
>
>
> Jeffrey Park Jones
> Excel, Access, Word, Office Expert
> Excel and Access, LLCÂ®
> http://ExcelAndAccess.Com
>
> 919-671-9870
> 5109 Deer Lake Trail
> Wake Forest, NC 27587
> jpjones23@...
>
>
>
>
> [Non-text portions of this message have been removed]
>

------------------------------------

Yahoo! Groups Links