ACCESS FEED: Re: [MS_AccessPros] Help with VBA

Kamis, 27 November 2014

Re: [MS_AccessPros] Help with VBA

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