RE: Yes/No checkbox is no longer a checkbox

Thanks Klatuu,

I'm aware of most of these issues. I generally use a make-table query as a
short cut to create the table structure and then change datatypes and field
names where appropriate, and use append queries afterwards. I wasn't aware of
the problem you describe with using them. Does compact/repair or decompile
undo the damage?

Anyway, I'm not posting this because it's a show-stopper. I'm just curious as
to why the field should appear as a checkbox in the original db, and a 0/-1
textbox in the product of the maketable query. Also wondering if there is any
way to get the checkbox back after the maketable query.

Are you suggesting that maketable queries are inherently shaky and that the
checkbox foolishness may be just another manifestation of that instability?

My users see only forms and reports. This just struck me as a curiosity.

Thanks,



Klatuu wrote:
0 means not checked (false) and -1 means checked (true)
First, don't use make table queries. Create the table the way you want it.
Then change your query from a make table to an append query to append to your
table.
Then before you run the append query, run a delete query against the table
to remove the old data.
Make table queries cause a lot of database bloat and really should not be
used in most cases.
As to how you view it, users shouldn't be seeing raw tables anyway. You
sould create a datasheet form and use check box controls to display the data.
I recently split my mdb for front and back end.

[quoted text clipped - 7 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: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cluster synchronize
    ... queries per unit time. ... CPU is the ONLY bottleneck. ... increase in query capacity. ... queries that perform sequential I/O or queries performing random I/O. ...
    (microsoft.public.sqlserver.clustering)
  • Re: "Query Too Complex" Errors
    ... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
    (microsoft.public.access.forms)