Prev: Order By/Filter clause corrupted with aliases
Next: How to run event on other options
From: Dirk Goldgar on 14 May 2010 16:16
"bicyclops" <bicyclops(a)discussions.microsoft.com> wrote in message
news:31C7B5A4-8D4B-4D01-A87E-6BD8002018BA(a)microsoft.com...
> Samples:
> PartPrefixID Part Type (Prefix) Prefix Description
> 1 001 CAD
> 2 400 Assembly
> 3 500 High-Level Assembly
> 4 998 Unknown
> 5 011 IC, Through Hole, Programmed
> 6 260 Stencil
> 7 350 Misc. Assembly
> 8 410 Flash Card Kit
> 9 411 EPROM Kit
> 10 999 Generics
>
> The data types are Autonumber, Text & Text


No obvious explanation is jumping out at me. If you'd like to send me a
cut-down copy of your database, containing only the elements necessary to
demonstrate the problem, compacted and then zipped to less than 1MB in size
(preferably much smaller) -- I'll have a look at it, time permitting. You
can send it to the address derived by removing NO SPAM and ".invalid" from
the reply address of this message. If that address isn't visible to you,
you can get my address from my web site, which is listed in my sig. Do
*not* post my real address in the newsgroup -- I don't want to be buried in
spam and viruses.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: KARL DEWEY on 14 May 2010 18:56
>>These are formatted as text with an input mask of 000.
Where is the mask applied?

If you insert a value in the bound table field does the combo show the
correct corresponding information? Such as 8 then it show 410 Flash Card
Kit?


--
Build a little, test a little.


"bicyclops" wrote:

> Samples:
> PartPrefixID Part Type (Prefix) Prefix Description
> 1 001 CAD
> 2 400 Assembly
> 3 500 High-Level Assembly
> 4 998 Unknown
> 5 011 IC, Through Hole, Programmed
> 6 260 Stencil
> 7 350 Misc. Assembly
> 8 410 Flash Card Kit
> 9 411 EPROM Kit
> 10 999 Generics
>
> The data types are Autonumber, Text & Text
>
>
> "Dirk Goldgar" wrote:
>
> > "bicyclops" <bicyclops(a)discussions.microsoft.com> wrote in message
> > news:BDA8C7D8-0119-49C1-9B8B-37FF19764BF3(a)microsoft.com...
> > > Dirk - answers below.
> > >
> > > Row Source:
> > > SELECT TblPartPrefix.PartPrefixID, TblPartPrefix.PartPrefix,
> > > TblPartPrefix.[Prefix Description] FROM TblPartPrefix ORDER BY
> > > TblPartPrefix.PartPrefix;
> > >
> > > Bound Column:1
> > > Control Source: PartPrefixID
> > > Default Value: blank
> > > Column Count: 3
> > > column Widths: 0";0.5";2"
> > > Format: blank
> > >
> > > Thanks for looking into it!
> >
> > Could you give me a few sample rows from TblPartPrefix? There aren't any
> > rows with the same PartPrefixID, are there? What type of data are
> > PartPrefixID and [Prefix Description]?
> >
> > --
> > Dirk Goldgar, MS Access MVP
> > Access tips: www.datagnostics.com/tips.html
> >
> > (please reply to the newsgroup)
> >
From: bicyclops on 17 May 2010 16:38
Karl/Dirk - My bad. I just double-checked, and I did have a default value in
the table after all. I had been checking the wrong table. You pointed me in
the right direction though. It works as expected after I removed the default
value.

Thanks again for looking into it.

"KARL DEWEY" wrote:

> >>These are formatted as text with an input mask of 000.
> Where is the mask applied?
>
> If you insert a value in the bound table field does the combo show the
> correct corresponding information? Such as 8 then it show 410 Flash Card
> Kit?
>
>
> --
> Build a little, test a little.
>
>
> "bicyclops" wrote:
>
> > Samples:
> > PartPrefixID Part Type (Prefix) Prefix Description
> > 1 001 CAD
> > 2 400 Assembly
> > 3 500 High-Level Assembly
> > 4 998 Unknown
> > 5 011 IC, Through Hole, Programmed
> > 6 260 Stencil
> > 7 350 Misc. Assembly
> > 8 410 Flash Card Kit
> > 9 411 EPROM Kit
> > 10 999 Generics
> >
> > The data types are Autonumber, Text & Text
> >
> >
> > "Dirk Goldgar" wrote:
> >
> > > "bicyclops" <bicyclops(a)discussions.microsoft.com> wrote in message
> > > news:BDA8C7D8-0119-49C1-9B8B-37FF19764BF3(a)microsoft.com...
> > > > Dirk - answers below.
> > > >
> > > > Row Source:
> > > > SELECT TblPartPrefix.PartPrefixID, TblPartPrefix.PartPrefix,
> > > > TblPartPrefix.[Prefix Description] FROM TblPartPrefix ORDER BY
> > > > TblPartPrefix.PartPrefix;
> > > >
> > > > Bound Column:1
> > > > Control Source: PartPrefixID
> > > > Default Value: blank
> > > > Column Count: 3
> > > > column Widths: 0";0.5";2"
> > > > Format: blank
> > > >
> > > > Thanks for looking into it!
> > >
> > > Could you give me a few sample rows from TblPartPrefix? There aren't any
> > > rows with the same PartPrefixID, are there? What type of data are
> > > PartPrefixID and [Prefix Description]?
> > >
> > > --
> > > Dirk Goldgar, MS Access MVP
> > > Access tips: www.datagnostics.com/tips.html
> > >
> > > (please reply to the newsgroup)
> > >
First  |  Prev  | 
Pages: 1 2
Prev: Order By/Filter clause corrupted with aliases
Next: How to run event on other options