Recent content by Cat_129

The files that are being attached are from a controlled drawing system, so if two files with the same name are added it wont make a difference because they will be the same file. If they are different something has gone wrong in a different system, but yes you are correct this would happen if...

@isladogs Thanks, this was my understanding, one field per hyperlink, we want to limit people to a maximum of 5 hyperlinks per form so I was just going to add 5 fields. I know it's not pretty but only have a couple of days to get this done in, and the other way is beyond my skills at the...

Sorry if I am being stupid buy why would it need to be in another table? I was going to add a field to the existing table that the link could go into

Hey, I have been trying to work this out but think what I am looking at as examples are doing more than I need and I am getting brain melt! I have been using these as help documents (https://www.access-diva.com/d15.html &...

Yes, I am working on the test version that is outside of the server. I am using this as a basis at the moment which I found from a previous thread. I dont understand 100% but get most of it https://www.access-diva.com/d15.html

Yes, they will be stored on the same server as the backend in the same folder structure so it is all held in the same place. I've done some googling but I dont understand the code well enough to tweak it to my needs or if it even does what I need. This stuff is beyond my knowledge

Morning All I started a thread earlier on how best to manage my data because we are going to reach data limits soon (https://www.access-programmers.co.uk/forums/showthread.php?t=308028) Currently there is an attachment field on the form which is heavily being used. What I need to do is remove...

Hey, Thanks for the advice guys, not harsh at all. I totally agree with you on all of the above. SQL server is 100% out. If it cant work without SQL then its getting binned. Ruling was from company overlords who dont actually understand what or why we are doing this. I'm going to start...

Thanks for the advice guys. I will look into how we can do this. Do I need to start another thread in forms to talk about best way to do this or just continue this thread?

I'm not sure how that would work. Is it possible to have the database save them into this other folder so that it behaves the same way or would you need to link to it like a hyperlink? We need all attachments to be with the record not in a folder outside of the database due to network issues...

Hey, Have a little predicament, I have created a database which works great, But after a little under a month of use its now at 1.7 GB :eek: We store a lot of images in our database because it logs build issues and people attach images of problems / solutions / drawings to records. There are...

Just wanted to let you know that I have solved this, I just changed the order things were done in, so I had the message box pop up on the second form which then made the screen capture happen on the second form. Thanks for all your help Cat

Thank You, I am now leaving work for the weekend so won't have access to this until Monday, all help is really appreciated.

So this uses a code that arnelgp gave me to create the screenshot. (https://www.access-programmers.co.uk/forums/showthread.php?t=306902) Then the rest goes as follows This is run from the log form DoCmd.OpenForm "Deviations", , , "[DR Number] = " & Me![DR Number] Call BTNLeadApproval_Click...

I Lied....Sorry, I was accidentally running the wrong macro when I tested it :banghead: any further ideas? Thanks for all the help recently, I should pay you all a retainer...