By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,412 Members | 2,835 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,412 IT Pros & Developers. It's quick & easy.

Check Box Problem with Make Table Query

P: n/a
I'm probably doing something stupid, but I have a make table query.
One of the tables I reference has some check box fields in it. Their
Data Type is Yes/No, their field property format is Yes/No, they have
no default value, and their Display Control is Check Box. When I run
my make table query, the new fields have a Yes/No Data Type, but the
field property format comes up blank, and the Display Control comes up
as Text Box. How come all of the properties aren't coming over with
the make table query? I tried setting them manually, but when I run
it again, and the table gets deleted before it gets made again, the
properties go away. Any ideas?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Design details like that will not be transferred by a Make Table Query.
Do you really need to re-make the table every time?
It's often more convenient to use a Delete Query to remove all data from
your table, then an Append Query to put the new data in.
Note that with a MakeTable Query, you lose all your indexing as well -
including your primary key!

HTH
- Turtle

"Kathy Krizl" <kk****@co.el-dorado.ca.us> wrote in message
news:7f**************************@posting.google.c om...
I'm probably doing something stupid, but I have a make table query.
One of the tables I reference has some check box fields in it. Their
Data Type is Yes/No, their field property format is Yes/No, they have
no default value, and their Display Control is Check Box. When I run
my make table query, the new fields have a Yes/No Data Type, but the
field property format comes up blank, and the Display Control comes up
as Text Box. How come all of the properties aren't coming over with
the make table query? I tried setting them manually, but when I run
it again, and the table gets deleted before it gets made again, the
properties go away. Any ideas?

Nov 13 '05 #2

P: n/a
Delete and append is perfect. Thanks!!
"MacDermott" <ma********@nospam.com> wrote in message news:<TX***************@newsread3.news.atl.earthli nk.net>...
Design details like that will not be transferred by a Make Table Query.
Do you really need to re-make the table every time?
It's often more convenient to use a Delete Query to remove all data from
your table, then an Append Query to put the new data in.
Note that with a MakeTable Query, you lose all your indexing as well -
including your primary key!

HTH
- Turtle

"Kathy Krizl" <kk****@co.el-dorado.ca.us> wrote in message
news:7f**************************@posting.google.c om...
I'm probably doing something stupid, but I have a make table query.
One of the tables I reference has some check box fields in it. Their
Data Type is Yes/No, their field property format is Yes/No, they have
no default value, and their Display Control is Check Box. When I run
my make table query, the new fields have a Yes/No Data Type, but the
field property format comes up blank, and the Display Control comes up
as Text Box. How come all of the properties aren't coming over with
the make table query? I tried setting them manually, but when I run
it again, and the table gets deleted before it gets made again, the
properties go away. Any ideas?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.