Roz Clarke
roz.clarke at donnslaw.co.uk
Thu Apr 3 02:30:12 CST 2003
Thanks everyone *hugs*, but much as I could chat all day, all WEEK about it, I know not everyone is so totally enthralled by the topic. Beavered away last night and got the pics set up on our own site - and lots more of them - at http://homepage.ntlworld.com/maxamber/gallery/gallery.htm <http://homepage.ntlworld.com/maxamber/gallery/gallery.htm> The b&w ones were taken by our friends Sienna & Enzo and are really good photos. I hope you like it 'cause I missed the football to get it done! That's it from me - if you can stand to hear any more you have my yahoo address and my msn id is the same. Roz -----Original Message----- From: Drew Wutka [mailto:DWUTKA at marlow.com] Sent: 02 April 2003 19:30 To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] OT / Roz Got Married I second that. I think part of the 'charm' of the List, is that it's like a big family. Drew -----Original Message----- From: William Hindman [mailto:wdhindman at bellsouth.net] Sent: Wednesday, April 02, 2003 8:54 AM To: accessd at databaseadvisors.com Subject: [AccessD] OT / Roz Got Married ...ok ...change in subject to be PC ...but anytime one of our own has such a major life change, it is ON TOPIC as far as I'm concerned ...Pamela had already sent me some pics ...just thought the rest of AccessD would like to know how great you looked :))) 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: Wednesday, April 02, 2003 8:00 AM Subject: RE: [AccessD] Roz Got Married ...was Updating queries with linked 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. _____ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _____ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _____ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030403/9189ca16/attachment-0001.html>