Recent content by mkranz

  1. mkranz

    Calculating the number of days between dates.

    Hello Rich; Thank you for responding so quickly, but I'm not sure how to apply your suggestion (Q149127) to as a calculated field on a form or report. What I need to know is the elapsed number of days from when a customer places an order and when it ships; less weekends and holidays. Perhaps you...
  2. mkranz

    Restrict certain RECORDS by password

    What MS Access version are you using and what is the method your supervisors use to "logon"? Also, what is the extension of your application; is it an mdb or mde?
  3. mkranz

    Calculating the number of days between dates.

    On a form how would I calculate the number of working days between a range of dates that doesn't count Saturdays, Sundays, or holidays for example: from Septemer 1, 2002 to September 7, 2002. The answer I want Access to return would be 4 working days. I know Excel can do it like this...
  4. mkranz

    Sending a report or form by e-mail

    In the database windo click on the "Report" tab. Find the report you want to send and open it in preview. Click "File" on the command menu and choose "Print". In the Printers box choose "Microsoft Fax". This should work if you're running Windows 95 or 98 2nd. If you're using Windows NT 4.0...
  5. mkranz

    Use Access "mail merge report" and print other documents.

    I print out customer letters sorted by state through an Access query. There are other forms unique to those states represented as hypelinks the the same query (some states have more than one form). I'd like to prinout the customer letter and a form unique to that state. The result I'm looking...
Back
Top Bottom