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!
Search results for query: *
- Users: planetjeff
- Content: Threads
- Order by date
-
dynamically apply colors to entries in a subform?
Hello all, I have three tables: Events (with pk EventID), Adjudicators (with pk AdjudicatorID, and Assignments (with pk EventID,AdjudicatorID) which tracks a many-to-many relationship. Events can have many judges (adjudicators), and judges can judge many events. In my form for assigning events...- planetjeff
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
How to select an item on a subform to create a table entry?
Hello all, I have a form showing judges and a subform showing a list of all the events the judge can, well, judge. I also have a couple buttons where I'd like to be able to work on the selected record in the subform and take those values to create a new record entry (or delete an existing...- planetjeff
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
-
How to build query/subform based on dynamic, unrelated list?
Best way I know how to describe it, sorry! I am tracking Events and Adjudicators (judges) - each event is of an event type, and each Adjudicator can judge a selection of these types. For example, judge1 may judge three types of events, whereas judge 2 may judge only one type. The events can...- planetjeff
- Thread
- Replies: 11
- Forum: Microsoft: Access Queries and JET SQL
