Search results

Need help with a report calculation Hello all! I have 2 problems with my db program. I have a form for each problem. They're not on the same form. 1. I have a report that is serving as a Late Notice to my tenants. It has a Previous balance field, rent field, late fee field, and total due...

Need help with mail merge Hello all! I'm trying to do a mail merge with a word document in my real estate program in Access. I searched the forums and found a link to support on Microsoft's website for how to code in automatically doing a mail merge in word. However, when I try to do the mail...

I'm creating a query that will provide me with people that have their lease expiring in the next 60 days from whatever date the query is ran. However, I can't think of how I would specify that in the criteria for my query. Can't somebody help me with this? Thanks! David Somers

Hello! I'm doing a mail merge with a Word document and here's the code that I have (got it off the Microsoft website after doing a search here on the forums): Private Function MergeIt() Dim objWord As Word.Document Set objWord = GetObject("G:\Past Due Notice - 5th.doc"...

Hello all, I have a design question concerning my real estate program. I want to be able to click on button on my utilities form and have it open a form that lists all the tenants with an active lease. From there I want to be able to select tenants that I want to post rent to and be able to hit...

On my real estate management software I need to get a LeaseID from Building Number and Apartment Number for my transactions form. However when I try to get it and store it in txtLeaseID so I can use it, it doesn't do it. I've attached my db to this message. If someone could look and see what I'm...

I have a table that has only one column and one entry which is supposed to be the name of the property that the program is used for. How can I get that name displayed in a label on my switchboard and have it set to whatever that one entry is set to? Thanks! David Somers

I've got one more question. I have a form that adds and deletes apartment numbers. When I entered the data to start with I entered it in the datasheet view of the table and put in numbers like 1, 2, 3, ..., etc. My form allows for the addition and deletion of apartment numbers. When I delete...

I'm having a problem with my startup screen that basically gives information and then has a Don't display on startup check box and an OK button that is supposed to close the startup screen and load the Switchboard form. However, its not doing this when I click ok or check the check box. I've...

I have a form that opens whenever I open my database. It opens as if I went and hit open from the database list box. How do I prevent this form from opening whenever I open the database? Thanks! David Somers

I have a form that I set the style as Stone when I created it using the wizard. Is there a way to change it without redoing the form? I want to give it a solid gray background instead of the marble look that Stone has. Thanks! David Somers

Hello all! I need on my new tenant form a button that opens my lease form. But I need to have that button make the determination of whether they've added the new tenant first. If they have, open the lease form, if not display a message box saying you must add the tenant before putting lease...

I've set up my tables and created a query that consists of fields from several tables. I then created a form and linked the query to it as the source. Since there are multiple tables, I had Access split the form into a main form and subform. The problem I'm having is I can enter data on the main...

Hello all! I got my relationships fixed in my real estate management program and started working on an add new tenant form. I created a query and selected the fields from the different tables I wanted to put data into that is necessary for a new tenant. I then created a form and put the query as...

Hello all! I've started working on my redesigned db, and have a problem when I create a new tenant form, when I try to run it to see what it looks like and see if it pulls the data, nothing but the background shows up. I've attached it to this message. Thanks! David Somers

Hello all! On my real estate management software I have a couple of quirks that I've come across that I need implemented within my query. To begin with, I have fields: Balance, Prev. Balance, Late Fee, Monthly Rent, Rent Paid, Date Rent Paid. Here's what I want to do: 1. Set balance to 0 at...

Hello all! I'm using required fields and found some code to use in another thread, but I'm trying to set a clear button on my form and it gives me an error about having to enter certain fields afterwards. Here is the code: Private Sub cmdClear_Click() Me.ContactFirstName = vbNullString...

Hello all! I'm still in need of help with cascading combo boxes. I've searched the forums for cascading combo boxes and the threads I have found had some examples but nothing that really told me what I needed to do to get started. So far what I've done is created a table with all the building...

I know this is going to sound like a silly question, but in some of the forms that I have that have quite a few text fields, when I try to use the TAB key to navigate around, sometimes the cursor when I open the form is not on the first text field and when the tab key is pressed it may go to the...

Hello all! In my real estate software, I have my tenants in two groups: active and inactive. On my manage tenants form I have a toggle button that I want to be able to switch between viewing only active tenants or inactive tenants in this form. I just need to add this functionality to it. How...