ACCESS FEED: Re: [MS_AccessPros] Help with VBA

Hi John, problem is solved, it was my mistake trying to run the code while form was in Edit mode. It works well in Add mode.
Thanks as always
Kambiz

--------------------------------------------
On Sat, 11/29/14, John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Subject: Re: [MS_AccessPros] Help with VBA
To: MS_Access_Professionals@yahoogroups.com
Date: Saturday, November 29, 2014, 2:55 AM

Kambiz-
Is the Enabled property of any of
the controls on frmDebit set to No? That would certainly
cause the error.
Also, is there any code in
frmDebit in the Open, Load, or Current events of the
form?

John Viescas,
AuthorMicrosoft Access 2010 Inside
OutMicrosoft Access 2007 Inside
OutMicrosoft Access 2003 Inside
OutBuilding Microsoft Access
Applications SQL Queries for Mere
Mortals http://www.viescas.com/ (Paris,
France)

On Nov 29, 2014, at 6:34 AM,
Crystal strive4peace2008@yahoo.com
[MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
wrote:

Hi Kambiz,
perhaps
the problem is that you cannot leave the form you are
already on

is the
focus even going to the other form? Press the TAB key to
see where you are

if you
could possibly have a dirty record, try this in the code
behind the form where the code is:
'~~~~~~~~~~~~~~~~~~
if
me.dirty then me.dirty = false'~~~~~~~~~~~~~~~~~~
Does the
EVENT property on the property sheet say [Event
Procedure]? Perhaps the code just needs to be hooked up
again. Put a MsgBox in the code to see if it is
executing.

do you
have comboboxes or listboxes that have control references?
I have seen that cause problems too. I personally do not
do that -- prefer to replace the SQL instead of letting it
use references to controls.
Warm
Regards,Crystal
Do you
want to know how to make a graph in Access? Watch this
7-minute video.
How To
Make a Graph with Microsoft Access (cc)
http://www.youtube.com/watch?v=YhgNX6BWWmk
*   (:
have an awesome day :) *

On Friday, November 28, 2014 5:18 PM, "Kambiz
Afshartous kenaf42@yahoo.com
[MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
wrote:

Hello Crystal,
The control name in
Table is "Whom", in property Sheet of Form under
Data control source is "Whom" and under Other of
property Sheet is also "Whom"

Private Sub Form_Close()
DoCmd.OpenForm
"frmDebit"

Forms!frmDebit.SetFocus

Forms!frmDebit!Whom.SetFocus
I get the error Run-Time 2110. By
the way control "Whom" tab stop is 6
Kambiz

--------------------------------------------
On Fri, 11/28/14,
Crystal strive4peace2008@yahoo.com
[MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
wrote:

Subject: Re:
[MS_AccessPros] Help with VBA
To: "MS_Access_Professionals@yahoogroups.com"
<MS_Access_Professionals@yahoogroups.com>
Date: Friday,
November 28, 2014, 2:00 PM

Hi
Kambiz,
you must
use the control NAME property,
which is not necessarily the
name of the field in the control
as specified by

ControlSource. For bound controls, I like to make the
Name
=
ControlSource to make things easier

Warm
Regards,Crystal
Contact
Template for Access -- use for
Christmas Cards!
http://msaccessgurus.com/Contacts.htm

*   (:
have an awesome day :) *

On Friday, November
28, 2014 11:15 AM,
"Kambiz Afshartous kenaf42@yahoo.com

[MS_Access_Professionals]"
<MS_Access_Professionals@yahoogroups.com>
wrote:

John
I used the control name
"Whom" which is combo box
it did not worked and then
control "Medical" that
is plain Text box and in both
cases I received an error
message access can not move
focus to control Whom and then
Medical
Kambiz

--------------------------------------------
On Thu, 11/27/14, John Viescas
JohnV@msn.com

[MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
wrote:

Subject: Re:
[MS_AccessPros] Help with VBA
To: MS_Access_Professionals@yahoogroups.com
Date: Thursday,
November 27, 2014, 3:55 PM






   Kambiz-

What is the name of the
control that is bound
to the field
CERTAIN? That's what
you
should
use.

John Viescas, Author

Microsoft Access 2010
Inside
Out

Microsoft Access 2007
Inside Out

Microsoft
Access 2003 Inside Out

Building Microsoft Access
Applications

SQL Queries
for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Nov 27, 2014, at 8:47 PM,
Kambiz

Afshartous
kenaf42@yahoo.com

[MS_Access_Professionals]
<MS_Access_Professionals@yahoogroups.com>
wrote:

Thank you John,

First and second line of code
works perfectly

but third line

triggers error 2110 run time
"access can not move
focus
to
control

CERTAIN"

Kambiz

--------------------------------------------

On Wed, 11/26/14, John
Viescas JohnV@msn.com

[MS_Access_Professionals]

<MS_Access_Professionals@yahoogroups.com>
wrote:

Subject: Re: [MS_AccessPros]
Help with
VBA

To: MS_Access_Professionals@yahoogroups.com

Date: Wednesday, November
26, 2014, 3:38
PM

Private Sub Form_Close()
' Open the
other

form

DoCmd.OpenForm
"B" ' Put
focus on form

to

force it to finish
opening
Forms!B.SetFocus ' Put
focus on CERTAIN

control

Forms!B!CERTAIN.SetFocusEnd
Sub

No need to do the
SetFocus on the

second form if the control
you want to have
the focus is

the

first in the tab
order on
that
form.

John Viescas,

AuthorMicrosoft Access 2010
Inside

OutMicrosoft
Access 2007 Inside

OutMicrosoft Access 2003
Inside

OutBuilding
Microsoft Access

Applications SQL
Queries for Mere

Mortals http://www.viescas.com/
(Paris,

France)

On Nov 26, 2014, at 7:29 PM,
kenaf42@yahoo.com

[MS_Access_Professionals]
<MS_Access_Professionals@yahoogroups.com>

wrote:

I need a
code for OnClose event of form
"A", to

open form "B" and
set focus on
CERTAIN field in

form "B"

#yiv5612097998 #yiv5612097998
--


#yiv5612097998ygrp-mkp {

border:1px solid

#d8d8d8;font-family:Arial;margin:10px

0;padding:0 10px;}

#yiv5612097998
#yiv5612097998ygrp-mkp hr {

border:1px solid #d8d8d8;}

#yiv5612097998
#yiv5612097998ygrp-mkp
#yiv5612097998hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

0;}

#yiv5612097998
#yiv5612097998ygrp-mkp #yiv5612097998ads {

margin-bottom:10px;}

#yiv5612097998
#yiv5612097998ygrp-mkp
.yiv5612097998ad {

padding:0 0;}

#yiv5612097998
#yiv5612097998ygrp-mkp
.yiv5612097998ad p

{

margin:0;}

#yiv5612097998
#yiv5612097998ygrp-mkp
.yiv5612097998ad a
{

color:#0000ff;text-decoration:none;}

#yiv5612097998
#yiv5612097998ygrp-sponsor

#yiv5612097998ygrp-lc {

font-family:Arial;}

#yiv5612097998
#yiv5612097998ygrp-sponsor

#yiv5612097998ygrp-lc
#yiv5612097998hd

{

margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5612097998
#yiv5612097998ygrp-sponsor

#yiv5612097998ygrp-lc
.yiv5612097998ad
{

margin-bottom:10px;padding:0
0;}

#yiv5612097998
#yiv5612097998actions {

font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv5612097998
#yiv5612097998activity {

background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv5612097998
#yiv5612097998activity span
{

font-weight:700;}

#yiv5612097998
#yiv5612097998activity
span:first-child {

text-transform:uppercase;}

#yiv5612097998
#yiv5612097998activity span a {

color:#5085b6;text-decoration:none;}

#yiv5612097998
#yiv5612097998activity span span {

color:#ff7900;}

#yiv5612097998
#yiv5612097998activity span

.yiv5612097998underline {

text-decoration:underline;}

#yiv5612097998
.yiv5612097998attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

0;width:400px;}

#yiv5612097998
.yiv5612097998attach div a {

text-decoration:none;}

#yiv5612097998
.yiv5612097998attach img {

border:none;padding-right:5px;}

#yiv5612097998
.yiv5612097998attach label {

display:block;margin-bottom:5px;}

#yiv5612097998
.yiv5612097998attach label a
{

text-decoration:none;}

#yiv5612097998
blockquote {

margin:0 0 0
4px;}

#yiv5612097998
.yiv5612097998bold {

font-family:Arial;font-size:13px;font-weight:700;}

#yiv5612097998
.yiv5612097998bold a {

text-decoration:none;}

#yiv5612097998
dd.yiv5612097998last p a {

font-family:Verdana;font-weight:700;}

#yiv5612097998
dd.yiv5612097998last p span {

margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv5612097998
dd.yiv5612097998last p

span.yiv5612097998yshortcuts
{

margin-right:0;}

#yiv5612097998
div.yiv5612097998attach-table
div div a {

text-decoration:none;}

#yiv5612097998
div.yiv5612097998attach-table
{

width:400px;}

#yiv5612097998
div.yiv5612097998file-title a,
#yiv5612097998

div.yiv5612097998file-title
a:active,

#yiv5612097998

div.yiv5612097998file-title a:hover, #yiv5612097998

div.yiv5612097998file-title
a:visited {

text-decoration:none;}

#yiv5612097998
div.yiv5612097998photo-title
a,

#yiv5612097998
div.yiv5612097998photo-title
a:active,

#yiv5612097998
div.yiv5612097998photo-title
a:hover,

#yiv5612097998
div.yiv5612097998photo-title
a:visited {

text-decoration:none;}

#yiv5612097998
div#yiv5612097998ygrp-mlmsg

#yiv5612097998ygrp-msg p a

span.yiv5612097998yshortcuts {

font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5612097998
.yiv5612097998green {

color:#628c2a;}

#yiv5612097998
.yiv5612097998MsoNormal {

margin:0 0 0 0;}

#yiv5612097998 o {

font-size:0;}

#yiv5612097998
#yiv5612097998photos div {

float:left;width:72px;}

#yiv5612097998
#yiv5612097998photos div div {

border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}

#yiv5612097998
#yiv5612097998photos div label
{

color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv5612097998
#yiv5612097998reco-category
{

font-size:77%;}

#yiv5612097998
#yiv5612097998reco-desc {

font-size:77%;}

#yiv5612097998
.yiv5612097998replbq {

margin:4px;}

#yiv5612097998
#yiv5612097998ygrp-actbar div
a:first-child
{

margin-right:2px;padding-right:5px;}

#yiv5612097998
#yiv5612097998ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,

sans-serif;}

