Search results

Hehehe.. I was thinking vba was the way I had to go. Just wanted to see if I could get lucky with a macro. With the circular reference I posted a topic called Circular reference in the Query section of the forums. If you couuld help me with that, that would be great. Thanks! David Somers

You can print Word Documents with mailmerge data, say using the switchboard and using a macro? I guess I'm not following the printing part. Could you explain how? Thanks! David Somers

See next post

Hey all! I'm getting a circular reference problem in a query I'm using and unsure how to resolve it. Here's what I've got: - I have a field called Balance which stores the total balance of a tenant. Mathematically Balance is equal to: Balance = (Prev Balance + Monthly Rent + Late Fee) - Rent...

Hello all! With this real estate software I'm workin on, I need several macros to automate processes that need to be done. I need to be able to run these macros from the switchboard that I have. However, I'm not sure if using a macro would be able to accomplish this easily. Visual basic may be...

Well, here's how I currently have things setup for what I've done so far which is add new tenants, when rents come in, post it to their account (ie. make their balance = 0), and print a receivables listing showing all tenants, their rent paid and remaining balance. I have a table that holds all...

Hello all! This may sound like a silly question, but its about to drive me up the wall. :) I'm working on a report and at the top I need it to say: For the Month of <Month> <Year> (ie. For the Month of November 2003) I've done the insert date/time and it just shows the current date. I need...

Hello all! I'm still working on my real estate management software several of you have helped me on. I appreciate everyone's help. I have another question regarding a different aspect of my program. I want to be able to keep a history for my tenants (ie. from their move in date show: rent for...

Thanks for the reply! Basically I need to have the Late Fee stored in a table or somewhere so that when I go to print my late notices, I can go through my list of tenants and find ones that have an unpaid balance and add my late fee to it. I guess I didn't make my first post clear of what...

Here's a thread I posted in the Word section. It probably should go in this section because I know its going to take some VB programming to get it done. If anyone can help me or even point me in the right direction, I would really appreciate it! Hello all! I'm working on some real estate...

Hello all! I'm fairly new to Microsoft Access, so what I'm about to ask may sound silly. I am working on a real estate management program where I have a table called Tenants which lists all of my tenants and their related information. However, I have a field called Late Fee which is the amount...