Search results

Yeah, I'm interested in that too. I'd just assume it to save subform information when I click my subform's add button and save main form information when I click my main form's add button. Thanks! David Somers

Could it possibly be something wrong with my design? Somebody please let me know. Thanks! David Somers

The error I keep getting is 'You cannot change or add a record because a related record is required in table tblTenants'. Can someone look at my db posted above and advise me where I'm going wrong and what I need to do to fix this? Thanks! David Somers

Do you all think that if I added DepositID and ApartmentID from tblLease and BuildingID from tblApartmentInfo to my NewTenantQuery that it would correct this error? Thanks! David Somers

Oh yeah... sorry... :) Later, David Somers

You can enter the row source from the form properties under Data/Record Source. The AfterUpdate option you'll have to go to the form properties/All/After Update. When you click on After update select Event Procedure and click the '...' to enter the code in the VBA window. Later, David Somers

Nevermind.. I got that fixed I think. I had to add tblApartmentInfo.BuildingID instead of tblBuildingInfo.BuildingID. So you were correct. It will let me input an apartment number now. However, now when I try to add a new tenant it gives me an error about duplicate information. I have add new...

Here's what I've put in: SELECT tblApartmentInfo.ApartmentNumber, tblBuildingInfo.BuildingNumber, tblBuildingInfo.BuildingID, tblDeposit.SecDeposit, tblDeposit.PetDeposit, tblLease.MoveInDate, tblLease.LeaseStartDate, tblLease.LeaseExpirationDate, tblLease.AdditionalRent...

Nevermind, I figured it out. However, there's still a problem. Here's my record source for my subform: SELECT tblApartmentInfo.ApartmentNumber, tblBuildingInfo.BuildingNumber, tblDeposit.SecDeposit, tblDeposit.PetDeposit, tblLease.MoveInDate, tblLease.LeaseStartDate...

Please forgive me for asking this question because I'm pretty new to Access programming. How do I enter those into the record source? Thanks! David Somers

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

What I've found out is when I go to the form properties and changed recordset type to Dynaset (Inconsistent Updates), it would show a blank form but when I try to hit add to add the new record it give me an error that says: "You cannot add or change a record because a related record is required...

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

That is no problem. I appreciate all the help you have given me. In fact I have been reading up on my relationships, and I've changed my relationships again, but still cannot get it right where the items will show on the form. I have made a flow chart for the program I'm trying to build. Here...

Well, I use Winzip. But you want to get your database small enough that when you "zip" it up, it is less than 102400 bytes (102kb). When you add a reply, there's an option to attach a file. Hit the browse button and browse to the zip file you created. Double click it and the pathname should be...

For transporting my db around, I have a USB Flash ROM (aka Pen Drive). It has 128MB storage space which is plenty of room for my db and supporting documents. I got mine for like $69. Later, David Somers

Well, I've tried to figure out the relationships in my db. I think I've screwed it up pretty badly. I've attached a copy of my db. Can somebody please take a look and tell me what I'm doing wrong? Thanks! David Somers

My recordset is set to my New Tenant Query which is the one I created for the form. As far as the relationships go, I've tried to create the relationships that I think would make sense. However, I don't know if I've got them right. I basically linked each PK ID with the FK ID that corresponds to...

When I created a query called New Tenants Query and selected the fields I wanted from my tables (about 4 different tables), and set that as the record source for my form, it still come up with a blank form. Any ideas? Thanks! David Somers

I've determined the problem with the items not showing. When I add fields from more than 1 table, the fields do not show. When I add fields from just my tblTenants table, the fields show. Not sure why that is or how I can get it to where when I enter a new Tenant I can put their information in...