Search results

  1. H

    Bypass Shift Key at Startup

    Hello, I am able to bypass the shift key so I can disable ribbon and all menus at startup. But the issue I have is anytime someone makes a copy of the database or it is their first time opening it they get prompted with the security warning: "Security Warning - some active content has been...
  2. H

    How do I use "LAST" in query?

    I have a table with 4 fields PaymentID(autonumber PK) / PaymentPayer / PaymentDate / PaymentAmount I want to do a LAST of query on PaymentDate to find the last payment date for each customer When I set LAST under totals in the query on the Pay mentDate field it returns every row as if LAST is...
  3. H

    Last Row only by Month

    I have a table set up like: CUSTOMER ID / CUSTOMER NAME / PAYMENT ID / PAYMENT DATE Only want to show the last of each payment per month in form based on query. So if they have a payment in April of $900 on 4/15 and then a payment in May 5/2 $500 and May 15 $1000 It will show two rows...one...
  4. H

    HELP PLEASE! - Multiple Different Queries as Recordsource for one form

    Hi everyone. Thanks in advance for help. I have a query that I am using as recordsource for a form. I also have a list box that I am using to change records on the form. My issue is I need to use the same form for similar queries. For example, I want to open the form with only "Manager1"...
  5. H

    Question Validating Two Fields against each other PLEASE HELP!

    Hi, I am trying to validate two fields in a form against each other. Neither are required, but If one is filled in, then the other must be filled in. If neither is filled in then they can both be blank. It is for a time, and description related to that time. So if they enter in 5 hours, they...
Back
Top Bottom