Minggu, 30 November 2014

Re: [MS_AccessPros] MAXIMUM NUMBER OF CRITERIA IN MSACCESS QUERY

 

It's not the number of columns, it's the complexity of the SQL.  The query engine "compiles" your query into something like a 64K "workspace", and if the compile won't fit in that, you'll get query too complex.  A very complex WHERE clause is often the culprit.


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 
(Paris, France)




On Dec 1, 2014, at 1:51 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Can you share the SQL view? Have you declared the data type of your criteria?

Duane Hookom, MVP
MS Access


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Sun, 30 Nov 2014 23:24:33 +0000
Subject: [MS_AccessPros] MAXIMUM NUMBER OF CRITERIA IN MSACCESS QUERY



Please can someone assist. I was running a query with many criteria (very well in  excess of 60) and the system came back with a message that 'Query is too complex' I thought I could go as far as 255 columns .

Thanks.

Ade.





__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)

.

__,_._,___

Re: [MS_AccessPros] Any Suggestions for SharePoint Services?

 

Jerry-

No, it's not against the rules of this group to ask for help like this. It IS against the rules to advertise your own service.

I checked with my provider - Lunarpages - and they do offer web hosting on Windows, but do not appear to offer SharePoint.

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 Dec 1, 2014, at 6:10 AM, Jerry bearjercares@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

If it is not against the rules of this group, are there any of you in
the group who could recommend inexpensive Internet hosting services who
have SharePoint servers and can accommodate Microsoft Access
databases? Thanks! Jerry in Michigan, USA

------------------------------------
Posted by: Jerry <bearjercares@gmail.com>
------------------------------------

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

Yahoo Groups Links

__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

[belajar-access] ACCESS FORM IN HTML

 

Dear suhu access


mohon bantuannya, saya sedang coba menjalankan form di database access 2007 ke dalam HTML internet, ada ide?


Thanks

__._,_.___

Posted by: abduldedysubhansyah@yahoo.co.id
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Yahoo Groups
Test Campaign
subject line for test

SPAM IS PROHIBITED

.

__,_._,___

[MS_AccessPros] Any Suggestions for SharePoint Services?

 

If it is not against the rules of this group, are there any of you in
the group who could recommend inexpensive Internet hosting services who
have SharePoint servers and can accommodate Microsoft Access
databases? Thanks! Jerry in Michigan, USA

__._,_.___

Posted by: Jerry <bearjercares@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

RE: [MS_AccessPros] MAXIMUM NUMBER OF CRITERIA IN MSACCESS QUERY

 

Can you share the SQL view? Have you declared the data type of your criteria?

Duane Hookom, MVP
MS Access


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Sun, 30 Nov 2014 23:24:33 +0000
Subject: [MS_AccessPros] MAXIMUM NUMBER OF CRITERIA IN MSACCESS QUERY



Please can someone assist. I was running a query with many criteria (very well in  excess of 60) and the system came back with a message that 'Query is too complex' I thought I could go as far as 255 columns .

Thanks.

Ade.




__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (9)

.

__,_._,___

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

__._,_.___

Posted by: Kambiz Afshartous <kenaf42@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (13)

.

__,_._,___

Re: [MS_AccessPros] Help with VBA

 

Hello Crystal
Thank you for your help. Problem is solved, it was my mistake trying to run the code while form was in Edit mode. It works well in Add mode.
Kambiz

--------------------------------------------
On Sat, 11/29/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: Saturday, November 29, 2014, 12:34 AM


 









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


Traditional

    (Yahoo! ID required)

    MS_Access_Professionals-fullfeatured@yahoogroups.com















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

#yiv8546906046 #yiv8546906046ygrp-mkp hr {
border:1px solid #d8d8d8;}

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

#yiv8546906046 #yiv8546906046ygrp-mkp #yiv8546906046ads {
margin-bottom:10px;}

#yiv8546906046 #yiv8546906046ygrp-mkp .yiv8546906046ad {
padding:0 0;}

#yiv8546906046 #yiv8546906046ygrp-mkp .yiv8546906046ad p {
margin:0;}

#yiv8546906046 #yiv8546906046ygrp-mkp .yiv8546906046ad a {
color:#0000ff;text-decoration:none;}
#yiv8546906046 #yiv8546906046ygrp-sponsor
#yiv8546906046ygrp-lc {
font-family:Arial;}

#yiv8546906046 #yiv8546906046ygrp-sponsor
#yiv8546906046ygrp-lc #yiv8546906046hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv8546906046 #yiv8546906046ygrp-sponsor
#yiv8546906046ygrp-lc .yiv8546906046ad {
margin-bottom:10px;padding:0 0;}

#yiv8546906046 #yiv8546906046actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv8546906046 #yiv8546906046activity span {
font-weight:700;}

#yiv8546906046 #yiv8546906046activity span:first-child {
text-transform:uppercase;}

#yiv8546906046 #yiv8546906046activity span a {
color:#5085b6;text-decoration:none;}

#yiv8546906046 #yiv8546906046activity span span {
color:#ff7900;}

#yiv8546906046 #yiv8546906046activity span
.yiv8546906046underline {
text-decoration:underline;}

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

#yiv8546906046 .yiv8546906046attach div a {
text-decoration:none;}

#yiv8546906046 .yiv8546906046attach img {
border:none;padding-right:5px;}

#yiv8546906046 .yiv8546906046attach label {
display:block;margin-bottom:5px;}

#yiv8546906046 .yiv8546906046attach label a {
text-decoration:none;}

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

#yiv8546906046 .yiv8546906046bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv8546906046 .yiv8546906046bold a {
text-decoration:none;}

#yiv8546906046 dd.yiv8546906046last p a {
font-family:Verdana;font-weight:700;}

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

#yiv8546906046 dd.yiv8546906046last p
span.yiv8546906046yshortcuts {
margin-right:0;}

#yiv8546906046 div.yiv8546906046attach-table div div a {
text-decoration:none;}

#yiv8546906046 div.yiv8546906046attach-table {
width:400px;}

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

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

#yiv8546906046 div#yiv8546906046ygrp-mlmsg
#yiv8546906046ygrp-msg p a span.yiv8546906046yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv8546906046 .yiv8546906046green {
color:#628c2a;}

#yiv8546906046 .yiv8546906046MsoNormal {
margin:0 0 0 0;}

#yiv8546906046 o {
font-size:0;}

#yiv8546906046 #yiv8546906046photos div {
float:left;width:72px;}

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

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

#yiv8546906046 #yiv8546906046reco-category {
font-size:77%;}

#yiv8546906046 #yiv8546906046reco-desc {
font-size:77%;}

#yiv8546906046 .yiv8546906046replbq {
margin:4px;}

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

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

#yiv8546906046 #yiv8546906046ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv8546906046 #yiv8546906046ygrp-mlmsg pre, #yiv8546906046
code {
font:115% monospace;}

#yiv8546906046 #yiv8546906046ygrp-mlmsg * {
line-height:1.22em;}

#yiv8546906046 #yiv8546906046ygrp-mlmsg #yiv8546906046logo {
padding-bottom:10px;}


#yiv8546906046 #yiv8546906046ygrp-msg p a {
font-family:Verdana;}

#yiv8546906046 #yiv8546906046ygrp-msg
p#yiv8546906046attach-count span {
color:#1E66AE;font-weight:700;}

#yiv8546906046 #yiv8546906046ygrp-reco
#yiv8546906046reco-head {
color:#ff7900;font-weight:700;}

#yiv8546906046 #yiv8546906046ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv8546906046 #yiv8546906046ygrp-sponsor #yiv8546906046ov
li a {
font-size:130%;text-decoration:none;}

#yiv8546906046 #yiv8546906046ygrp-sponsor #yiv8546906046ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv8546906046 #yiv8546906046ygrp-sponsor #yiv8546906046ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv8546906046 #yiv8546906046ygrp-text {
font-family:Georgia;}

#yiv8546906046 #yiv8546906046ygrp-text p {
margin:0 0 1em 0;}

#yiv8546906046 #yiv8546906046ygrp-text tt {
font-size:120%;}

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

__._,_.___

Posted by: Kambiz Afshartous <kenaf42@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (12)

.

__,_._,___