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

Please help me. Multiple problems/challenges

P: n/a
I need a button that will check (make true) two check boxes (fields)
For the record that has the focus (the record on the form that I am
presently looking at). The two check boxes would be like a "sold"
check box and an "add to report" check box (for print out). Also as
part of this button, I would like for it to enter a date into a field
such as a "date sold" field. That should be fairly simple and I could
probably figure out how to do it but if anybody knows I'd rather take
the shortcut. I do not design for others. This is my own project for
keeping track of inventory and contacts.

I also need a button that will clear all check boxes (make all false)
for the "add to report" for print out check box. I use a check box to
print out a report with all the items I need to look up. The problem
is two days later the list has changed. I can go in and uncheck the
boxes one by one but there has to be an easy way to make all
checkboxes in that field false so I can just start over again. I need
to leave the "Sold" check box as is for future data analysis and
reports.

I have asked about this before and received no response. Can someone
please, please help me with this?

If you would be so kind as to post as a follow up so I can find the
response that I am so hopeful to find.
Thanks a terabyte,
Larry

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In the Click event, to set check boxes chkX and chkY, and to set the current
date and time into txtDateSold, the following air code should work:

Me!chkX = True
Me!chkY = True
Me!txtDateSold = Now()

To reset the Yes/No field (the one to which I assume those check Boxes are
bound), use an Update Query. The Query Builder will "lead you by the hand"
in building it: Open the QueryBuilder, add the table of interest, and drag
and drop the Yes/No fields down into the Grid. Then, on the menu, Query |
Update, and look at the grid -- it will now have an UpdateTo: line. Specify
False or 0 for the Yes/No fields and run the Query. Once you have that Query
working to your satisfaction, you can copy the SQL into code and run it from
the Click event of a Command Button.

Larry Linson
Microsoft Access MVP

"Pax S" <la*******@hotmail.com> wrote in message
news:7n********************************@4ax.com...
I need a button that will check (make true) two check boxes (fields)
For the record that has the focus (the record on the form that I am
presently looking at). The two check boxes would be like a "sold"
check box and an "add to report" check box (for print out). Also as
part of this button, I would like for it to enter a date into a field
such as a "date sold" field. That should be fairly simple and I could
probably figure out how to do it but if anybody knows I'd rather take
the shortcut. I do not design for others. This is my own project for
keeping track of inventory and contacts.

I also need a button that will clear all check boxes (make all false)
for the "add to report" for print out check box. I use a check box to
print out a report with all the items I need to look up. The problem
is two days later the list has changed. I can go in and uncheck the
boxes one by one but there has to be an easy way to make all
checkboxes in that field false so I can just start over again. I need
to leave the "Sold" check box as is for future data analysis and
reports.

I have asked about this before and received no response. Can someone
please, please help me with this?

If you would be so kind as to post as a follow up so I can find the
response that I am so hopeful to find.
Thanks a terabyte,
Larry

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.