16370 Yes/No field in a table-Make exclusive or default?
Sign Up |  Live StatsLive Stats    Articles 37,332| Comments 177,288| Members 19,416, Newest Kaylee| Online 485
Home Contact
 (Forgotten?): 
    Sikhism
    For best SPN experience, use Firefox Internet Browser!


                                                                   Your Banner Here!    




Click Here to Register/Sign Up Daily Hukamnama Member Blogs Downloads Website Navigation Help Fonts Tags
Sikh Philosophy Network » Sikh Philosophy Network » Current News » Information Technology » Yes/No field in a table-Make exclusive or default?

Yes/No field in a table-Make exclusive or default?

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 500 USD, Received: 115 USD (23%)
Please Donate...
     
Related Topics...
Thread Thread Starter Forum Replies Last Post
Populate field in one table with data from field in another table OfficeMiner Information Technology 4 28-Jul-2006 08:37 AM
How do I create field in table with default value current user? MikiV Information Technology 1 28-Jul-2006 08:29 AM
how do i use ' or " in a default value of a field alanstein001 Information Technology 3 28-Jul-2006 08:19 AM
How do I make the “Search Field As Formatted” the default? DHEC Information Technology 5 28-Jul-2006 08:15 AM
Enter a Default Value in a Field in a Table access user Information Technology 5 28-Jul-2006 08:01 AM


Tags
default, exclusive, field, tablemake, yes or no, yesno
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 12-Nov-2005, 22:39 PM
Karl H's Avatar Karl H
Guest
 
Posts: n/a
   
   
Yes/No field in a table-Make exclusive or default?

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
Hi,
Can you have a yes/no field in a table that will have a validation rule that
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7246-yes-no-field-table-make-exclusive.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7246
only one rowsource can have the "yes" choice selected? This would allow for
declaring that row source the default.

The validation rule would need to state, If "yes", then all other records in
the same table = no.

Is this possible? What would the expression for the validation rule be?

THank you,
Karl

*







Got anything to share on This Topic? Why not share your immediate thoughts/reaction with us! Login Now! or Sign Up Today! to share your views... Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-Nov-2005, 22:39 PM
Sprinks's Avatar Sprinks
Guest
 
Posts: n/a
   
   
RE: Yes/No field in a table-Make exclusive or default?

Karl,

Validation rules apply to the data in the current record, so it can't be
used. But you can loop through the recordset, and accomplish this in the
checkbox' AfterUpdate event:

' If field in current record is checked, set all others to false,
' essentially creating a multi-record option group.
On Error Resume Next

Dim rst As DAO.Recordset
Dim intindex As Integer

' Remember ID of current record
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7246
intindex = Me!YourPrimaryKeyID

If Me!YourCheckBox = True Then

' Create recordset clone, loop through all records
Set rst = Me.RecordsetClone
rst.MoveFirst

Do Until rst.EOF
If rst![YourPrimaryKeyID] <> intindex Then
With rst
.Edit
!YourYesNoField = False
.Update
End With
End If
rst.MoveNext
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7246
Loop

' Clean up
Set rst = Nothing

End If

Sprinks



"Karl H" wrote:

> Hi,
> Can you have a yes/no field in a table that will have a validation rule that
> only one rowsource can have the "yes" choice selected? This would allow for
> declaring that row source the default.
>
> The validation rule would need to state, If "yes", then all other records in
> the same table = no.
>
> Is this possible? What would the expression for the validation rule be?
>
> THank you,
> Karl

Reply With Quote
  #3 (permalink)  
Old 12-Nov-2005, 22:40 PM
Karl H's Avatar Karl H
Guest
 
Posts: n/a
   
   
RE: Yes/No field in a table-Make exclusive or default?

Hi Sprinks,
After connecting the checkbox to the yes/no data field in the table, that
worked great. Thank you very much! Have a good wknd!
Karl

"Sprinks" wrote:

