Results 1 to 4 of 4
  1. #1
    Sam.Metcalfe is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    6

    Can I set a rule to update [Date] in all pop ups?

    I have Marcos which run update queries based on a date value but I have to input the date value in every pop up, can i set a rule to only have to input the date value once?

    Thanks


    Sam

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Sure, enter it on a form textbox and have all the queries use that instead:

    Forms!FormName.TextboxName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Sam.Metcalfe is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    6
    Thanks! That works a charm!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 3
    Last Post: 08-29-2017, 07:35 AM
  2. Struggling with a validation rule / before update
    By thompjas in forum Programming
    Replies: 6
    Last Post: 02-19-2015, 07:18 PM
  3. Validation Rule for Date Format
    By selvakumar.arc in forum Forms
    Replies: 3
    Last Post: 03-04-2014, 01:31 PM
  4. Cannot set validation rule on Date/Time type
    By intheflesh77 in forum Access
    Replies: 2
    Last Post: 10-12-2013, 08:57 AM
  5. Validation Rule: Date
    By krymer in forum Access
    Replies: 0
    Last Post: 08-27-2008, 03:30 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