AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, January 22, 2009

Comment and uncomment block in VBA

Is there an easy way to comment out blocks of code, without having to do it line by line? Yes, there are such buttons, but they are not on the toolbar by default. Right-click on VBA toolbar, click Customize, in Commands tab select Edit category and in Commands listbox find Command block and Uncomment block commands. Drag both to your toolbar - and here you are!

image

Labels: ,

Wednesday, January 21, 2009

FMS Development Team Blog

One more blog on Access - FMS Development Team Blog.

Tuesday, January 20, 2009

Migration to SQL Server

Here a great compilation of Access to SQL Server migration resources from Mary Chipman, Microsoft, that will help to understand - do you need to migrate, when to migrate and what one can get from migration:

TechEd Online Panel (video) -  Go to  and search for: "Are we there yet? Successfully navigating the bumpy road from Access to SQL Server"

Microsoft Access or SQL Server 2005: What's Right in Your
Organization?

Optimizing Microsoft Office Access Applications Linked to SQL Server

What are the main differences between Access and SQL Server?

"The Best of Both Worlds--Access MDBs and SQL Server"

SQL Server Migration Assistant for Access (SSMA for Access)

FMS Upsizing Center

Microsoft Access Developer's Guide to SQL Server

Migration Considerations for Access 2007

Labels: