Bill
The user has this process that downloads data and is updated yearly and she wants to archive the table. The crazier thing that the user does is that she renames the table and then makes a copy of the database and gives it the name of the database and the prior year. My Boss gets so frustrated with the user because she does not understand. We get a good laugh when they rename the table and then make a copy of the database for the next year.
We work in an environment where the customer or Departments get what they want, PERIOD. We are dealing with people that do not understand. Right now another department after spending months of development to get most of their databases to have a very cool email process, are considering going back to the manual process with excel and filtering the data for each department and copying to a different tab and then printing and walking the results to the supervisors. We have saved them so much paper and hours that it is not funny and now they want to throw it all away. All because they are accountants and do not understand Access. They are Excel users.
I do not mind the chastisement at all. Just understand that 99% of our data comes from outside sources like PeopleSoft, Advantage Financials, WebTMA, AS400 and others. Linked tables do not allow manipulation, unless we use make table queries to create a lot of tables for the data, which we have done but creates bloat in the databases. Sometimes it can take 25 queries to get a few tables to use for sources.
I appreciate all that my Yahoo user groups have done for me over the years. Thank You Bill for the honesty.
Jim Wagner
________________________________
________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, July 31, 2012 6:04 PM
Subject: RE: [MS_AccessPros] docmd.Rename question
Jim, Jim, Jim! Why are you renaming objects? Why not put a field in the table
and add a new record for each year?
Think RELATIONAL!
Don't mean to chastise, but tables should not be renamed based on some outside
information. A good design takes things like that into consideration.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My Nothing-to-do-with Access blog
<http://wrmosca.wordpress.com> http://wrmosca.wordpress.com
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Tuesday, July 31, 2012 3:46 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] docmd.Rename question
Hello all
I have an object that I need to rename in a process with the current year. I was
going to use the copy object but I thought why not just rename it. I do not want
to copy just rename. I have the current line for the copy object below but I use
the Date to add the current date. I tried to change the word Date to Year but it
does not work.
DoCmd.CopyObject , "Building Inspection Data Before Inflation on" & " " & Date,
acTable, "Building Inspection Data"
Below is what I have to rename the object it does not work
DoCmd.Rename "Building Inspection Data Before Inflation" & " " & Year, acTable,
"Building Inspection Data Before Inflation on 7/30/2012"
any help would be appreciative
Thank You
Jim Wagner
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar