Recent content by AccessWater

Hi, In a report, I want to read both project ID and name in one text box. Is there a way to do this? Thank you.

Hi, Bodisathva, Thank you for your reply. However, changing ALL to "ALL" gave me the same result. I still could not get what I want. Any other idea? Thank you.

I create a list box to store a lsit of groups. It allows user to have multiple selections. I also have a "ALL" is the list. On listbox Click event, I then set up the SQL based on the selection. This SQL will be the query for the report. If user select "ALL", I want all project to be...

I have created two list boxes that allow user to move the items between the two boxes. I want to give an index for each item moved from left to right (for example, 1, 2,3,...). When this item is moved from right to left, the index will be deleted. Could anyone give me some hints? Thank you...

Hi, grnzbra, thank you for reply. I am trying to do as you suggested. However, how exactly to set up the SQL? there are dozens of variables from several tables in the query for the report. Besides the group, there are three other combo boxes in the form, together tehy determine the report...

I used a Form to allow user select a group, then a report will be created for this group. I set up [Forms]![frmReportSelector]![cmb_ReportType] in report query. There are other variables such as project status(Not Started, Completed, etc) and completionDate. Now I need to do one more thing...

Could any body help me with this issue? The deadline is coming . What did I do wrong ? Why cannot I make the second time selection to move projects in LS3 to LS4. I really appreciate your help.

Hi, RG, Could you please take look at my code and help me with it? Thank you very much.

Hi, RuralGuy, Need your help again. Currently, the way I set up the row source for LS3 and LS4. It works fine after teh first selection for RollUp and Area. I can move projects between LS3 and LS4 back and forth. However, if I make anotehr selection (either Roll up or even Area), it give me...

RuralGuy, it works now. It may not in the exact way as you suggested, but your suggestion did help me thinking about the way to set up RowSources for LS3 and LS4. Thanks a lot!

RuralGuy, Thank you again for this idea. I now created a new variable as YES/NO in the original table (tb1). LS4 also use this table. Now it won't delete or add anything to tb1. The ideal situation is when a project is moved to LS4, it should be cleared out from LS3. I used the following...

Hi, RuralGuy, I am having new problem now. Because there is no temp table to store projects shown in LS3, after I move projects to LS4 (a paired list box of LS3), I kind of delete proejct from the original table which is not what I want. It messes up the original data set. Could you please...

Hi, RuralGuy, Thank you for your reminder. Yes, you are absolutely right. I can use the following code in the click event of ls2 and got the projects shown in the ls3. lssource.RowSource=strSQL.

I have a combo box (cmb1)to allow user to choose rollUp groups, after that, all areas within that group will be shown in a ListBox (Ls2). After user click the area(s), I will run a query to find out all projects in the selection. Then I want to show these projects in another listbox (LS3) for...

Thank you very much, chrisjrim. I will check it out soon.