MS-ACCESS 2010 - Date Stamps

Access Discussion in 'Microsoft Office' started by ProRod21, Aug 17, 2012.

  1. ProRod21

    ProRod21

    Joined:
    Aug 17, 2012
    Likes Received:
    0
    Hello, :bow:

    1st Question:

    I'm currently building a Database for my job. I have a field titled "Date Received." What I want to have access do is automatically populate a "Due Date" for 2 business days after the "Date Received" field.


    2nd Question:

    In my database there is a "Status" field where the agents will be able to select a status from a drop down menu. Is there a way to keep record (auto Date/Time stamp) every time the status is changed? How do I do this?

    I have this in a Form. I'm fairly new to ACCESS but am a quick learner. Please help me with this!!!!

    Thank you for any help! Just joined this site today so I hope I can find the help I so need! :cry::cry::cry:
     
    Last edited: Aug 17, 2012
    ProRod21, Aug 17, 2012
    #1
    1. Advertisements

  2. ProRod21

    ProRod21

    Joined:
    Aug 17, 2012
    Likes Received:
    0
    I need help! Some one please help me with this!
     
    ProRod21, Aug 20, 2012
    #2
    1. Advertisements

  3. ProRod21

    floppybootstomp sugar 'n spikes Moderator

    Joined:
    Mar 5, 2002
    Likes Received:
    497
    Location:
    Greenwich
    If nobody's answered, probs means nobody knows a solution. Patience!

    Good luck in solving your problem.
     
    floppybootstomp, Aug 20, 2012
    #3
  4. ProRod21

    DSG

    Joined:
    Aug 21, 2012
    Likes Received:
    0
    (now)+2 should work
     
    DSG, Aug 21, 2012
    #4
  5. ProRod21

    alow Excel Formulator

    Joined:
    Mar 20, 2012
    Likes Received:
    3
    Location:
    US
    I've been slacking in the forums here lately :blush:. If you want the field to always show 2 days after today's date, then the formula that DSG gave you should work. If you're looking for a date that is 2 days after the Date Received field, you could try the following formula:
    =DateAdd ( "d" , 2 , [Date Received]).

    Good Luck!
     
    alow, Aug 22, 2012
    #5
  6. ProRod21

    ProRod21

    Joined:
    Aug 17, 2012
    Likes Received:
    0
    alow,

    Thank you for your help! I'm sorry where should I plug this formula into? Is this done through the property sheet (if so which field) or through the main table where the field (Date Received/ Due Date) is located?
     
    ProRod21, Aug 22, 2012
    #6
  7. ProRod21

    alow Excel Formulator

    Joined:
    Mar 20, 2012
    Likes Received:
    3
    Location:
    US
    To create a calculated field on a form, insert a text box and put the formula in the Control Source property.
     
    alow, Aug 22, 2012
    #7
  8. ProRod21

    ProRod21

    Joined:
    Aug 17, 2012
    Likes Received:
    0
    Alow,

    Thank you so much it works! :bow: :thumb:

    Question, how do I get this now to reflect back to original table? I want it to populate the due date in the database table.

    Also, is there a way to send an alert (via email - outlook or even just through the database?) I don't know how this works, your help is highly appreciated!
     
    ProRod21, Aug 22, 2012
    #8
  9. ProRod21

    alow Excel Formulator

    Joined:
    Mar 20, 2012
    Likes Received:
    3
    Location:
    US
    If you want it to append those values back to the original table, it will require either code, or an update query attached to code, or something that I'm not familiar with, honestly. I could walk you through creating an update query that will do it in a one-off and then you don't need the calculated field in the form. But going backwards from the form to the table with a calculated field is tricky.

    What kind of alert are you looking for? (I have no idea how to integrate Outlook with Access, but the answer to this question might help someone else answer it.)

    It's a mouthful, try to wade through it and let me know if it helps.
     
    alow, Aug 22, 2012
    #9
  10. ProRod21

    ProRod21

    Joined:
    Aug 17, 2012
    Likes Received:
    0
    Yes please tell me how the you would create an update query that will do it in a one-off. If you wouldn't mind can you please explain how this would be more beneficial or even just how this would help (I want to explain it back to my peer). It doesn't need to be through Outlook. The Alert is fine just through Access. OR do you believe a report would just be more beneficial?

    okay, this is now going to get a bit more challenging, I have 4 Categories that the agents can select that have 4 different future due dates.

    For example

    Appeal - 45 Days
    Expedited Appeal 3 Days
    Grievance- 90 Days

    Is there any possible way to tie in the Category Chosen (Appeal, Expedited Appeal, or Grievance) to the number of days the "Due Date" would auto populate?

    Sorry to be annoying! I'm currently taking a class on MS Access but we haven't come to this part yet and I would like to have this for my boss.

    Thank you!
     
    ProRod21, Aug 22, 2012
    #10
  11. ProRod21

    ProRod21

    Joined:
    Aug 17, 2012
    Likes Received:
    0
    Also! Is there any way to only count business days?! (Monday-Friday)
     
    ProRod21, Aug 22, 2012
    #11
  12. ProRod21

    alow Excel Formulator

    Joined:
    Mar 20, 2012
    Likes Received:
    3
    Location:
    US
    I haven't forgotten about you. I'll need to find a little bit of free time to get you a proper answer. Maybe someone else will step in before then, and you can always try a little bit of Googling.
     
    alow, Aug 23, 2012
    #12
  13. ProRod21

    ProRod21

    Joined:
    Aug 17, 2012
    Likes Received:
    0
    Thank you Alow! I've been searching through google for the answer... I've searched several pages but if I do come across anything I will be sure to let you know!

    Honestly thank you for all of your help and anything else you're able to help me with is greatly appreciated! :bow:
     
    ProRod21, Aug 23, 2012
    #13
  14. ProRod21

    alow Excel Formulator

    Joined:
    Mar 20, 2012
    Likes Received:
    3
    Location:
    US
    I haven't had a chance to really dive into this for you, but this link might hold you over. It's the basics of creating an update query. As far as only counting work days between dates, there isn't an easy answer in Access. In Excel, you would use the NETWORKDAYS function, however to recreate it in Access you would need VBA, and this one is above me. You can try this link to see if you can get that working.
     
    alow, Aug 28, 2012
    #14
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. allisond

    Access MS Access 2000 to MS Access 2002 problem

    allisond, Mar 23, 2006, in forum: Microsoft Office
    Replies:
    0
    Views:
    273
    allisond
    Mar 23, 2006
  2. shailesh_bali

    Excel MS excell File Error, MS Win XP Professional Version 2002

    shailesh_bali, Nov 17, 2009, in forum: Microsoft Office
    Replies:
    1
    Views:
    558
    Chuck D
    Jan 3, 2010
  3. trishcollins
    Replies:
    2
    Views:
    1,062
    trishcollins
    Mar 23, 2012
  4. Sérgio Santos

    Excel MS Excel 2010: Any help with the macro/vba?

    Sérgio Santos, Sep 26, 2012, in forum: Microsoft Office
    Replies:
    2
    Views:
    887
    Sérgio Santos
    Sep 26, 2012
  5. Dodge

    Excel Creating two adjacent Y axes in MS Excel 2010

    Dodge, Oct 1, 2012, in forum: Microsoft Office
    Replies:
    3
    Views:
    1,462
  6. ahmsuza

    Excel MS Access 2010- Excel templete autofill from form record

    ahmsuza, Jul 23, 2013, in forum: Microsoft Office
    Replies:
    0
    Views:
    890
    ahmsuza
    Jul 23, 2013
  7. Sven Weichbrodt

    Word Using the 'IF' Formula in MS Word 2010

    Sven Weichbrodt, Jun 30, 2015, in forum: Microsoft Office
    Replies:
    0
    Views:
    402
    Sven Weichbrodt
    Jun 30, 2015
  8. NickCee

    Excel MS Excel - MS Office 2010

    NickCee, Jul 11, 2016, in forum: Microsoft Office
    Replies:
    0
    Views:
    542
    NickCee
    Jul 11, 2016
Loading...