Search results

  1. E

    DSUM Criteria to exclude a null field

    I am trying to use a DSUM function in a form that I've got working with a few critieria. But I want to add one more criteria (with an 'And' function) for a field that usually contains a price (Currency) but may contain nothing (null). I want the DSUM to exclude the Null. My function that...
  2. E

    Applying one 'global filter' on a form that remains while I apply other filters

    My database is a large dataset that contains RFQ data for my part numbers from multiple customers for multiple years. I have a form (with subforms) that displays one record at a time and subtotals calculations in the header (like total value of the RFQ). I would like to apply a drop down combo...
  3. E

    Creating a Task in Outlook with Access VBA

    I've found this code on-line and tried to adapt it to my Access Database. I want to Create an Outlook Task. But for some reason this code is creating an EMAIL! I can't figure out why. Any clue? Private Sub Command202_Click() Dim OlApp As Object Dim OlTask As Object Set OlApp...
  4. E

    Hi All

    I've been using Access since the 90's for VERY BASIC at home functions. I find it kind of fun. Recently I started using MS Access to help me manage many data files at work. I've started using Macros and some basic VBA code- usually i copy from various posts and figure out how to apply it to my...
Top Bottom