Wednesday, December 26, 2012

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.FullName
End Function
Function g_GetPath()
   'Returns the path to currently opened MDB or ADP
   g_GetPath = CurrentProject.Path
End Function
Function g_GetFullConnection()
   'Returns the filename of the currently opened MDB or ADP
   g_GetFullConnection = CurrentProject.Connection
End Function
Function g_GetName()
   'Returns the name of of the currently opened MDB or ADP : returns "my app name.accdb"
   g_GetName = CurrentProject.name
  
End Function
' save time run all in one call
Function GetAll()
Debug.Print "con: "; g_GetFullConnection; vbCrLf
Debug.Print "PATH:  "; g_GetPath; vbCrLf
Debug.Print "name:   "; g_GetName; vbCrLf
Debug.Print "Full Path:   "; g_GetFullPath; vbCrLf

End Function



Share:

Seo Skills




SEO Skills 

Google Analytics Combines Data From All Devices; Renames Visits, Visitors

•SEO Skills 
Web Analytic's is one of the more complicated elements of web development as there are thousands if ideas on how to find more users, clicks, visits and more leads to more tricks, traps and pitfalls.  In the end it's about content and good content wins! 

Google Analytics Combines Data From All Devices; Renames Visits, Visitors

Share:

Wednesday, December 19, 2012

Tuesday, December 18, 2012

Developer Overview

Solo Developer Seeking New Clients

Great Rates
Fast Service
Over 20 years direct client consulting

Hard Technical:

  • ASP.NET, VB.NET, C# and SQL Server Development
  • Windows Web Development using Visual Studio 2010
  • Expert level with XML and XSLT
  • Comfortable with using .NET library with XML
  • Intermediate level with XML and XSLT
  • Thorough understanding of core ASP.NET
  • Object models, data model, and web service design
  • Entity Framework, LINQ, Strong Data Patterns
  • Silverlight, AJAX, JavaScript, Jquery

MS Office Skills - Expert Level

  • MS Access Databases from cradle to grave
  • MS Access Developer
  • MS Outlook - Custom Add-ins, Custom VBA Scripting
  • MS Publisher
  • MS Word Integration using RTF to create complex data driven forms
  • MS PowerPoint - complex business driven presentations
  • MS Excel - functions, formulas and data access

Consulting Services

  • Business Development
  • CRM Systems and Selections
  • Legal and Business Strategies
  • Business Process Development
  • Internal Forms Development
  • Business Intelligence

Qualifications:

  • Over 20 years of software development
  • Over 30 years of business acumen
  • Strong Legal Background - thorough understanding of tort and contract law
  • Strong analytical capabilities
  • Passionate commitment to engineering quality and productivity
  • Self Regulated, Self Directed and Self Taught
  • More

Other Technical Skills

  • Code/Logic
  • User Interface
  • Reporting
  • Security/Authentication
  • Application

Utilizing the latest Microsoft Tools/Architecture

  • Microsoft Web Applications and Services
  • Microsoft SQL Server Database Applications
  • Microsoft Windows Applications
    • Microsoft Azure Cloud Applications Mobile Applications

Industries Served

  • Banking, Mortgage, And Finance
  • Real Estate, Real Estate Firms and Mortgage Operations
  • Construction, Construction Management
  • High Tech, Software and Hardware Companies
  • Medical, Hospital, Records Management
  • Manufacturing, ERP, MRP
  • Small Business Enterprise

What you need to know about Pete Bennett :d to know about Pete Bennett :
  • Has appeared on CNN, ABC and Wall Street Journal
  • Speaker and presenter
  • Seasoned Musician and Performer
  • Worked at Fortune 10 Companies
We pride ourselves on delivering more than just great programming -- we deliver true software consultation. We are talented, self-directed individuals who flourish while working under tight deadlines. Our development environment is high energy with quick cycles. Individual work is critical to projects, and success stands out.
Share:

PROFESSIONAL OBJECTIVE

PROFESSIONAL OBJECTIVE
A challenging position with a progressive company that will effectively utilize acquired expertise and experience. Currently seeking assignments based on my extensive project history.

QUALIFICATION HIGHLIGHTS
Extensive experience within various technology, construction, business and financial arenas with demonstrated success.

Proficient in project execution from inception to completion, conceptual development of all aspects of website development including revenue models, technical requirements, e-commerce components, and data translation, mapping and distribution. Comprehensive experience with many aspects of current technology from database to media distribution.

