Selasa, 23 Agustus 2016

Re: [MS_AccessPros] From Screen to Add or Edit screen

 


Does anyone have any ideas or advise?

With Warm Regards,
 

Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

--------------------------------------------
On Fri, 8/19/16, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Subject: [MS_AccessPros] From Screen to Add or Edit screen
To: MS_Access_Professionals@yahoogroups.com
Date: Friday, August 19, 2016, 11:39 AM


 









I have a screen called frmHohSearch
which has the following unbound fields on
it:txtLastNametxtFirstNametxtPhonetxtSSNcmdNext

When in use, the user will
fill out one or all the fields and then click the cmdNext
button. I need to lookup in a table called
tblHeadOfHousehold (primary key HohID) by whatever criteria
that was entered on the frmHohSearch, if a record is found I
need to open a form called frmHoHDetails in edit mode with
the record found. If multiple records are found I would like
to pop a msg box listing the multiple values and probably a
way to select the record they want to edit.
If a record was not found I need to open
the form frmHoHdetails in add mode.
Hope that makes
sense.
Thank you Art
Lorenzini










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

#yiv5259635555 #yiv5259635555ygrp-mkp hr {
border:1px solid #d8d8d8;}

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

#yiv5259635555 #yiv5259635555ygrp-mkp #yiv5259635555ads {
margin-bottom:10px;}

#yiv5259635555 #yiv5259635555ygrp-mkp .yiv5259635555ad {
padding:0 0;}

#yiv5259635555 #yiv5259635555ygrp-mkp .yiv5259635555ad p {
margin:0;}

#yiv5259635555 #yiv5259635555ygrp-mkp .yiv5259635555ad a {
color:#0000ff;text-decoration:none;}
#yiv5259635555 #yiv5259635555ygrp-sponsor
#yiv5259635555ygrp-lc {
font-family:Arial;}

#yiv5259635555 #yiv5259635555ygrp-sponsor
#yiv5259635555ygrp-lc #yiv5259635555hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5259635555 #yiv5259635555ygrp-sponsor
#yiv5259635555ygrp-lc .yiv5259635555ad {
margin-bottom:10px;padding:0 0;}

#yiv5259635555 #yiv5259635555actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv5259635555 #yiv5259635555activity span {
font-weight:700;}

#yiv5259635555 #yiv5259635555activity span:first-child {
text-transform:uppercase;}

#yiv5259635555 #yiv5259635555activity span a {
color:#5085b6;text-decoration:none;}

#yiv5259635555 #yiv5259635555activity span span {
color:#ff7900;}

#yiv5259635555 #yiv5259635555activity span
.yiv5259635555underline {
text-decoration:underline;}

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

#yiv5259635555 .yiv5259635555attach div a {
text-decoration:none;}

#yiv5259635555 .yiv5259635555attach img {
border:none;padding-right:5px;}

#yiv5259635555 .yiv5259635555attach label {
display:block;margin-bottom:5px;}

#yiv5259635555 .yiv5259635555attach label a {
text-decoration:none;}

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

#yiv5259635555 .yiv5259635555bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5259635555 .yiv5259635555bold a {
text-decoration:none;}

#yiv5259635555 dd.yiv5259635555last p a {
font-family:Verdana;font-weight:700;}

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

#yiv5259635555 dd.yiv5259635555last p
span.yiv5259635555yshortcuts {
margin-right:0;}

#yiv5259635555 div.yiv5259635555attach-table div div a {
text-decoration:none;}

#yiv5259635555 div.yiv5259635555attach-table {
width:400px;}

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

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

#yiv5259635555 div#yiv5259635555ygrp-mlmsg
#yiv5259635555ygrp-msg p a span.yiv5259635555yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5259635555 .yiv5259635555green {
color:#628c2a;}

#yiv5259635555 .yiv5259635555MsoNormal {
margin:0 0 0 0;}

#yiv5259635555 o {
font-size:0;}

#yiv5259635555 #yiv5259635555photos div {
float:left;width:72px;}

#yiv5259635555 #yiv5259635555photos div div {
border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}

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

#yiv5259635555 #yiv5259635555reco-category {
font-size:77%;}

#yiv5259635555 #yiv5259635555reco-desc {
font-size:77%;}

#yiv5259635555 .yiv5259635555replbq {
margin:4px;}

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

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

#yiv5259635555 #yiv5259635555ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv5259635555 #yiv5259635555ygrp-mlmsg pre, #yiv5259635555
code {
font:115% monospace;}

#yiv5259635555 #yiv5259635555ygrp-mlmsg * {
line-height:1.22em;}

#yiv5259635555 #yiv5259635555ygrp-mlmsg #yiv5259635555logo {
padding-bottom:10px;}


#yiv5259635555 #yiv5259635555ygrp-msg p a {
font-family:Verdana;}

#yiv5259635555 #yiv5259635555ygrp-msg
p#yiv5259635555attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5259635555 #yiv5259635555ygrp-reco
#yiv5259635555reco-head {
color:#ff7900;font-weight:700;}

#yiv5259635555 #yiv5259635555ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5259635555 #yiv5259635555ygrp-sponsor #yiv5259635555ov
li a {
font-size:130%;text-decoration:none;}

#yiv5259635555 #yiv5259635555ygrp-sponsor #yiv5259635555ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5259635555 #yiv5259635555ygrp-sponsor #yiv5259635555ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5259635555 #yiv5259635555ygrp-text {
font-family:Georgia;}

#yiv5259635555 #yiv5259635555ygrp-text p {
margin:0 0 1em 0;}

#yiv5259635555 #yiv5259635555ygrp-text tt {
font-size:120%;}

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

__._,_.___
Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

__,_._,___
Diposting oleh di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)