Solved

Change  to CheckBox Option

Posted on 2013-01-15
7
333 Views
Last Modified: 2013-01-15
Hello All,

Can you help me Change the “ShipName” field in the form to a checkbox instead?

Like a checkbox with “Jones” – when user click on it, it filters the subform by Jones?
Is that at all possible within the access limitations?

Sorry have something that due in few hours from now...
finalTestPleaseRev101.accdb
0
Comment
Question by:Rayne
  • 3
  • 3
7 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
that is possible, but you will have a lot of checkboxes..


do you still want it?
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
Comment Utility
By the way, there are no "Jones" records in the data in this file...

but look at the code in the checkbox's click event and change the text if needed:

Private Sub chkJones_Click()
    If Me.chkJones = True Then
         Me.frmSource.Form.Filter = "[Ship Name] Like '*Jones*'"
         Me.frmSource.Form.FilterOn = True
    Else
        Me.frmSource.Form.FilterOn = False
        Me.frmSource.Form.Filter = ""
    End If
End Sub

Open in new window

0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Closing Comment

by:Rayne
Comment Utility
Awesome, that works like a Charm :)
Thank you
0
 

Author Comment

by:Rayne
Comment Utility
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
Thats a great article!   If you have done so yet vote yes at the bottom of the article and post a reader comment.
0
 

Author Comment

by:Rayne
Comment Utility
thanks  mbizup, done :)
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now