Expertise in organizational and prioritization skills. Ability to think, plan, and execute resourcefully. Extensive knowledge of business processes and operational issues within an organization. At ease in high stress environments requiring the ability to effectively handle multi-task levels of responsibility.

Quick learner with ability to assimilate job requirements and employ new methodologies. Energetic and self-motivated team player/builder. Known for exceeding goals and objectives. Self taught individual seeking outlet for acquired skills.

Excellent communication, interpersonal and leadership skills. Ability to work independently in self-directed roles. Ability to assemble compatible, efficient programming teams. Ability to successfully deploy resources effectively.

Self starter, self directed individual with comprehensive skills in business, marketing, databases, business process, startups, venture capital and software technology

Ability to access, understand complex abstracts of law, contracts, economics, finance, outstanding abilities in quantitative, analytical and data modeling skills.

Self-Directed Researcher, extensive experience and knowledge in the development customized databases for research, marketing, analysis and business development. Have extensive skills in integration of information from government sources, public records, marketing lists, and research data. Strong ability to integrate and associated information from unassociated repositories.
Share:

THE TELERIK DIFFERENCE



Telerik Controls Since 2007

Vibrant community
Be a part of one of the biggest .NET communities. 880,000 registered users are here to help you find answers to your questions and discuss common interests. It's a vibrant and growing network of fellow developers, whose needs and ideas shape our product roadmaps.
Browse the community forums





Industry-leading support

Technical support makes a difference for your project. And we offer the very best — even during your trial period. Actually, that's a key reason why people choose Telerik. We are there when you need us most. You don't get just software, but solutions for your project.
Get support now

Beyond exceptional software




Our experts provide development and design services as well as training and mentoring. We can assess your software and processes to ensure you’re on the right track. Whether you’re in need of an enterprise solution or just looking for a local partner, we can help.

Recognized excellence




Innovation and reliability


Innovation is our expertise. Pushing AJAX when it didn't have a name, and implementing same code base for Silverlight and WPF when no one believed in it. But we don't gamble with innovation, we bet on reliability. We are proud with both, and most of all we are grateful for your continuous trust in us. Proven by the hundreds of awards we have received.   
Share:

Musician - Vocals - Guitar - Musician - Performer



FAVORITE SONGS &/or INFLUENTIAL SINGERS

Frank Sinatra | Micheal Buble | Gordon Lightfoot | Harry Chapin | Cat Stevens | Ray Charles | Joe Cocker

SONGS
I’m a believer
Ill Be Seeing You
In The Wee Small Hours Of The Morning
Killing Me Softly
Learning The Blues
Lets Do It
Love
Love Me Tender
Mack The Knife
Everything
My Girl
My Way
Need You Now
New York New York
Operator
Penny Lane
Piano Man
Put Your Head on my Shoulder
Save The Last Dance For Me
Sentimental Journey
She's always a woman to me
Someone To Watch Over Me
Something
Strangers In The Night
Sundown
Sweet Caroline
Tequila Sunrise
That’s Life
The Eagles - Peaceful Easy Feeling
The Long and Winding Road
The Way You Look Tonight
Time
Unchained Melody
What The World Needs
Yesterday
You don’t Know Me
You fill up my senses
You Raise Me Up
YOU REALLY GOT A HOLD ON ME
You’ve Got a Friend
Youll Never Walk Alone
Young At Heart
Angel Flying Too Close to the Ground
Aquarius
Autumn Leaves Chords
Bad, Bad Leroy Brown
Black Magic Woman
Blue Skies Tab
Box of Rain
Bridge Over Troubled Water
Coming into Los Angeles
Coming into Los Angeles
Everything
Fly Me To The Moon Chords
Folsom Prison Blues
Girl From Ipanema
Golden Slumbers
HELLO
Home
How Can You Mend A Broken Heart
Xmas Song 
Jingle Bells 

Share:

Microsoft Technology

