Search results

One thing however, I need if a new tenant moves in after the 5th of the month, to have my Balance field in my query to not charge them a late fee. Not sure how that will change things... Thanks! David Somers

Ok.. I think I see what you're getting at. But how do I code that in? There are 4 situations that I have. Here they are: 1. On first day of each month, have rent posted to MonthlyRent. Have place to enter additional rents. 2. On 6th day of month, auto post 5% of MonthlyRent to anybody that is...

I don't think you're understanding what I'm getting at. I'm not trying to record a 0 payment. Lets say you pay $350 for this month's rent. At the end of the month, I want your rent paid to go back to 0 because obviously you paid for 1 month's rent, not 2. So that field for you needs to be reset...

On further inspection that code adds entries to my database with $0.00 rent paid instead of changing the entries for the tenants. Any ideas? Thanks! David Somers

If the amount of rent paid is never set back to 0, then how do you know if charge a late fee or not? Thanks! David Somers

Ok, I have a form created and linked to my tenants table. When I run the code from above there's no errors or anything, but when I got back to check to see if anything has been set back to 0 or cleared, there is nothing. The data has not changed. Any ideas? Thanks! David Somers

How would I call this code in switchboard manager using the Run Code option if I name the module Reset Month Code? However, in the module, the function name is Reset_Month(). Thanks! David Somers

I want to reset only those 2 fields. I tried converting the macro to VB code and renamed the module Reset Month Code. The first function that appears in the code is Reset_Month(). It handles displaying a MsgBox and then going to reset the code if confirmed. When I try to run this code using Run...

What if I took that macro and converted it to VB code? Would that do the same thing and I could run the code from my switchboard? Reason why I ask is I got a MsgBox that comes up confirming the reset. Thanks! David Somers

You mean open the switchboard form? I have several forms where the Rent Paid and Date Rent Paid are used. Thanks! David Somers

Switchboard manager. Thanks! David Somers

How do I get to the switchboard code to insert this code? Thanks! David Somers

Also, the reasoning behind this resetting is because at the first of every month I need the Rent Paid to be 0 and the Date Rent Paid to be cleared out so I can enter new data for the next month. Thanks! David Somers

Sorry.. that came out wrong. I have 2 fields that I want to reset using this macro. I have [Rent Paid] and [Date Rent Paid]. [Rent Paid] is set for currency and [Date Rent Paid] is set to Short Date. When I reset I was [Rent Paid] = 0 and [Date Rent Paid] to be empty. How can I configure the...

I meant all those "=0" and "=""" without the =. Thanks! David Somers

Hello all! I have several fields in a query that I want to be able to click a button on my switchboard at the beginning of each month that will reset fields that I select back to 0 or to an empty string, such as Rent Paid and Date Rent Paid (set as currency and date/time). I've attempted to set...

Thanks! But now I have a little different problem. The record I'm using has a monthly rent of $350, late fee of $17.50 if not paid between the 1st and 5th of each month, a previous balance of 0, and date rent paid as 11/16/2003. When I enter an amount lower than $350 (say $330), the balance is...

Hello all! I'm trying to use a statement from one of the Access books I have on finding dates within a certain range. Here is the statement I'm using though I modified it from the original from the book to try to fit my needs: [Date Rend Paid] Between #m/1/yyyy# And #m/5/yyyy# Obviously this...

Well, I tried it and it worked. hehe.. thanks! Now with the DateDiff() function, I need to be able to determine if the date is between m/1/yyyy and m/5/yyyy, not to add the late fee. Any date after the 5th, add the late fee. How would I use the DateDiff() function to accomplish this? Thanks...

I'm using that IIf() to determine whether the balace is 0 though. How would I rewrite that without storing balance? Thanks! David Somers