Hodgins Family wrote:
Good morning!
No matter what, there will always be at least one feature that you
liked better in another product.
That is clear.
People would look at me funny if I said that I refused to use any MS
Office product because they do not support exporting to a PDF file
like OpenOffice.org has supported for a long time. At least with OOo,
you are able to create an RFE (Request For Enhancement).
I had been thinking about waiting for the next release until the OP
brought the issue up.
I poked around the data types and I could not find anything
resembling what you desire. This sounds like a useful thing to have.
It is nothing more than a text field with special properites. You can
probably use a Pattern Field. What sort of URLs did you want to
recognize?
For simplicity, I have photos, word processing docs, etc. (call 'em
FILES) living on one computer's hard drive and the database table on a
second computer's drive. The database table has a series of columns
that contain data about the various files.
I would like to be able to have a field in a database table on the
second computer that contains the path to the FILES on the first
computer. Clicking on the field would "run" the file. That is to say
that a jpg file would open a viewer, a mpg file would open a media
player, etc. This strikes me as being somewhat similar to something
people might use at work: a personnel file, names, addresses, etc and
a photo of the individual. Embedding the files (OLE, I think) under
Access really bloated the table size, and cutting and pasting the path
from a text field in the table into a Explorer bar just seems so painful.
What special behavior does a URL field have in Access? A URL field is
NOT a valid SQL type of which I am aware, so it is nothing more than
a special behavior when used in a form.
I hope that defines my issue a bit (it is somewhat ramblin'...I just
woke up!)
Thanks for listening.
Thanks,
Rob
What you want is to be able to click on a link in the database and let
OOo worry about figuring out which program should be used to open the
link. I understand. This might be easy to add the functionality as a
button next to the field. You simply pass the link to the underlying OS
and tell it to worry about it. (or something like that anyway)... Either
way, sounds like a nice field to have around.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
