Adding new field/s to an old form

[stealth3]

This should be an easy question - I would like to add a new field to my main form. The new field will contain hyperlinked documents from the web and/or the local network.

Could a modification affect my database and queries, reports, tables etc? Should I create two fields, one for weblinks, the other for local drive documents?

Thank you

Stealth

 

[TheAceMan1]

How are ya stealth3 . . . . .

[blue] I would like to add a new field to my main form.[/blue]

[ol][li]For [blue]unbound hyperlinks[/blue] use a [blue]Label[/blue] or [blue]Command Button[/blue]. Call up the properties for the control and put the cursor on the [purple]Hyperlink Address[/purple] property line. Click the three elipses

just to the right and fill out the [purple]Edit HyperLink Dialog[/purple].[/li]
[li]For [blue]bound hyperlinks[/blue], and a field to the approiate table ans select [blue]hyperlink data type[/blue]. In Table or Form view, right-click to select the [purple]Edit HyperLink Dialog.[/purple][/li][/ol]

[blue]Could a modification affect my database and queries, reports, tables etc?[/blue]

If you added a hyperlink field to a table, only in that it has be [blue]included/added in the appropriate Record Sources[/blue] for their use.

[blue]Should I create two fields, one for weblinks, the other for local drive documents?[/blue]

No, one will accept either.

See Ya! . . . . . .

 

[stealth3]

Thank you - knew it was going to be straightforward
stealth