We have a couple of access programs that we use for data conversions. These programs convert the csv files that are generated from our CRM to a fixed file format that is then uploaded to interface with other government institutions.
With the introduction of OFfice 2007 there is this extra step that the users were required to do to enable macros manually every time they use these programs.
I thought this manual should not be there for the users so I set out to look at all the options available to automate this step.
HEre are the results.- Open the access file -- click on the office button at the top and click on Access Options
- From the menu that appears choose the Trust Centre and click on the Trust Centre Settings.
- From the menu that appears choose Macro settings and Enable (the fourth option) and click ok.
- Next time when you open the porgram the annoying notification where there is a tendency to forget to enable will disappear.
Tuesday, November 30, 2010
Enable Macros in Access 2007
Subscribe to:
Post Comments (Atom)
Navigating the Data Science Seas: A Journey with Microsoft Fabric
Data science is a vast and exciting field, brimming with the potential to unlock valuable insights. But like any seafaring voyage, navigatin...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des... -
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
No comments:
Post a Comment