PC Review


Reply
Thread Tools Rate Thread

MS-ACCESS 2010 - Date Stamps

 
 
New Member
ProRod21's Avatar
Join Date: Aug 2012
Posts: 13
 
      17th Aug 2012
Hello,

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!

Last edited by ProRod21; 17th Aug 2012 at 05:00 PM..
 
Reply With Quote
 
 
 
 
New Member
ProRod21's Avatar
Join Date: Aug 2012
Posts: 13
 
      20th Aug 2012
I need help! Some one please help me with this!
 
Reply With Quote
 
 
 
 
sugar 'n spikes
floppybootstomp's Avatar
Join Date: Mar 2002
Location: Greenwich
Posts: 18,252
 
      20th Aug 2012
Quote:
Originally Posted by ProRod21 View Post
I need help! Some one please help me with this!
If nobody's answered, probs means nobody knows a solution. Patience!

Good luck in solving your problem.

 
Don Van Vliet 1941 - 2010. And the acid gold bar swirled up and down, up and down.
 
Reply With Quote
 
DSG DSG is offline
New Member
Join Date: Aug 2012
Posts: 2
 
      21st Aug 2012
(now)+2 should work
 
Reply With Quote
 
Excel Formulator
alow's Avatar
Join Date: Mar 2012
Location: US
Posts: 756
 
      22nd Aug 2012
I've been slacking in the forums here lately . 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!

 
 
Reply With Quote
 
New Member
ProRod21's Avatar
Join Date: Aug 2012
Posts: 13
 
      22nd Aug 2012
Quote:
Originally Posted by alow View Post
I've been slacking in the forums here lately . 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,

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?
 
Reply With Quote
 
Excel Formulator
alow's Avatar
Join Date: Mar 2012
Location: US
Posts: 756
 
      22nd Aug 2012
To create a calculated field on a form, insert a text box and put the formula in the Control Source property.

 
 
Reply With Quote
 
New Member
ProRod21's Avatar
Join Date: Aug 2012
Posts: 13
 
      22nd Aug 2012
Alow,

Thank you so much it works!

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!
 
Reply With Quote
 
Excel Formulator
alow's Avatar
Join Date: Mar 2012
Location: US
Posts: 756
 
      22nd Aug 2012
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.

 
 
Reply With Quote
 
New Member
ProRod21's Avatar
Join Date: Aug 2012
Posts: 13
 
      22nd Aug 2012
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!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert 24/03/2010 date into 03/24/2010 date format Nitesh Microsoft Excel Programming 3 5th Jun 2010 10:44 AM
How to Convert 24/03/2010 as text into 03/24/2010 date format Nitesh Microsoft Excel Worksheet Functions 2 5th Jun 2010 10:34 AM
scdocvm.dll versions and date stamps =?Utf-8?B?b2xkcHJvd2xlcg==?= Windows XP General 1 24th Apr 2005 06:51 PM
Date stamps jj Microsoft Outlook Discussion 2 16th Mar 2004 01:03 PM
Date/Time Stamps On Messages? =?Utf-8?B?QnJhZGVu?= Windows XP Messenger 1 5th Mar 2004 11:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:58 AM.