Search results

I tried your advice GalaziomAtHome but no luck.

Once again Forms are providing me with a problem. I have two forms On one form (Lease Form) i enter a monthly rent price and the payment frequency (eg: Weekly or Monthly ) On the second form (Paymeny Form) i want to display the monthly rent price from the Lease form as the amount due and the...

Problem solved thanks for the help vbaInet, greatly appreciated Also thank you BrianWarnock and ghudson :)

I cant. I dont have a tenantID to select and if i try and change it when i go to form view it displays the form with all the fields missing..... basically a blank page. The bottom query i post above. If i select the form and use that query as the control source it will fill in my Address, town...

My lack of knowledge is very furstrating..... My form is getting info from two different tables and i can get the form to show the last name of the person leasing the selected property by using the following code: SELECT Tenant.LastName, Lease.TenantID AS Lease_TenantID, Property.TenantID AS...

Ok, i tried your suggestion ghudson for which im grateful, but am still unable to get it to work how i want it to. Im still getting the same error :confused:

I have two tables Property Table and Tenant Table I have TenantID in both tables: Tenant Table -> TenantID is the primary key Property Table -> TenantID is the foregin key Joined with a one to one relationship, because my thinking is only one tenant can have one property at one time I have...

Thank you very much bob for the help. Lesson learned and noted. Thank you once again for the help you provided, greatly appreciated.

I have two tables as shown below Im trying to create a join between the two tables to use in a form I have tried a lot of code but cant seem to get it to work My latest attempt been: SELECT [Payment].[PaymentID], [Payment].[LeaseID], [Payment].[DateDue], [Payment].[DatePaid]...

Hi everyone, a newbie here to the world of Access, trying to get to grips with it and learn it by myself. :confused: Hope to make some friends here and learn a lot hopefully Thank you for having me here :)

I have a form which has a drop down box which has a list of names the i enter through another form. In the drop down box it lists the names by last name, first name with a small divider between the last and first name, last name being to the left of the divider, first name being to the right of...