#yiv5612097998
#yiv5612097998ygrp-mlmsg table
{

font-size:inherit;font:100%;}

#yiv5612097998
#yiv5612097998ygrp-mlmsg select,

#yiv5612097998 input,
#yiv5612097998
textarea {

font:99% Arial, Helvetica,
clean, sans-serif;}

#yiv5612097998
#yiv5612097998ygrp-mlmsg
pre,
#yiv5612097998

code {

font:115% monospace;}

#yiv5612097998
#yiv5612097998ygrp-mlmsg * {

line-height:1.22em;}

#yiv5612097998
#yiv5612097998ygrp-mlmsg
#yiv5612097998logo
{

padding-bottom:10px;}

#yiv5612097998
#yiv5612097998ygrp-msg p a {

font-family:Verdana;}

#yiv5612097998
#yiv5612097998ygrp-msg

p#yiv5612097998attach-count
span {

color:#1E66AE;font-weight:700;}

#yiv5612097998
#yiv5612097998ygrp-reco

#yiv5612097998reco-head {

color:#ff7900;font-weight:700;}

#yiv5612097998
#yiv5612097998ygrp-reco {

margin-bottom:20px;padding:0px;}

#yiv5612097998
#yiv5612097998ygrp-sponsor

#yiv5612097998ov

li a
{

font-size:130%;text-decoration:none;}

#yiv5612097998
#yiv5612097998ygrp-sponsor

#yiv5612097998ov

li {

font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5612097998
#yiv5612097998ygrp-sponsor
#yiv5612097998ov

ul {

margin:0;padding:0 0 0 8px;}

#yiv5612097998
#yiv5612097998ygrp-text {

font-family:Georgia;}

#yiv5612097998
#yiv5612097998ygrp-text p {

margin:0 0 1em 0;}

#yiv5612097998
#yiv5612097998ygrp-text tt {

font-size:120%;}

#yiv5612097998
#yiv5612097998ygrp-vital ul li:last-child
{

border-right:none !important;

}

#yiv5612097998

------------------------------------

Posted by: Kambiz Afshartous
<kenaf42@yahoo.com>

------------------------------------

------------------------------------

Yahoo
Groups Links





#yiv5117803344 #yiv5117803344
--

#yiv5117803344ygrp-mkp {

border:1px solid
#d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv5117803344
#yiv5117803344ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5117803344
#yiv5117803344ygrp-mkp
#yiv5117803344hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5117803344
#yiv5117803344ygrp-mkp #yiv5117803344ads {
margin-bottom:10px;}

#yiv5117803344
#yiv5117803344ygrp-mkp
.yiv5117803344ad {
padding:0 0;}

#yiv5117803344
#yiv5117803344ygrp-mkp
.yiv5117803344ad p {

margin:0;}

#yiv5117803344
#yiv5117803344ygrp-mkp
.yiv5117803344ad a {

color:#0000ff;text-decoration:none;}

#yiv5117803344
#yiv5117803344ygrp-sponsor

#yiv5117803344ygrp-lc {

font-family:Arial;}

#yiv5117803344
#yiv5117803344ygrp-sponsor

#yiv5117803344ygrp-lc
#yiv5117803344hd {

margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5117803344
#yiv5117803344ygrp-sponsor

#yiv5117803344ygrp-lc
.yiv5117803344ad {

margin-bottom:10px;padding:0
0;}

#yiv5117803344
#yiv5117803344actions {

font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv5117803344
#yiv5117803344activity {

background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv5117803344
#yiv5117803344activity span {

font-weight:700;}

#yiv5117803344
#yiv5117803344activity span:first-child {
text-transform:uppercase;}

#yiv5117803344
#yiv5117803344activity span
a {

color:#5085b6;text-decoration:none;}

#yiv5117803344
#yiv5117803344activity span span
{

color:#ff7900;}

#yiv5117803344
#yiv5117803344activity span

.yiv5117803344underline {

text-decoration:underline;}

#yiv5117803344
.yiv5117803344attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

0;width:400px;}

#yiv5117803344
.yiv5117803344attach div a {
text-decoration:none;}

#yiv5117803344
.yiv5117803344attach img {

border:none;padding-right:5px;}

#yiv5117803344
.yiv5117803344attach label {

display:block;margin-bottom:5px;}

#yiv5117803344
.yiv5117803344attach label a
{
text-decoration:none;}

#yiv5117803344 blockquote {
margin:0 0 0
4px;}

#yiv5117803344
.yiv5117803344bold {

font-family:Arial;font-size:13px;font-weight:700;}

#yiv5117803344
.yiv5117803344bold a {

text-decoration:none;}

#yiv5117803344
dd.yiv5117803344last p a {

font-family:Verdana;font-weight:700;}

#yiv5117803344
dd.yiv5117803344last p span
{

margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv5117803344
dd.yiv5117803344last p

span.yiv5117803344yshortcuts
{

margin-right:0;}

#yiv5117803344
div.yiv5117803344attach-table div div a {
text-decoration:none;}

#yiv5117803344
div.yiv5117803344attach-table
{
width:400px;}

#yiv5117803344
div.yiv5117803344file-title a,
#yiv5117803344
div.yiv5117803344file-title
a:active,
#yiv5117803344

div.yiv5117803344file-title a:hover, #yiv5117803344

div.yiv5117803344file-title a:visited {
text-decoration:none;}

#yiv5117803344
div.yiv5117803344photo-title
a,
#yiv5117803344
div.yiv5117803344photo-title
a:active,

#yiv5117803344
div.yiv5117803344photo-title a:hover,
#yiv5117803344
div.yiv5117803344photo-title
a:visited {
text-decoration:none;}

#yiv5117803344
div#yiv5117803344ygrp-mlmsg

#yiv5117803344ygrp-msg p a
span.yiv5117803344yshortcuts {

font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5117803344
.yiv5117803344green {

color:#628c2a;}

#yiv5117803344
.yiv5117803344MsoNormal {
margin:0 0 0
0;}

#yiv5117803344 o {
font-size:0;}

#yiv5117803344
#yiv5117803344photos div {
float:left;width:72px;}

#yiv5117803344
#yiv5117803344photos div div
{
border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}

#yiv5117803344
#yiv5117803344photos div label
{

color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv5117803344
#yiv5117803344reco-category {

font-size:77%;}

#yiv5117803344
#yiv5117803344reco-desc {

font-size:77%;}

#yiv5117803344
.yiv5117803344replbq {

margin:4px;}

#yiv5117803344
#yiv5117803344ygrp-actbar div a:first-child
{

margin-right:2px;padding-right:5px;}

#yiv5117803344
#yiv5117803344ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv5117803344
#yiv5117803344ygrp-mlmsg table
{

font-size:inherit;font:100%;}

#yiv5117803344
#yiv5117803344ygrp-mlmsg
select,

#yiv5117803344
input, #yiv5117803344 textarea {
font:99% Arial, Helvetica,
clean,

sans-serif;}

#yiv5117803344
#yiv5117803344ygrp-mlmsg pre,
#yiv5117803344
code {

font:115% monospace;}

#yiv5117803344
#yiv5117803344ygrp-mlmsg * {

line-height:1.22em;}

#yiv5117803344
#yiv5117803344ygrp-mlmsg #yiv5117803344logo
{
padding-bottom:10px;}

#yiv5117803344
#yiv5117803344ygrp-msg p a {

font-family:Verdana;}

#yiv5117803344
#yiv5117803344ygrp-msg

p#yiv5117803344attach-count span
{

color:#1E66AE;font-weight:700;}

#yiv5117803344
#yiv5117803344ygrp-reco
#yiv5117803344reco-head {

color:#ff7900;font-weight:700;}

#yiv5117803344
#yiv5117803344ygrp-reco {

margin-bottom:20px;padding:0px;}

#yiv5117803344
#yiv5117803344ygrp-sponsor
#yiv5117803344ov

li a {

font-size:130%;text-decoration:none;}

#yiv5117803344
#yiv5117803344ygrp-sponsor
#yiv5117803344ov
li {

font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5117803344
#yiv5117803344ygrp-sponsor
#yiv5117803344ov

ul {

margin:0;padding:0 0 0 8px;}

#yiv5117803344
#yiv5117803344ygrp-text {

font-family:Georgia;}

#yiv5117803344
#yiv5117803344ygrp-text p {

margin:0 0 1em 0;}

#yiv5117803344
#yiv5117803344ygrp-text tt {

font-size:120%;}

#yiv5117803344
#yiv5117803344ygrp-vital ul li:last-child
{
border-right:none
!important;

}

#yiv5117803344

------------------------------------
Posted by: Kambiz Afshartous
<kenaf42@yahoo.com>

------------------------------------

------------------------------------

Yahoo Groups Links

Traditional

(Yahoo! ID required)

MS_Access_Professionals-fullfeatured@yahoogroups.com

#yiv7892225601 #yiv7892225601
--

#yiv7892225601ygrp-mkp {
border:1px solid
#d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv7892225601
#yiv7892225601ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv7892225601
#yiv7892225601ygrp-mkp #yiv7892225601hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv7892225601
#yiv7892225601ygrp-mkp #yiv7892225601ads {
margin-bottom:10px;}

#yiv7892225601
#yiv7892225601ygrp-mkp .yiv7892225601ad {
padding:0 0;}

#yiv7892225601
#yiv7892225601ygrp-mkp .yiv7892225601ad p {
margin:0;}

#yiv7892225601
#yiv7892225601ygrp-mkp .yiv7892225601ad a {

color:#0000ff;text-decoration:none;}
#yiv7892225601
#yiv7892225601ygrp-sponsor
#yiv7892225601ygrp-lc {

font-family:Arial;}

#yiv7892225601
#yiv7892225601ygrp-sponsor
#yiv7892225601ygrp-lc
#yiv7892225601hd {
margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv7892225601
#yiv7892225601ygrp-sponsor
#yiv7892225601ygrp-lc
.yiv7892225601ad {
margin-bottom:10px;padding:0
0;}

#yiv7892225601
#yiv7892225601actions {

font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv7892225601
#yiv7892225601activity {

background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv7892225601
#yiv7892225601activity span {
font-weight:700;}

#yiv7892225601
#yiv7892225601activity span:first-child {
text-transform:uppercase;}

#yiv7892225601
#yiv7892225601activity span a {

color:#5085b6;text-decoration:none;}

#yiv7892225601
#yiv7892225601activity span span {
color:#ff7900;}

#yiv7892225601
#yiv7892225601activity span
.yiv7892225601underline {

text-decoration:underline;}

#yiv7892225601
.yiv7892225601attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv7892225601
.yiv7892225601attach div a {
text-decoration:none;}

#yiv7892225601
.yiv7892225601attach img {

border:none;padding-right:5px;}

#yiv7892225601
.yiv7892225601attach label {

display:block;margin-bottom:5px;}

#yiv7892225601
.yiv7892225601attach label a {
text-decoration:none;}

#yiv7892225601 blockquote {
margin:0 0 0
4px;}

#yiv7892225601
.yiv7892225601bold {

font-family:Arial;font-size:13px;font-weight:700;}

#yiv7892225601
.yiv7892225601bold a {
text-decoration:none;}

#yiv7892225601
dd.yiv7892225601last p a {

font-family:Verdana;font-weight:700;}

#yiv7892225601
dd.yiv7892225601last p span {

margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv7892225601
dd.yiv7892225601last p
span.yiv7892225601yshortcuts
{

margin-right:0;}

#yiv7892225601
div.yiv7892225601attach-table div div a {
text-decoration:none;}

#yiv7892225601
div.yiv7892225601attach-table {
width:400px;}

#yiv7892225601
div.yiv7892225601file-title a, #yiv7892225601

div.yiv7892225601file-title a:active, #yiv7892225601

div.yiv7892225601file-title a:hover, #yiv7892225601

div.yiv7892225601file-title a:visited {
text-decoration:none;}

#yiv7892225601
div.yiv7892225601photo-title a,
#yiv7892225601
div.yiv7892225601photo-title a:active,
#yiv7892225601
div.yiv7892225601photo-title a:hover,
#yiv7892225601
div.yiv7892225601photo-title a:visited {
text-decoration:none;}

#yiv7892225601
div#yiv7892225601ygrp-mlmsg
#yiv7892225601ygrp-msg p a
span.yiv7892225601yshortcuts {

font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv7892225601
.yiv7892225601green {
color:#628c2a;}

#yiv7892225601
.yiv7892225601MsoNormal {
margin:0 0 0 0;}

#yiv7892225601 o {
font-size:0;}

#yiv7892225601
#yiv7892225601photos div {
float:left;width:72px;}

#yiv7892225601
#yiv7892225601photos div div {
border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}

#yiv7892225601
#yiv7892225601photos div label {

color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv7892225601
#yiv7892225601reco-category {
font-size:77%;}

#yiv7892225601
#yiv7892225601reco-desc {
font-size:77%;}

#yiv7892225601
.yiv7892225601replbq {
margin:4px;}

#yiv7892225601
#yiv7892225601ygrp-actbar div a:first-child {

margin-right:2px;padding-right:5px;}

#yiv7892225601
#yiv7892225601ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv7892225601
#yiv7892225601ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv7892225601
#yiv7892225601ygrp-mlmsg select,
#yiv7892225601 input,
#yiv7892225601 textarea {
font:99% Arial, Helvetica,
clean, sans-serif;}

#yiv7892225601
#yiv7892225601ygrp-mlmsg pre, #yiv7892225601
code {
font:115% monospace;}

#yiv7892225601
#yiv7892225601ygrp-mlmsg * {
line-height:1.22em;}

#yiv7892225601
#yiv7892225601ygrp-mlmsg #yiv7892225601logo {

padding-bottom:10px;}

#yiv7892225601
#yiv7892225601ygrp-msg p a {
font-family:Verdana;}

#yiv7892225601
#yiv7892225601ygrp-msg
p#yiv7892225601attach-count span
{

color:#1E66AE;font-weight:700;}

#yiv7892225601
#yiv7892225601ygrp-reco
#yiv7892225601reco-head {

color:#ff7900;font-weight:700;}

#yiv7892225601
#yiv7892225601ygrp-reco {

margin-bottom:20px;padding:0px;}

#yiv7892225601
#yiv7892225601ygrp-sponsor #yiv7892225601ov
li a {

font-size:130%;text-decoration:none;}

#yiv7892225601
#yiv7892225601ygrp-sponsor #yiv7892225601ov
li {

font-size:77%;list-style-type:square;padding:6px 0;}

#yiv7892225601
#yiv7892225601ygrp-sponsor #yiv7892225601ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv7892225601
#yiv7892225601ygrp-text {
font-family:Georgia;}

#yiv7892225601
#yiv7892225601ygrp-text p {
margin:0 0 1em 0;}

#yiv7892225601
#yiv7892225601ygrp-text tt {
font-size:120%;}

#yiv7892225601
#yiv7892225601ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv7892225601

------------------------------------
Posted by: Kambiz
Afshartous <kenaf42@yahoo.com>
------------------------------------

------------------------------------

Yahoo Groups Links

http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID
required)

MS_Access_Professionals-fullfeatured@yahoogroups.com

#yiv0328313448 #yiv0328313448 --
#yiv0328313448ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv0328313448 #yiv0328313448ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv0328313448 #yiv0328313448ygrp-mkp #yiv0328313448hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv0328313448 #yiv0328313448ygrp-mkp #yiv0328313448ads {
margin-bottom:10px;}

#yiv0328313448 #yiv0328313448ygrp-mkp .yiv0328313448ad {
padding:0 0;}

#yiv0328313448 #yiv0328313448ygrp-mkp .yiv0328313448ad p {
margin:0;}

#yiv0328313448 #yiv0328313448ygrp-mkp .yiv0328313448ad a {
color:#0000ff;text-decoration:none;}
#yiv0328313448 #yiv0328313448ygrp-sponsor
#yiv0328313448ygrp-lc {
font-family:Arial;}

#yiv0328313448 #yiv0328313448ygrp-sponsor
#yiv0328313448ygrp-lc #yiv0328313448hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0328313448 #yiv0328313448ygrp-sponsor
#yiv0328313448ygrp-lc .yiv0328313448ad {
margin-bottom:10px;padding:0 0;}

#yiv0328313448 #yiv0328313448actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv0328313448 #yiv0328313448activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv0328313448 #yiv0328313448activity span {
font-weight:700;}

#yiv0328313448 #yiv0328313448activity span:first-child {
text-transform:uppercase;}

#yiv0328313448 #yiv0328313448activity span a {
color:#5085b6;text-decoration:none;}

#yiv0328313448 #yiv0328313448activity span span {
color:#ff7900;}

#yiv0328313448 #yiv0328313448activity span
.yiv0328313448underline {
text-decoration:underline;}

#yiv0328313448 .yiv0328313448attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv0328313448 .yiv0328313448attach div a {
text-decoration:none;}

#yiv0328313448 .yiv0328313448attach img {
border:none;padding-right:5px;}

#yiv0328313448 .yiv0328313448attach label {
display:block;margin-bottom:5px;}

#yiv0328313448 .yiv0328313448attach label a {
text-decoration:none;}

#yiv0328313448 blockquote {
margin:0 0 0 4px;}

#yiv0328313448 .yiv0328313448bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv0328313448 .yiv0328313448bold a {
text-decoration:none;}

#yiv0328313448 dd.yiv0328313448last p a {
font-family:Verdana;font-weight:700;}

#yiv0328313448 dd.yiv0328313448last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv0328313448 dd.yiv0328313448last p
span.yiv0328313448yshortcuts {
margin-right:0;}

#yiv0328313448 div.yiv0328313448attach-table div div a {
text-decoration:none;}

#yiv0328313448 div.yiv0328313448attach-table {
width:400px;}

#yiv0328313448 div.yiv0328313448file-title a, #yiv0328313448
div.yiv0328313448file-title a:active, #yiv0328313448
div.yiv0328313448file-title a:hover, #yiv0328313448
div.yiv0328313448file-title a:visited {
text-decoration:none;}

#yiv0328313448 div.yiv0328313448photo-title a,
#yiv0328313448 div.yiv0328313448photo-title a:active,
#yiv0328313448 div.yiv0328313448photo-title a:hover,
#yiv0328313448 div.yiv0328313448photo-title a:visited {
text-decoration:none;}

#yiv0328313448 div#yiv0328313448ygrp-mlmsg
#yiv0328313448ygrp-msg p a span.yiv0328313448yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0328313448 .yiv0328313448green {
color:#628c2a;}

#yiv0328313448 .yiv0328313448MsoNormal {
margin:0 0 0 0;}

#yiv0328313448 o {
font-size:0;}

#yiv0328313448 #yiv0328313448photos div {
float:left;width:72px;}

#yiv0328313448 #yiv0328313448photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv0328313448 #yiv0328313448photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv0328313448 #yiv0328313448reco-category {
font-size:77%;}

#yiv0328313448 #yiv0328313448reco-desc {
font-size:77%;}

#yiv0328313448 .yiv0328313448replbq {
margin:4px;}

#yiv0328313448 #yiv0328313448ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv0328313448 #yiv0328313448ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv0328313448 #yiv0328313448ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv0328313448 #yiv0328313448ygrp-mlmsg select,
#yiv0328313448 input, #yiv0328313448 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv0328313448 #yiv0328313448ygrp-mlmsg pre, #yiv0328313448
code {
font:115% monospace;}

#yiv0328313448 #yiv0328313448ygrp-mlmsg * {
line-height:1.22em;}

#yiv0328313448 #yiv0328313448ygrp-mlmsg #yiv0328313448logo {
padding-bottom:10px;}

#yiv0328313448 #yiv0328313448ygrp-msg p a {
font-family:Verdana;}

#yiv0328313448 #yiv0328313448ygrp-msg
p#yiv0328313448attach-count span {
color:#1E66AE;font-weight:700;}

#yiv0328313448 #yiv0328313448ygrp-reco
#yiv0328313448reco-head {
color:#ff7900;font-weight:700;}

#yiv0328313448 #yiv0328313448ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv0328313448 #yiv0328313448ygrp-sponsor #yiv0328313448ov
li a {
font-size:130%;text-decoration:none;}

#yiv0328313448 #yiv0328313448ygrp-sponsor #yiv0328313448ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0328313448 #yiv0328313448ygrp-sponsor #yiv0328313448ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv0328313448 #yiv0328313448ygrp-text {
font-family:Georgia;}

#yiv0328313448 #yiv0328313448ygrp-text p {
margin:0 0 1em 0;}

#yiv0328313448 #yiv0328313448ygrp-text tt {
font-size:120%;}

#yiv0328313448 #yiv0328313448ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0328313448