[AccessD] Roz Got Married ...was Updating queries with linke d tables

Francisco H Tapia my.lists at verizon.net
Wed Apr 2 11:30:34 CST 2003


Congratulations Roz! Don't start any bound/unbound wars now that you're
married ;o).

-Francisco
http://rcm.netfirms.com

On Wednesday, April 02, 2003 5:41 AM [GMT-8],
Roz Clarke <roz.clarke at donnslaw.co.uk> wrote:

: My dad's very kindly put my sister's snaps on his site
:
:  <http://www.dcs.qmul.ac.uk/~keithc/wedding/>
: http://www.dcs.qmul.ac.uk/~keithc/wedding/
:
: Roz
:
:
:
: -----Original Message-----
: From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
: Sent: 02 April 2003 14:01
: To: 'accessd at databaseadvisors.com'
: Subject: RE: [AccessD] Roz Got Married ...was Updating queries with
: linke d tables
:
:
:
: LOL
:
: OK I'll tell, but remember I'm supposed to be setting a good example!!
:
: Pics aren't up anywhere as yet, hopefully we can get that done tonight
: before folks lose interest :)
:
: As you can see, I'm honeymooning in the office, but the wedding itself
: was completely fab. Marrying Paul was the most exciting moment of my
: whole life, the venue was ace, we both shook all the way through the
: ceremony, people cried, my hair was fantastic (ask Pamela, she's had a
: photo), I mean, it was just wonderful. And it was OURS <vbg>
:
: I guess you always think your own will be the best wedding you've been
: to (and it was) but so many other people said the same thing that I
: have to believe it was a good wedding!
:
: I can't send photos from here but if anyone wants one, mail me at
: zora_db at yahoo.com <mailto:zora_db at yahoo.com>  and I'll send one when I
: get home tonight.
:
: -----Original Message-----
: From: William Hindman [mailto:wdhindman at bellsouth.net]
: Sent: 02 April 2003 03:54
: To: accessd at databaseadvisors.com
: Subject: [AccessD] Roz Got Married ...was Updating queries with linked
: tables
:
:
: ...to heck with queries Roz ...tell us about the wedding, the
: honeymoon ...and where the pics are? :))))
:
: William Hindman
: "War is an ugly thing but not the ugliest of things; the decayed and
: degraded state of moral and patriotic feelings which thinks that
: nothing is worth war is much worse. A man who has nothing for which
: he is willing to fight, nothing which is more important than his own
: personal safety, is a miserable creature and has no chance of being
: free unless made and kept so by the exertions of better men than
: himself."  John Stuart Mill
:
:
: ----- Original Message -----
: From: Roz Clarke <mailto:roz.clarke at donnslaw.co.uk>
: To: 'accessd at databaseadvisors.com'
: <mailto:'accessd at databaseadvisors.com'>
: Sent: Tuesday, April 01, 2003 10:52 AM
: Subject: RE: [AccessD] Updating queries with linked tables
:
: No blank record, all fields locked.
:
: It wouldn't surprise me if this is just a 'feature'.
:
: R.
:
: -----Original Message-----
: From: Susan Harkins [mailto:harkins at iglou.com]
: Sent: 01 April 2003 16:25
: To: accessd at databaseadvisors.com <mailto:accessd at databaseadvisors.com>
: Subject: Re: [AccessD] Updating queries with linked tables
:
:
: Well, when you say "combine" -- I think of append or UNION.
: Relationships "join" records -- nothing wrong with the way you siad it
: -- I just thought I'd check to make sure. So here's the next question
: -- how do you know it's not updateable? Are you getting an error
: message? Is there a blank (new) record at the bottom of the query in
: Datasheet View?
:
: Susan H.
:
:
:
: Standard left outer join on staff ID - is there another way?!
: *bangs head on desk*
:
: R.
:
:  -----Original Message-----
: From: Susan Harkins [mailto:harkins at iglou.com]
: Sent: 31-Mar-2003 17:20
: To: accessd at databaseadvisors.com <mailto:accessd at databaseadvisors.com>
: Subject: Re: [AccessD] Updating queries with linked tables
:
:
:
: How are you combining your tables?
:
: Susan H.
:
: What I'm finding (and I can't believe I never hit this before) is that
: although the SQL tables can be updated through the Access FE, and the
: local tables can be updated, combine them and wallop, not updateable.
: Even if all the key fields are included in the query.




More information about the AccessD mailing list