Search results

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.

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

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

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

Hello, I once used a program, when you click this .mdb file, it opens a main Form interface that user can run programs such as view report etc. That is, all tables, querys reports, other forms are behind the sence (user does not need to know them). Could anyone tell me how to do this...

I use a close button to close a form. There is list box in this Form. If the list box is empty, then simly close the form. However, if there are projects in the list box, I want to give a warning. If the user say YES, then everything in the listbox will be deleted and the form will be...

Hello, I am suing an append query to append new tables to an existing table. However, I only want to append the records that are not in the existing table. I have three variables: Category, Group, Project. None of them are unique. How to wirte this query. For example: In existing Table...

I have a list box that stores the project names in a Form. The user wants to have the ability to order the project in a way they want. And the report need to present this order in the same way. In other word, user wants to move the proejcts around in the listbox. Could anyone give a hand...

Hello, I used a commond button to run a query in a form. This is an append query that appends the new setups in the form to a table. However, every time I click the button, a message come out: You are about to run an append query that will modify data in your table. Since this is a form...

hello, I am trying to get rid of spaces from a imported data in a macro. I used clean(trim(Emp_name)). Emp_name is a string. However, when I run the macro, it says: Sub or function not defined. If I delete CLean (), it works fine. But there are spaces for some names. Could anyone tell me...

Hello, I calculated subtotals of each group in the group footer. Instead of present the subtotals at the end of each group, I want to present all subtotals together at the end of the report. Could anyone give me a hand? Thank you very much. The report will look like this: Group A...

I want to create a form that allows user to set up groups of projects. I plan to have two combo boxes. cmbA has group name, cmbB has all project names. User can choose a group name in cmbA and several projects in cmbB. That is, users create their own group of projects. I also want to save...

I used two combo boxes in a form to enter data into a table. I want to allow user to look at the table from the Form. Can I use a Command Button to do so? Thank you for your help.

I have a table (A) with three variables: ProjectID, SubprofileID, and Budget. A projectID may have several subprofileIDs. I need to update this table monthly. Each month, I will get a table (B) with exact format. I want to update table A using data from Table B. I used UPDATE..... Left...

I need to calculate a variance between actual and budget. Some projects have only Budget data but not Actual data. When I calculate the variance, it gives me #error. I used a subreport to get Actuals. The link of this sureport to main report is Project ID. There is always Budget for each...

I am trying to use HasData method to get SUM using subreport data. Attached is an example I did. But it still asks me to enter the .hasData parameter. Could anyone tell me what I did wrong? Why it does not work. Rich, if you are there, could you please give me a hand again? Thank you...

hello, Not sure if this is right placeto post. In the subreport, I calculated a difference between budget and actual. I want to present this difference in a way that if it is positive, then just show it the way it is, but if it is a negative number, I want to show it in a (). FOr example, if...

I have created a list box that shows all the projects' names. Now, I want to add another column in this list box that allow user to choose YES or No for each individual project. In creating a table, you can set a variable as YES or No type. Can I do something like this in the list box. Thank...

I used a combo box to let user select "Proejct Status" such as active, completed, cancled. I want to set active as a default selection if user does not choose other status. How can I do that? Thank you very much for your help.