Search results

  1. C

    Issue with foreign key field of subform

    I have a database that's tracking funds owed by customers and there is some erratic behavior occurring. To put this in a sort of real-world scenario, imagine I'm paying bills on behalf of people and those people, in turn, owe me money. So, I might list John Doe owes me for Netflix, Comcast...
  2. C

    Multi-Value ComboBox Selections

    I found a snippet of code online that I'm trying to use in an asset tagging database I'm developing, but I'm struggling to get it working. To start, I have a multi-column ComboBox that displays information in this format: 1001 | iPhone5c 1002 | iPhone5s 1003 | iPhone6 1004 | iPad2 1005...
  3. C

    Working with recordset - is there a cache that needs to be cleared?

    I have a Public Function that is being auto executed when my database opens. It is designed to change the value of a record from "Trailing" to "Critical" when the record is older than 90 days. Everything works as expected initially by changing the status and adding some text to a comment field...
  4. C

    Displaying results of a Select statement

    Good afternoon, all. Need some assistance. I have a database with several one-to-many relationships and a nested subform based off of those relationships. Relationships are as follows: One Lender to Many Relationship IDs One Relationship ID to Many Tax IDs One Tax ID to Many DocumentsRequired...
  5. C

    Stumped on looping

    I've been searching for an answer to my specific problem, but I've finally conceded defeat and need some assistance (I'm still relatively new to VBA). I have a database that tracks exceptions for different loans. The loan record is in one table and the exceptions are in a different table because...
  6. C

    Introduction

    Hello! Just following the instructions I received when I signed up today. I'm an Access lover - I like learning the complexities of how it works. I'm pretty good with most of the basic Access functions, but I'm pretty new to all things VBA. I would LOVE to know more than I do. Thinking...
  7. C

    VBA Code doesn't review all subform records

    I'm having some problems with VBA code I'm writing that references a subform. I'm pretty new to VBA and am not sure what the problem could be. The parent form (TrackingForm) tracks dates different tasks were completed. The subform (Child2) tracks exceptions that also need to be marked completed...
Top Bottom