Next Tip Access Unlimited News - Edition 85
See all newsletters

In This Issue

·    VBA Lives on and on
·    Closing Down Databases With The Workbench
·    How we use Basecamp from 37Signals to run our software business
·    Bill Gates Last Day at Microsoft
·    Shift Key

 

VBA Lives on and on

Just in case you were wondering, Microsoft have categorically denied that VBA is on the way out in Office Access 2009.

Note: You can find this sort of news in our Max Out newsletter delivered once a week at http://vb123.com/news

Read more


Closing Down Databases With The Workbench

Here is one of the questions and answers from the Workbench FAQ page.

We purchased the Workbench at the request of one of our developers.
He thought he had the ability to close open databases, or kick the users off of it, but I don't see that ability. Am I missing something here?

It is in the Workbench, you need to add a bit of code and a form to each database.
Read More Here

You may have the Admin button turned off, it can be turned on in the Options form by pressing the options button. See figure 2 on this page.
Read more here

Read more


How we use Basecamp from 37Signals to run our software business

A year ago I decided that it was time to crank the business up a bit and start using more contractors. When the work starting rolling in thanks to my more pro active marketing, so did the emails and files and the time sheets came in different forms. Quickly I felt like I was losing touch with my clients and projects and the Inbox took far too long to organize. Here is the story about how we used BaseCamp to help out...

Read more


Bill Gates Last Day at Microsoft

Funny video taking the Cheese out of Bill Gates. Takes a while to download.

Read more


Shift Key

Hi Garry

Any tips on preventing a user from getting to the database window by holding down the SHIFT key when opening a database?

Robert
--

Allow Bypass Key

http://msdn2.microsoft.com/en-us/library/aa200349.aspx

Easy to do in my workbench
http://www.vb123.com/workbench/help/version.htm#Startup

--

Many thanks for such a prompt and helpful response.

Robert

Read more

 
 
So thanks for reading our popular newsletter. Feel free to make comments, copy the email to a friend or maybe even contribute to the next edition. If you really like this newsletter, why not purchase The Toolbox and you will get all the other newsletters and plenty more in a developer’s knowledge base tool with super searching facilities.
 

Garry Robinson - Software Consultant and Author
Editor of vb123.com

Microsoft Office Access MVP

 

 


Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
  • Get Good Help
    If you need help with a database, our Australian Professionals could be the answer

  • Smart Access is online 
    The best magazine written about Microsoft Access is now being transferred to the web. There are 400 articles written by a 100 authors in the collection. 

    Purchase Smart Access

  • The Workbench
    Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, creation versions,  shutdown database

  • Read about the Toolbox
    Sample downloads, library resource kit and searchable help file comprising most of the information at vb123.com.au plus hidden downloads etc. Includes one of Smart Access downloads.

  • Convert Access to SQL Server  
    Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query  translation and web form conversion.
  • Purchase the Popular FMS Products  
    If you purchase the Popular FMS products from us, you will receive a complimentary of Smart Access Gold, Silver or Bronze Collections [Your choice]

 

 

vb123 Professionals


Get Good Help Here

If you need help with a database or Office programming, our Professionals could be the answer because we have worked on many similar solutions



Frontpage Conversions
We have converted vb123.com to Expression Web, contact us if we can help you move to the latest Microsoft web tool.


About The Editor ~ Contact Us
Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia

Access 2003 Security

MS Access Security

Read More here