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
At the beginning of this month, I received an email from #microsoft telling me that I have received the Most Valuable Professional (MVP Awa...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
In this post I would like to share my experience of migrating our Reporting server from sql server We installed SQL SERVER 2017 on...
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...