Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Hyperlink Error Message Required

Discussion in 'Information Technology' started by Sue Wilkes, Jul 28, 2006.

  1. Sue Wilkes

    Sue Wilkes
    Expand Collapse

    I have been struggling with my problem for a week and have tried various
    self help sites. I have a text box on a form bound to a table which is
    datatype hyperlink. All works well I can open the files from the links no
    problem. What I have are two forms, one for adding records and one for
    editing records. On adding records I use the following code

    If IsNull(Me.Hyperlink1) Then
    Canel = True
    End If

    On the event OnGotFocus of my command button to print the document.

    In the edit form, I moved the code to BeforeUpdate of the individual
    controls and it works okay however with the hyperlink field I have tried
    using the code in several places on the control (text field) including
    BeforeUpdate but cannot get the message to appear, or stop the user saving
    and closing the form without the hyperlink1 field being populateed. All I
    seem to be able to manage is to get the run time error 3314 as the field is
    set to required in the table. Does any one know of a code which if the
    hypelink is selected then deleted so the field is blank it would prompt the
    user to select another hyperlink as the control/field cannot be blank. I
    suspect that deleting the link in the hyperlink field behaves differently to
    ordinary text being deleted but I do not know what the difference is?

    Thanking you in anticipation for your assistance this is my last stumbling
    block to getting this database up and running, I would not have got this far
    without the help of these discussion forums, so thank you to all those who've

    Best regards
    Sue Wilkes
  2. Loading...

Share This Page