MICROSOFT ACCESS HELP 773-809-5456

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

Create DELETE Audit Tables in SQL Server by Juan Soto	08/10/2010
Record only delete changes to your data in a seperate table

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

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

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

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

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

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

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

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

Map route on Yahoo Maps with Addresses in Access by Juan Soto	08/10/2010


Map route on Google Maps with Addresses in Access by Juan Soto	08/10/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	08/10/2010
There are a few reasons you may wish to consider using ADPs with SQL Server

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

Spell out date, i.e., by Juan Soto	08/03/2010
Use these functions to spell out the date in your reports and forms

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

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

Store your beloved code online by Juan Soto	08/03/2010
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	08/03/2010
TSQL for the Access Expert

How to create a new directory using Access VBA by Juan Soto	08/03/2010
Create directories under the same path of the database

Criteria for the current month in a query by Juan Soto	08/03/2010
Use one single line to return all records for the month

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

Access function to return day of the week by Juan Soto	08/03/2010
If you need

How to create Outlook message from Access by Juan Soto	08/03/2010
Control Outlook from Access

Access 2007 no longer exports reports to Excel by Juan Soto	08/02/2010
Use another method to export your data

How to retreive Identity Key when inserting a new record by Juan Soto	08/02/2010
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/02/2010
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	08/02/2010
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	08/02/2010
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	08/02/2010
Leverage the power of SQL Server with Microsoft Access

Keeping eyes off of sensitive data in Access by Juan Soto	08/02/2010
How do you prevent users from seeing all records?

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

Problem with null fields and calculated query columns by Juan Soto	08/02/2010
When calculating formulas as query columns, avoid null data.

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

Calling stored procedures with decimal parameters by Juan Soto	08/02/2010
Avoid problems with data types by using decimal types with numeric scales

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

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

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

Internet Tip: Innovative Uses of Online Services by Juan Soto	07/09/2007
Keep the information you need online

Avoid Credit Card Security Issues with Some Simple Steps by Juan Soto	07/05/2007
Your customers count on you to protect their data

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.

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

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

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!