Search results

  1. S

    Help with DLOOKUP

    Hi All, I'm still learning the some formulation in Access (my head is still stuck in Excel mode). I'm tyring to use the DLOOKUP function (my understanding is this works similar to VLOOKUP in Excel), but I'm having difficulty understanding it. I have two tables, and I wish to run a query...
  2. S

    Make fields visible in a report based on criteria from a form

    Hi All, I'm kinda stuck on something. I'm trying to make fields either visible or invisible based on criteria chosen in a form. I have a table with five fields, call "Sign Selection" Field 1 is called "Window banners" Field 2 is called "Theme pennants" Field 3 is called "Exterior banner"...
  3. S

    Prompt to select certain fields to show on a report

    Hi All, So far, you have all been so much help for me and I thank you :) So, here's my dilema: I have a report (based on a query) that shows Store number, City, State etc, followed with Field1, Field2, Field3 etc. Pretty simple stuff so far. What I'd like, is when the user runs this...
  4. S

    Update a field based on any changes in a that record

    Hi All, Still fairly new to Access events and triggers, and trying to get my head around it all. I have a field called "date_modified" (I know, so original). I'd like to set up an event that will automatically update this field to the current date if any other field in the same record has...
Back
Top Bottom