Recent content by Straylight

I will paste some of the headers and fields of the two tables being dealt with in just a short bit so you can see what I am working with. It is a lawfirm so I gotta of as you mentioned delete sensitive stuff on clients. But you understand it comepletely. Your table examples are exactly the...

I could not think of a way to use Bound Controls for what I was doing. Basically you have a Database with 50,000 clients. For each client stored in a large table there is a table called C_Notes which stores the notes and are commonly displayed as a continous form on the main front end. My...

I understood his point and read a very good article for a amateur programmer like myself on the topic of normalization. Being antagonistic like this, is unnecessary, and unappretiated. The final, much prettier code thanks to the suggestions in this thread... You can see the page flips are much...

Thank you a ton, very useful and defintely something I am going to keep in mind next time I have such a problem.

Thank you for the responses. I had to go around this and do the code very.... not elegantly.. I will post it just so you can see what I was doing. Basically I have a form with 16 identical groups of unbound controls, they are basically client notes. Normally they are viewable on the front end 1...

I have the following code... Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSQL As String Dim rs As DAO.Recordset Dim x As Integer Set db = CurrentDb Set qdf = db.QueryDefs("CNoteFullPage") strSQL = "Select * FROM CNotes WHERE CID = " & Form_PacketClients!RecordID & " ORDER BY NDate...

Ok so I have code that changes the border color of a form, it is a recordset of Notes for a client. The color changes based on if a person has a checkmark next to a "flagged" checkbox. Since it is a continous form it highlights every record if one is checked. What I want to do it highlight only...