Search results

  1. C

    Open/Close Outlook within Access

    Background: I manage an Access 2016 db for our local food pantry, which is staffed by (mostly senior and mostly PC-neophyte) volunteers. I mention this since my approach is to make the db interface as user-friendly as possible. Problem: I've recently added a feature that allows our volunteers...
  2. C

    Strange Gremlin in Search Field

    This may not be appropriate for this forum, but I'll give it a shot. I am the administrator for an MS Access 2016 database for our local food pantry. It's been working well for the past 6 years, except for one (minor) quirk: When a string of characters is entered into the search box to find a...
  3. C

    Delete all data from field?

    A database at our Food Pantry needs to be updated yearly on Jan. 1 by eliminating all data in two fields: "ID Check Date" (date field) and "Signature Obtained" (check box). There are hundreds of records. Is there a way to remove the data from the two fields (columns) while retaining the fields...
  4. C

    Automatically Run Access 2007 Report

    I'm rather new to Access, so forgive my inexperience. I've just created a database for a food pantry to keep track of data on clients, their families and food deliveries. We need to produce monthly reports of activity as a requirement of our grant. I've designed the report and it works great...
  5. C

    Use List Box to Open Form

    Please help me with a problem I'm having constructing a database for a local food pantry. As an Access 2007 beginner, I can't figure out how to link names of clients in a list box to the chosen Client Data Entry Form. My list box is in its own form, with its contents derived from the first...
  6. C

    Find last date in series and test is within range

    Hi- I new to the forum and new to Access, so please forgive any transgression or lack of experience. I am constructing a db in Access 2007 for a local food pantry and am having a problem constructing a query that will return those records of clients who have picked up food in the last 30 days...
Top Bottom