Search results

Would this not violate the second normal form? If I have: tblRedeemed PropertyID (PK) RedeemedDate AmountReceived RecordedDate But then put these in the main table to make it look like: PropertyDetails PropertyID (PK) All the property info fields Redeemed (Y/N) RedeemedDate AmountReceived...

Stage 1 is pretty much the Property Details table and happens before the information is even entered into the database. Researching all that information and buying the specific properties is Stage 1. I do research into ~500 properties on a slow month and ~1800 properties on a busy month. Only a...

Sorry, I didn't do enough research. I just realized that I can put an expression in the "Update To" box and that was my missing link.

Also, I just want to thank you all again. Your help is immensely appreciated.

It's only confusing because this is forcing me to think about data in a new way and I'm constantly reevaluating how I have my data organized. I don't consider this a bad thing. I appreciate your response. This is good to know. However, this is where I have to apologize because this one is on...

I need to add an entire field's worth of records from one table to another, without adding new rows of records. Would the best way to do this be to use a create table query with all the fields and just replace the old table?

Ok, so I think it's this concept that I'm having trouble wrapping my mind around. I think I need to go into more detail (I was trying to keep things simple, but that seems to be a mistake) in order to give a better example of how my tables are set up, so that you may see my thought process...

I do actually have the stages separated out into different tables already. If anything, I think I've actually over normalized some of the tables, creating multiple tables with one-to-one relationships. For instance, I have a table (tblRedeemed) for when an investment gets redeemed, or bought...

Without going into too much detail, we are a law firm and investment company. Our investments mature over the course of three stages. The first stage requires research and acquiring a piece of land, then waiting for a certain length of time. The second requires just a little legal work. The...

Each checkbox would correspond with a different record. So, CheckboxA would record current date for FieldA CheckboxB would record current date for FieldB Checkbox C would record current date for FieldC, etc.

One more question. It doesn't seem like I could do this for the If Then statements that are click events, but if I wanted to do this for multiple checkboxes, is there a way to combine all those If Then or Else statements in the form's current event? Or do I have to make new statements for each...

That worked beautifully. Thank you for your help pbaldy. You helped me figure it out without just giving me the answer. I appreciate it.

Can I combine the two? For instance Private Sub Form_Current() If IsNull(Me.txtPublicationMotionFiled) Then Me.chkMotPub = False Else Me.chkMotPub = True Me.chkMotPub.Enabled = False End If End Sub

Yes, that does help. Thank you. So I have Private Sub chkMotPub_Click() If Me.chkMotPub = True Then Me.txtPublicationMotionFiled = Now() End Sub Is this the correct code so the form checks to see if a date is already entered, so that when I change records or load the form, it doesn't...

I think this should be relatively easy, but I still don't have a grasp of VBA/Macros enough know exactly how to do it myself. I want to be able to click a checkbox and then for the form to put in today's date in a related record. For example: "Paperwork X Filed:" *clicks checkbox*, then in the...

Ok, good, so this is how I have it set up currently, as each stage has its own paperwork, dates, and other benchmarks it needs to hit before proceeding.

I see. That makes sense. I appreciate you clearing some things up for me. I've been doing a lot of reading and video watching and without someone to help clarify some things with, it's easy to misinterpret. Another follow up for you then. My company deals with investments and these investments...

So if there's just one "AssessoryValue" data point per property, then it's not worth it to place that in a separate table? Even if something like 70-80% of those records are blank? Is it fine to have a table with 30 (what about 60?) different fields, as long as all of those fields have a...

Trying to figure out how to break up a table I've imported from Excel. The table has 32 fields and 85%-90% of the fields are filled in with data. Here is the table broken down by field: tblPropertyDetails PropertyID Client Tag DateAquired County ParcelID ParcelLink PreviousOwner PhotoLink *...

I'm a newbie trying to understand VBA; mind if I try to break down your code and see if I understand it well enough? dim rs as dao.recordset declaring "rs" as a record set data access object if me.dirty then me.dirty = false What is the point of this? If the form has been modified since it was...