MICROSOFT ACCESS HELP 773.809.5456

Inserting a record in SQL Server and retrieving key ID. by Juan Soto	08/03/2010
Use this code when you need to insert a record and retrieve that record's key.

Tips for designing SQL Server tables for Microsoft Access by Juan Soto	07/24/2010
Applies to all versions of Access

Map route on Yahoo Maps with Addresses in Access by Juan Soto	07/21/2010
Sometimes you need to display a yahoo map with a route that has already been defined in Access

Map route on Google Maps with Addresses in Access by Juan Soto	07/21/2010
Sometimes you need to display a google map with a route that has already been defined in Access

Part 3: Why I grew to love Microsoft Access Data Projects by Juan Soto	06/21/2010
There are a few reasons you may wish to consider using ADPs with SQL Server

Launch Email Window from Form by Juan Soto	06/17/2010
If your database contains an email field, here's how to setup a single click email

Part 1 Access ADP Tip: Using ADP ServerFilter property by Juan Soto	06/03/2010
Use ServerFilter when loading forms in your ADP project.

Part 2 Access ADP Tip : Get rid of the login box on startup by Juan Soto	06/03/2010
How to use code and a special user account to rid yourself of Access' login box.

How to create PDFs in Word using Access VBA by Juan Soto	05/13/2010
Programatically convert Word documents to PDF from Access

Using a SQL Server stored procedure with a insert query in Access by Juan Soto	04/19/2010
Creating a pass-through query based on a action stored procedure can be tricky

Using SQL Server Views with Access: Index needed for editing data. by Juan Soto	03/03/2010
You can't edit data on a SQL Server view unless you create a unique index

SQL Server: Easily Grant Select to All Tables and/or Views in a Database by Tech-Recipes.com	02/25/2010
A real time saver!

Stuck on how to connect to a data source? by Juan Soto	02/15/2010
If you ever need to connect to a data source, this site is for you.

Create DELETE Audit Tables in SQL Server by Juan Soto	11/27/2009
Record only delete changes to your data in a seperate table

Criteria for the current month in a query by Juan Soto	11/05/2009
Use one single line to return all records for the month

"Property Not Found Error" in Access 2007 by Juan Soto	11/03/2009
Bug will occur when using datasheet view in a sub form.

Access function to return day of the week by Juan Soto	10/19/2009
If you need "Monday" instead of 2, then this function is for you.

How to create Outlook message from Access by Juan Soto	10/10/2009
Control Outlook from Access

How to create a new directory using Access VBA by Juan Soto	10/09/2009
Create directories under the same path of the database

Store your beloved code online by Juan Soto	10/08/2009
We all have a way to store our favorite code, but have you thought about this alternative?

Create Audit tables in SQL Server by Juan Soto	10/08/2009
TSQL for the Access Expert

What would you change in Access? by Juan Soto	09/14/2009
Let me know what you would like to change in Access and I will relay the information to the Access t

Make Access 07 behave as Access runtime by Juan Soto	09/14/2009
If you're an Access developer and you use Access runtime here is a tip for you.

Spell out date, i.e., "September 1st, 2009" by Juan Soto	09/02/2009
Use these functions to spell out the date in your reports and forms

How to retreive Identity Key when inserting a new record by Juan Soto	08/22/2009
AddNew will not return the last key created when using ADODB in VBA

Use Group Policy Editor to Modify Access Trust Center Settings - Access 2007 by Juan Soto	08/09/2009
Avoid the wrath of your network users and make their lives easier with Office Group Policies

Create SQL Server Views using Access code by Juan Soto	07/23/2009
Use the Create View TSQL command to create views from your code

Use VBA code to customize the Office 2007 Ribbon? Not Possible by Juan Soto	06/09/2009
Microsoft really dropped the ball on this one, how can you customize the famous ribbon can't be chan

Use Access with SQL Server over the Internet by Juan Soto	05/08/2009
Leverage the power of SQL Server with Microsoft Access

Keeping eyes off of sensitive data in Access by Juan Soto	11/14/2008
How do you prevent users from seeing all records?

Access Tip: Become a keyboard warrior. by Juan Soto	11/14/2008
The keyboard is always faster then the mouse, in this article we discuss becoming a keyboard warrior

Calling stored procedures with decimal parameters by Juan Soto	04/25/2008
Avoid problems with data types by using decimal types with numeric scales

Use your code with different sets of data by Juan Soto	04/17/2008
Sometimes you need to limit who can see what data, but you don't want to change table names

Access 2007 no longer exports reports to Excel by Juan Soto	01/06/2008
Use another method to export your data

Problem with null fields and calculated query columns by Juan Soto	06/26/2007
When calculating formulas as query columns, avoid null data.

We LOVE Access! by Juan Soto	03/04/2007
There are many reasons, but mostly, it makes it easy for us to help our clients.

Why a custom software system makes more sense. by Juan Soto	06/26/2006
Not ready to spend millions in software? Consider a custom solution instead.

Editorial: Is it time to write off Access? by Juan Soto	06/11/2006
VB.net? AJAX? Are they better than Access?

Access Help: BeforeDelConfirm Event Displays no Data by Juan Soto	06/03/2006
When using this event you will lose access to your data.

Get free online storage! by Juan Soto	05/21/2006
Use Yahoo to store up to 30 megabytes of free file storage.

Installing new software? by Juan Soto	03/30/2006
Take this simple precaution in case the installation goes bad.

Avoid getting shocked this winter. by Juan Soto	02/26/2006
Use this simple technique to avoid static electricity shocks when grabbing door handles.

How to query for nothing by Juan Soto	02/15/2006
If you need to query for the lack of values, then use Null in your criteria

Stop SPAM with three simple email rules by Juan Soto	12/01/2005
Flooded by SPAM? Use your existing email program to guarantee your Inbox is 100% SPAM free

Keyboard Tip: Zoom in and out with ease by Juan Soto	11/30/2005
Use the control key to zoom in and out with ease.

Web Tip: Use Google to get help on your cell phone by Juan Soto	11/15/2005
Receive address information, movie times and phone numbers by text messaging Google from your cell p

Use barcodes to minimize data entry and improve accuracy. by Juan Soto	10/18/2005
Combine barcodes with programming to improve productivity

Leverage the Power of Pocket PCs Within Your Company by Juan Soto	09/25/2005
There are many ways to collect data using Pocket PCs

Expert Tip: Determine what startup programs are worth keeping around. by Juan Soto, Senior Project Manager	07/31/2005
Have you noticed your computer slowing down over time?

Web Tip: Do you really need to give out your email address? by Juan Soto, Senior Project Manager	07/25/2005
Using your email address every time a site requests is asking for trouble.

Access Tip: Become a keyboard warrior. by Juan Soto	06/30/2005
The keyboard is always faster then the mouse, in this article we discuss becoming a keyboard warrior

Avoid using your email address on your webpages by Juan Soto	06/13/2005
Prevent spammers from harvesting your email addresses on your webpages.

Expert Tip: Frustrated with long security keys? by Juan Soto	05/18/2005
When using a secure WIFI network, you may be given a long string of numbers to enter

Expert Tip: Avoid spam on your mobile device by Juan Soto, Senior Project Manager	11/29/2004
Forwarding email to your device? Stop the spam today!

Password Technique by Juan Soto, Senior Project Manager	11/29/2004
Use this simple password technique to remember all of your passwords!