Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-17-2019, 04:37 AM   #1
bigmac
Newly Registered User
 
Join Date: Oct 2008
Location: wales
Posts: 267
Thanks: 71
Thanked 0 Times in 0 Posts
bigmac is on a distinguished road
Question error message

hi all can you help please, i have a hyperlink field on my form and when i drag a pdf link to it i keep getting this message "the field is too small to accept the amount of data you attempted to add, try inserting or pasting less data. but the strange thing is that if i click on another field the link appear's on the hyperlink field and works , how do i stop the error message please

bigmac is offline   Reply With Quote
Old 03-17-2019, 10:38 AM   #2
James Dickinson
Newly Registered User
 
Join Date: May 2018
Posts: 31
Thanks: 2
Thanked 8 Times in 8 Posts
James Dickinson is on a distinguished road
Re: error message

I can't speak to the actual issue but this should get you past the error.
Paste this into your forms code

Code:
Private Sub Form_Error(DataErr As Integer, Response As Integer)

Response = acDataErrContinue

end sub
James Dickinson is offline   Reply With Quote
Old 03-17-2019, 12:43 PM   #3
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,153
Thanks: 349
Thanked 535 Times in 517 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: error message

No point ignoring the error, as Access is not going to do what the O/P wants?

Perhaps it is trying to past the file into the control and not the link?

Try copying and pasting instead. I've never dragged anything on to a form yet, except another form in design view.

What is the size of the field as well? Too short, and the url will not fit?

__________________
Access novice. Sometimes trying to give something back.
Access 2007


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote
Old 03-18-2019, 04:20 AM   #4
bigmac
Newly Registered User
 
Join Date: Oct 2008
Location: wales
Posts: 267
Thanks: 71
Thanked 0 Times in 0 Posts
bigmac is on a distinguished road
Re: error message

hello James Dickinson/Gasman, thank you for your response, but none seem to work . the field i am trying to put the hyperlink is an hyperlink field so it should work, (the link works after the error message goes and works ever time i click on it ) the database has a lot of files in it (around 8 thousand and growing ) it is a front end back end database, what if i change the hyperlink field to an attachment? would this effect the size of the front end or the back end to be bigger than allowed?
bigmac is offline   Reply With Quote
Old 03-18-2019, 04:35 AM   #5
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,760
Thanks: 67
Thanked 1,935 Times in 1,884 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: error message

@bigmac,

Have you considered just using a text field rather than hyperlink type?
Then use the Application.FollowHyperlink "yourtextfield here" or more specifically

Application.FollowHyperlink "pdffilecoordinates"

see this thread for related info
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by jdraw; 03-18-2019 at 04:48 AM.
jdraw is offline   Reply With Quote
Old 03-18-2019, 05:33 AM   #6
bigmac
Newly Registered User
 
Join Date: Oct 2008
Location: wales
Posts: 267
Thanks: 71
Thanked 0 Times in 0 Posts
bigmac is on a distinguished road
Thumbs up Re: error message

think i have solved this, i have made a carbon copy of the hyperlink field and copied this onto my form, now i get no error messages, i dont know what was wrong with other one but this one looks ok

bigmac is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Message "Reserved Error ( -1104); there are no message fot this error." radek225 Modules & VBA 4 12-07-2015 06:18 AM
Custom message for error message "MySQL server has gone away"?? perlfan General 1 10-16-2011 03:54 AM
A question about the error message "Run-time error '3061' Too few parameters, Expecte dariyoosh Modules & VBA 7 03-12-2010 06:26 AM
Reserved Error (-1517); there is no message for this error. swhite General 10 04-11-2006 02:25 AM
ACC2000: Error Message: Error Accessing File. Network Connection May Have Been Lost. jenvandiver General 0 10-30-2002 09:19 AM




All times are GMT -8. The time now is 01:02 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World