Reply to post: Re: Difficult to describe this one

'Microsoft Office has been the bane of my life, while simultaneously keeping me employed'

Alien8n

Re: Difficult to describe this one

At one company I worked at their entire print and control system was written in Access and ran on a timer overnight to print thousands of letters each night. The macros built into the Access database would open a form, show or hide images embedded into the form (creating client's company logos for the letters) and then a bespoke printer driver would select the printer for the letter to be printed on.

Along with that there was a reporting database (again Access) which would also run overnight producing the reports. The VBA code for that one would open a Excel spreadsheet, write the results of an SQL query to it and then send it via Outlook to a list of people.

Invariably something would go wrong every day.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon