Moving and updating data with command button

[RichMorrison]

Sara
<<
I ended up using secret option #4... let me know if this is a bad idea... but I used 2 queries on top of each other...

The first was an update query which asks the user to assign a tdNumber to the current record (in tblApplicant.) The second appended to tblEmployees. This worked well, because it also kept the TDNo in tblApplicant to be referred to later, if that person were to apply to another position.
>>

Sound great

<<
How, though, might I lock the applications and posting?
>>

How about locking the application with secret query #5 right after #4.

After you assign a TDNo to tblApplicant you could set the "winner" field or whatever field you use in tblApplication to mark the successful candidate.

Good progress this week.

RichM

 

[SaraMegan]

Okay, RichM, we're finally at the home stretch here... I just have a few more questions...

1) How do I get a message box to say "Are you sure you want to hire [applicant] for Position #[positionNo] ([PositionTitle], [Office])? (So If I applied for a Secretary I position it would say: "Are you sure you want to hire SaraMegan for Position #12345 (Secretary I, Human Resources)?" Then I could click OK to continue or Cancel to abort...

2) Cascade deleting old records... I want to delete after one year, the posting and all associated applications. I can delete the record in tblPosting and it cascade deletes the record in tblJunction, but the records which apply to that posting in tblApplication do not delete... Is there a way to do that, or should I use two separate delete queries?

I think that's it... But as for the rest of it, I've got it. (At least I've got something that does the job... )

Thanks again, RichM.

--Sara

 

[RichMorrison]

Sara,

1)
Dim intReturn As Integer
intReturn = MsgBox("Do you want to quit application ?", _
vbYesNo, "Quit ?")
If (intReturn = vbYes) Then
' they chose Yes
Else
' they chose No
End If

This is the general form of a "Yes/No" message box. "vbYesNo" is an internal constant. See Help topics "MessageBox Function" for more detail.


2) Sounds like 2 delete queries will be easier.

RichM