Search results

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

I have tried implementing this code and it is still giving me errors. Here's the code I'm using: Private Function checkFields() As String If IsNull(Me.ContactFirstName) Then checkFields = addToString(checkFields, "First Name") End If If...

Any ideas on why my code isn't working? Thanks! David Somers

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

What about to wrap back around to the first record if you reach the last record using command buttons as navigational buttons? Thanks! David Somers

Also another question I have, is there a way to hide the navigational bar at the bottom of forms and just use command buttons to navigate to the next record or previous record? Thanks! David Somers

Is there a way for after you tab through all the fields to not go to the next record and go back to the field with the tab index of 0? Thanks! David Somers

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

I'm trying to learn how to do this cascading combo box thing and my question is how did you create the table tblcategories? For my use, I'm grouping apt #'s by building number and I can't get past this first step. Thanks! David Somers

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

Here is the code I'm using: Private Sub Save_Click(Cancel As Integer) On Error GoTo Err_Save_Click DoCmd.SetWarnings (Not dataOK) DoCmd.GoToRecord , , acNewRec Exit_Save_Click: Exit Sub Err_Save_Click: MsgBox Err.Description Resume Exit_Save_Click End Sub Private...

So is this section required in order for the rest of the code to work? I guess a better question for my understaning is what is [1st_rjct] and [1st_rjct_reason]? I just want to test all the fields on my new tenants form to see if their empty or not and either allow them to save or not. Thanks...

Could you explain what this line does: 'Now test emplyness If Nz(Me![1st_rjct], "") <> "" And Nz(Me![1st_rjct_reason], "") = "" Then MsgBox "You have not entered the first reject reason", vbOKOnly + vbExclamation dataOK = False I've implemented all of the statements below this one to fit...

I noticed in the search I did that in an example sombody uploaded you can group in tables. So, would this idea work: Have the building 1219 as a group and inside have the room numbers that go with that building #, and same thing for 1229 and 1231 and 1233? There are only these building numbers...

One thing I'd like to add that I've started doing is I have a table that has all the building numbers and apartment numbers in the same table. It has a Building Number and Apt. columns. I also have a tenants table that has the same two columns in it along with all their info about them (ie...

Hello all! I have my real estate management software and I need to use combo boxes to specify the building number and room number. There are 2 things that I need and I'm not sure how to implement them. 1. I need for when a new tenant comes in to have a drop down box (combo box) for the building...

Can somebody tell me the limitations on Access 2002 (ie. how many entries in a table, etc.)? This doesn't have to be exact, but a general ballpark figure. Thanks! David Somers

And how is that done? What would the actual expression look like? Thanks! David Somers

How do you change this to not charge them a late fee if they move in after the 5th of the month? Thanks! David Somers