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

Roz Clarke roz.clarke at donnslaw.co.uk
Wed Apr 2 07:00:38 CST 2003


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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030402/82ada16e/attachment-0001.html>


More information about the AccessD mailing list