Integrating the web with Office

Contact Pete's Team 925-399-1082 There are several core changes with MS Office Suite 2013 that shift focus from VBA to standard web centric languages e.g. HTML, CSS, JavaScript and Cloud based solutions that offer up an impressive selection of solutions that once required weeks of effort...

Read More

Visual Studio Tools for Office

Visual Studio Tools for Office Microsoft Visual Studio Tools for the Microsoft Office System can help you take advantage of the productivity enhancements in the Microsoft .NET Framework version to extend applications in Microsoft Office.   Below are links to all three versions...

Read More

Blogging For Page Views

Contact Pete's Team 925-399-1082 Blogging for Page Views Walnut Creek CA: One of the main reasons I'm using Blogger or Blogspot is during my testing phase it was clear that Google was indexing pages nearly on the spot.  The traffic patterns was noticeably better with near instantaneous search...

Read More

MS Access Controls

Contact Pete's Team 925-399-1082MS ACCESS CONTROLS From Left To Right Pointer:  Text Box: Label: Button:  Tab Control: Hyperlink: Browser Navigation  Option Group: Insert Page Break:  Combo Box:  Chart: Line: Toggle Button: List Box:  Rectangle: Check...

Read More

MS Excel Pivot Tables

...

Read More

MS Access or SQL Database Development

MS Access Custom Form MS Access or SQL Database Development Quality database using MS Access or SQL Server Administering SQL server databases. Backups, Recovery, jobs, linked servers, Triggers SQL Profiler Replication Implement and troubleshoot replication in SQL server...

Read More

MSACC: Dir Paths and ShortCuts

Subject: finding the paths of an MS Access Project Posted Under: Files, Directories and Path Borrowed in part but extended from this posting: http://support.microsoft.com/kb/210395 Option Compare Database Function g_GetFullName()   'Returns full path including file to currently opened MDB or ADP   g_GetFullPath = CurrentProject.FullNameEnd FunctionFunction g_GetPath()  ...

Read More

BRIEF HISTORY OF PAST PROJECTS

A Brief History of Past Projects The projects are shielded to protect clients from marketers, spams and unsavory salespersons who have in the past have used my resume to build their client list.  Important Information about past clients.  I strive to remain current in technology...

Read More