Search results

Hi all, Sorry for bothering again :o I have got another problem.I have two tables Department and Expenses. Department has the following fields: ID, Name, Budget Expenses has the following fields: ID, InvoiceNo, Department, Budget, Expense, Description, etc. I have designed a form for Expense...

Thank you very much It works and I have fitted this method into my project. Thanks Brianwarnok! God bless you...

I am realy very sorry that I cannot understand both of solutions. I am new to access and have started work on it recently. The situation I mentioned is an example. I shall adjust the solution into my actual project (that is little bit complecated). I am attaching the sample file...

I have a table Table1 having the fields ID, Department, Expense, etc. Each department has many expenses that are listed in this table. I want to make a query such that all the fields of Table1 are there AND an additional field should be placed into query such that it shows total expense of that...

I have a table Table1 having the fields ID, Department, Expense, etc. Each department has many expenses that are listed in this table. I want to generate a report such that on a page all the table fields will be displayed AND the total expense of each department should also be there. Each page...

Great......... :) Thanks a lot. I works according to my requirements. Thanks again for your correction.

I am using this code for populating second combobox in actual scenario. Previously I was using example and there it works fine. But now in actual scenario, My combobox shows the query, not result. Here is code cmbCostCodes.RowSource = "Select CostCodes.Codes " & _ "FROM CostCodes " & _...

Hello everybudy I have got a problem and I want help from some buddy. I have two tables Table1 & Table2. Table1 has two fields ID and Department. Table2 has 3 fields ID, Employee & Department. In a form, I have 2 Combo Boxes cmbDept and cmbEmp. I populate cmbDept from Table1 with...

Thank you very much for this information. It realy work well... Now I am using Dsum with nz Thanks

Thanks for reply. I have used the above syntax. Actualy the problem was that I was summing up the field which has null values except few cells. So, DSum returned Null after summing all nulls of the set. It is not allowed and DSum cannot return Null value. Now I have put 0 at every null and...

Dear Paul, I have bracketed the field name and this is my line of code: Me.lblTotalExpense.Caption = DSum("[Expense]", "Issues Log", "[CostCodes] =""" & Forms![Issues Log]!cmbCodes & """") But now it is showing the following message: What could be the problem? Plz Help me... Thanks

In an access form, I am using a combo box and a label object. I want that when I select any value in combo box, its value be picked up and match in a table, and add corresponding values of all the entries with the same combo box value. I am using this function to calculate SUM of values from...

Thanks MStef has sent the thing which I was looking for. I presented a simple scenario and I shall fit this example into my project accordingly. Thanks again. :) But lagbolt is very right that there should be two tables. Actualy I have two tables. Almost the same as you have mentioned...

This thread is related to my previous one. I have a table Table1 having 3 fields, ID, Department, Expenses. In a form, I have a ComboBox populated with all Departments and text box of Total Expense. I want that when I select any Department in ComboBox, all the Expenses from Table1, of the...

I have tried this one and it works. Private Sub cmbCodes_AfterUpdate() txtBudget = DLookup("Budget", "Table1", "Codes=" & "cmbCodes") End Sub Although I have acieved my objective, I am wandring if it can be solved through SQL query! Thanks

I write this event procedure but it has errors.:confused: Can you see this or tel me some other method. Private Sub cmbCodes_AfterUpdate() Dim qdf As QueryDef Dim rst As Recordset Set qdf = CurrentDb.CreateQueryDef("", "SELECT T1.Budget FROM Table1 AS T1 WHERE T1.Codes=[Value];")...

Thanks for so quick reply. Actualy Code is like some ID given to some department, for example, and each department has allocated some Budget. Code is some string of characters while Budget is dollar amount. ComboBox on form have code values picked up from Table1. When I use wizered to make...

I am new to access and have got a problem. I have a table Table1 in which there are 2 fields. One is Code and other is Budget. e.g. Code ------- Budget A12 --------- 20000 A14 --------- 19000 . ------------- . . ------------- . Now in a form, I have different objects for entring data into...