Recent content by ultra5219

hi guys i did try create search data using search Text box find. my question is, how to add search keyword function? For example if i type keyword: "JAVA" it will shows any keyword related "JAVA" on the table record for membertbl. i try to modified my code, it seems many syntax error. anyone...

Well The YES and No condition means if YES the book return in good conditions and Poor means when the return the book conditions very poor. Book Record represent all the record of book. Borrow book table means the record for all who borrow the book and Return book means they return the book from...

I see.. well im not very good in database access. can u fix for me the table and relationship? this is just for my small practical excercise :confused:

hi guys. anyone know how to generate Report Borrow book By month and Year. For example, when i open report view, the report prompt the user enter month (July) and year (2016) and generate overall summary List of borrow Book By month and year. I did Test usung query but how to generate in report...

Thank You!! :) finally solved!! oh yea.. the DLookup which search hours many hours based what i select for time schedule right?

hello i wana ask about calculation hours for schedule table. lets say how to calculate based on what i select from my schedule table for : no class: how many hrs lesson i got class: how many hours.. for example: 1+0.5= 1.5 hrs total of hours: which is based on "no class" + " lesson i got class"...

hi everyone does anyone know how to create timetable report in Access? i have encounter difficulty to create timetable report. currently im using report wizard options. i select table under "Timetable Table" then select field which i want to display on report.. then select grouping etc then end...