, ,
Microsoft Technology -
Highly Skilled in most phases of Windows Server

 
Application - Service - Technology
Windows Server 2000 to current versions - we strive on being 100% current
SQL Server 2000 to 2008
ASP.NET
.NET Framework (all versions)
Windows Development
Application Framework
Microsoft IIS Web Servers and Solutions
Web Site Development
Server Monitoring
HTML
CSS – Tables, Forms, Controls
ASP Controls
VB or C# Experience in either language is related to
AJAX Controls
DevExpress
Telerik – RadGrid, RadUpload, RadMultiView, RadMenu
Telerik - Silverlight Controls (limited experience)
SQL, XML, XMPP, Web Services, SOAP, REST
Visual Studio 2005, 2008, 2010
Custom Repeaters, Custom Data Paging, DataBinding, Datasets
Custom LINQ Paging, SQL Paging
Adobe: PhotoShop, Bridge, Premier (Limited), PDF
Microsoft Azure Cloud Computing – testing only
Microsoft Partner since 1996
www.DotNetStoreFront.com customization and installation
www.splendidcrm.com
Minor customization and installation
CSS – Extensive use of tableless forms, ordered lists, divs, precision stylesheets that seamlessly integrate with master pages,
Microsoft Office Suite from 1997 to 2010, Excel, Word, Access, PowerPoint, Info Path, VBA, Publisher
Share:

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 as much as humanly possible but the focus is squarely set Microsoft technology and ASP.NET

Software Development – 1990 to Present
Develop custom database applications; provide software services and business consulting to various companies primarily in the Bay Area. Developing applications using the majority of current social networking tools and API.


Managing Resources
Managed application developers, Graphic Designers, multi-media professionals and Creatives for the purposes of managing projects.

Projects utilized numerous technologies but our focus was constantly stay current with leading technology to be fully prepared when major revisions would roll out.

Mortgage Industry – Present 
Strong knowledge of back end mortgage processing, debt consolidation, HELOC, default rates, developing real estate marketing systems for mortgage brokers, contractors, and real estate agents.

Mortgage Loan Agent – Present 
Independent loan representative originating home mortgages, commercial loans, and home refinancing. Originate customers, loans, sourced clients through various marketing programs and efforts. Strong ability to interpret loan rate sheets and loan programs.

Terra Vista Software Walnut Creek CA 2004/05Developed software testing application for SonyStyle.com project, evaluated application architecture, made recommendations and implemented strategy to replace underlying software model.
Built For My Son 2003
 

Cabinetmaking Shop – Fairfield CA 2003-2004
Owner of custom cabinet shop, built and designed cabinets, fixtures and restaurants under temporary operations for 9 months, sold business operations back to owner.

Contra Costa County Summer 2001
Developed with MS Access database to that extracted and analyzes telephone billing calls and patterns.

SBC/Pacific Bell- San Ramon CA Summer/Fall 2001
Develop customized application for DSL order department using ASP Classic , VB and Internet.
Wells Fargo Bank 2000/2001 – Internal IT tracking database
MS Access database for managing internal projects and initiatives.

Jobwire.net – Authentic Technologies 1998-2004
Developed an internet job posting board for Dot Com Web Play. Successful revenue generating operation - ASP Classic and SQL.

Plan-it Interactive –1999-00 
Developed customer and account management database. Installed WAN/LAN for five locations. Automated business processes, scheduled events, employees and trucks. Used MS Access and ASP classic.

MustangSoccer.com – Authentic Technologies 2000 
Development of a youth sports site complete with fields, schedules, players, and on-line registration system. Site was taken over by larger vendor and original site was donation from our firm.

Authentic Technologies –1997-2002 President
Founder of a software development operation consisting focusing on projects for the Dot Com boom, raised capital for multiple web plays, created joint venture agreements, cross marketing programs and customized business solutions.

Outlook Companion – Email management 1998-99
Developed add-in for client and then created a version for downloading. Used Outlook 97/98 to assist MS Office users with automation of tasks inside of MS Outlook.

www.FreeSportsPlay.com – Joint Venture Project
Lead architect for developing online gaming application that allowed users to play for points and prizes. Project consisted of integrating five developers focused on web development. This site is down as the venture folded.

Bank of America  –Loan Systems 
Developed internal mortgage tracking system to capture transactions related to Mortgage Transaction Processing.

 PG&E  San Bruno Fire 
Developed internal tracking system specifically related to the San Bruno Fire in Sept 2010.  Project began in 2011 and finished later that summer.

 Comerica Bank Developed custom reporting application using MS Access to track loan defaults and delinquent loan accounts. Integrated reporting data into MS Access and Excel for analysis via pivot tables.

AMI Flight Charter Operations - San Francisco 1997-98
Developed reporting application using MS Access to supplement flight operations scheduling program. Importing and exporting of schedules, airport arrivals/departures and expense data. Reports provided with detailed expenses for each plane.

