Search results

  1. D

    Items not showing on forms

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

    Resetting Fields with macros

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

    Resetting Fields with macros

    Here's the 97 version. Thanks! David Somers
  4. D

    Resetting Fields with macros

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

    Resetting Fields with macros

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

    Resetting Fields with macros

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

    Resetting Fields with macros

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

    Resetting Fields with macros

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

    newbie: cascading combo boxes

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

    Resetting Fields with macros

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

    Resetting Fields with macros

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

    Resetting Fields with macros

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

    newbie: cascading combo boxes

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

    newbie: cascading combo boxes

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

    Resetting Fields with macros

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

    Required field error message

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

    Required field error message

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

    newbie: cascading combo boxes

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

    Resetting Fields with macros

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

    Setting Clear Button

    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...
Back
Top Bottom