Dear Liveson,
Thank you
for your tips, but this is not one, which I am searching for; it is because my
question may lead you in a different way.
I will ask my doubt in a different way
I have one table like follow
Product name
Material utiles no:1
Material utiles no:1
Material utiles no:1
xyz
Calcium
Magnesium
Carbonates
abc
Calcium
Magnesium
Carbonates
def
Calcium
Magnesium
Carbonates
Now I want to make one new table in there I want to enter
the qty of material utilise in respective product name. my future table view
like follow
Product name
Calcium
Magnesium
Carbonates
xyz
25
36
38
abc
2
252
238
def
235
2465
264
So the filed name in second table from first tables
This is my problem pls give me some solution for this
Any tips pls
Regards
Faisal
Riyadh
----- Original Message ----
From: L Tumbulu <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, December 4, 2007 4:26:32 PM
Subject: Re: [ms_access] table field name
I personally don't know if it is possible to have a field in one
table automatically updated when data in a field in another table is changed.
What I know is that you can write code in VBA in AfterUpdate event that runs a
query that updates a field in the other table. For example you write the
following code
Dim stSQL As String, stCriteria as String
stSQL = "UPDATE YourTableName SET FieldName = " & Me.TextBoxNameOnFor m
CurrentDb.Execute stSQL, dbFailOnError
where YourTableName is the name of the table, FieldName is the name of the
filed in the table and TextBoxNameOnForm is the name of the textbox on the form
on which the AfterUpdate event has occurred. If the textbox contains
non-numeric data then enclose it in single quotes like stSQL = "UPDATE
YourTableName SET FieldName = '" & Me.TextBoxNameOnFor m & "'". Please note
that there is a single quote soon after the second equals sign and a single
quote with double quotes on either side at the end.
HTH
Liveson
----- Original Message -----
From: Muhamed Faisal
To: [EMAIL PROTECTED] ps.com
Sent: Tuesday, 04 December, 2007 2:18 PM
Subject: [ms_access] table field name
dears,
There is any way to have a tables field name should automaticaly liknked with
another table
becuse i want to design a table in there field name should updated
utomaticaly from another table
any tips pls
regrds
Faisal
Riyadh
____________ _________ _________ _________ _________ _________ _
Be a better pen pal.
Text or chat with friends inside Yahoo! Mail. See how. http://overview.
mail.yahoo. com/
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
[Non-text portions of this message have been removed]
