Here is again my db......
On Thursday, October 5, 2017 3:39 PM, "ashfaque_online@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Sir,
I have sent my db to ms_access_professionals-owner@yahoogroups.com the address given by someone in trailing post of this thread.
Because there is no appearance of upload button here. What is the reason Sir, I do not have any idea.
But I sent my zip file on the given email id. If there is any other email address, I will send zip file again.
Now the question is what I need.
My codes are exporting data to a excel file in which is it adding number of difference sheets in ONE single file kept as read-only at some destination.
The data is of vehicle expenses. Each sheet in the excel file are given a vehicle number.
We have around 96 vehicles so my code is adding 96 sheets and placing data on it. Finally the code add last sheet and names it as SUMMARY where all the vehicle numbers are generated.
Now let us say we are in Excel sheet (as it is just received data from Access codes) I want when I click the vehicle number on SUMMARY sheet, control should transfer to that particular sheet and thats all.
Hopefully I have explained it properly.
Thanks,Ashfaque #yiv4065951751 #yiv4065951751 -- #yiv4065951751ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4065951751 #yiv4065951751ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4065951751 #yiv4065951751ygrp-mkp #yiv4065951751hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4065951751 #yiv4065951751ygrp-mkp #yiv4065951751ads {margin-bottom:10px;}#yiv4065951751 #yiv4065951751ygrp-mkp .yiv4065951751ad {padding:0 0;}#yiv4065951751 #yiv4065951751ygrp-mkp .yiv4065951751ad p {margin:0;}#yiv4065951751 #yiv4065951751ygrp-mkp .yiv4065951751ad a {color:#0000ff;text-decoration:none;}#yiv4065951751 #yiv4065951751ygrp-sponsor #yiv4065951751ygrp-lc {font-family:Arial;}#yiv4065951751 #yiv4065951751ygrp-sponsor #yiv4065951751ygrp-lc #yiv4065951751hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4065951751 #yiv4065951751ygrp-sponsor #yiv4065951751ygrp-lc .yiv4065951751ad {margin-bottom:10px;padding:0 0;}#yiv4065951751 #yiv4065951751actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4065951751 #yiv4065951751activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4065951751 #yiv4065951751activity span {font-weight:700;}#yiv4065951751 #yiv4065951751activity span:first-child {text-transform:uppercase;}#yiv4065951751 #yiv4065951751activity span a {color:#5085b6;text-decoration:none;}#yiv4065951751 #yiv4065951751activity span span {color:#ff7900;}#yiv4065951751 #yiv4065951751activity span .yiv4065951751underline {text-decoration:underline;}#yiv4065951751 .yiv4065951751attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4065951751 .yiv4065951751attach div a {text-decoration:none;}#yiv4065951751 .yiv4065951751attach img {border:none;padding-right:5px;}#yiv4065951751 .yiv4065951751attach label {display:block;margin-bottom:5px;}#yiv4065951751 .yiv4065951751attach label a {text-decoration:none;}#yiv4065951751 blockquote {margin:0 0 0 4px;}#yiv4065951751 .yiv4065951751bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4065951751 .yiv4065951751bold a {text-decoration:none;}#yiv4065951751 dd.yiv4065951751last p a {font-family:Verdana;font-weight:700;}#yiv4065951751 dd.yiv4065951751last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4065951751 dd.yiv4065951751last p span.yiv4065951751yshortcuts {margin-right:0;}#yiv4065951751 div.yiv4065951751attach-table div div a {text-decoration:none;}#yiv4065951751 div.yiv4065951751attach-table {width:400px;}#yiv4065951751 div.yiv4065951751file-title a, #yiv4065951751 div.yiv4065951751file-title a:active, #yiv4065951751 div.yiv4065951751file-title a:hover, #yiv4065951751 div.yiv4065951751file-title a:visited {text-decoration:none;}#yiv4065951751 div.yiv4065951751photo-title a, #yiv4065951751 div.yiv4065951751photo-title a:active, #yiv4065951751 div.yiv4065951751photo-title a:hover, #yiv4065951751 div.yiv4065951751photo-title a:visited {text-decoration:none;}#yiv4065951751 div#yiv4065951751ygrp-mlmsg #yiv4065951751ygrp-msg p a span.yiv4065951751yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4065951751 .yiv4065951751green {color:#628c2a;}#yiv4065951751 .yiv4065951751MsoNormal {margin:0 0 0 0;}#yiv4065951751 o {font-size:0;}#yiv4065951751 #yiv4065951751photos div {float:left;width:72px;}#yiv4065951751 #yiv4065951751photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4065951751 #yiv4065951751photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4065951751 #yiv4065951751reco-category {font-size:77%;}#yiv4065951751 #yiv4065951751reco-desc {font-size:77%;}#yiv4065951751 .yiv4065951751replbq {margin:4px;}#yiv4065951751 #yiv4065951751ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4065951751 #yiv4065951751ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4065951751 #yiv4065951751ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4065951751 #yiv4065951751ygrp-mlmsg select, #yiv4065951751 input, #yiv4065951751 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4065951751 #yiv4065951751ygrp-mlmsg pre, #yiv4065951751 code {font:115% monospace;}#yiv4065951751 #yiv4065951751ygrp-mlmsg * {line-height:1.22em;}#yiv4065951751 #yiv4065951751ygrp-mlmsg #yiv4065951751logo {padding-bottom:10px;}#yiv4065951751 #yiv4065951751ygrp-msg p a {font-family:Verdana;}#yiv4065951751 #yiv4065951751ygrp-msg p#yiv4065951751attach-count span {color:#1E66AE;font-weight:700;}#yiv4065951751 #yiv4065951751ygrp-reco #yiv4065951751reco-head {color:#ff7900;font-weight:700;}#yiv4065951751 #yiv4065951751ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4065951751 #yiv4065951751ygrp-sponsor #yiv4065951751ov li a {font-size:130%;text-decoration:none;}#yiv4065951751 #yiv4065951751ygrp-sponsor #yiv4065951751ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4065951751 #yiv4065951751ygrp-sponsor #yiv4065951751ov ul {margin:0;padding:0 0 0 8px;}#yiv4065951751 #yiv4065951751ygrp-text {font-family:Georgia;}#yiv4065951751 #yiv4065951751ygrp-text p {margin:0 0 1em 0;}#yiv4065951751 #yiv4065951751ygrp-text tt {font-size:120%;}#yiv4065951751 #yiv4065951751ygrp-vital ul li:last-child {border-right:none !important;}#yiv4065951751
| | Virus-free. www.avg.com |
[Non-text portions of this message have been removed]
Posted by: Sayyed Ashfaque Hussain <ashfaque_online@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar