Search results

  1. S

    Solved Best practices -- One-to-One table vs keep in same table

    I'm working on restructuring an Access database at work, and I'm curious if there's a 'best practice' in this scenario. In this database, there's a table of customers and a table of reps. All active customers get listed in our directory with a primary rep. There can only ever be one directory...
  2. S

    Solved DSum issue when using dynamic criteria

    I have data like this: ID Item Qty 2 Item 1 2 3 Item 2 1 4 Item 1 1 5 Item 3 5 On a report, I want to return the quantity of the current item. That is, if the current record is Item 1, I want to get 3. The items aren't linked to IDs (e.g. Item 1 doesn't always have an ID of 53)...
  3. S

    Solved Subform Record Source - Method or data member not found

    I have a dynamic query which is generated by a function (it updates every day). When my parent report loads, I want it to pull in the subreport using this query. Currently, I'm using this code: Private Sub Report_Load() Dim dailyQ As String dailyQ = GetDailies() S_RecurSub.SourceObject =...
  4. S

    Query that excludes entries from last year if they have registered for current year

    I am trying to run a query as a mail merge source. The purpose of this query is to pull up a list of anyone who sponsored an event last year, and to exclude from that list anyone who has already signed up to sponsor the event this year. Essentially, I'm filtering to people who sponsored the...
  5. S

    Solved Error referring to object in form with query as record source

    I have a continuous form filtered to a query, so that it only shows entries where the inactive box is NOT checked. When I click a button, I want the current record to update to change the value of the inactive field to 'true'. The query which is the record source for this particular form looks...
  6. S

    Solved Get value from first column of listbox

    I am basically trying to create my own wizard using an Access form. On the first step, the user needs to make a choice between two types of events. Because this is a wizard, I don't want to store the value they choose in my database, but I *do* need to use the choice to call something else. I...
  7. S

    New but excited to learn a new tool

    Hello! I'm an experienced Excel wrangler but only recently learned about the magic of Access through my new job and am LOVING it so far. Now I'm using it to build a database for an event planning business I want to start. Happy to meet you all!
  8. S

    Solved DLookup in form with multiple criteria not returning expected value

    I am trying to display information in a form using DLookup based on multiple (in this case two) criteria. The form is linked to an event table but is referencing a related table (in this case, a junction table it shares with a customer table). For the purposes of troubleshooting, I'm using...
Top Bottom