PE02086A.gif (1977 bytes)

Menu
+ Free On-Line Tutorial

-Avoid #Error

-Customize 'Not In List' msg

-Programmatically add items to a combo box list

-Programmatically hide controls

-Security

MS Access Tools

About Us

Consulting Services



Tools, Add-ins, and Tutorials for Microsoft Access Developers 888-287-9497
linegld.gif

Learn More About Microsoft Access
Avoid #Error in Reports

How do I avoid #Error in my reports? I want to use Sum([InvoiceAmt]). InvoiceAmt is a number field. However, in some cases there is no data and the Sum function does not work. The report prints a #Error and the total is "#Error". How can I get around this?  

 

www.moretools.com
Customize Not In List error message

My users get a generic error when they type something in a combo box control that is not in the list. I still want to force them to select a choice from the list, but how do I customize this error message to make it more friendly?

 

 www.moretools.com

 

Programmatically add items to a combo box list

How do I programmatically add an item to a combo box that wasn't originally in the list? When my users type in a value that is not in my combo box list, they get an error. Instead, I want a message to ask the user if they want their desired item added to the list. How do I do this?

 

 www.moretools.com
Programmatically Hide Controls

Why do I get an error when I try and hide a control? The error is "You can't hide the control that has the focus" I found a work around by setting the height and width of the control to 0, but is there a better way?

 

 www.moretools.com
Steps to MS Access Security

How do I use the Security Wizard? What does it do and are there any other steps I need to take to completely secure my database?

 

www.moretools.com

[Free On-Line Lessons] [ MS Access Tools ]  [Consulting] [About Us] [ Home ]


Copyright More Web Sales, LLC All Rights Reserved.
2245 N. Green Valley Parkway, #212
Henderson NV  89014 
orders@morewebsales.com
Office: 1-888-287-9497 (toll free)
Fax: 702-447-1401
International Callers