User Profile

Collapse

Profile Sidebar

Collapse
JMichaelM
JMichaelM
Last Activity: Nov 2 '16, 08:53 PM
Joined: Aug 3 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JMichaelM
    started a topic Auto Number Module for Query
    in Access

    Auto Number Module for Query

    How do I get the number to start at 1 and not 0?

    Option Compare Database

    ' Declaration section
    Public AutoNumber As Long

    Function SeqAutoNumber(i As Variant) As Variant

    SeqAutoNumber = AutoNumber
    AutoNumber = AutoNumber + 1

    End Function
    See more | Go to post
    • JMichaelM
      replied to VBA Date Problem
      in Access
      Already figured it out thanks.
      See more | Go to post

        Leave a comment:

      • JMichaelM
        started a topic VBA Date Problem
        in Access

        VBA Date Problem

        I am having great difficulty trying to resolve this. WCCNF1 should turn to yes for previous dates in 2015 not 2016. I cant get it to work using -1. If Year = 2015 it should turn to Yes. Can anyone help me?
        If (Year(Nz([WCCClmDt1])) = Year(Date)()) Then
        WCCNF1 = "Yes"
        ElseIf (Year(Nz([WCCMRDt1])) = Year(Date)()) And _
        (Year(Nz([wccmrdtwgt])) = Year(Date)()) And _
        (Year(Nz([wccmrdthgt])) = Year(Date)())...
        See more | Go to post
        • JMichaelM
          replied to Field Validation using date range for current year
          in Access
          Im trying to integrate into the current logic but it is turning to yes for each year. If its 2017, it should be for previous year.


          If (Year(Nz([WCCClmDt1])) = 2016) Then
          WCCNF1 = "Yes"
          ElseIf (Year(Nz([WCCMRDt1])) = 2016) And _
          (Year(Nz([wccmrdtwgt])) = 2016) And _
          (Year(Nz([wccmrdthgt])) = 2016) Then
          WCCNF1 = "Yes"
          Else
          WCCNF1 = "No"
          End If
          See more | Go to post

            Leave a comment:

          • JMichaelM
            replied to Field Validation using date range for current year
            in Access
            How do you subtract 1 or two years from the year?...
            See more | Go to post

              Leave a comment:

            No activity results to display
            Show More
            Working...