Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Date stamp update each time a person clicks a command button

Posted on 2008-10-14
5
Medium Priority
?
330 Views
Last Modified: 2013-11-28
Hello experts,
I have a form in ms access 2003.  This form is for inputing and mailing requistion data.  I would like to place a date stamp that tracks the date each time the requistion is mailed.  I all ready have the mailing function working and it includes emailing an attachment based on the forms data.  My problem is, I can not find a way to display the date(s) in which each requistion record has been mailed.  The mailing function is iniciated by a command button on the form.  Any questions, Let me know.
Thank you in advance for this learning assistance.
MyRocco
0
Comment
Question by:Myrocco
  • 2
5 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 750 total points
ID: 22712665
When you send the requisition by email, on your requisitions table, you can put a new field like "Sent_on", date type, where you could keep the date/time that requisition was sent. Something like this:

UPDATE tblRequisition SET tblRequisition .Sent_on= Now()

jppinto
0
 
LVL 16

Expert Comment

by:Chuck Wood
ID: 22712670
Try this:

1. Create a DateMailed field in the table that the form is based on.
2. Create a hidden text box on the form that has the DateMailed field as its ControlSource.
3. In the code for the CommandButton_Click event, place this code:

DateMailedTextBoxName = Format(Now, "Short Date")

(replace DateMailedTextBoxName with the name of your hidden text box)

-Chuck
0
 

Author Comment

by:Myrocco
ID: 22714943
Hello experts.  I figured it out.  I used a macro to place the current date in the date field on the mainform, then the macro copies that value and places it in the appropriate field in the subform. done deal.
thank you for the quick response!!!
Myrocco
0
 

Author Closing Comment

by:Myrocco
ID: 31505955
found the solution
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question