hyperlink in forms

[Guest]

I am working on a small database where I also want to keep track of documents
(via links). I have set up a table with a field of type "Hyperlink", and I
can drag a file to that field in the table, and it then enters the link to
that document.
I then created a form with a text field and linked the field to the field in
the table. I can now copy and past links in the form and they also show up in
the table. But when I try to drag a document from a folder to the field on
the form, it does not work. The pointer changes to a "not allowed" sign
(crossed circle). How do I have to set up a field on a form so that it
accepts a drag and drop operation like the underlying table field?

 

[kingston via AccessMonster.com]

Are you placing the cursor in a control via the mouse? If so, don't. Just
go to a new record and drop the file into the control before you do anything
else. Otherwise, use the tab key to enter into the hyperlink control and
then drop the file in. Is this the problem you're experiencing?

 

[Guest]

No, not really. My problem is that the control on the form does not accept it
when I drag and drop a file from a folder onto it. The underlying table field
does accept the link, but not the control on the form. Do I have to enable
that somehow?

All I want is to be able to drag and drop a file from a folder onto a
control in a form, so that the underlying table records the link to the file.

 

[kingston via AccessMonster.com]

You should be able to use the hyperlink as you'd expect by dropping it into
the form in design mode. Are you sure that it doesn't accept the file if you
go to a new record and the first thing you do is drop the file into the
control?

No, not really. My problem is that the control on the form does not accept it
when I drag and drop a file from a folder onto it. The underlying table field
does accept the link, but not the control on the form. Do I have to enable
that somehow?

All I want is to be able to drag and drop a file from a folder onto a
control in a form, so that the underlying table records the link to the file.

Are you placing the cursor in a control via the mouse? If so, don't. Just
go to a new record and drop the file into the control before you do anything

[quoted text clipped - 11 lines]

 

[Guest]

That's what I thought, but it ain't so. I just did the following: Open the
database, open the table that holds the fields, open the form in "Form view".
Then I grabbed a file from a folder and dragged it over the database window.
The table readily accepts the link, but when I continue dragging it to the
control on the form, the cursor changes to "no accepted" (crossed circle).

I then opened the form in design mode, as you suggested", and dropped the
file there. All that did is to put the text in the file on the form when I
switch back to "Form view".

Then I added a new control to the form by dragging the filed from the "field
list" onto the form. Same result. Does not accept drag and drop.

Do I have to enable drag and drop somewhere?

You should be able to use the hyperlink as you'd expect by dropping it into
the form in design mode. Are you sure that it doesn't accept the file if you
go to a new record and the first thing you do is drop the file into the
control?

No, not really. My problem is that the control on the form does not accept it
when I drag and drop a file from a folder onto it. The underlying table field
does accept the link, but not the control on the form. Do I have to enable
that somehow?

All I want is to be able to drag and drop a file from a folder onto a
control in a form, so that the underlying table records the link to the file.

Are you placing the cursor in a control via the mouse? If so, don't. Just
go to a new record and drop the file into the control before you do anything

[quoted text clipped - 11 lines]

(crossed circle). How do I have to set up a field on a form so that it
accepts a drag and drop operation like the underlying table field?

 

[kingston via AccessMonster.com]

No, I meant that you drag and drop the field (not the file) in design mode
into the form. Since the field is a hyperlink, the control that is created
should automatically be correct. Then in view mode, the control should work
as expected. Anyway, it seemed like it didn't work.

There is an IsHyperlink property for the control that you might try (at the
bottom of the first tab of the control properties window). Otherwise, I'd
make sure your version of Access has the latest patches. You might also try
looking in the VB->Tools->References list. I'm sorry I couldn't be of more
help.

That's what I thought, but it ain't so. I just did the following: Open the
database, open the table that holds the fields, open the form in "Form view".
Then I grabbed a file from a folder and dragged it over the database window.
The table readily accepts the link, but when I continue dragging it to the
control on the form, the cursor changes to "no accepted" (crossed circle).

I then opened the form in design mode, as you suggested", and dropped the
file there. All that did is to put the text in the file on the form when I
switch back to "Form view".

Then I added a new control to the form by dragging the filed from the "field
list" onto the form. Same result. Does not accept drag and drop.

Do I have to enable drag and drop somewhere?

You should be able to use the hyperlink as you'd expect by dropping it into
the form in design mode. Are you sure that it doesn't accept the file if you

[quoted text clipped - 14 lines]