Search results

Dear All, In our department, we have different kinds of trainings: TU (Training Unit), Overseas, InHouse (for local in our department), External (local but not in our department) Each will have it's own source tables: tblTU, tblOverseas, tblInHouse, tblExternal I want to create a Entry...

Sorry, I did a reply, but I want to post for help!! Dear All, Last year, with the great help from vbaInet, I put the concat function into my queries, it worked fine with a few entries, but run like forever for > 3000 entries. Now I am in deep trouble. I have to force to erase the function...

Dear All, I have a question: I have 2 text boxes for user to enter Start Day and End Day, I only use the Start Day for all my queries. I can also sql to union Start day and End day to form a Special Date field. What if the event start day is January and end day is March. During the search...

Dear All, I have a main report, with 14 subreports. I also recreated 14 invisible text boxes of "NIL" for one for each subreport (on main report), I want to turn the "NIL" visible when the subreport has no data. I tried to add event "On No Data" event but no luck! Could anyone help me on...

Dear all, I am creating a training record which can accomodate "individual dates" and "continuous date", so that a training can be held in consecutive and non-consecutive dates. In order to do the above requirements, I have created 3 tables, table with continuous date (start & end date), table...