Recent content by BBK

After much hair loss and a long night i finally got it working With unmatched query wizard an a addition of an extra field in my payments form :D

Ok i got it working a little better with this code SELECT DISTINCT Query1.FirstName, Query1.LastName, tblPayment.DatePaid, Query1.DayOfPayment FROM Query1, (tblTenant INNER JOIN tblLease ON tblTenant.TenantID = tblLease.TenantID) INNER JOIN tblPayment ON tblTenant.TenantID = tblPayment.TenantID...

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

Thanks John for the reply, but that is way over my head. Any easier way to overcome this, i dont even know where to start :confused:

John, your going to kill me. I just had a thought. I have another problem, i am only going to run this query Monday thru Friday, but how am i going to pick up the tenants that are due to make payments if there payment day happens to fall on a Saturday or Sunday. Any help once again is GREATLY...

Oops, i got it working.... Thanks a million John for all the advice, and your patience. I added to your reputation :)

SELECT tblTenant.FirstName, tblTenant.LastName, tblLease.RentAmount, tblLease.PaymentFrequency, tblLease.MonthlyRentDue, tblLease.DayOfPayment, tblLease.CurrentTenant FROM tblTenant INNER JOIN tblLease ON tblTenant.TenantID = tblLease.TenantID WHERE (((tblLease.CurrentTenant)=Yes)) and...

I want to be able to get a list of all Tenant that are due to pay today. So if i have say 20 tenants that agreed to pay on the 30th of every month, when i run my query it will list just them 20 tenants

I could have sworn i done that and it gave me an error, but now it seems to be working fine..... Thank for your time and patience John. So now i create a query with the DateDiff to compare the dates, or am i wrong

Well i have my textbox added as a number field, user can enter a number <32 Im not sure how or where i go about converting this number to a date using DateSerial. My knowledge is very limited and along with my stupidity it makes it more difficult :confused:

Not able to get to grasp with this :(, sorry John

Thanks John for taking the time to reply and give advice, but im still not sure how i would use datediff.... I edited my original post with more info to my prediciment: EG: The textbox field will only contain a single number beteeen 1 and 31, eg: 15 (so this would mean the tenant would pay his...

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

Thanks for the reply SOS appreciate your time for looking into it for me. Looks like i got to redo a lot of queries now as well. :(