thank you, Doyce. That was a wonderful message! Bill does a great job of steering the ship and making this a comfortable place to post. As for being unselfish, I cannot agree. Have you ever read Ayn Rand's book on "The Virtue of Selfishness"? I post for selfish reasons as I benefit from sharing with others ... see commonality in what seems to be diversity which helps uncover simplicity ... get to meet great people ... and, best of all, good comes back around :)
> "Doesn't the built-in documenter include the field description?"
No, it does not. This is the very reason my Analyzer exists. I am diligent about filling out field descriptions and I wanted a way to document them. My web page says this of the Analyzer Reports, "You will see descriptions if you have filled them out -- for both fields and tables. And this, my friend, is why I originally wrote the analyzer ... the data dictionary could be gotten from data gymnastics on the object analyzer report saved as a table ... but a quicker data dictionary was also a mighty convenient way to show descriptions that there was no built-in way to document. "
everything but the blood type? hmmm, I'll have to work on that ;) thanks, my friend
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: Bill Mosca
Doyce
You have truly warmed the cockles of my heart. I started this group with the intent to keep it as pure from spam as possible and still allow off-topic posts if they fell into my definition of "relevent". After all, I am the king here. I never imagined this group would become as much of a friendship group as a techincal one.
I owe it all to people like Crystal, Paul, A.D. Beth, Pat (the proverbiale Lurker) and John who share their experience with the group at no compensation other than our admiration. (Please don't let the moderators know that their MS-AccessPros pay checks are better used as wallpaper) and to people like you who keep coming back to seek help and offer what they have learned here an don their own.
I am so pleased that you, Doyce, and others, recognize our efforts.
Bill
--- "dnwinberry" <winberry.doyce> wrote:
>
> Crystal,
>
> Aside from your excellent Access advice, I really like the contributions you make to the group such as below. You are a very positive person and your vigor for life and optimism is inspiring and contageous. Remarks like these below that are exchanged on this forum add a personal element that makes me feel as if we are all friends here that help each other out. I really appreciate you and all the professionals that so unselfishly give of your time and expertise to help others. Thank you all from the bottom of my heart. I also really enjoy Bill and John's sense of humor when they sneak out in their posts. <grin> Thanks guys for putting smiles on my face.
>
> Doyce
>
>
> --- Crystal <strive4peace> wrote:
> >
> > you're welcome, John ;)
> >
> >
> > One of my favorite quotes is from Hellen Keller, who was blind and deaf and overcame those obstacles. She even gave public speeches
> >
> >
> > "When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us."
> > - Helen Keller
> >
> > oftentimes, we would not make a change if it were not forced upon us
> >
> >
> > Find a job where you enjoy the people around you and you are doing something productive. Go outside your box, apply for some crazy positions! One of the best things I did when I was young was sign up for work through a Temp Agency. I got a diversity of work, met lots of people -- it was interesting. You might want to temp for awhile to expose yourself to what else is out there.
> >
> > Good luck to you. Keep your chin up. The pursuit of happiness only needs enough money to keep above poverty
> >
> > "It is easier to live without good things than it is to live with bad things"
> > - Crystal (me)
> >
> >
> > Warm Regards,
> > Crystal
> >
> > http://www.AccessMVP.com/strive4peace
> >
> > *
> > (: have an awesome day :)
> > *
> >
> > ________________________________
> > From: John Moss
> > Subject: Re: [MS_AccessPros] How can you view a tables Description -- My Analyzer
> >
> > Thanks Crystal
> >
> >
> > On 1/27/2012 12:02 PM, Crystal wrote:
> > >
> > > Hi John,
> > >
> > > I am sorry to hear that ... there must be something better for you,
> > > follow your calling
> > >
> > > Meanwhile, download the Trial version of Office 2010
> > >
> > > http://office.microsoft.com/en-us/try/
> > >
> > > make time to study. Watch all of Chris Downs' 2010 videos here:
> > >
> > > Chris Downs: Access 2010 videos (some Excel too)
> > > http://www.youtube.com/playlist?p=PL03F031C24A42B6A7
> > >
> > > This would be a GREAT time for you to learn !
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > Microsoft MVP
> > > remote programming and training
> > >
> > > Access Basics by Crystal
> > > http://www.AccessMVP.com/strive4peace
> > > Free 100-page book that covers essentials in Access
> > >
> > > *
> > > (: have an awesome day :)
> > > *
> > >
> > > ________________________________
> > > From: John Moss
> > >
> > > not yet, I don't have 2010 at home and I just got laid off again.
> > >
> > >
> > > On 1/27/2012 10:14 AM, Crystal wrote:
> > > >
> > > > Hi John,
> > > >
> > > > > "Does your Analyzer work with Access 2010?"
> > > >
> > > > you didn't just try it? It only take a minute to open it up, browse
> > > > to the file to analyze, and click OK ;)
> > > >
> > > > It does work in 2010, and on web databases too :) I had a 2010
> > > > version on the site but took it down because the 2007 version has
> > > > nicer reports and does the same thing.
> > > >
> > > > Warm Regards,
> > > > Crystal
> > > >
> > > > Microsoft MVP
> > > > remote programming and training
> > > >
> > > > Access Basics by Crystal
> > > > http://www.AccessMVP.com/strive4peace
> > > > Free 100-page book that covers essentials in Access
> > > >
> > > > *
> > > > (: have an awesome day :)
> > > > *
> > > >
> > > > ________________________________
> > > > From: John Moss
> > > > Subject: Re: [MS_AccessPros] How can you view a tables Description --
> > > > My Analyzer
> > > >
> > > > Crystal,
> > > > Does your Analyzer work with Access 2010?
> > > >
> > > > Thanks,
> > > > John M
> > > >
> > > > On 1/26/2012 11:56 PM, Crystal wrote:
> > > > >
> > > > > thanks, Bill ;)
> > > > >
> > > > > Hi John,
> > > > >
> > > > > My Analyzer will get everything you need -- and a bunch of things you
> > > > > probably only dreamed about ;) you can download it here:
> > > > >
> > > > >
> > > >
> > > http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/
> > > > >
> > > > > The Access 2007 reports are prettier :) Otherwise both versions work
> > > > > the same ... except one MAJOR difference. The 2007 Analyzer also
> > > > > reports information stored in lookup fields -- and tests the sources!
> > > > > this information is not on any report but it is in the tables. Look
> > > > > at the relationship diagram at the new tables. Lookup fields are the
> > > > > only way to define relationships in web databases, which is why they
> > > > > are included.
> > > > >
> > > > > I have a LOT of information about this tool here:
> > > > >
> > > > > http://www.AccessMVP.com/strive4peace/dictionary
> > > > >
> > > > > have fun :)
> > > > >
> > > > > Warm Regards,
> > > > > Crystal
> > > > >
> > > > > *
> > > > > (: have an awesome day :)
> > > > > *
> > > > >
> > > > > ________________________________
> > > > > From: Bill Mosca
> > > > >
> > > > > Doesn't the built-in documenter include the field description?
> > > > >
> > > > > Have you tried Crystal's documenter. It does a slick job of getting
> > > > > just about
> > > > > everything but the database's blood type. It's in the Files>Crystal
> > > > > folder if I
> > > > > remember right.
> > > > >
> > > > > 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/Bill.Mosca>
> > > > > https://mvp.support.microsoft.com/profile/Bill.Mosca
> > > > >
> > > > > From: jfakes.rm
> > > > >
> > > > >
> > > > >
> > > > > I have a user that has put descriptions of each field in a MS Access
> > > > > 2003 table.
> > > > > This user wants to be able to get a listing of the following items to
> > > > > send to
> > > > > some SAS programmers so they can write code then export it into
> > > Access.
> > > > >
> > > > > The programmers need to see the Field Name, Data Type, as well as the
> > > > > Description. I haven't found anyone to get the Field Name description
> > > > > so the
> > > > > user can export the structure.
> > > > >
> > > > > Anyone have any idea how to do this?
> > > > >
> > > > > John F.
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar