Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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...

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page