Recent content by DreamingSpires

  1. D

    How to report on many to many relationship?!

    Hi Lizzy Can a person only belong to one group? And can a folder only belong to one group for FullRootAccess and one group for ReadOnly?
  2. D

    Error when leaving out Client ID field

    Why not have a button on your Rental form 'Add New Client' that opens a pop-up modal form bound to your client list table with fields for the client details you need to fill in? Have that form open in 'add new record' model. When you save that form, it'll close and create the new client. If you...
  3. D

    Navigation combobox on subform ignoring subform's master-child relationship

    Hi Paul, thanks for replying! The primary key is autogenerated when a new record is recreated. I had understood that it was best practice to not have the PK be something that users filled in themselves. As the PK is fairly meaningless to the user, I then had no reason for it appear on the form...
  4. D

    Navigation combobox on subform ignoring subform's master-child relationship

    I'm in a bit of a pickle with navigation combo boxes; can anyone help? I have a form, frmProjects, with a continuous subform, sfrPeopleOnThisProject. They have a master-child relationship. The form shows one Project record at a time, while the subform shows all the People records for that...
  5. D

    Hello!

    Hi everyone. I've found myself here so many times over the last month while trying to learn Access for work that I thought I should join to be able to say thank you! Now just need to remember where all those awesome posts were...
Back
Top Bottom