Project Management Database- Authentic Technologies 1998-2000
Internal company database created in MS Access 2000. Tracks projects, customers, Utilizes MS Outlook libraries to manage Email, appointments and calendars. Integrates to MS project. Tracks employee time on projects, manages hosted clients DNS records, and generates billing statements. Created ASP web interface for client access. Tools: NT Server, ASP, SQL, MS Access, Java Script, VB script, COM, VB, CDONTS, Win32 API and MS Exchange.

McCready Insurance Summer 1998
Converted billing system using VB and MS Access. Migrated user to NT servers from Novell 3.x to Windows 4.0.

Levi Strauss 1997 
Developed Access/VB application to manage subsidiary cash flows. Provided currency translations, FTP upload from 88 subsidiaries located world wide. Project provided corporate treasurer with accurate information regarding cash on hand held by subsidiaries.

Irwin Home Equity – 1996-97
Developed a variety of applications for a fast growing mortgage loan company. Developed multiple applications in Access 2.0 and 95, DOS, Qbasic, VB 4.0 and 5.0, supported Eastern Loan Origination System, FiServe, Novell 3x, NT server 3.5, Created database to manage loan portfolio for 10 Q reports, portfolio cash flows available cash reserves.

Computer Land Stores– 1995-96
Developed in-house reporting system for tracking returns and shipments from distribution system. Primary tools were MS Access using ODBC against Sybase database. Rolled up data for integration with Excel using VB, VBA and Office 2.0 Automation. Reports provided clients with relevant reports on product pipeline, sales and production plus developed MBS Analytics.

Clone Zone 1990-93 
Retail computer store owner: Focused on selling new and used computer. Installation, repairs, service, networks, new systems, training and consulting. Authorized reseller for most major brands. Staff consisted of 4 employees, managed sales, marketing, advertising, purchasing and payables. Prepared all aspects of accounting and tax preparation requirements.

MainFrame Designs 1980-89 
Operated 10,000 SF mid-sized cabinet and millwork shop with ten full time employees. Design build operation focused on commercial fixtures, stores, schools, hospitality and restaurant trades. Projects included Moscone Convention Center, San Jose Airport, Tony Roma’s, Wendy’s International, McDonalds, Emporium Capwells, Macy’s, Flakey Jakes Restaurants, Fresh Choice. Contra Costa County Colleges District, UC Berkeley, Wells Fargo Bank, Chevron, Pacific Bell and many major chains in Northern California and Nevada.
Share:

MS Access Developer - 1994 to Present



Over 20 years I've developed at least 300 databases.  Many very small that often served shortterm client needs.  In the late 1990's MS Access was very popular with the workgroups but was hated by IT Managers back when Novell Networks always had trouble with file handles. 

Past customers have been Fortune  500 entities to the small business.  Scope of work usually is get it done fast and it's too complicated for us or we don't have the time. 

The natural transistion was porting my skills to ASP, then to ASP.NET / .NET technologies.  The early days of .NET were bumpy with libraries that said they could do something but often failed but now Visual Studio (2012) is rock solid with zillions (big word) of features.

MS Acess is a solid application that serves many companies very well but MS Access has shortcomings that may or may not be a problem.  The .NET platform takes longer but outperforms in many ways but we can support either technology.

Share:

Support Products: THE TELERIK DIFFERENCE

THE TELERIK DIFFERENCE

Vibrant community


Be a part of one of the biggest .NET communities. 880,000 registered users are here to help you find answers to your questions and discuss common interests. It's a vibrant and growing network of fellow developers, whose needs and ideas shape our product roadmaps.
Browse the community forums




Industry-leading support

Technical support makes a difference for your project. And we offer the very best — even during your trial period. Actually, that's a key reason why people choose Telerik. We are there when you need us most. You don't get just software, but solutions for your project.
Get support now

Beyond exceptional software

Our experts provide development and design services as well as training and mentoring. We can assess your software and processes to ensure you’re on the right track. Whether you’re in need of an enterprise solution or just looking for a local partner, we can help.

Recognized excellence


Innovation and reliability


Innovation is our expertise. Pushing AJAX when it didn't have a name, and implementing same code base for Silverlight and WPF when no one believed in it. But we don't gamble with innovation, we bet on reliability. We are proud with both, and most of all we are grateful for your continuous trust in us. Proven by the hundreds of awards we have received.   
Share: