Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Insert Into error on form/subform
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...- caburky
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Prevent user from moving to another control
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...- caburky
- Thread
- Replies: 12
- Forum: Microsoft: Access Forms
-
I have start_date and end_date and need to track all scheduled dates
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...- caburky
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
