Search results

  1. B

    Subform field not saving when navigating to other record

    Hi everyone, its been 4 years since I've had to build a database and there is something I can't figure out. frmActiveDesign is my main form and I have 3 subforms (single form combo boxes) sbfrmBranch_ActiveDesign, sbfrmConsultant_ActiveDesign and sbfrmPM_ActiveDesign. There are also a few...
  2. B

    Filter records depending on subform's value?

    Hey all, got an answer from a different source so I'll share it. The dialouge box that asks for a value for "tblManagers.ManagerName" comes up because there isn't a field ManagerName in my record source! My form is based on tblProjects, and ManagerName isn't a field there! So what I needed...
  3. B

    Filter records depending on subform's value?

    Hello all, Description: I have a database that tracks Construction projects. Each project can have multiple Managers, so I have a many to many relationship set up with tblProjects, tblProjects_Managers and tblManagers. I created frmProjects and sbfrmProjects_Managers. sbfrmProjects_Managers...
  4. B

    Have table-level MVF-lookups, how can I fix it?

    hey jdraw, I did read through it, but it seemed to deal mostly with Normalization which wasn't really my issue. I knew that my tables weren't normalized, and I knew what they would look like if I did normalize them. I just didn't know how to build forms from the normalized tables that would...
  5. B

    Keeping Track of data

    I think you should go to the Suppot section of the official Microsoft Office website. I'm extremely new to Access too, and before I did anything I watched every single video on the official site. It really helped explain the ultra-basics for me.
  6. B

    Looking for some advice

    On the top of the window there is a "Create" tab. Create a table, seach normalization here or on google and keep the info in mind when you're making the table. Once you're done, select the table where it is listed on the very left side of the screen. Now, on the "Create" tab, create a form. You...
  7. B

    Have table-level MVF-lookups, how can I fix it?

    Hello, I've been having a bunch of problems with the database I'm designing, and it seems like whenever I solve one of them I cause another. I've decided to take a more holistic approach by simply showing what I'm working with and asking what I can do to make it better. The thing is, from...
  8. B

    New, wanted to know if this is acceptable to do here...

    Hello! This is my second post here, the first being in a thread I started in the Introduce Yourself section. It was my responsibility over the last month at my place of work to learn how to create a database from scratch, then use the old Word and Excel files to create an Access database...
  9. B

    Hello from HI

    Hey guys! Brand new to Access, actually went in for an interview a few months back, addmitted to never having used Access before, then got hired to create Access databases. Been on the job about a month now and just finished up my first 3 databases, and I'm looking for a community to help me...
Back
Top Bottom