Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 05-17-2012, 03:21 PM
macropod's Avatar
macropod macropod is offline Creating a consecutive list of dates in a MS word document whenever it is accessed Windows 7 64bit Creating a consecutive list of dates in a MS word document whenever it is accessed Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,371
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Del,

If you open both documents and press Alt-F9, the field coding they use wll be displayed. In the first form I posted, each date that was calculated use a full dat calculation field, just as the first one in the second form's table still does. I've simplified the 2nd-6th fileds in the second form's table by picking up the first one's julian date calculation, but that's not especially important. The real difference is that each of the calculation fields now uses a different set of bookmark names (created by the SET fields) for key parts of the calculation. That way, there's reduced cross-over of the calculations between the fields.

The signature date could be gathered by a formfield with an 'on-exit' macro that locks it after a valid date has been input, but then you'd need the supervisor's macro security set low enough to allow the macros to run and they'd need to either allow macros to run in each & every timesheet or open them only from a trusted location. Once you do that, though, every user is liable to get the macro security warning when the open the timesheet. There are possible workarounds in which only the supervisor has the macro, but implementing such a scheme would be somewhat problematic.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a consecutive list of dates in a MS word document whenever it is accessed seach an Excel list elements in word document 7ajar Word VBA 5 03-16-2011 12:38 PM
Filling the consecutive cell by day. aligahk06 Excel 1 09-15-2010 08:17 AM
Creating a consecutive list of dates in a MS word document whenever it is accessed Can I print a log showing when my email account was accessed partner Outlook 1 03-09-2008 07:07 AM
creating a categories list owwiii Outlook 0 08-09-2007 01:56 PM
Creating a Map From a List of Addresses aleccamp Excel 0 11-19-2005 03:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft