How do you create a checkbox in a column?

[Guest]

I have been tasked to "refresh" an existing database, where we track proposal
activity, and I have no Access experience whatsoever. My goal is to
rearrange the information to sequentially match how we currently work on
proposals. For instance, I don't need the "Award Date Column" to be the
third column in the table. It's too early to reflect that information. It
should be near the end.

With that in mind, some colums are text and there are a few columns that
consist of checkboxes. In rearranging the columns with checkboxes, I thought
it would be as simple as doing the old copy/paste method. However, when I
paste, I have numbers instead of checkboxes.

So, since it's apparent that I can't move the checkboxes using the
copy/paste method, how do I create a column with checkboxes?

 

[Wayne Morgan]

First, the order of the columns in the table shouldn't matter as far as data
entry goes because you shouldn't be entering the data directly into the
tables. Design a form for data entry. Place the controls on the form where
you desire and set their tab order to move between them in the order
desired.

Next, a checkbox is a True/False or Yes/No field. Access stores True as -1
and False as 0.

 

[Larry Daugherty]

Hi,

I tried to reply directly to you but got returned mail. While it is
encouraged that we handle all dialogue here in the newsgroup there are times
when it may be better to communicate more directly. If you'd like, you can
remove the spam filter and reply to me directly.

Best regards,

 

[Guest]

Hi Wayne,

Thanks for responding. Instead of working within the old database, I
decided to create a new one, which I have completed. I know it will create
additional work because I'll have to re-enter the data but, since I'm new at
Access, I'd rather re-enter than mess up the existing database.
Unfortunately, my new database doesn't work in Form View when I attempt to
enter the data.

For the Combo drop down boxes, I can see the options that I entered
however, in Form View, when I attempt to select one of the options, nothing
appears in the window. Also, for the text boxes, when I view the database in
Form
View, instead of the name of the field showing up in the white area, this is
what I see #Name?. I can't type any data in the white area.

The only boxes that are working are the option group boxes. Everything else
seems to be disabled therefore, how can I fix this so I can enter information
into the database and use my drop down boxes?

Other than that, the database is really pretty!! LOL

 

[Guest]

Hi Larry,

My spam blocker, if that's the same thing, is already off so I'm not sure
why you're having problems reaching me directly.

Anyhoo, I have an update that I posted. It may be easier just to view it on
the site.

I am determined to have an awesome database.

Cheryl

 

[Wayne Morgan]

What is the Record Source for the form? Is it a query or table? If it is a
query and if you open just the query by itself, can you make entries into
the query? If you can't make the entries directly into the query, then the
form won't be able to make the entries either.

How many tables do you have? How are they linked (relationships)?


You should be able to import the data from the old data base rather than
reentering all of it unless the way it has been entered in indecipherable.

 

[Guest]

Since I'm new at this, I'm really not sure what you're asking but, somehow, I
fixed my errors and I am now able to type in the fields and, if I make a
selection with the drop down boxes, it now appears in the window. The #Name?
error message is now gone.

I don't know how to do it but, it would save a lot of time if I can export
the data from one database to the other. I didn't work with it today but,
I'll try tomorrow.

 

[Albert D. Kallal]

It is not clear if you are using datasheet view, or continues forms view.

You can get some ideas, and see some screen shots of continues forms here:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

I always used continues forms in place of datasheet view, as then you have
more control, and users can't mess with, or change the layout.

The above may not be a solution for you, but it will give you some ideas
about using listbox, or continues forms in ms-access...