[AccessD] OT / Roz Got Married

Lembit Soobik Lembit.Soobik at t-online.de
Wed Apr 2 11:04:34 CST 2003


Messageagree,
sincere congratulations, and I wish you a really happy time together.
Lembit

Lembit Soobik

  ----- Original Message ----- 
  From: William Hindman 
  To: accessd at databaseadvisors.com 
  Sent: Wednesday, April 02, 2003 4:53 PM
  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 
    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 
        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



------------------------------------------------------------------------------


  _______________________________________________
  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/362fae6b/attachment-0001.html>


More information about the AccessD mailing list