Search results

I have with fantastic help from John Big Booty created a query that lists all tenants that are due to pay rent for today. Supposing my query returns 3 results that are due payment. I check my bank records and see only 2 of these results are true. I want to be able to run another query that...

I want to add a textbox field to my Lease table that will contain the date that each tenant would like to pay their rent, so that each day I would be able to run a query to check who owes rent for that day. EG: The textbox field will only contain a single number beteeen 1 and 31, eg: 15 (so...

Can someone show me an example or sample code of how to cleanly cancel a macro. I dont want the Macro single step message box ( stop all macros etc... from showing) if i hit 'cancel' half way through running it

Having problems when i delete a record from my tenants table. Two tables one property to many tenants is my relationship with enforced referential integrity ticked and cascade update ticked and i took the cascade delete off. Problem: When I delete a tenant from tenant table it is also deleting...

I have 3 text boxes in a form - Rent Amount is user input field - Payment frequency is dropdown combo box with weekly rent or monthly rent - Monthly Rent Due - is calculation field with this formula =[RentAmount]*Switch([PaymentFrequency]="Monthly Rent",1,[PaymentFrequency]="Weekly Rent",13/3...

I have 3 input fields: - RentAmount ( Currency, entered by user ) - PaymentFrequency ( Drop down selection which is either Weekly or Monthly ) - MonthlyAmountDue ( Currency, calculated ) I would like to be able to have the 'MonthlyAmountDue' textbox automatically display the total...

I want to create a query that by entering a 'Location' and a specific time frame eg Jan 21- Dec 12 it will return the total amount paid/received on that Location during that time frame. (Enter a location Enter a beginning date Enter a end date And the query to return the 'Total Amount Paid'...

Im trying to get a query working that will selected all properties that have no lease(vacant) I have tried countless ways but am unable to get it to return the correct results. Is it even possible from my two tables show below. :confused: Once again any assistance is greatly appreciated. :)...

I want to enter a location and get the total rent for that location. My SQL is as follows: SELECT tblProperty.Address, tblPayment.AmountDue FROM tblProperty INNER JOIN tblPayment ON tblProperty.PropertyID = tblPayment.PropertyID WHERE (((tblProperty.Address) Like "*" & [Enter Location:] &...

Can someone be kind enough to explain (in simple terms) what exactly the following is doing. SELECT Lease.* FROM Lease WHERE (((Lease.EndDate) Between Date() And Date()+45)); Sorry for my stupidity :confused: Thank you for taking the time to read this :)

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...

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.

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:

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...

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...

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...