Search results

Great thank you So going on form there, looking at the database again on the tabs you can see invoice, in another tab via a query i have summarized the totals by exp code so if i select Group A code 55 in the value box after description (see new attached database) what is the code for this...

I attach the database, on the form Annual Accounts Form and the Income and Exp Tab you can see i have a combo box to look up the code i want (which saves in the main table) in the txt box next to it i need to to display the description its the later part I am having issues with Thanks for...

I use the combo to 'see' the exp code and the description, but only want it to display in the combo the exp number as i have to use that for another fuction, in a txt box next to it i need it to the auto populate the description of the exp code.

Hi Guys on a subform i want to lookup a value in another table (which I do using a combo box) then i want it to auto fill in the description in a txt box, and save that information in another table. How to do?

Thank you so much that solved it might i touble you now for a more complex issue you can see on tabs "Invoice" that look like this Invoice Date PO Invoice Contractor Expense Code Lease Code Invoice Amount Status 28/09/2013 34606 1141 Platinum Landscapes 55 A 240.00 03/09/2013 35311 2021...

I have zip database up and enclosed the only site that has any data is 0289S

Hi I dont know if the first part works as I cant see the results and the second part i am getting #Name?

This is what I did calling the textbox Addupofrec =Sum([Forms]![Arrears and Income Report subform]![Actually Received]) Then need to display the result on another subform so i have =[Forms]![Arrears and Income Report subform]![Addupofrec] but it comes up an Name? Using 2010

Hi Guys Hope you can help I have a subform on Tab page, it has a id "site code" that then displays on the subform all entries with the site code. after the site code is various fields and i need to add the columns up whats the best way to do this? Thanks

I have 2 tables Main table called Site Details and another table called expense codes On the form I want to use a combo to look at the expense Number 52, 53, 54 ect the in the next field to show the description of the code it relates to How do I do this?

Can anyone help on this problem?

I have a subform in columns that has a list of invoices bound together by the site number on the form there is a Expense code that runs 51 to 95. on another tab i want to add all the invoices for a expense code together and display the total amount Below is an example of invoices ID Site...

resolved =DLookUp("[CountOfAsigned To]","CountCoSec","[Asigned To]='Keith'")

I tried creating a new field on the form didn't work i assume this is what you meant?

in the control source of which field?

Conditional formatting is the simple way to do this Left click mouse and go from there

On My Form I have a button controlled by a macro that returns a result of 'active' - 'Keith' = Number of forms with these. When I click the button it only shows the forms to the above - works fine Now on the form I want a box that displays the total number of forms that are 'active' and...

I have a folder called site docs on our server m:/estates/sitedocs I want to have a button that opens this folder but in the correct site sub folder Ie:- primary Key on form site number 0001S if i click site docs button i want it to open folder in estates.sitedocs/0001S or which ever site...

Following on from this how would you make this front end user friend, ie: when you click to run the query it ask you a start date then a end date

Can anyone help?