Search results for query: *

Figured out where I went wrong, thanks!

I have 3 Tables - that each have their own data entry form. All 3 tables are related through a one to one relationship. I have added the following code to the AfterInsert event of the parent form: Private Sub Form_AfterInsert() If Me.NewRecord = True Then CurrentDb.Execute "Insert Into...

lameid if you were here I'd kiss you. Thank you, thank you, thank you, it's perfect!!!

lameid, I must not be seeing the forest for the trees. I tried both of your suggestions. What it is doing: If RATE is <3 it fires off the backcolor change and the "remediation message", but I am able to tab to the next control without entering a REM value. However, if the RATE is <3 and I...

Yes, that is what was happening. Compacted and repaired. I modified the code slightly and the first IF fires OnExit fine. What is happening with the Else is this: When I enter a value of 2 in ALARM_Q1_RATE then I am prompted for a ALARM_Q1_REM value, which is correct. However, when I DO NOT...

I really appreciate you taking the time to help me out with this. I seem to have lost the OnGotFocus functionality with the change to the OnExit. Maybe to spell it out would help... If ALARM_Q1_RATE >= 3 then jump to ALARM_Q2_RATE, else If ALARM_Q1_RATE <3 then set the focus to ALARM_Q1_REM...

lameid thanks for your help! This did prevent me from going any further until a value was added. However, once I did add the value I could not stop the msgbox. I did not understand what you meant by set a boolean scoped to the procedure and try to test the value if it is true on events and...

I have two simple functions on a control; 1 changes the backcolor of the control and requires a value to be input if criteria in another control equals a specific value, and the second to reset the backcolor on exit. My question is this: Is there a way to prevent the user from exiting the...

Max, I'm at a loss for words...I don't know how to thank you. This is perfect! [thumbsup2]

Max, First of all, thank you for putting so much effort into your response. I really appreciated you adding the lines of comment to your code so I can begin to understand. I had to make one change in the from statement: CourseSchedule to CourseDay. Then it ran, and ran, and ran. When I...

Thanks PHV, I appreciate you checking this out for me. I had originally thought of using the crosstab, but I had no idea how to enumerate the schedule dates. It was then suggested to me to possibly use a select case to determine a MondayDate and then nest statements within that for the length...

I have a start date, end date, and length (hours) for a course and need to track the dates an instructor should be scheduled. As an example if we have a course that starts on July 11 2007, and ends on July 13 2007, I would expect 3 intructors required over the days of the course. This same...