Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Tag Cloud
access acer asus bios bsod computer crash desktop drive driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory missing monitor motherboard network printer problem ram random registry router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: access 2002 database issue

Reply  
Thread Tools
chrisuk2009's Avatar
Member with 37 posts.
 
Join Date: Nov 2009
Experience: Beginner
21-Nov-2009, 07:22 PM #1
Solved: access 2002 database issue
i am working on a new database which so far has 24 record sets in it. I have a hyperlink field and every time time i insert a hyperlink it works ok then i lose the record set link is within. More links i add more record sets i loose. good job i had a back up of my work.
Can anyone please infom me of cause and solution to this problem please ?
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
22-Nov-2009, 09:42 AM #2
chris, welcome to the Forum.
I have never heard of your problem. But you can overcome it by using a plain text field and then using the VBA "Follow Hyperlink Method"
chrisuk2009's Avatar
Member with 37 posts.
 
Join Date: Nov 2009
Experience: Beginner
22-Nov-2009, 09:57 AM #3
VBA "Follow Hyperlink Method"
thank you for responding, i am a beginer to this and i do not know what VBA "Follow Hyperlink Method" is

please tell me more
chrisuk2009's Avatar
Member with 37 posts.
 
Join Date: Nov 2009
Experience: Beginner
22-Nov-2009, 10:24 AM #4
i forgot to say, record only vanishes after you close the database and restart it
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
22-Nov-2009, 10:36 AM #5
chris, the VBA code goes in the Form Field's "On Click Event Procedure" for your hyperlink field which should now just be a text field with 255 characters.
The code itself would like this

if Not Isnull(me.hyperlinkfieldname) then Application.FollowHyperlink me.hyperlinkfieldname, , True

Where hyperlinkfieldname is the actual name of the field on the form, the Not Isnull is there to ensure that you don't try to follow a blank hyperlink
__________________
OBP
I do not give up easily
chrisuk2009's Avatar
Member with 37 posts.
 
Join Date: Nov 2009
Experience: Beginner
22-Nov-2009, 11:11 AM #6
partly fixed
Thank you for your help, this fixes original problem, but now has generated a second problem. I was right clicking the individual files in explorer and then pasting into here before, but won’t let me do this in this text box. I have around 1000 records to generate in here I need to hyperlink, so typing in every one will take me weeks
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
22-Nov-2009, 11:42 AM #7
chris, I didn't realise it was for files, I thought it was for Internet addresses.
You can download all the files in a Folder in one go.
Have a look at this database, I created for Document Management, it has some very good VBA in it, but it does rewuire that you set VBA Editor Library References, so there is also an Excel sheet showing what they should be.
You are quite welcome to use any of it you like and I will talk you trhough how to do it.
It has some built Instructions on how to use the various Forms.
Attached Files
File Type: zip Document Management 1.2 .zip (336.8 KB, 54 views)
__________________
OBP
I do not give up easily
chrisuk2009's Avatar
Member with 37 posts.
 
Join Date: Nov 2009
Experience: Beginner
22-Nov-2009, 02:23 PM #8
Thank you for your help and patience, but it seems not my data today. The database will not open, please see my attachment. It is on my desk top so on my computer, I can’t see why it sees this as a threat
Attached Files
File Type: doc message.doc (155.5 KB, 108 views)
chrisuk2009's Avatar
Member with 37 posts.
 
Join Date: Nov 2009
Experience: Beginner
22-Nov-2009, 03:34 PM #9
it is a shame this DB would not open, could have saved many hours of work with so many files to link to
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
23-Nov-2009, 07:33 AM #10
Copy the database to your desktop, zip it and then delete the desktop copy.
Unzip the database try it again.
You can also change the Properties of the database to from a Trusted site.

If that doesn't work get back to me and I will post the code that you need.
__________________
OBP
I do not give up easily
chrisuk2009's Avatar
Member with 37 posts.
 
Join Date: Nov 2009
Experience: Beginner
23-Nov-2009, 01:55 PM #11
Smile cheers , this worked fine it opens OK now
cheers , this worked fine it opens OK now

i will now need help on what to do next, i can see how to select a file from my folder at it does show in the box , but how will i get this to link with my database ?

your help is much appreciated, thank you
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
23-Nov-2009, 02:37 PM #12
Chris, you don't, what you need to do is Import the Form and VBA Modules in to your Database. I will then give you Instructions on what to change (File Table name in the VBA, form's record source etc).
You will probably need the File Types table & query as well to make the form work

Or you could import them in to the table in my database and then Copy and Paste them in to your table or Import my table in to your dataabse and then create an Append or Update query to add the data to yout Table.

Or I can do it for you.
__________________
OBP
I do not give up easily
chrisuk2009's Avatar
Member with 37 posts.
 
Join Date: Nov 2009
Experience: Beginner
24-Nov-2009, 04:14 PM #13
Smile have attached my file for you
yes please , if you can modify this for me it would i guess be easier, please file zipped

regards chris
Attached Files
File Type: zip OI ver 17.zip (287.3 KB, 15 views)
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
25-Nov-2009, 06:58 AM #14
Chris, oh boy does that bring back memories for me, if you check my Forum profile you will see that I worked for Ford's for 33 years in the Quality Engineering Department and created a Quality Engineering Database (QED) while I was there.
I can offer a couple of improvements for your Operator Mainform if you like.

What I am going to do is create a "Document" table to hold the Path to your Instuctions, it will have an ID to match up to your current "OI_Document_Number" but it should really be the "IDNumber", but you won't know that until you have created all of the OI_Table's records.
If you run the VBA code to populate that table we can then discuss matching up the data to the OI_Table.
Is the Hyperlink Address on a Local Network Server that you can browse to?
Or can you provide it's designated Drive letter?
__________________
OBP
I do not give up easily
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 14,665 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
25-Nov-2009, 08:36 AM #15
Chris, here is the Importing Version, it works Ok on my computer. The VBA code that gets the "OI_Document_Number" from the File name won't work properly if you change the file naming convention from "oi OI_Document_Number etc.
Attached Files
File Type: zip OI ver 17.zip (315.5 KB, 21 views)
Reply

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 03:02 AM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.