Here's mine Connie. I have used Access to pull AP and AR data from our ERP software and upload it into Oracle Financial accounting at corporate headquarters. Our process for end of month close included about 3 hours of running reports, one at a time and saving electronic copies on the server. With a little help from this group, I automated the reports and came up with a procedure where you merely click a button and the reports run, are saved, and printed and it only takes about 10 minutes during which the operator can go to the water cooler, restroom or whatever. Further, with some help from AD Tejpal, I have numerous reports that are emailed automatically every day to our customers that provide them with shipping documents, production information and product shipment. All of these processes used to be manual ones, we were literally able to reduce our staff in the acccounting department because of the automations made with Access. The good news is we didn't fire anyone, but retirees were not replaced. I thank God for all the MVP's that assist us with this group. They have helped me do some pretty incredible things and I have learned so much. Thanks Pro's!!!!
Doyce
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> Love these stories!
> Connie
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> >
> > I had a similar story when I watched an employee (report, copy, paste, edit)^12 (repeated steps over and over). I showed her a little Access ad-hoc query tool connected to her SQL database that provided the same functionality in minutes. She said I had just eliminated her position. I knew her supervisor and assured her that Jack had lots of tasks to keep her busy. It's nice working for a company that has 100s of manufacturing facilities worldwide that can utilize the same applications.
> >
> > Duane Hookom
> > MS Access MVP
> > ### posting from the new Outlook.com interface ###
> >
> >
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: wrmosca@
> > > Date: Wed, 1 Aug 2012 17:44:28 +0000
> > > Subject: Re: [MS_AccessPros] docmd.Rename question
> > >
> > > Jim
> > >
> > > Interesting! When I first came to my current employer it was as a consultant. The financial reportng system I mentioned was a fiscal period thing that had to be processed each month. The woman who did the processing used an Access 2.0 database that imported flat files that were actually COBOL reports with headers and page numbers and other garbage. Luckily, Access will not roll back an import if some of the rows are bad.
> > >
> > > It took her 12 hours and constant baby-sitting the database; clicking this button and that button, cleaning up the data, manually entering some data. There are more than 20 imports to run.
> > >
> > > I redesigned the entire thing in about one month and spent another 5 months adding more features. When it went live I showed her how to run the processing. Pick the month; click a button. It took 10 minutes to run. She started crying. I thought "Oh, my God. She's going to get laid off!" But they were tears of joy. She said she hated monthly processing because it made all of her other work have to wait.
> > >
> > > The IT department offered me a permanent job which I graciously accepted. Seems that that application had very high importance.
> > >
> > > Bill
> >
> > [Non-text portions of this message have been removed]
> >
>
Tidak ada komentar:
Posting Komentar