#1
|
|||
|
|||
Auto insert year only
Hi. How can I automatically insert the current year into a doc that updates itself? Thanks
Last edited by fithawk; 10-30-2011 at 08:34 AM. Reason: clarify |
#2
|
||||
|
||||
Hi fithawk,
You don't need a useform or vba coding for this, Simply use a DATE field in the document, coded as: {DATE \@ YYYY} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
|
#4
|
||||
|
||||
I am unable to replicate that behaviour. Can you describe exactly what you're doing?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Highlighting area for insertion, going to quick parts/field codes/formula (pasting your formula there). Hope that helps? Thanks
|
#6
|
||||
|
||||
Well, that's not how I described creating the field but, provided you delete the '=' from the formula field's code, it should work fine.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Still confused
I'm a real newby to this version of Access (2016). I want to make an automatically incremental file number for each of my records. I want this format: YY-000-A. How do I get that both in a table and in my reports? Right now I have it split into 3 different fields. Is there a way to put it all in the same field? If not, how to I make the table field/report field just give me the two number year automatically? Thanks.
|
#8
|
|||
|
|||
Quote:
Using Date Fields in Microsoft Word |
#9
|
|||
|
|||
Quote:
|
#10
|
||||
|
||||
For Access-related questions, you should visit AccessForums: http://www.accessforums.net/
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#11
|
|||
|
|||
Is there any way to insert the next year automatically in Word? That is to say, if the current year is YYYY, how can I insert YYYY+1?
Thanks |
#12
|
||||
|
||||
You could create a custom Quick Part (aka Building Block) containing a field coded as:
{={DATE \@ YYYY}+1} Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to calculate Leap Year | USAOz | Excel | 2 | 09-11-2011 04:58 PM |
Creative Ways for a year-to-year comparison??? | ridonkulous5 | Excel | 1 | 03-23-2011 04:49 PM |
Year | janak | Excel | 6 | 12-12-2010 10:08 PM |
Form auto insert | DaveC | Word | 4 | 06-20-2010 04:14 AM |
Auto insert current month's name and current year | Styler001 | Word | 4 | 01-25-2010 06:40 PM |