Hi Gina,
Below is what I found in the event procedure:
Private Sub Uncheckbox_Click()
On Error GoTo Err_Uncheckbox_Click
Dim stDocName As String
stDocName = "Uncheckbox"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Exit_Uncheckbox_Click:
Exit Sub
Err_Uncheckbox_Click:
MsgBox Err.Description
Resume Exit_Uncheckbox_Click
End Sub
I really do not understand this terminology and would appreciate your
assistance
Thank you and have a Happy Thanksgiving
HankL
HankL,
When you moved the button, did you move the code? The code does not
move with the button. Check that the button in the Header section of
your form actually has the code. Go to Properties of the button and
look for the On_Click line and make sure it says [EVENT PROCEDURE].
Then press the elipse button [...] and see if the code is there. If
not, move your code there.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
The button was on the form itself. I went into Design View and in the
VIEW dropdown, I selected Form Header/Footer and moved the command
button into the header. Just as a point of information I have another
button on the form itself and that works just fine.
I am using continuous forms as the Default View on the Format in the
properties.
I do not believe I am using a form/subform. When I originally setup
this database, I have the table and form views. I just have the one
form view and have no integrated it with any other databases.
HankL
HankL,
Where is the button? It should be in the form header or footer. OR
is this a form/subform?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors II
http://www.regina-whipp.com/index_files/TipList.htm
Here what I did to check it;
I put some checkmarks on 3-4 records in Form view
I opened the updated query in design view
Then I opened View dropdown and selected Datasheet View
I see the column PrintME and it shows the checkboxs with 3 checks
I selected Uncheckbox button on my Form view and the checks did not
disappear.
I also opened up the table and saw the checkmarks in the PrintMe
column of the table.
It is working but in a weird way.
I am using a continuous form and I scroll down and select certain
records with a checkmark in the PrintMe.
Then I select Uncheckbox button in the first record. Nothing
happens
If I go down to the second or fifth record and select Uncheckbox
then the checkmarks go away.
It is not always consistent. I have to play around from various
records to make it work.
As an example, I selected 4 records. I clicked the Uncheckbox and
one or two checkmarks disappeared..
Then I selected Uncheckbox button from another record and the other
disappeared.
I thought it didn't matter how many were checked off, once I clicked
on the Uncheckbox button all of the checkmarks would disappear
HankL,
No worries, here's how you view it without running it...
Open your query in Design View and click the datasheet *View*
button located in the upper left hand corner under File on the Menu
Bar. If the is a True or Yes in that view then run it and see if it
turns to False. If there is only blanks in there then it has
nothing to do. Either way, post back with what you see.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
I am sorry but I do not quite understand your question of:
When you view it, without running it, do you see
any results?
I am not quite certain how I can see any results unless I attempt
to run the command button.
Please excuse my lack of knowledge.
Do you want me to do anything specific. I have attempted several
times to delete and reinstall the updated query as well as the
command button
HankL
I am not
HankL,
Well nothing wrong there. When you view it, without running it,
do you see any results?
--
Gina Whipp
"I feel I have been denied critical, need to know,
information!" - Tremors II
http://www.regina-whipp.com/index_files/TipList.htm
UPDATE Restaurant SET Restaurant.PrintME = False
WHERE (((Restaurant.PrintME)=True Or (Restaurant.PrintME)=Yes));
Access 2003
No messages
HankL
HankL,
By not working, I assume you mean your check boxes remain the
True. Please post the SQL of your query. To do so, go to
Design View of your query and select SQL from the drop down
over in the far left corner.
When you post back, also post Access version and whether or not
you get any messages along with what the messages say.
--
Gina Whipp
"I feel I have been denied critical, need to know,
information!" - Tremors II
http://www.regina-whipp.com/index_files/TipList.htm
I setup a update query with a command button. However it is
not executing.
Update query has the following information:
Field: PrintME
Table: Restaurant
Update To: False
Criteria: True
I am attempting to create a button that will undo check marks
in a checkbox named PrintME
Properties of the Visual Basic code that was setup by the
Query Wizard as shown as follows:
Private Sub Uncheckbox_Click()
On Error GoTo Err_Uncheckbox_Click
Dim stDocName As String
stDocName = "Uncheckbox"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Exit_Uncheckbox_Click:
Exit Sub
Err_Uncheckbox_Click:
MsgBox Err.Description
Resume Exit_Uncheckbox_Click
End Sub