> Karl,
>
> Validation rules apply to the data in the current record, so it can't be
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7246
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7246
> used. But you can loop through the recordset, and accomplish this in the
> checkbox' AfterUpdate event:
>
> ' If field in current record is checked, set all others to false,
> ' essentially creating a multi-record option group.
> On Error Resume Next
>
> Dim rst As DAO.Recordset
> Dim intindex As Integer
>
> ' Remember ID of current record
> intindex = Me!YourPrimaryKeyID
>
> If Me!YourCheckBox = True Then
>
> ' Create recordset clone, loop through all records
> Set rst = Me.RecordsetClone
> rst.MoveFirst
>
> Do Until rst.EOF
> If rst![YourPrimaryKeyID] <> intindex Then
> With rst
> .Edit
> !YourYesNoField = False
> .Update
> End With
> End If
> rst.MoveNext
> Loop
>
> ' Clean up
> Set rst = Nothing
>
> End If
>
> Sprinks
>
>
>
> "Karl H" wrote:
>
> > Hi,
> > Can you have a yes/no field in a table that will have a validation rule that
> > only one rowsource can have the "yes" choice selected? This would allow for
> > declaring that row source the default.
> >
> > The validation rule would need to state, If "yes", then all other records in
> > the same table = no.
> >
> > Is this possible? What would the expression for the validation rule be?
> >
> > THank you,
> > Karl

Reply With Quote
  #4 (permalink)  
Old 13-Nov-2005, 17:33 PM
Karl H's Avatar Karl H
Guest
 
Posts: n/a
   
   
RE: Yes/No field in a table-Make exclusive or default?

  Donate Today!  
Hi Sprinks,
Now I'm trying to load frmPilot so that a combo box called cboProvider will
open with the default provider. Most of this form is based on tblPilot,
rather than tblProv, but the combo box is related to tblProv.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7246
I tiied this script w/o success:

'Inserts default provider information
Private Sub Form_Load()
cboAMEName.SetFocus
' Find default provider name and put in cboAMEName
SELECT Tables.tableProvider.ProvName
WHERE defProv = True
cboAMEName.Text = ProvName
End Sub

The debugging tool says "tables" is not a defined variable. How would I
wirte the correct code?

Thank you,
Karl

"Sprinks" wrote:

> Karl,
>
> Validation rules apply to the data in the current record, so it can't be
> used. But you can loop through the recordset, and accomplish this in the
> checkbox' AfterUpdate event:
>
> ' If field in current record is checked, set all others to false,
> ' essentially creating a multi-record option group.
> On Error Resume Next
>
> Dim rst As DAO.Recordset
> Dim intindex As Integer
>
> ' Remember ID of current record
> intindex = Me!YourPrimaryKeyID
>
> If Me!YourCheckBox = True Then
>
> ' Create recordset clone, loop through all records
> Set rst = Me.RecordsetClone
> rst.MoveFirst
>
> Do Until rst.EOF
> If rst![YourPrimaryKeyID] <> intindex Then
> With rst
> .Edit
> !YourYesNoField = False
> .Update
> End With
> End If
> rst.MoveNext
> Loop
>
> ' Clean up
> Set rst = Nothing
>
> End If
>
> Sprinks
>
>
>
> "Karl H" wrote:
>
> > Hi,
> > Can you have a yes/no field in a table that will have a validation rule that
> > only one rowsource can have the "yes" choice selected? This would allow for
> > declaring that row source the default.
> >
> > The validation rule would need to state, If "yes", then all other records in
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7246
> > the same table = no.
> >
> > Is this possible? What would the expression for the validation rule be?
> >
> > THank you,
> > Karl

Reply With Quote
   Click Here to Donate Now!

Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools Search
Search:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Active Discussions
Request for assistance...
Today 04:52 AM
9 Replies, 104 Views
Panjabi
By Ishna
Today 04:40 AM
16 Replies, 306 Views
Woolwich Killing: The...
Today 03:50 AM
2 Replies, 55 Views
Rozana Reports (ਪੰਜਾਬੀ...
Today 03:09 AM
316 Replies, 7,632 Views
Sikh Spokesman (ਪੰਜਾਬੀ...
Today 03:00 AM
179 Replies, 4,531 Views
How does Sikhi help you...
Today 00:52 AM
31 Replies, 975 Views
Transgenderism ... Right...
By Kaylee
Today 00:33 AM
25 Replies, 1,255 Views
Losing My Religion: Why...
Today 00:00 AM
14 Replies, 382 Views
Occultism - Rejection in...
Yesterday 23:57 PM
61 Replies, 2,623 Views
Kirtan
Yesterday 21:24 PM
0 Replies, 34 Views
Keeping Amrit Vela
Yesterday 16:49 PM
12 Replies, 937 Views
Do you believe in...
Yesterday 15:08 PM
196 Replies, 4,106 Views
Black Sikhs?
Yesterday 06:33 AM
20 Replies, 5,881 Views
Man Driving Without...
Yesterday 05:06 AM
5 Replies, 147 Views
Health Exercise And...
Yesterday 02:10 AM
1 Replies, 98 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.3
All times are GMT +6.5. The time now is 06:02 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright 2004-12, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.45206 seconds with 32 queries
0