Results 1 to 4 of 4

Thread: [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field

  1. Feb 9th, 2018, 12:15 PM #1
    cham27
    cham27 is offline

    Thread Starter
    New Member
    Join Date
    Feb 2018
    Posts
    1

    Question [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field

    Hi all,

    I am having trouble getting a date field in a table to auto fill when a certain status is chosen from a combo box within a form. Specifically, I have a field called "Status" (Combo Box) in a form and one called "Closed Date" (Date/Time) in a table and want today's date to fill when the Status is changed to "Closed". I have been perusing several forums and threads, and have not been able to pinpoint this specific issue. All that I have been able to do is create a macro that populates the date when any status is chosen from the "Status" combo box. The macro has an Action of "SetValue", and under the Argument: Item is [Closed Date], and Expression is Date(). I cannot get it specified to only fill when the status is changed to "Closed". Any help would be greatly appreciated!

    Thanks
    Reply With Quote Reply With Quote
  2. Feb 10th, 2018, 06:13 PM #2
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,930

    Re: [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field

    Welcome to VBForums

    Thread moved from the 'Database Development' forum (which is for questions about table design/SQL/etc) to the 'Office Development/VBA' forum (which is where VBA and other Access based questions belong)
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  3. Feb 13th, 2018, 11:11 AM #3
    jdc2000
    jdc2000 is offline
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,398

    Re: [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field

    Post the code you are using for this.
    Reply With Quote Reply With Quote
  4. Feb 14th, 2018, 06:48 AM #4
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field

    When you say 'macro' you are on about access macro or vba code?

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width