Search results

Hello, Trying to get better i have much trouble providing code for my DB.. and i would like help on insert into fired from command button "cmdAllAthletes" on the subform of my form Fr_CourseSessions I would like to fill rows to Tbl_CourseAttendances for athletes registered in tennis course...

Thank you. I shall try to accomplish your suggestions. Also i saw what you warn me about when eg in a course { mini tennis) with an id from Tbl_CourseYears, it is a different course from another year's course with same name (different ID) so when in a query, if pull up athletes from courses...

I am trying to understand what to do. I dont understand how to build it from now on. In last sentence do you suggest it or purpose not to. Also if i wasnt using lookup fields in my tables... When seeing recordsourses i would try to understand what is in there (whome of instrucrors which course...

i think that is not a problem (indexing is proper so not book same court same time in a day etc.)

Hello, i have difficulty to produce proper code on an AfterUpate event In my Db in order to keep Attendance of athletes i have a main form called Fr_CourseSessions it has subforms to select Academic year Tennis Cource, Instructor etc All is working except: to make easier to track attendance i...

Thank you for helping but i am thinking that: a) There is no purpose for connection (especially one to many) between club details wish courses ? (DB is for only one club or wasn't it said? ) b) There was purpose to have Tbl_AcademicYears because an athlete in a year could be skilled so there...

In order to manage changes i got lost because i ve already had reached to finishing forms.. These are db relationships and i could use some advise in making some changes on these tables... lets say Tbl_CourseSession' s instructorID should get values from Tbl_CourseInstructors / (instructorID)...

I thinking to have a subform to a form that holds planning Sessions and be helped on scheduling by seeing specific date and time what does instructor and which court is occupied. Just need the indexing to be helped..

Thank you but It would be easer now to keep on to what i already have as a structure.. i simply need to see how to do it. Could you help me on the specific table? I think i have divided information and cases in that db already in too many pieces..

Hi, i am trying to make a simple DB for scheduling tennis courses ( course, instructor, court, date and time ) and that info is held in a table Tbl_CourseSessions Need to index the table properly and I am stuck because i cant think more of how to ensure that, because otherwise there will be...

Could you please help me solving this? I have tried a lot with listboxes and comboboxes in my db wich is intended to hold tennis classes In form named Fr_InstructorCourseAthlet i need help making three listboxes a) On first on top, selecting a tennis Instructor to show his courses in the second...

Sorry i cannot see the example..

Because mostly the tennis instructor will use the db, besides husband (manos39) i would like a) tennis instructor selected by first listbox to see her courses ..- I should had involved date of the course in the second listbox lstGroups, b) then, in the third listbox , lstAthlets, to provide...

Hello, i would like a solution about three list boxes that i have on an unbound form that i need to populate from selections on A) first and b) second here it is first on is lstInstructor SELECT Tbl_Instructor.instructorID, Nz([iSurname] & " " & [iName]) AS Instructor, Tbl_Courses.courseID...

i hope you mean this i ll try answer later .. have to go thank you

I ve tested it is superb but when theres no record on form i am asking

is there an easy way for disolve problem giving error on when entering data on a new record?

Thank you very much

WOWWW Thank you very much

ok, for tmimaID SELECT [Tbl_Tmimata].[tmimaID], [Tbl_Tmimata].[ONOMA] FROM Tbl_Tmimata ORDER BY [tmimaID]; and for athetID SELECT [Tbl_Athlets].[atheltID], [Tbl_Athlets].[ΕΠΙΘΕΤΟ], [Tbl_Athlets].[ΟΝΟΜΑ] FROM Tbl_Athlets ORDER BY [atheltID];