In 2015 Micrsosoft announced that they would be phasing out public facing websites in Office 365 sharepoint. So there will be no more posts here.
The good NEWS is that I continue to publish and produce a popular newsletter using http://vb123.blogspot.com.au/
If you want to move Autonumbers from one SQL database to another, you need to use the Set Identity command like in this sample
SET IDENTITY_INSERT [garrytest].[dbo].[LocationType] on
INSERT INTO [garrytest].[dbo].[LocationType] ( locationTypeID, companyID, name, statusID ) SELECT locationTypeID, companyID, name, statusID FROM [ST2Live].[dbo].[LocationType];
SET IDENTITY_INSERT [garrytest].[dbo].[LocationType] off
I first found this out from this page
To change colors of a control in a Web Page, you seem to need to use Hexidecimal Color codes . See the picture of the web macro below and look for ForeColor
When you get a file from the internet, it can be blocked. This will make the file have a variety of warnings when you open it. To unblock a file, right click on it, choose Properties and Unblock as in this picture.
Ok, I know I have been banging on about Access Web Apps
and I really haven't told you how to get started. In Office 365 there is currently the offer of a 10 users free trial of Small Business Premium. Here is my tip, don't bother with the free trial, go with a one user licence of Small Business and cough up the 5-6$ a month for a year.
- Its going to take more than a month before you really get a hang of it unless you are a 24/7 sort of person.
- If you get the Small Business Premium 10 user licence, you probably will need to contact a technician to turn it back into a Small Business licence.
- There is a chance when switching between the Small Business products that you will lose the SharePoint sub-domain name that you started with and the data that went with it. I nearly did because of my procrastination :(
I found it really useful to use a second domain name whilst setting up the website. SharePoint allows you to switch between domains whilst you are working on your public website.
Well I have 3 copies of Professional Access 2013 Programming to win and your challenge is to connect from your web place to 5 articles that you like at the new www.vb123.com.
To be in the running, in Twitter or Facebook or Linked-In or Blogger or a good old fashioned website, add your 5 favourite articles at vb123.com and add a little description on those articles. Then ping me with Facebook or Twitter or Linked-In. Upto 3 people will win, those that don't will be in the draw with those that didn't win in July for yet more copies of Teresa, Ben, George and Dagi's book. No correspondence entered into. Don't enter unless you intend keeping the links.
Examples of links to articles at vb123.com
The Trouble with Normal by Peter Vogel
Queries Queries by John Veiscas
or maybe even my very first article
Exploring Data Visually with MS Access
Idea: Go for a theme using the great SharePoint search tool at vb123.com
See my Twitter and Facebook links at the top of every page.
This is where I'll be sharing my programming tips and articles. I have been doing this for years at http://vb123.blogspot.com.au/ and becuause Google is the king of search, I will still post things over at blogger as well.