Stockwell43 said:
Hi Albert, thanks for replying.
So it's more of the mechanics that are different correct?
If by mechanics you mean user interface, then yes.
In general, what
percentage would say is different in 2007 from 2003 maybe 20%?
In terms of VBA, they are 100% the same....there is no change except if you
are using new features.
The only real changes is in terms of the user interface. So, lots of little
new features that are really nice, such as buttons can have both text and
graphic image on them now (something I wanted for years). You can now
specify what form will be used for a combo box to "edit the list" of items
(this just simply makes maintain of combo box lists in your application a
lot easier and you don't have to write code to do this anymore).
Also, When I look at the TOC in some of these books, they mention
SharePoint. What is SharePoint and is it something new for 2007? I seem to
see it mentioned quite a bit.
When you read all the technical IT magazines and articles on the web, you
hear the term called cloud computing. Share point is simply a web based
interface that allows you to collaborate with members of your organization,
or even outside clients. Share point is the fastest billion dollar product
in the history of Microsoft, and its gaining momentum every day. If you're
familiar with something like face book, think of share point as facebook for
businesses.
In simple terms, SharePoint is simply a web based system that allow you to
have messages, blogs, and share all of your word documents, excel etc in a
web space. Imagine if you have 10 people in your company that are working
on some kind of construction project. And, you also have 4 outside people.
You going to have tons of documents, papers, charts, (excel, power point,
word etc). It really becomes impossible for everybody to share this
mountain of documents via email. So you use SharePoint and any and all the
documents that get updated are now available for all to use together. It
simply allows you to put all pieces of information for a particular project
into one little website that manages everything for you. And, you can
integrate workflow operations into the system. So, for example you might
have an area for proposals and when somebody upload a proposal to the
system, the boss and the people who are supposed to give approval will be
emailed and notified automatically.
And just like we're having a discussion on this newsgroup board right now,
you can imagine those fifteen people working on the construction project
would also have discussions that all need to particpate in.
Access 2007 was a huge leap forward in terms of usability with share point.
The possibilities that share point opens up for MS access is becoming
mind-boggling right now.
I have an application which the three users in three completely different
cities need access to the same information at the same time. I could go to
ask their IT department to set up some SQL server and a vpn private network,
but this would take months and months of red tape and all kinds of hassles.
All as I did was skip on down to office live.com and sign up for the free
version of share point (in case you didn't know, the new free office live
online is based on share point).
I simply then linked my data tables to this share point site, and then
distributed the application to the three computers in three different
cities, and presto in a matter of minutes I have a distributed multiuser
application up and running. What's really incredible here is that I did not
have to purchase a server, I did not have to set up a server, yet I have a
multiuser system running now. That is the power of power cloud computing.
So, these people can now run this application anywhere where they have
Internet connections...even a wi-fi hot spot. It would have been a science
fiction dream just a few years ago that by installing my access application
on 3 computers that they would be instant multi-user anywhere and anytime
(and I did not purchase or even have to setup a server to do this).
Yet, with the free on-line Office live (SharePoint) I now have free
multi-user software that my clients can use...