In a table, I have number of records belonging to a particular ID now
if I enter a value in one of the fileds of this table I want it to be
copied in all the records belonging to this particluar ID. for example
ID Name
--------------------------
1 xyz
1
1
1
2
2
2
When I enter "xyz" for any one of the record of ID# 1.. I want all the
other records (with ID# 1) to have the name field as "xyz" so after
this.. the table would look like this
ID Name
--------------------------
1 xyz
1 xyz
1 xyz
1 xyz
2
2
2
I know this is not possible in table itself.. However I presume it
would be possible to do this in a form. But I dont know HOW
cheers
Rex
Oct 5 '06
38  1818 
David W. Fenton wrote:
"Granny Spitz via AccessMonster.c om" <u26473@uwewrot e in
news:6760aec11f 3b8@uwe:
Oh, my!
You're an idiot.
<PLONK>
Lyle sings the old Connie Francis tune to Granny:
Who's sorry now?
Who's sorry now?
Whose heart is aching for breaking each vow?
Who's sad and blue?
Who's crying too?
Just like I cried over you?
Right to the end
Just like a friend
I tried to warn you somehow
You had your way,
Now you must pay
I'm glad that you're sorry now.
Just to try to make her feel better.
Lyle Fairfield wrote:
Lyle sings the old Connie Francis tune to Granny:
(snip)
Just to try to make her feel better.
That's so sweet of you, Lyle! I'm unhappy about being plonked, but you've
made me feel better. Thank you so much!
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200610/1
David W. Fenton wrote:
>Oh, my! You mean we're supposed to remember *when* it's safe to
use the ones that are on one list but not the other?!
(snip)
You're an idiot.
<PLONK>
I'm so glad David sugar coated that remark. I'd hate to hear what he
*really* thinks of me.
(Note to self: Don't quit day job in favor of that gig on the comedy circuit.
)
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200610/1
Granny Spitz via AccessMonster.c om wrote:
David W. Fenton wrote:
Oh, my! You mean we're supposed to remember *when* it's safe to
use the ones that are on one list but not the other?!
(snip)
You're an idiot.
<PLONK>
I'm so glad David sugar coated that remark. I'd hate to hear what he
*really* thinks of me.
Take the last train to Plonksville
And I'll meet you at the station.
You can be here by four thirty,
David made your reservation.
Don't be slow, oh, no, no, no!
Oh, no, no, no!
Cause I'm stuck way out in limbo,
David put me here as well.
Cruelly and without mercy
He just sent me to this hell
And I must go, oh, no, no, no!
Oh, no, no, no!
And I don't know if I'm ever coming back.
Take the last train to Plonksville.
I'll be waiting at the station.
We can talk VBA Idents
And some JET word reservations
Oh... oh, no, no, no!
Oh, no, no, no!
Take the last train to Plonksville,
Now I must hang up the phone.
I can't hear you in this noisy
Newsgroup all alone.
I'm feelin' low, oh, no, no, no!
Oh, no, no, no!
And I don't know if I'm ever coming back.
Take the last train to Plonksville,
Take the last train to Plonksville.
Lyle Fairfield wrote:
Granny Spitz via AccessMonster.c om wrote:
>David W. Fenton wrote:
>Oh, my! You mean we're supposed to remember *when* it's safe to
use the ones that are on one list but not the other?!
(snip)
You're an idiot.
<PLONK>
I'm so glad David sugar coated that remark. I'd hate to hear what he
*really* thinks of me.
Take the last train to Plonksville
And I'll meet you at the station.
You can be here by four thirty,
David made your reservation.
Don't be slow, oh, no, no, no!
Oh, no, no, no!
Cause I'm stuck way out in limbo,
David put me here as well.
Cruelly and without mercy
He just sent me to this hell
And I must go, oh, no, no, no!
Oh, no, no, no!
And I don't know if I'm ever coming back.
Take the last train to Plonksville.
I'll be waiting at the station.
We can talk VBA Idents
And some JET word reservations
Oh... oh, no, no, no!
Oh, no, no, no!
Take the last train to Plonksville,
Now I must hang up the phone.
I can't hear you in this noisy
Newsgroup all alone.
I'm feelin' low, oh, no, no, no!
Oh, no, no, no!
And I don't know if I'm ever coming back.
Take the last train to Plonksville,
Take the last train to Plonksville.
LOL! Thank you, Lyle! You made my day!
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200610/1
"Granny Spitz via AccessMonster.c om" wrote
LOL! Thank you, Lyle! You made my day!
You two DO know that you are taking all the sting that David intended right
out of his <PLONK>, don't you? :-) Why, you seem to be having fun with it!
Larry Linson wrote:
You two DO know that you are taking all the sting that David intended right
out of his <PLONK>, don't you?
That's one of Lyle's many talents!
Why, you seem to be having fun with it!
Yes indeed! But David will never know what's going on. He's plonked us both.
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200610/1
Granny Spitz via AccessMonster.c om wrote:
Yes indeed! But David will never know what's going on. He's plonked us both.
Of course, he won't. Suggesting that he does know or will know would
imply that he uses <PLONK!only for effect, to demonstrate his
capacity for incisive action. I'm sure David is much too genuine for
that, and I should know. After all he's plonked me several times ...
hmmmm ... ?
"Lyle Fairfield" <ly***********@ aim.comwrote in message
news:11******** ************@i3 g2000cwc.google groups.com...
Granny Spitz via AccessMonster.c om wrote:
>Yes indeed! But David will never know what's going on. He's plonked us
both.
Of course, he won't. Suggesting that he does know or will know would
imply that he uses <PLONK!only for effect, to demonstrate his
capacity for incisive action. I'm sure David is much too genuine for
that, and I should know. After all he's plonked me several times ...
hmmmm ... ?
Ah, ha! Term-limited plonks?
There's a fellow in a private newsgroup who does either term-limited plonks
or "virtual" plonks. After a while, he'll respond to something I post...
then I know he's reading my posts (again?). I know it doesn't mean that I'm
"out of the doghouse" with him, because it won't be long until he plonks me
again. See you in Plonksville, probably sooner than later.
Larry
Lyle Fairfield wrote:
I'm sure David is much too genuine for
that
I'm sure he's not bluffing either. I really am in Plonk City, at the corner
of Walk and Don't Walk.
After all he's plonked me several times ...
hmmmm ... ?
You're posts are worthy of a second, third, fourth,... chance. David's not
interested in anything I have to say. I won't be getting a second chance.
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200610/1 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Google Mike |
last post by:
I have RH9 and am using the PHP and MySQL that came with it. I was
doing fine with all manner of my web pages for this app until I
started having this very strange problem.
It's a work order mgmt system. I have 3 tables for the orders:
TicketsOpen, TicketsVoided, and TicketsResolved. When one wants to
void a ticket, they click it, choose Void, and it is copied to the
TicketsVoided table, then removed from the TicketsOpen. And I can...
|
by: Zoo Keeper |
last post by:
For some reason, the Python preprocessing balks on the "\" line continuation
character. Any ideas/thoughts? Is it just that my version of gcc is not
supported?
I don't "need" numeric in my current project, but it is a nice package to have!
Apps that do not need to be compiled install and run fine. Actually, SQLite
built and installed fine...
Thanks, in advance.
|
by: Club-B42 |
last post by:
i've compiled my programm using command "python setup.py py2exe >1"
python script works fine, but .exe version fails with
=====================================================================
D:\\Scripts\B-4-2\la2luncher\dist>la2launcher.exe
Traceback (most recent call last):
File "la2launcher.py", line 9, in ?
File "config.pyc", line 11, in ?
File "config.pyc", line 8, in u
LookupError: no codec search functions registered: can't find...
|
by: Jason |
last post by:
In enterprise manager I am copying a table from one database to
another. I am using the dts wizard to import the data. After I
successfully import the data, I open both tables to compare the
records to make sure they are the same. I right click on a field and
click "last" for both tables. However, the record is different for
both. If I do a query the record is still there but they do not show
up in the same order. Why does'nt the...
|
by: Vince |
last post by:
I have a very specific problem to solve but I cannot find a data
structure for it.
I don't know if I am posting on the good newsgroup but I cannot find
a software.design group.
I would like to declare a smart structure initialized via a XML file.
The goal of this structure is to store data from a smart card.
My XML file describes the file structure of my smart card. On a smart
card file are identified by number(sfid) and not by their...
| | |
by: Nathan Sokalski |
last post by:
I am writing an ASP.NET application in which I need to copy DataRows from
one DataTable to another. When I use code such as the following:
temprows = nodes.Select("state='PA'")
temptable.Clear()
For Each row As DataRow In temprows
temptable.Rows.Add(row)
Next
|
by: Howard, Steven |
last post by:
I have created a web app that stores and displays all the messages from
my database maintenance jobs that run each night. The web app uses Java
servlets and has PostgreSQL 7.0 as the back end.
When the user requests the first page, he gets a list of all the servers
with maintenance records in the database, and a drop down list of all
the dates of maintenance records. If the user chooses a date first, then
the app uses a prepared...
|
by: Neil |
last post by:
I'm using Access 2000 with a SQL 7 back end. I recently implemented some
code in a form's AfterUpdate event which calls a stored procedure which
copies the contents of the current record to a history table. The code works
fine when the user edits and saves the record. However, if the user performs
a Find and Replace, the code hangs.
At first I thought the code was hanging because of multiple records being
replaced. But when I debugged...
|
by: Jan |
last post by:
Hi:
I've been tearing my hair out over this one for a few days; did a search
of the archives and found similar questions but no real answers. Here goes:
This is an application for a retail store. There are transactions,
transaction details, and then, depending on the type of detail, related
records in other tables. So when I'm entering a new transaction, I open
a new form (dialog mode) in which additional detail is entered. I need...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
