If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A2007 - OLE vs. Attachements
I would like to add a picture to a record but do not know the best way to do
it. From what I can see OLE gives the option to "link" to the picture file rather than imbed the picture in the database which then bloats my database. The "attachment" type field has a nicer interface when I put it on a form but bloats the database. Is there a way to use the Attachment field type but have it be a link to the picture. Thanks, J |
#2
|
|||
|
|||
A2007 - OLE vs. Attachements
Store all your pictures in a common folder. Each picture will have an unique
path. Store the complete path in a text field in your table. To display your pictures in a form or report, add an image control (see the toolbox). Set the Picture property of the image control to the field that holds the path. Steve "Jay Oken" wrote in message ... I would like to add a picture to a record but do not know the best way to do it. From what I can see OLE gives the option to "link" to the picture file rather than imbed the picture in the database which then bloats my database. The "attachment" type field has a nicer interface when I put it on a form but bloats the database. Is there a way to use the Attachment field type but have it be a link to the picture. Thanks, J |
#3
|
|||
|
|||
A2007 - OLE vs. Attachements
Have you considered using the attachment field and bloating?
Pros and cons for each approach. A picture to a contact record is probably the typical senerio Microsoft envisioned for using the attachment field "as is". Not storing tons and tons of graphics etc... You get to see a preview of the image (for most formats). I believe they made it better on the "amount of bloating that occurs". I don't think you can use the attachment field to hold a link. You can add/extract attachments via code to move things back and forth from the filesystem to the database. HTH Mark "Jay Oken" wrote in message ... I would like to add a picture to a record but do not know the best way to do it. From what I can see OLE gives the option to "link" to the picture file rather than imbed the picture in the database which then bloats my database. The "attachment" type field has a nicer interface when I put it on a form but bloats the database. Is there a way to use the Attachment field type but have it be a link to the picture. Thanks, J |
#4
|
|||
|
|||
A2007 - OLE vs. Attachements
"Steve" schreef in bericht ... Store all your pictures in a common folder. Each picture will have an unique path. Store the complete path in a text field in your table. To display your pictures in a form or report, add an image control (see the toolbox). Set the Picture property of the image control to the field that holds the path. Steve -- Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 10.000 pageloads... it's a shame !!) For those who don't 'agree' with this mail , because $teve was 'helpfull' with his post... We warned him a thousand times... Sad, but he is not willing to stop advertising... He is just toying with these groups... advertising like hell... on and on... for years... oh yes... and sometimes he answers questions... indeed... and sometimes good souls here give him credit for that... == We are totally 'finished' with $teve now... == Killfile 'StopThisAdvertising' and you won't see these mails.... Arno R |
#5
|
|||
|
|||
A2007 - OLE vs. Attachements
This is ridiculous. So let's not ban a person who is clearly violating terms.
Let's instead create a MASSIVE online "info-attack" on them. Just ridiculous. So reminiscent of the Aaron Kempf drama. If Steve is the person that you claim then why oh, WHY are they NOT simply banned and their multitude of posts simply deleted? Bordering on stupid. -- www.Marzetti.com "StopThisAdvertising" wrote: "Steve" schreef in bericht ... Store all your pictures in a common folder. Each picture will have an unique path. Store the complete path in a text field in your table. To display your pictures in a form or report, add an image control (see the toolbox). Set the Picture property of the image control to the field that holds the path. Steve -- Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 10.000 pageloads... it's a shame !!) For those who don't 'agree' with this mail , because $teve was 'helpfull' with his post... We warned him a thousand times... Sad, but he is not willing to stop advertising... He is just toying with these groups... advertising like hell... on and on... for years... oh yes... and sometimes he answers questions... indeed... and sometimes good souls here give him credit for that... == We are totally 'finished' with $teve now... == Killfile 'StopThisAdvertising' and you won't see these mails.... Arno R |
#6
|
|||
|
|||
A2007 - OLE vs. Attachements
In all fairness, though, this post lacks the usual advertising... Or
is there something my browser doesn't show? |
#7
|
|||
|
|||
A2007 - OLE vs. Attachements
I don't see it, either. So in this instance one could argue that StopThis
Advertising is in violation of harrassment. These kinds of "wars" ruin things for everyone. StopThisAdvertising claims, "We warned him a thousand times..." Who is "we" and what/who has given "we" the authority to warn ANYBODY? I just reviewed the TOU: http://www.microsoft.com/info/cpyright.mspx#E1 These don't seem to have been altered for a couple years. If Steve is such a violator then he should be properly reported to MS. Steve appears to be a troll and to have taken on other identities. So if it can be so easily proven then simply do so and be done with it. I'm entirely annoyed by self-appointed forum police! Considering that Steve has been warned "a thousand times" yet is still free to post makes it CLEAR that those who have been warning him are entirely out of line. --- www.Marzetti.com "Piet Linden" wrote: In all fairness, though, this post lacks the usual advertising... Or is there something my browser doesn't show? |
#8
|
|||
|
|||
A2007 - OLE vs. Attachements
John,
I am not defedning anyone but please note that the TOU you preseted is for Software. The Rules of Conduct for the Newsgroup can be found here... http://www.microsoft.com/library/gal...RulesofConduct. And to quote... "Advertising/Solicitation: These communities were created as a forum for providing peer-to-peer assistance on Microsoft products and services. We ask that you refrain from posting advertisements or solicitations that do not pertain directly to the intended use and purpose of the newsgroup or chat." 1. No, I have to agree I do not see it in this posting either. HOWEVER, I have seen it as much as 9 (nine) times ALL in seperate posts. 2. and 3. As for who the "We" are please refer to postings where Steve has advertised. If you do a search on Steve you will find the "We" and the solicitations. 3. He has been reported several times and has had to make several adjustments to post here. I am not going to defend Steve or StopThisAdvertising. I will say if you don't want to see either one please use Killfile. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "JohnLute" wrote in message ... I don't see it, either. So in this instance one could argue that StopThis Advertising is in violation of harrassment. These kinds of "wars" ruin things for everyone. StopThisAdvertising claims, "We warned him a thousand times..." Who is "we" and what/who has given "we" the authority to warn ANYBODY? I just reviewed the TOU: http://www.microsoft.com/info/cpyright.mspx#E1 These don't seem to have been altered for a couple years. If Steve is such a violator then he should be properly reported to MS. Steve appears to be a troll and to have taken on other identities. So if it can be so easily proven then simply do so and be done with it. I'm entirely annoyed by self-appointed forum police! Considering that Steve has been warned "a thousand times" yet is still free to post makes it CLEAR that those who have been warning him are entirely out of line. --- www.Marzetti.com "Piet Linden" wrote: In all fairness, though, this post lacks the usual advertising... Or is there something my browser doesn't show? |
#9
|
|||
|
|||
A2007 - OLE vs. Attachements
Thanks for the clarification, Gina. I'm certainly not defending anyone,
either. I'm simply saying that the "info-attack" on Steve is as ridiculous and annoying as Steve's trolling for $$$. This smacks of the Aaron Kempf issue. Good GAWSH - if the Rules of Conduct are so explicit and clear than why in the world are these things allowed to blow up like this? Simply ban the offender and get on with life. I really appreciate these forums but I find these playground antics just a bit much and feel compelled to voice my irritation. -- www.Marzetti.com "Gina Whipp" wrote: John, I am not defedning anyone but please note that the TOU you preseted is for Software. The Rules of Conduct for the Newsgroup can be found here... http://www.microsoft.com/library/gal...RulesofConduct. And to quote... "Advertising/Solicitation: These communities were created as a forum for providing peer-to-peer assistance on Microsoft products and services. We ask that you refrain from posting advertisements or solicitations that do not pertain directly to the intended use and purpose of the newsgroup or chat." 1. No, I have to agree I do not see it in this posting either. HOWEVER, I have seen it as much as 9 (nine) times ALL in seperate posts. 2. and 3. As for who the "We" are please refer to postings where Steve has advertised. If you do a search on Steve you will find the "We" and the solicitations. 3. He has been reported several times and has had to make several adjustments to post here. I am not going to defend Steve or StopThisAdvertising. I will say if you don't want to see either one please use Killfile. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "JohnLute" wrote in message ... I don't see it, either. So in this instance one could argue that StopThis Advertising is in violation of harrassment. These kinds of "wars" ruin things for everyone. StopThisAdvertising claims, "We warned him a thousand times..." Who is "we" and what/who has given "we" the authority to warn ANYBODY? I just reviewed the TOU: http://www.microsoft.com/info/cpyright.mspx#E1 These don't seem to have been altered for a couple years. If Steve is such a violator then he should be properly reported to MS. Steve appears to be a troll and to have taken on other identities. So if it can be so easily proven then simply do so and be done with it. I'm entirely annoyed by self-appointed forum police! Considering that Steve has been warned "a thousand times" yet is still free to post makes it CLEAR that those who have been warning him are entirely out of line. --- www.Marzetti.com "Piet Linden" wrote: In all fairness, though, this post lacks the usual advertising... Or is there something my browser doesn't show? |
#10
|
|||
|
|||
A2007 - OLE vs. Attachements
The problem is that these newsgroups aren't moderated, nor can they be.
You're using Microsoft's web interface to post, but you're actually posting to NNTP newsgroups, not a website. The groups exist on a multitude of servers, not simply the ones that Microsoft administers themselves (msnews.microsoft.com). While Microsoft conceivably could delete posts originating on their server, they would be unable to delete posts originating on other servers. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "JohnLute" wrote in message ... Thanks for the clarification, Gina. I'm certainly not defending anyone, either. I'm simply saying that the "info-attack" on Steve is as ridiculous and annoying as Steve's trolling for $$$. This smacks of the Aaron Kempf issue. Good GAWSH - if the Rules of Conduct are so explicit and clear than why in the world are these things allowed to blow up like this? Simply ban the offender and get on with life. I really appreciate these forums but I find these playground antics just a bit much and feel compelled to voice my irritation. -- www.Marzetti.com "Gina Whipp" wrote: John, I am not defedning anyone but please note that the TOU you preseted is for Software. The Rules of Conduct for the Newsgroup can be found here... http://www.microsoft.com/library/gal...RulesofConduct. And to quote... "Advertising/Solicitation: These communities were created as a forum for providing peer-to-peer assistance on Microsoft products and services. We ask that you refrain from posting advertisements or solicitations that do not pertain directly to the intended use and purpose of the newsgroup or chat." 1. No, I have to agree I do not see it in this posting either. HOWEVER, I have seen it as much as 9 (nine) times ALL in seperate posts. 2. and 3. As for who the "We" are please refer to postings where Steve has advertised. If you do a search on Steve you will find the "We" and the solicitations. 3. He has been reported several times and has had to make several adjustments to post here. I am not going to defend Steve or StopThisAdvertising. I will say if you don't want to see either one please use Killfile. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "JohnLute" wrote in message ... I don't see it, either. So in this instance one could argue that StopThis Advertising is in violation of harrassment. These kinds of "wars" ruin things for everyone. StopThisAdvertising claims, "We warned him a thousand times..." Who is "we" and what/who has given "we" the authority to warn ANYBODY? I just reviewed the TOU: http://www.microsoft.com/info/cpyright.mspx#E1 These don't seem to have been altered for a couple years. If Steve is such a violator then he should be properly reported to MS. Steve appears to be a troll and to have taken on other identities. So if it can be so easily proven then simply do so and be done with it. I'm entirely annoyed by self-appointed forum police! Considering that Steve has been warned "a thousand times" yet is still free to post makes it CLEAR that those who have been warning him are entirely out of line. --- www.Marzetti.com "Piet Linden" wrote: In all fairness, though, this post lacks the usual advertising... Or is there something my browser doesn't show? |
Thread Tools | |
Display Modes | |
|
|