Search results

Well I figured it out and got it working. Thanks for the typo from above. :) There is another question I have, but it concerns the report for my late fee form. In the report when it lists the amounts, they are not lining up correctly. At least the dollar signs are not lining up like they...

Thanks! When I corrected that first problem you mentioned, when I select my tenants now and try to add the court costs to the tenant, it acts likes its working, but it doesn't show up. Also my transactions table isn't reflecting a transaction was made. Can you see whats going on with this as...

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

Well, I've been working most of the day trying to get this mail merge to work right and I can't get it. So, my question now is if there is a way to import my Word documents into Access and have them imported into a report? Thanks! David Somers

I would like to save creating a report as a last resort for this document. I really would like to get this mail merge working correctly because I would like to as my next step select a tenant and have it print their lease with all the information filled in. The lease that I have is in doc format...

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

Nevermind, I figured it out. I had to add the Word Object Library to my references list. Later, 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"...

Well, I've got something almost working. However, I used a query to create a temporary table. Here's the VB code for what I'm doing when I open the form: Private Sub cmdPost_Click() On Error GoTo Err_cmdPost_Click Dim stDocName As String Dim stLinkCriteria As String...

Thanks! I tried to download version 3 from that link and Winzip says the archive is part of a spanned set. I downloaded version 2 and the listbox is similar to what I want, but I would rather have a checkbox rather than highlighting the selected entries. Is this possible? Thanks! David Somers

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

Ok, I've tried putting some code in so that it will update CurrAmtOutstanding when a number is entered into txtDebitAmt or txtCreditAmt. Here's the code I'm using: Private Sub txtCreditAmt_AfterUpdate() Dim ADOrs As New ADODB.Recordset Dim sSQL As String sSQL = "Select * From tblLease...

Oh.. forgot to mention that I changed the pass to the ftp site above. Sorry! user: davidinncsu2003 pass: ncsuwon Thanks! David Somers

I have one more question regarding this. I need to be able to have the CurrAmtOutstanding be updated right after the user enters either a debit or credit amount. And have the new value show up in txtCurrAmtOutstanding. My guess is to use the AfterUpdate of the textfields, but I'm not sure how I...

I got it fixed. I had to redo the next sSQL statement and then remove the line that stores TransID. Thanks for the help! Thanks! David Somers

Did you change both sSQL statements to the above? Thanks! David Somers

Ok, I got that in, and its storing the correct LeaseID in txtLeaseID. However, when I try to add the transaction, it says that no value is given for one or more of the parameters. Can you take a look at that and see where I'm going wrong? Thanks! David Somers

I get a syntax error with that. Any ideas? Thanks! David Somers

Is there a way to tell it to use the LeaseID that is Active? (ie. tblLease.ActiveLease = True) Btw, I had to recreat txtLeaseID because it wasn't showing as unbound for some reason. Anyhow, it works.. Just need to get it to always go to the active lease. Thanks! David Somers