Search results

  1. R

    Access Form with grayed out Subform

    This thing (DB) is just too big & convoluted. No way for me to make sure I'm completely protecting participant personal information while getting you all the pieces you need to figure out a solution. Thank you again to those who offered help if I posted the DB, but I'm just not savvy enough to...
  2. R

    Access Form with grayed out Subform

    Hey All - still have the same issue & cannot really post the database because it contains personal information for many participants in our program. There are two parts to our training program that run identical databases. One has this problem I'm trying to correct and the other doesn't, just...
  3. R

    Access Form with grayed out Subform

    Oh, right, thanks for clarifying. New photo attached in which you can see the issue described. Lots of records in the DB and I can access all through tables and queries, but this particular subform is "locked". Although everything I can find in design views says it's not locked and allows...
  4. R

    Access Form with grayed out Subform

    For that example record it is correct, but other records contain more courses (new & historical) which show up in that lower form. I can scroll through all the records, I just cannot input anything like I used to be able to do. The "new record" button remains grayed-out and I cannot enter or...
  5. R

    Access Form with grayed out Subform

    Good idea...same thing happened with working database. At least it helps narrow things down, I think. Must be an issue within the table(s). I'll keep at it, thank you!
  6. R

    Access Form with grayed out Subform

    Hey Ranman - Not sure what you mean by "1 table too many". We've been using this DB for years without issue, nothing has been changed (intentionally). I see no evidence that anything is disabled or locked, the subform is linked to qryCourseDetails which is working fine (enabled & unlocked)...
  7. R

    Access Form with grayed out Subform

    Hey All - Our student records database (Access 2003) is working fine aside from this annoying, recently developed issue; we have a Form showing student records and an integrated subform showing student class records (hopefully a photo is attached). The main form works fine, we can enter new...
  8. R

    Old dog learning new tricks

    Hey All - I'm familiar with Access, but not as much as I want to be. Been using an old Access DB (previously set up) for years now at work. I can do the basics behind the scenes and a little more. Doing more DB work these days which is pulling me from my real job so I thought I'd dive in...
Top Bottom