Microsoft Access - List box used to display varying data?

Asked By G James
03-Nov-09 12:19 PM

Hi, I hope I can explain this properly.

I have a switchboard page for searching records in my database, and on this page, there are several selections for searching, such as: By Committee, By Cost Centre, By Status, etc.  When the user selects any of these options, I want the related table values to appear in a list box that is also on the same switchboard page.  So for Committee, I want the list box to display the value of the Committee table that I have previously created, which has 35 committees available.  However, I would like the list box to remain blank until the user selects the search criteria, which they would do by clicking on a command button.  Then I want the list box to populate the values.

Can this be done, and if yes, how would I do it?

Any help would be greatly appreciated.  Thanks in advance!

G

Unbound List Control  Unbound List Control

03-Nov-09 08:02 PM
You want to create an unbound rowsource (nothing assigned to the rowsource property) list box control and assign the rowsource using VBA. Create each of the queries that answer each of the combo boxes. Then for each of the combo boxes' After Update event assign the appropriate query to the list boxes' rowsource.

As an example, say you made a query called Committees selecting the info you want in the list box. I will call the list box lstSelectValue and the committee combo box cboCommittee. Then in the cboCommittee combo box After Update event put:

Me.lstSelectValue.Rowsource = "Committees"

Hopefully you have basic VBA skills to accomplish the above. Let me know if not.

Worked perfectly!  Worked perfectly!

04-Nov-09 08:12 AM

Thanks so much Dean!  That worked exactly as I imagined it.  I really appreciate your help.

G

Create New Account
help
field (txtCCSelection) in my table (JHSC_Items) that allows the user to select one or more Cost Centres from a list box and then populates the textbox with the user's selection on my separate Search page, I want the user to be able to select the Cost Centre(s) that they want to find in the table, and I want to search changes. This works just fine. However, if I press one search option (ex. Search by Committee) then select a Committee in the list box but instead of searching for that committee, I change my mind and select another search option (ex. Search by Location) and select the primary key (Id?) of the JHSC_Items table and the other column would be the Cost Centre (or, better yet, the Cost Centre key from a Cost Centres table). Then your query would be: SELECT i.*, c.CostCentre FROM JHSC_Items i JOIN
completed with an additional resource? One way could be to check for Work Variance and Cost Variance, but there could be Work and Cost variance for various other reasons also. I specifically want to know if I can get Server (1) Microsoft Project (1) FAQs (1) Variance (1) Julie (1) Mary (1) Varianble (1) Committee (1) Try using the Resource Usage View. On the right side youcan add the rows for Cost Variance or Schedule Variance. You can do this by right clicking on one of the can also add the other varianble such as Actual Work, etc. Now you should see cost variances for a specific resource on a specific task. Just a thought, if you added manager that a resource worked on the project, but for a PMO or some steering committee, it it has to depend on the schedules to know whether the resource got added completed with an additional resource? One way could be to check for Work Variance and Cost Variance, but there could be Work and Cost variance for various other reasons also. I specifically want to know if I can get
Fixed Cost Cash Flow Project I have an issue with accruing cash flow in project for what I believe would be a fixed cost. I am managing a construction project with oversight of several subcontractors. Work is generally bid out as “lump sum” proposals and is invoiced monthly. Therefore, in most cases, Fixed Cost should remain a fixed amount for total cost. I have set options so that I can enter actual values in the task usage view actual cost fields. My desire is to set fixed cost accrual to prorated, a timescale to monthly, and update actual cost to the invoice values as I receive invoices. My problem is that when I update invoiced with fifty percent complete. The way Project handles this is by increasing my total Cost by ten percent. I want total cost to remain constant and the remaining field to
2), @TotalPower int, @Power decimal, @Cabvolt int, @Qty int, @BOM Char(20), @Description nvarchar(50), @Cost decimal (18, 2), @c char set @cabvolt = dbo.UDF_CabinetVoltage(@Voltage) set @description = 'Transformer BOM' set v = '4' and @c = 'a' begin SELECT TOP (1) @BOM = [Transformer BOM], @POWER = [Transformer Power], @cost = cost FROM tlbTransfomerBOM WHERE [Max Voltage] = 460 ORDER BY Cost set @QTY = @FLA / @POWER set @qty = @qty+1 set @TotalPower = @QTY*@Power insert into @tbl v = '1' and @c<> 'a' begin / * SELECT TOP (1) @BOM = [Transformer BOM], @POWER = [Transformer Power], @cost = cost FROM tlbTransfomerBOM WHERE [Max Voltage] = 460 ORDER BY Cost * / SELECT TOP (1) @BOM = [Transformer BOM], @POWER = [Transformer Power], @cost = ((cast(1765.45 / [Transformer Power] as int) + 1)*cost) as [Total Cost] - -This line has