Search results

  1. J

    Need feedback about database design decision (Access 2007)

    Dear Galaxiom and Lightwave, Thank you so much for your feedback. I'm glad that my original idea was on the right track. Thanks to John Big Booty on this forum, I now know how to base forms on junction tables. I could never get junction tables to work right in the past, so I just didn't use...
  2. J

    Need feedback about database design decision (Access 2007)

    Hi, I'm working on an educational program database using Access 2007. I'm currently designing Version 2. I made Version 1 when I didn't know much about database structure, and it's currently in production. A problem I'm having with Version 1 is that students have multiple entry and exit...
  3. J

    Subform Based on a Junction Table

    That worked perfectly. Thank you so much for your help!
  4. J

    Subform Based on a Junction Table

    John, I can't thank you enough. The advice you gave me about OpenArgs just solved a problem I've had for years. If you wouldn't mind giving me one more piece of advice I'd really appreciate it. My subform is now populating with the foreign key the way it's suppsed to. I have a link criteria...
  5. J

    Subform Based on a Junction Table

    Hi, I'm working with Access 2007. I've designed a subform based on a junction table. The subform is not embedded on the main form. It's called from a command button on the main form. I put some VBA code in the command button that links the record, so that the main and subform show the same...
  6. J

    Question Trying to Design a Split Database Access 2007/SQL Server Express

    Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I've been researching this for awhile...
  7. J

    Question Access 2007 Create E-mail/Manage Replies Features

    Hi, This is my first post on this forum. I've been reading it, since I discovered it. Thank you all for the work that you do here! I've been using Access 2007 for a couple of years, but did not discover the Create E-mail/Manage Replies features on the Collect Data tab until yesterday. I did...
Back
Top Bottom