Recent content by DenisCooper

Thanks for the advice. I created an unbound text box on the form and on the combo box change event did this Me.TextboxName = Me.ComboName.Column(1). When i change the combobox it shows the selected value in the combo box, i swap to another tab in the navigation form, and then go back to this...

great - thanks for your help

Hi, I have two tables, one showing expenses and one showing payments received. They are then linked to another table with all property details. I am try to write a query which shows the payments received and expenses paid on each property. I can do this as seperate queries, but then when i...

Hi, On tab 1 of my navigation field i have a combo box which i use to select the record i want to look at. but then if i click on another tab in my navigation form to have a look at another set of forms (not related) and i click back on the first tab with my combo box the combo box has reset...

Hi, I have a report generated by a query. The query shows the total rent collected per property and the total expense per property. It then has a sum in it to work out the total profit - SUM(rent collected - expense paid.). This works fine and the report works fine. But i want to add the...

Hi, I have two reports which are generated when i click a button in a form. The reports work fine by themselves, but i'd like to import the data into excel automatically, so when i press the button on my form it creates a new excel document with two tabs, the first tab with the first report and...

it looks like it's something to do with the query. In the form that opens this form (the one with the query) i have an unbound combo box which shows the landlord. In the row source i have landlordID in row 0 and landlord display name in row 1. In the query i filter by the landlord ID - it looks...

Hi, Got a form that opens using data in a query, and for some reason it's start causing the above error when opening. It never used to before, and nothing has changed in the form or the query... SELECT qryPercentOccupied.FirstName, qryPercentOccupied.LastName...

i think i've got it working by using this as the filter <Date()+6 AND >Date() thanks for help

intrestingly though, if i just put date() then it works ok

hi, tried all variations and it just seems to ignore the criteria and show everything...SQL query is shown here SELECT qryMaxPaymentDate.cboTenant, qryMaxPaymentDate.MaxOfDateDue, qryMaxPaymentDate.cboPaymentTerms...

Thats great - i managed to do it in two queries, one to show me properties that never had a lease using the unmatched query, and one to show me properties with expired leases using a date filter. Thanks :)

Hi, in a query i have setup, i work out when a tenant is next due to pay their rent. Looks like this Tenant Last Payment Date Payment Terms Next Payment Date User1 01/07/13 Monthly 01/08/13 User2 01/07/13...

great - thanks - seems to have done the trick :)

thanks for getting back to me.... i don't think this will work because some properties don't have a reference in the lease table... i only create a lease for a property when a tenant moves in, so for example, if i buy a new property, and it's not got anyone ever having lived in there, there...