Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Getting 2 months back of records only on a continuous form

    I have a button with this code



    Me.Filter = "[BookingDate] Between #" & Date & "# and #" & Date - 60 & "#"

    I'm trying to get the continuous form to show only records from the current date back 2 months (I figured Date -60 would do unless there is a better way) all via a button click.

    I'm planning to make a printable report later that only prints what is filtered too....

    may have solved - filteron = true

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    I seem to be filtering them out instead of in...

    I've put a not in the vba but it's showing dates earlier than the 60 days
    Me.Filter = "[BookingDate] not Between #" & Date & "# and #" & Date - 60 & "#"



Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 05-23-2013, 10:51 AM
  2. selecting all records on continuous form using vb
    By Mclaren in forum Programming
    Replies: 13
    Last Post: 01-03-2012, 12:20 PM
  3. Rearranging records on continuous form
    By aytee111 in forum Forms
    Replies: 6
    Last Post: 11-16-2011, 03:04 PM
  4. how to get auto numbering on continuous form records
    By shubhamgandhi in forum Programming
    Replies: 1
    Last Post: 08-04-2011, 02:26 PM
  5. Clear records off of continuous form
    By Ashe in forum Forms
    Replies: 2
    Last Post: 01-04-2011, 12:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums