Search results

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 Dave, I put the scripts in the detail section, "On Format", instead in the subreport "on no data", it works! Thank guys, you guys been really helpful. Through the Q & A with you all experts, it opens up my thinking! Just wish can be as good as you guys! For me long way to go!!! Many many...

I am confuse where to put the SQL count function to make the label visible. Thank you so much for you information anyway. In fact I am thinking another direction: Try to put in some VBA like: If Me.rptCertification_subform.Report.HasData Then Me.Label01.Visible = False Else Me.Label01.Visible =...

I am quite new to Database, but I am sure my subreports are base on query from a table, which can be switched to SQL! for example: "SELECT qrySystem.Staff, qrySystem.Course, qrySystem.organ, qrySystem.CourseDate, qrySystem.Rank, qrySystem.lining FROM qrySystem;"

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...

Sorry try one more attachment!

Dear vbaInet, Sorry to keep you waiting, got shift duty which may me very busy! The objective of my program is doing a summary for a department of sixty some people. Please forgive me I am trying to avoid some confidential details and information, so I will use some alias. Besides, please...

Ok! Give me a little more time, I'll give you a full detail of my training db!

Dear vblInet, Sorry to reply you mail so late. I was on night shifts, and I was too exhausted for the whole time. First, thank you so very much for your very sincere assistance! You really did put yourself into my problem! You are correct, I need to concatenated values based on TWO references...

Dear vbaInet, Thank you very much, I have a group ID for the Course Date It works well but I encounter some other problems: 1) The report produced multiple number of concatenated value of each same ID(different training categories). 2) The number is of duplication is = number of original...

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...