Make Access 2003 forget selection checkboxes upon closing a docume

[Guest]

We're using Access 2003 professionally and we have databases with checkboxes
in them, through which we export selected fields to Excel.
However, for some reason, Acess stores the names of the boxes you check and
keeps them there forever unless you uncheck them again manually. Naturally,
this is not very practical when it comes to unchecking say 1000 checkboxes.
How can I make Access to stop remembering which checkboxes were checked the
last time we opened the Access document/database?

 

[RBear3]

Not sure I understand. You have a checkbox (Male or Female, charter member,
member of management, etc.) Each record has the various checkboxes set.
Why would you not want to remember them? If you don't want to store the
item, then it should probably not be in your table.

What is the checkbox (or checkboxes) used for in your database?

 

[Guest]

It's like this:
We have a list of terms with different categories and numbers etc, but what
matters are the terms.
In front of each of the terms is a check box to either select or deselect it.
Checking this checkbox adds the term to an import queue in an Excel
document. That's the purpose of the checkboxes.

Unfortunately, the checkboxes remain checked, even after we close the active
database. Even when we say no to any dialogue that appears asking if we want
to save changes, it STILL keeps the checkboxes checked.

Basically, I need a way to either:
1. Make Access forget which checkboxes were checked during a database
session and reset it to the previous value (ie. everything unchecked)
- or -
2. Quickly deselect all the checkboxes. (Right now we have to do them one by
one, manually)

A hand in this matter would be greatly appreciated.

 

[Aaron Kempf]

uh you can make them unbound? lol

that won't work with you export to excel though
I'd reccomend learning how to write an update query

 

[Guest]

Where are the checkboxes being used, on a form or in the table.
Are you allowed to make changes to the database? If you are we might me able
to give you some pointers...

Maurice

 

[Pat Hartman \(MVP\)]

The easiest way to deselect all the checkboxes is to run an update query
that sets the checkbox to false. Use the QBE to create it and then run it
in code using the .execute method. You should find examples in help.

 

[Susie Johnson]

QBE is obsolete

if you're talknig about SQL you'd best be using SQL Server Management Studio

 

[Guest]

Ehhhh... this seems helpful, but.. I have no idea how to go about this...
What's an update query? What's the QBE? How do I run anything (in .execute
method or otherwise)?