J

JOWINO

New member
Joined
Last seen
Messages
5
Reaction score
0
Points
1

Profile posts Latest activity Postings About

  • J
    Why does ms access form I recently added a button for me.allowedits = true and on current I set the vb code to me.allowedits = false interfering with my duplicate macro button returning a pop up message the command or action 'paste isn't available now. In ms access 2019
    Gasman
    Gasman
    I would suggest walking your code, but do not know how to do that with macroes.
    Perhaps set AllowEdits to False elsewhere, like at the end of your duplicate macro? as to make a duplicate you would move to the next record to paste, so the Current event would run.
    You could try testing for Me.NewRecord in that event?
    J
    What exactly does this criteria do
    Between DateSerial(Year(Date()),1,1) And DateSerial(Year(Date()),12,31)
    Gasman
    Gasman
    Looks for dates in the current year.
    Could have just checked against Year() on dates and Date()

    This not the place to ask questions either. Should use the appropriate forum.
  • Loading…
  • Loading…
  • Loading…
Back
Top Bottom