RE: Yes/No checkbox is no longer a checkbox

I tried changing it to Yes/No, but I still see 0's and -1's. Just another one
of those mysteries.

Thanks,


Klatuu wrote:
A make table query is the results of the output of a query. It can only
guess at what data types to use for a field. It appears, in this case, it is
makinging into an integer or long integer. You would have to change the data
type back to Yes/No (Boolean) data type.

Compact and repair will remove the bloat from a database, but it will not
affect any table structures. Avoid using the Decompile unnecessarily. It is
really only indented to use as a way to try to recove a corrupt database and
only works (sometimes) when the corruption is in a module (form, report,
standard, or class).

You Q&D for creating tables with a make table is okay, but be sure you check
the data types and for text fields, the length. A make table query assigns
the length specified in your database options as the default length, so it
may be too long or not long enough for the data you intend for later use.
Thanks Klatuu,

[quoted text clipped - 31 lines]

Thanks,

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200805/1

.

Relevant Pages

  • Re: Recordsource - display problem
    ... I've decompiled the database - No Change ... And presumably ALL the bound controls on the form have an exact matching ... and the data types are correct. ... Dim tableName As String ...
    (microsoft.public.access.formscoding)
  • Re: Embedded SQL and MS ACCESS Dates
    ... Date and Time Data Types ... Because OpenESQL can access any relational database and each database has ... of specifying dates and times in input host variables. ... To specify a date, move the date into the host variable in the form ...
    (comp.lang.cobol)
  • Re: Recordsource - display problem
    ... Or perhaps the VBA is corrupt. ... Decompile a copy of the database by entering ... and the data types are correct. ... RecordSource, Access has a guess and sets these to whatever it feels ...
    (microsoft.public.access.formscoding)
  • Re: Approximating Decimal Type consistency from DB to .NET
    ... We don't pass datatables to the ASP.Net pages that we use. ... we've been using numeric types in the database that directly ... > use SqlTypes, which map directly to SQL Server data types, without ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: trycatch getting the right line number
    ... to say the the underlying data types are different. ... One wrapper for all of the DB Types. ... frameworks maps it out to the proper database and underlying typed data ... Handling of the exception. ...
    (microsoft.public.dotnet.languages.vb)