Search results

This may be a clue as to why I'm stuck. When I look up someone, I write their familyID to an unbound textbox. I need the bookmark to align the familyID in the textbox to the actual form. This writes the value to the unbound textbox: famsubformname!txtbookmark.Value = rs1(1).Value...

I'm still stuck on bookmarks. Not sure why they stopped working.

That is very cool! Hopefully, I can use it in another project. Do you have any tricks or caveats regarding bookmarks?

Sorry, Set rs1 = db.OpenRecordset(sqlstrall) works

In this instance I'm looking for people with the same name (LastName = 'Jones') in my db through my subform. The first recordset never moves me to the next person, it always starts over and shows me the first person. My thinking is have a recordset within a recordset and the starting value of...

Actually Set rs1 = db.OpenRecordset(sqlstrall) might work if I could get my bookmarks working subformname.bookmark = rs1.bookmark

The last line of the code is where the error is being generated. Set rs1 = rs.OpenRecordset(sqlstrall) This didn't happen when I used "Set rs1 = db.openrecordset(sqlstrall)" but I didn't get the results I was looking for either.

Hi All, I thought opening a recordset (subset) within a recordset would be straightforward--evidently not. Here's what I have: Dim db As Database Dim rs As DAO.Recordset Dim rs1 As DAO.Recordset Dim sqlstr As String Dim sqlstr1 As String Dim sqlstrall As String ..... sqlstr = "SELECT...

Hi CJ, Thanks for all your help. I finally got my forms to work again!!! I kept my original design but changed the m/c links between frmFamily and frmPeople to FamilyID and dropped the PeopleID from frmFamily. I did update my table relationships as you suggested. I spend yesterday coding...

Hi CJ, I had a 'Move' button for when someone moved within the neighborhood. I just dropped it recently bc I've never used it. I would re-instate the 'Move' button. The 'move in' date goes with the new family's notes not the one that was deleted--their notes are deleted. The 'list' is a...

Hi CJ, Thank you for the in depth analysis! I've been trying to wrap my head around the list box idea. I like it and it does get rid of a subform. Thanks for the SQL statement. Here are the answers to your questions: Yes, this is correct I use the relationships when I make the...

Hi CJ, So if it's one table per form/subform, then my underlying query should just be a table? My current underlying query for frmPeople is qryNeighbors that contains four tables. Two of the tables provide the info for drop down boxes on the frmPeople. The other two tables show the the link...

Thank you CJ!!! I was thinking about your last post and I've been banging my head against trying to figure out my relationships. I think it's a design issue in my underlying queries because when my form was working, FamilyID wasn't being written to tblPeople, so I already had issues, but at...

Thanks JHB, that makes sense but I'm not a graphics user. I don't even have PP loaded on my computer.

Hi CJ, I'm missing something here. If I have my M/C FK set to Family, then all of the people have the same phone number and email address as the "primary". By having the M/C FK set to People, I'm able to record individual phone numbers and email addresses. How do I get around this? You...

Thanks Cheeco, I'll check out the db. JHB--I have no idea how to show screen shots of forms that aren't doing what I want them to do. The neighborhood input form is the way I want it to look, but on frmPeople (the big subform that contains the sub-subforms for phone numbers and notes)...

Hi JHB, I removed the PKRelationship=1 from qryFamily and my frmPeople is still showing only the "primary" for each household. I have the master/child for frmPeople set to PeopleID. frmFamily should be the only form showing the "primary". Some households have more than one "primary"--two...

Hello J, Thanks for the database! I'll start digging in and see if it can help me.

Hello CJ, Unfortunately, you're not the only one to tell me I haven't thought this through. Evidently, I'm dense because to me it's clear. The family is a collection of people living at one address but doesn't contain their individual information. You are correct, I am linked on PeopleID...

Hello All, I've posted this problem in February and May and I still can't get around it. Here is my basic set up: Address (main form)-->Family (subform M/C = addressID)-->People (subform M/C = PeopleID) The people have designations based on relationships within the Family--primary, spouse...