Kamis, 02 Agustus 2012

[MS_AccessPros] Re: docmd.Rename question

 

People who were hired to do monkey work are always in danger of being eliminated. That's why they need to expand their skill set whether it be becoming an Access expert or a Word form creator or a T-SQL ad hoc analyst. One cannot expect an employer to pay you for something he can get done by a scheduled job.

When I was a little kid the printing press put lots of monks out of work.

Bill

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> Dang. Now I'm going to have to think about what I'm doing. In these days of high unemployment I don't want to eliminate employment opportunities.
>
> I am waiting for the day where companies and large corporations actually brag about how many they employ instead of how large their profits are.
>
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
> Sent: Wednesday, August 01, 2012 2:59 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: docmd.Rename question
>
> Doyce
>
> Sounds familiar.Unfortunately on 2 databases they want to throw it all away and go back to manual processes.
>
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: dnwinberry <winberry.doyce@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, August 1, 2012 2:51 PM
> Subject: [MS_AccessPros] Re: docmd.Rename question
>
>
>
> 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]
> > >
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar