Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Aran10

    Access VBA to exclude holidays and weekends from a datediff formula

    Thanks for the suggestion, but is there a way to do it with my current field setup using Vba or a query?
  2. Aran10

    Access VBA to exclude holidays and weekends from a datediff formula

    There are loads of these over the web, but none that would work for my table "Public Function DateDiffW(BegDate As Date, EndDate As Date) As Integer 'Returns number of days, excluding Saturday and Sunday 'As written, counts both BegDate and EndDate, e.g., 'Monday - Friday would count as 5 days...
  3. Aran10

    Undefined Function Error

    what references do i need selected for the vba to work?
  4. Aran10

    Undefined Function Error

    Option Compare Database Public Function DateDiffW(BegDate As Date, EndDate As Date) As Integer 'Returns number of days, excluding Saturday and Sunday 'As written, counts both BegDate and EndDate, e.g., 'Monday - Friday would count as 5 days 'coded by: raskew Const SUNDAY = 1 Const SATURDAY = 7...
  5. Aran10

    HELP VBA DOESN'T WORK

    I copied and pasted this Vba into access with my tables http://www.tek-tips.com/faqs.cfm?fid=4531 I then made a query with the following functions The date due expressions can then be calculated by: - Creating a provisional date due field and using this expression: Provisional Date Due...
  6. Aran10

    Help with my Vba doesn't work

    I copied and pasted this Vba into access with my tables http://www.tek-tips.com/faqs.cfm?fid=4531 I then made a query with the following functions The date due expressions can then be calculated by: - Creating a provisional date due field and using this expression: Provisional Date Due...

Part and Inventory Search

Back
Top