Search results

I have create a seperate form for adding a new landlord to the database. If the 'dashboard' form is open at the same time as when a new record is created and the newlandlord form is then saved/closed, the new landlord doesn't show on the subform on the 'dashboard'. Is there a way of it...

It seems to be working fine now, the subforms weren't on the tab layer correctly and were just floating infront :o Is there a way of making the subforms auto update when a new record is added?

Thanks Beetle, im in awe of the effort you put into your posts. What you suggested looks great and seems to work great too. I keep getting an enter parameter value - 'textbox' dialog box popping up when I open the form and the 2nd subform appears blank. I suspect it may be because I have...

Thanks Beetle, I really appreciate the help. Took me a few goes to get it right, but its working how I want it now. Can the same thing be done using a datasheet/subdatasheet for the list of landlords rather than a combo box? Also is their a way to take off all the buttons (filter, search...

Thanks for the advice on the subdatasheetname, i've changed them all to none. Would doing that way with a form/subform mean that a Landlord can be picked from the list and it would show their houses in the subform automatically? How would I go about doing it? I managed to get the subform...

Hi Guys, well im back again... Working on the forms for my property db. Is there a way of having a form that will display a searchable list of Landlords and display the houses they own? perhaps in a seperate list. I've seen that when I have the datasheet view of the landlords in the form it...

ah, I see. In my lease table I currently have the fields: Tenant1 Tenant2 Tenant3 Tenant4 Does using a junction table means I dont need the multiple tenant fileds? Also, when it comes to imputting the data, will i need to put it into both the normal table and junction table? or is there are...

Hi Guys, well im a bit further down the line setting up a property database and i cant figure out how to set up a suitable relationship between 2 tables :banghead:. Table 1 is for leases, which can have up to 4 tenants (each has seperate field) Table 2 is a table for each tenant now I need to...

thanks for that, thats a great help. I'll get working on it and see how it goes, no doubt i'll be back here further down the line

Would I be able to create a statement/log of rents like the following? 01/01/2013 January rent charge 400 15/01/2013 received rent 200 30/01/2013 received rent 200 01/02/2013 February rent charge 400 cheers

Hi Guys, I've scoured the internet the past few days trying to find if it would be possible to use access for what i'm wanting to do but haven't had any luck. Im looking to set up a letting agency system and need a way to track rents for tenants and landlords. For each tenant im going to...