Help with MS Access | HomeBrewTalk.com - Beer, Wine, Mead, & Cider Brewing Discussion Community.

Homebrew Talk

Help Support Homebrew Talk by donating:

  1. Dismiss Notice
  2. We have a new forum and it needs your help! Homebrewing Deals is a forum to post whatever deals and specials you find that other homebrewers might value! Includes coupon layering, Craigslist finds, eBay finds, Amazon specials, etc.
    Dismiss Notice

Help with MS Access

Discussion in 'General Chit Chat' started by Brutus Brewer, Dec 16, 2013.

 

  1. #1
    Brutus Brewer

    Well-Known Member

    Posted Dec 16, 2013
    I have an Access 2010 database that I enter purchase orders into. By default when I enter a ship date the program inputs the current year which isn't a big deal until November and December of a given year, at that time the orders I'm inputting have a mix of ship dates of the current and the coming year. How can I make the program recognize that when I enter a PO line and have the new year inputted where needed?
     
  2. #2
    mrwizard0

    Well-Known Member

    Posted Dec 16, 2013
    Are you able to write your own code for the entry form? A simple if statement would clear that whole problem
     
  3. #3
    Brutus Brewer

    Well-Known Member

    Posted Dec 16, 2013
    No. I was hoping that there was some preloaded option I could check to make that happen but haven't been able to find it.
     
Draft saved Draft deleted

Share This Page

Group Builder