Search results

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

One more question I have is with this table setup, how do I implement cascading combo boxes for building number and apartment number? That way I can select from a drop down menu which building number the tenant stays in and have the correct corresponding apartment numbers for that building...

Here's the 97 version. Thanks! David Somers

Here is a copy of the new version with the correct tables and with the couple of changes Rich mentioned. The question I'm having is does my relationships look complete and correct? Thanks! David Somers

One more question I have is do I need a primary key for my tblDeposit and tblHistory tables? My first impression is no. Thanks! David Somers

Ok. How does this look: tblTenants: TenantID First Name Last Name Previous Address City State ZIP DOB SSN DL # Phone Number Active Status tblDeposits: TenantID Security Deposit Pet Deposit tblLease: TenantID ApartmentID Move In Date Lease Expiration Date tblHistory...

Thanks! I worked this weekend on how to reorganize my tables, and here's what I came up with. tblTenants: TenantID First Name Last Name Previous Address City State ZIP DOB SSN DL # Phone Number Active Status tblDeposits: TenantID Security Deposit Pet Deposit tblLease: TenantID Move In Date...

So I can link my tenants to their building number, apartment number, keep a history for each of my tenants by redoing my structure to link through the TenantID? Having a history is definitely something I would like to implement later. Any suggestions on from what you've seen from my db, how I...

Here is a copy of the db if you would like to take a look at what I'm doing. Thanks! David Somers

Sorry, here it is.. had to compress it and take some extras that don't pertain to this out so I could upload. Thanks for the help! Thanks! David Somers

Here it is... Any help is really appreciated! :) Thanks! David Somers

So what am I doing wrong in my program? How do I implement the points that I made earlier? Thanks! David Somers

Well, I got it working. However, when I try to save the record (add new tenant), it does not save their Building Number or Apartment Number. The example from Wizcow doesn't explain how this aspect of it would work. Can someone please help me? Thanks! David Somers

Thanks wizcow! But I'm having a little trouble. I followed exampled 1 from the link you provided and created 2 combo boxes: cboBuildingNumber and cboApartmentNumber. I created the tables accordingly from example 1 to fit my needs (1 for building number and 4 for each building's list of apt...

Yes, I've tried demos of other rental software and in my opinion they suck. Therefore, I'm writing my own to fit my needs. I know what I need, its just that I'm learning how to do this and some things I don't know how to implement. That is why I'm here asking for help. Thanks! David Somers

Thank God for AC/DC... I've got all their CD's... hehe. Later, David Somers

I got it figured out. I had the required settings in a few columns in my table set incorrectly. Thanks! David Somers

Are there any better examples or how-to websites or anything that someone can point me to to learn how to do this? Thanks! David Somers

To further the discussion on this, I need help on a couple of things that are automated and one that has to be set to use with a command button. Here they are: 1. Set Balance to 0 at the beginning of each month and if there's an outstanding balance, add that to Prev Balance. This can be done...

I actually got it fixed. What I was trying to do was fill in half the information and try to clear it to start a new entry (ie. made a mistake on data entry). I just set the Required back to no and used the VB code and used an Undo button to clear. I guess I was trying to do it the hard way...