Search results

I want to record many payments for tenants in a form. I want to enter payments for record 1 which i do, but when i then move to the next record the name and address (top details) etc change as they should but the payment details that i entered for the previous record show up on my next...

Yes, it one of the templates with changes to all of the forms, the one i got was more for the USA side of things. I have some basic knowledge of Access, its mainly the joins i struggle with a lotttt. My biggest problem is conveying my thoughts as you probably have noticed. Thanks for the help...

When i checked the payments table, it shows all the enteries i made. But i see a problem, it missing the TenantID, so i must figure out how to join the TenantID with the Payment being entered. ( lol great more joins for me ) Would this be the reason that when i go to the 'Tenants Payment Form'...

All checked and have a control source EDIT: It not even saving the payments for me :/ now :(

I dont think so, all are bound to a control source

Its the payments by tenants form. I want to navigate to a tenant and using the datasheet at the bottom enter in a payment they make, but when i do this, and say move to the next tenant name it displays the payment i just entered for the first tenant. So basically if i enter a payment it not...

Professionals cost money, i dont hafe money....... i work 15 hours a day for 40 euro a day.......... This was meant to be a little project to get a few extra euro, but i lost about 10 years of my life with agro over it, im burning Microsoft Access CD tonight

I quit..............

Ok,.... i have TenantID -> Tenant Table -> Primary Key (AutoNumber) PropertyID -> Property Table -> Primary Key (AutoNumber) TenantID -> Property Table -> Foregin Key (Number) So now i have the TenantID (Tenant Table) and TenantID (Property Table) linked in a one-to-many...

Thanks TrevorG for the reply, however i am unable to change it to a one-to-many relationship.... it will only let me do a one-to-one ?

Well, i knew it wouldnt take long for me to encounter a problem I have my Payment form finally done the way i wanted. But i need to Enter the payment details for the selected tenant and not all of them at once which is what is happening to me at the moment. I know it joins i need but im...

Sweet, Thanks vbaInet, working now. Im sure i will have another problem in a few minutes ;)

i have enabled set to YES on the text boxes But when i try and enter something into the textbox it doesnt do anything. No error appears Like for example DateDue... i click the box... calender appears but when i click a date nothing happens.

EDIT: Thought i got it working but it not Post removed

Ok, me again with more Form trouble, I have created a form like shown below: But the datasheet form at the bottom is not allowing me to enter any details. I hope it something simple, but for the life of me i cant figure out what is wrong. Any help greatly apprecaited.

Got it, thank you GalaxiomAtHome

Supposing i have: FormA FormBSubform FormA is a Single Form FormBSubForm is a Datasheet When opening FormA, FormBSubform appears at the bottom in a tab. How is this done. I tried the form wizard but it doesnt give the same result. Example of what it look likes:

Thanks vbaInet once again for your help and time. I still cant get my thick head around it, even with the link you provided, so im going trying some other way, just dont know yet what way. :( Thanks again for your time and help.

Yes, that is it vbaInet :) in a nutshell So i can enter the payment details only for the selected tenant from the first form.

Thanks for the reply vbaInet, i appreciate your time, but still no luck, it wont display the two fields values i want. I dont think im explaining what i want to do correctly, but here goes again. The Locate Tenant form i have, i find/search for the tenant i want and the form display the...