Re: Combo box returns numeric values

From: semaver (o1topcular_at_e-kolay.net)
Date: 11/30/04


Date: Tue, 30 Nov 2004 02:16:54 +0200

don't change baund column
just change (set) the first column lenght 0 (zero)
that you can see the value(i think text) which you want
and query from your baund column(number)

"Joe" <Joe@discussions.microsoft.com>, haber iletisinde şunları
yazdı:AF3F058E-8EE6-4B67-B16F-32876120C7EB@microsoft.com...
> I have a combo box that returns values back to my main table. However,
the
> way that I have the combo box setup, it returns the text values back as
> numeric values because of the way they are sorted in the query that the
combo
> box values are collected from and because of the primary values the table
has
> autonumbered.
>
> So now I want to run a query for the data that I've collected and I cannot
> because when I set the criteria to a text value and try to retrieve those
> values it shows nothing because all the data has been entered into the
table
> as numeric values. For example Wardrobe is seen as a 3. So I can search
for
> a 3 and get all the Wardrobe values, but if I put in Wardrobe it will show
> nothing.
>
> Please help.
>
> Thanks,
> Joe



Relevant Pages

  • RE: Data/Values change when Query Analyzed in Excel
    ... Jerry Whittle, Microsoft Access MVP ... I have a quantity in a reocrd of zero, when I analyze the data with Excel, it ... Please post the SQL statement for the query. ...
    (microsoft.public.access.queries)
  • Re: Filled dataset decimal value not same as fetched value?
    ... > I filled my dataset with the query above. ... I created a new DataRow ... > decimal places get an extra zero padded to them. ... >> I believe rounding and truncating are totally different things. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Issue with order placement...
    ... David's suggestion to use Me.Dirty = False is a good one. ... variable again to re-execute the same query, but I can also tell you this -- ... executing the identical update query to set a field to zero twice in a row ... There is good reason to set ...
    (comp.databases.ms-access)
  • Re: Nested Queries
    ... One suggestion is to use an immediate if in your query to return NULL if the ... GROUP By FieldA ... test the field to see if it is not Zero and sum the results of the ... > I had a reference article on nested queries that I believe handled this type ...
    (microsoft.public.access.queries)
  • Re: Lost tab fields
    ... If you create a query that returns records and which allows new record ... past record 3 to the NEW record position it will indicate that you are now ... zero of zero? ... form where you can still enter a new record and an empty form where you ...
    (microsoft.public.access.gettingstarted)