Prev: record Locking multi user
Next: Can not choose in combo
From: BenEl via AccessMonster.com on 1 Jun 2010 14:00
It's producing the same results. If the PositionID is in the table (even
attached to another CandidateID), it brings back that message box. The only
time it doesn't is if the PositionID is not yet in the table attached to ANY
CandidateID.

Any other ideas?

ruralguy wrote:
>Try:
>If IsNull(DLookup("[PositionID]", "MT_Job_Candidates", _
>"[PositionID] = " & Me.SelectJob & " AND [CandidateID] = " & Me.CandidateID))
>Then
>
><<< AIR CODE >>>
>
>>It is working - sorta! It looks up the PositionID and returns the message box.
>>It looks up the CandidateID and returns the message box. BUT... it is looking
>[quoted text clipped - 22 lines]
>>>>>
>>>>>Thanks for any help!
>

--
Message posted via http://www.accessmonster.com

From: ruralguy via AccessMonster.com on 1 Jun 2010 14:16
It should *only* return a PositionID when BOTH the PositionID AND the
CandidateID for that record match. You may have overlooked something in the
implementation.

BenEl wrote:
>It's producing the same results. If the PositionID is in the table (even
>attached to another CandidateID), it brings back that message box. The only
>time it doesn't is if the PositionID is not yet in the table attached to ANY
>CandidateID.
>
>Any other ideas?
>
>>Try:
>>If IsNull(DLookup("[PositionID]", "MT_Job_Candidates", _
>[quoted text clipped - 8 lines]
>>>>>>
>>>>>>Thanks for any help!

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

From: BenEl via AccessMonster.com on 2 Jun 2010 08:44
What could I have overlooked? I spent a long time trying to figure that out
and can't seem to see anything. Any clue?

ruralguy wrote:
>It should *only* return a PositionID when BOTH the PositionID AND the
>CandidateID for that record match. You may have overlooked something in the
>implementation.
>
>>It's producing the same results. If the PositionID is in the table (even
>>attached to another CandidateID), it brings back that message box. The only
>[quoted text clipped - 8 lines]
>>>>>>>
>>>>>>>Thanks for any help!
>

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201006/1

From: ruralguy via AccessMonster.com on 2 Jun 2010 10:28
Copy and paste *exactly* what you have into a post here.

BenEl wrote:
>What could I have overlooked? I spent a long time trying to figure that out
>and can't seem to see anything. Any clue?
>
>>It should *only* return a PositionID when BOTH the PositionID AND the
>>CandidateID for that record match. You may have overlooked something in the
>[quoted text clipped - 5 lines]
>>>>>>>>
>>>>>>>>Thanks for any help!

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201006/1

From: BenEl via AccessMonster.com on 2 Jun 2010 14:57
Private Sub Confirm_Click()

If IsNull(DLookup("[PositionID]", "MT_Job_Candidates", "[PositionID] = " & Me.
SelectJob & " AND [CandidateID] = " & Me.CandidateID)) Then
MsgBox "This position is already attached to this candidate. Please choose
another position.", vbOKOnly

End Sub

ruralguy wrote:
>Copy and paste *exactly* what you have into a post here.
>
>>What could I have overlooked? I spent a long time trying to figure that out
>>and can't seem to see anything. Any clue?
>[quoted text clipped - 4 lines]
>>>>>>>>>
>>>>>>>>>Thanks for any help!
>

--
Message posted via http://www.accessmonster.com

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: record Locking multi user
Next: Can not choose in combo