Search results

Hi Galaxiom, I think you're on to something but I'm not sure where to look. My basic design is for a neighborhood. Address (main form)-->Family (subform M/C = addressID)-->People (subform M/C = familyID) The people have designations based on relationships within the Family--primary, spouse...

Hello Galaxiom, That's good to know! All subform containers have the property 'filter on empty master' set to 'yes'. All subforms have 'filter on load' set to 'no'. I haven't changed the property 'filter on empty master' so I think that's the default value for a subform container. The main...

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

Head smack!!! I dropped AddressID from tblPeople because it was no longer relevant; it is still in my older design. It would have been nice if Access had just said the field didn't exist.

Hi plog, Getting rid of tblPeople_1 also gets rid of calling the function make_DirectoryName. So with both of those gone, I still get the same error regarding AddressID. I don't get it, it's only referenced once in the FROM clause. What's there to cause confusion??? BTW, my directory...

Instead of stripping out tblPeople_1, I used a query based on tblPeople with the same fields in the query. I still got the same error message regarding AddressID. Wouldn't replacing the reference to the table with a query rule out it's tblPeople_1 causing the problem? Access has been so weird...

Hi Plog, I'm glad you responded. This query was based on your work you did for me for my directory. Everything was working great 2 months ago, I even printed a directory and sent this report (based on the above query) to my neighborhood. Since then I've been working on integrating the new...

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 JHB, Yes, I'm working with a test db so no problems uploading it to the group. I have my content disabled but my form still comes to the front when it's in form view. I haven't timed it but it happens on regular intervals, I'm guessing every minute. My form contains 2 subforms and 2...

Hi CJ, I'm running Windows XP on a Mac OS Mountain Lion using Parallels Desktop v 5 (I think). Not the norm, but it's how I roll :) Thanks

Hi CJ, I've commented out all of my .refresh and .setfocus in my Utilities module (runs outside of my forms). But again, I just saw my Windows desktop shimmer, so I don't think that's going to solve my problem. Do you know what runs in the background of Access? Again, I think it's a setting...

Thanks Speakers, it does seem like a timer interval, but as I mentioned earlier--all of my forms timer intervals are set to 0.

I've rebooted when I updated yesterday (OS update). I compacted the db when I uploaded my db, yesterday--so I think I'm up on everything. This has been going on for the past week at least. Here's a thought--I do have a function in a module, outside of the form, that puts the focus on a...

Definitely not clicking on any forms. How do I know if VBA is running in the background? As far as I know, I'm only calling code in "on click" events, either on the forms or control buttons. Where else could I have code running?

Another note: this only seems to happen when I form is in "form view". I haven't noticed a problem in "design view".

The TimerInterval on all forms is set to 0.

Sorry, for clarity main screen is my main form that contains subforms. It is form that automatically loads when I open my db. I'm not sure how to set a timer. Is that an event on a control? HaHa! This has been going on before today, April 1. I have antivirus protection but not sure how...

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 Mark, frmAddress has both frmFamily (m/c AddressID) and frmPeople (m/c FamilyID) subforms. When I added a record to frmFamily I didn't get a new record in tblPeople. I thought I would have at least gotten a near empty record that showed PeopleID (PK) and FamilyID (FK) in tblPeople since...

You're right! So this got me thinking, my hierarchy is: tblAddress tblFamily tblPeople So the master/child link between my frmAddress and frmFamily is AddressID. I was using PeopleID as the master/child between frmFamily and frmPeople and changed that to FamilyID. I think I'm finally on the...