Home

How to quickly change a MS Access Report header with the new year?

%3CLINGO-SUB%20id%3D%22lingo-sub-321227%22%20slang%3D%22en-US%22%3EHow%20to%20quickly%20change%20a%20MS%20Access%20Report%20header%20with%20the%20new%20year%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321227%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI%20have%20an%20Access%20database%20that%20produces%20Reports%20every%20year%26nbsp%3B%20so%20I%20have%20to%20manually%20change%20the%20text%20from%202018%20to%202019.%20Is%20there%20an%20easy%20way%20to%20go%20this%20-%20I%20cannot%20see%20and%20%22Find%20%26amp%3B%20Replace%22%20.%20Or%20could%20the%20new%20year%202019%20be%20held%20in%20a%20field%20so%20it%20would%20populate%20the%20Report%20header%20automatically.%26nbsp%3B%20All%20suggestions%20welcome%20but%20I%20am%20not%20a%20programmer%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EBert%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-321227%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Echange%20text%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHeader%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EReports%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329704%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20quickly%20change%20a%20MS%20Access%20Report%20header%20with%20the%20new%20year%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329704%22%20slang%3D%22en-US%22%3EHello!%20You%20can%20change%20your%20Report%20with%20the%20edit%20mode.%20For%20instance%2C%20open%20your%20report%2C%20view%20in%20edit%20mode.%20Look%20at%20the%20fields%20content%20where%20you%20can%20usually%20see%20the%20actual%20year.%20MS%20Access%20has%20an%20expression%20generator%2C%20where%20you%20can%20see%2C%20what%20date%20content%20is%20made%20of%20a%20formula%20(expression).%20I%20guess%2C%20in%20your%20report%20footer%20or%20header%20areas%20you%20have%20at%20least%20on%20time%20%26amp%3B%20date%20function%20such%20as%20%3D%22Created%20in%20Year%20%22%20%26amp%3B%20format%20(Now()%2C%20%22yyyy%22)%20which%20has%20the%20result%20text%20%22created%20in%20Year%202019%22.%20If%20you%20are%20interested%20in%20dynamic%20date%20and%20other%20usefull%20Access%20functions%2C%20explore%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dele_mfb4dNE%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dele_mfb4dNE%3C%2FA%3E%20from%20Minute%208%3A30%20on.%20Dynamic%20Expressions%20are%20the%20quickest%20way%20to%20update%20your%20actual%20report(s).%20But%20you%20have%20to%20spend%20time%20and%20mind%20on%20it%20also.%20Hope%20that%20helps.%20Greets%2C%20Eva.%3C%2FLINGO-BODY%3E
bertj twomey
Occasional Contributor

Hi All,

I have an Access database that produces Reports every year  so I have to manually change the text from 2018 to 2019. Is there an easy way to go this - I cannot see and "Find & Replace" . Or could the new year 2019 be held in a field so it would populate the Report header automatically.  All suggestions welcome but I am not a programmer

Thanks

Bert

1 Reply
Hello! You can change your Report with the edit mode. For instance, open your report, view in edit mode. Look at the fields content where you can usually see the actual year. MS Access has an expression generator, where you can see, what date content is made of a formula (expression). I guess, in your report footer or header areas you have at least on time & date function such as ="Created in Year " & format (Now(), "yyyy") which has the result text "created in Year 2019". If you are interested in dynamic date and other usefull Access functions, explore https://www.youtube.com/watch?v=ele_mfb4dNE from Minute 8:30 on. Dynamic Expressions are the quickest way to update your actual report(s). But you have to spend time and mind on it also. Hope that helps. Greets, Eva.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies