Author Archives: lpyne

About lpyne

I started with the firm as a Sales Assistant and over the years worked my way up to Senior Access developer, I’m certified on Power BI, with more certifications coming. I'm also the chapter coordinator for AccessUserGroups.org, a worldwide organization of Access virtual chapters that meet each month online to discuss a range of topics in different languages. I LOVE working with Access and learning new technologies!

Using SQL Server Data Sets and Stored Procedures to Create Dashboards in Microsoft Access

AUG Tues., Nov. 11TUESDAY, NOVEMBER 11th @ 6.30pm CDT

Juan Soto, Microsoft Access MVP,  will be talking about how Dashboards are a wonderful way to convey a wide range of data points into a consolidated view that will provide a quick glance of the operations of a firm. In other words, clients can look at the dashboard and quickly see if there are issues that require additional research.

This session will do a deep dive into creating a simple dashboard using a SQL Server stored procedure, data sets and a temporary table, allowing participants to learn more about these concepts and use them with Access.

To join our meeting, please use the following link and phone number or use your computer’s speakers with audio:

Join the meeting: https://join.me/accessusergroups

On a computer, use any browser with Flash. Nothing to download.
On a phone or tablet, launch the join.me app and enter meeting code: 842-599-774

Join the audio conference: 
Dial a phone number and enter access code, or connect via internet.

By phone: 

United States   +1.213.226.1066
Access Code   842-599-774#

Other international numbers available

By computer via internet: 
Join the meeting, click the phone icon and select ‘Call via internet’. A small download might be required.

Stored Procedures in MS Access

In September Juan Soto, Access MVP, presented at the Chicago Access User Group (CAUG), on the topic of Stored Procedures in MS Access.  Once again he will be sharing his knowledge on this subject by speaking at the Access User Group meetings for Latino and España. Both these meetings will be held in Spanish.

Take your Access skills to the next level and discover new tricks, such as:

  • How to use stored procedures as a report source or as part of your code.
  • How to maximize performance between SQL Server and Access.

It this is a topic that interests you, and you have not yet done so, register with the group to receive information of future meetings.

This is our regular monthly meeting link. 

Join the meeting: https://join.me/accessusergroups

Spain on Thursday, October 16 at 21:00 CEST
Latin America on Wednesday, October 15 at 18:30 CTD

On a computer, use any browser with Flash. Nothing to download.
On a phone or tablet, launch the join.me app and enter meeting code: 842-599-774

Join the audio conference: 
Dial a phone number and enter access code, or connect via internet.

By phone: 
United States   +1.213.226.1066
Access Code   842-599-774#

Other international numbers are available

Tuesday, October 14th @ 6.30pm CDT – Working with XML Data Efficiently

Efficiently Working with XML data (1)Ben Clothier, Access MVP and co-founder of the AccessUserGroups.org, will be presenting at this month’s meeting for the SQL Server with Access Group. He will discuss working with XML data with an SQL Server backend.

Earlier this year Ben posted a 2 part blog posts on this topic and this will be an update/improved version of these resources.  Here are the links: Part 1 & Part 2

In the talk we will cover:

  • How to use XPath and XQuery to query a XML document.
  • How to use XML like a relational data source.
  • How to build a valid XML document in VBA with minimum code and especially without knowing the schema?.
  • How to post a XML document to a stored procedure in VBA?.

Please add this to your calendar and tell your friends!

This is a free online meeting, please join us at:

Join the meeting: https://join.me/accessusergroups

On a computer, use any browser with Flash. Nothing to download.
On a phone or tablet, launch the join.me app and enter meeting code: 842-599-774

Join the audio conference: 
Dial a phone number and enter access code, or connect via internet.

By phone: 
United States   +1.213.226.1066
Access Code   842-599-774#

Join me August 5th in Denver: “Wish you could live the glamorous consulting life?”

My dear readers,

I’ve been asked by the Denver Area Access User Group to present on starting or improving your consulting practice: “Wish you could live the glamorous consulting life?” Here are the details, please register if you plan on attending!

DENVER AREA ACCESS USERS GROUP

Time:                    Tuesday, August 5th, 2014 at 6:30 PM Mountain

Place:                    Rox Bar and Grill 12684 W Indore Pl, LittletonCO

Note:                      Finger food and non-alcoholic beverages included 

Agenda:               6:30 PM – Questions and Answers

Speaker:              Juan Soto, Microsoft Access MVP, President IT Impact, Inc.

Topic:                   Wish you could live the glamorous consulting life?

Free Registration: http://www.meetup.com/DAAUG-meeting/events/197615832/

Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn’t start earlier? (and walk away from a cushy job). Juan says that he would not trade his consulting career for any other choice; he loves the rewards and the freedom it provides him, but he has learned the hard way. In this session you will learn sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out.  

Note: Even when an IT person has a permanent position, they are usually on a separate career track from non-IT personnel. This session will provide tips for all IT personnel.

You can see a preview at http://bit.ly/1bLUZAE

I look forward to seeing some of you there!