Andy Lacey
andy at minstersystems.co.uk
Wed Apr 2 09:24:44 CST 2003
Seconded, thirded etc, just great. Andy Lacey http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/> -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: 02 April 2003 15:54 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' 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 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' 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 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 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/20030402/7633d10e/attachment-0001.html>