Search results

Hi All, I am running Parallels on my Mac to create a dual platform since MS hasn't released a Mac version of Access. My computer is getting slow, so I loaded Mac's version of Word and Excel and removed them from my Windows side so I have more space for Access. Now Access is complaining that...

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

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

Hi All, Back in February I had posted that I had made numerous changes to my form and all of the sudden it started to only show some of the records. I tried changing all of the settings, that I could remember, back to the way they were and I still had a problem. Someone suggested I might have...

Hello All, I'm trying to open a query and I keep getting the same error message: "The specified table 'tblPeople.AddressID' could refer to more than one table listed in the FROM clause of the SQL statement." It seems to me tblPeople.AddressID is very specific and can't be confused for...

Hi All, I've searched the forum for a screen refreshing issue. I'm using Access 2007 and I'm not using a tab control. I did use a tab control but dumped that design. My screen keeps refreshing about every minute. When I'm in the modules writing code, all of sudden I'm back to my main...

Hi All, I've been stuck on this for days and I'm still stuck. :banghead: I have a main form (Neighborhood). Within it I have a subform (Family)--master/child link AddressID, within Family I have a subform People, master/child FamilyID. I need the Family subform to display a list of families...

Hi All, I've posted another question to the Forms forum regarding subforms and that led me to trying another solution to my problem. I have a main form, a Family subform, and now a Neighbors subsubform. When I open the main form to test this new design, my Neighbors subsubform doesn't show...

Hi All, I have code that's not working and decided maybe it's me (and not the code). Based on the result of a combo box on a subsubform (Non child/child), I'd like to show and hide fields. i.e. I'd show an anniversary date for an adult rather than a birth date for a child. This worked when...

Hi All, This worked: Dim frmNeighborhood As Form Dim sfrmNeighbors As Control Set frmNeighborhood = Forms("Copy of Neighborhood Input Form") Set sfrmNeighbors = frmNeighborhood![Neighbors] This doesn't: Dim frmNeighborhood As Form Dim sfrmFamily As Control Dim sfrmNeighbors As Control Set...

Hello All, I've attached my db. My main form is Neighborhood Input Form. On that form I have subforms. There is one, Family subform, I've recently added and can't seem to get it to work how I want. Let me start from the beginning Original design: one family per address New design...

I posted another issue, then realized I've got bigger problems. My form isn't showing all of the results of the underlying query. It used to show all people living at an address and now I'm only getting the first person. The query is correct, the form isn't. I've removed all event procedures...

Hi All, Evidently I was trying to "improve" the look and security of my subform and I've changed something -- I don't know what. Now, I've set myself back when trying to get things working. I've attached a screen shot so you can see my form. The upper right subform is the Family subform...

Hi All, I've been using this code for years without problems (or so I think). I've added another table to my array and incremented my variable. When I step through the module, sqlstr returns a rec for tblFamily but the delete statement doesn't delete the record. I've copied both sqlstr and...

Hello All, I've attached a screen shot of my forms. I currently have my family subform (upper right hand corner) linked to my main form on AddressID. To show all of the families associated with an address. There are two families. I'd like to link my people subform (big subform) linked to my...

Hi All, I had a form (Address) containing a subform (People) and the main form was based on a query, qryNeighbors--everything worked. Then I realized I actually needed a tab control to show multiple families living at the address. So each tab would represent a family and contain the subform...

Hi All, I have a working db, forms, and code with a minor glitch. I have a main form for street address and subform for the family. A problem arose when I had 2 families at one address; also, when I have an owner and renter--so multiple families per address is causing me a problem. I thought...

Hello All, I'm new to the tab control. I've placed a tabbed control on my main form and populated it with my subform (which also contains subforms). Now my OnLoad for my main form isn't working. I've looked online on how to reference the subform and it seems simple subformname.sourceobject...

Hi All, I realized I need another table in my established db to go between two other tables. The new table, tblFamily, has one PK and two FK for the other two tables: tblAddress--->tblFamily-->tblPeople tblAddress: PK AddressID tblFamily: PK FamilyID tblFamily: FK AddressID tblFamily: FK...

Hello All, I'm trying to create a neighborhood directory that will show both spouses' phone numbers. The report is based on nested queries. My tables have a one to many (12M) relationship: Address (pk=AddressID)-->People (pk=PeopleID)-->Phone (pk=PhoneID) In the Directory, my goal is to have...