Recent content by lawman

  1. L

    Linking 2 sub-forms

    sorry for not understanding this fully, but.... 1. i've added CaseID in recordsource to the left subform in below db same as you did, but the vba still gives an error that it can't find CaseID member. 2. With Arrnel, his master txtCaseID is only using this code...
  2. L

    Linking 2 sub-forms

    Hi, All 3 approaches worked great. I wanted to go with MajP or Arnel as it only involved 1 step instead of 2 like Gizmos. I tried to recreate them so I understand the mechanics, but am confused why it doesn't work when I do them from scratch. 1. MajP - below is my db with your line of code...
  3. L

    Linking 2 sub-forms

    thanks guys. I'll try them all.
  4. L

    Linking 2 sub-forms

    MajP didn't work. Access automatically puts the [] around Column even if you omit it. I couldn't get .subform bit in on your suggestion. db attached with frmKeyCase being the issue i'm trying to resolve. Easy enough to refer to visible column 1 of combobox. Problem is how to refer to...
  5. L

    Linking 2 sub-forms

    Sorry, I thought that was a different site so not cross posted? Same problem there. All the solutions only work with visible data in the combobox. There is no solution for the hidden bound column 1 primary key in the combobox.
  6. L

    Linking 2 sub-forms

    thanks for the effort of making this DB. The problem is that it doesn't reference hidden column1 of the subform1 field. I can already do it with the visible CaseName field. But want to reference the primary key instead, which is not visible in bound column 1.
  7. L

    Linking 2 sub-forms

    Couldn't see an even 'on current' in subform1. Tried below but neither worked. Private Sub CaseName_GotFocus() Me.Parent.txtCaseID = Me.CaseName.Column(1) End Sub Private Sub Form_Current() Me.Parent.txtCaseID = Me.CaseName.Column(1) End Sub
  8. L

    Linking 2 sub-forms

    Hi, Tried above. There is no option for .[Column] in the expression builder. The several options include ColumnCount or ColumnHead or others, but no [Column] by itself. I entered ...[Column](1) anyway and ...[Column](0) Neither worked.
  9. L

    Expanding Note Field

    I understand. How to popup on double click?
  10. L

    Linking 2 sub-forms

    I'm following a guide to link 2 subforms. Can't seem to post the link here but mdb is attached. Aim is to have an outlook style 2 vertical forms next to each other. One master subform on left is tasks list datasheet called keydates. On right is detail of the task that has focus. The...
  11. L

    Expanding Note Field

    A popup would be okay too if expanding field isn't possible. I could perhaps place the popup in same starting place as notes field. What is the solution? Is it possible to do on focus instead of double click? Thanks
  12. L

    Expanding Note Field

    Hi, I have a datasheet form with notes field. How can I expand the notes field when it gets focus, to allow a much larger writing area, with greater height/width then when not in focus. Preferably, the expanded notes field won't push the datasheet columns to the right, but will just hover...
  13. L

    Reducing rows in sql query

    Plog. That works perfectly. Thanks
  14. L

    Pipes in MS-Access sql

    Does MS-Access allow usage of pipes in sql query? eg. ¦¦ I have a query below suggested for sqlite using pipes. When I try to use it in MS-Access, I get an error because of the pipes. What should I replace that with to make this query work? select t.students, c.name class...
  15. L

    Reducing rows in sql query

    I have below query, with 3 tables 1. Client table - (fields = ID (primary) , Surname) 2. Case table - (fields = ID (primary), Reference) 3. ClientCase-Join - joining table (fields = ID (primary), ClientID (foreign), CaseID (foreign)) SELECT Client.Surname, Case.Reference FROM [Case]...
Top Bottom