Improve company productivity with a Business Account.Sign Up

x
?
Solved

Microsoft Access 2003 Forms Object properties created & modified dates are equal to the created date. I need the real modified date.

Posted on 2008-10-15
4
Medium Priority
?
255 Views
Last Modified: 2013-11-28
Needed: From VB, the modified date of a form.
Description of problem:  When I retrieve the object properties, the modified date is identical to the older created date.   The modified date in the forms window shows the correct date.
0
Comment
Question by:amountainclimber
  • 2
3 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 22728609
As far as I know, there is no way to get this information.
Even though Access stores it internally, it is not exposed anywhere that is accessible programmatically.

0
 
LVL 2

Accepted Solution

by:
EruditeMonkey earned 400 total points
ID: 22729388
Hi, You should be able to ge the dates from the main database window with the code below.

currentproject.AllForms("Form_Name").DateModified 
currentproject.AllForms("Form_Name").DateCreated

Open in new window

0
 
LVL 77

Expert Comment

by:peter57r
ID: 22729480
v good!  never knew that was there.
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

606 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