Search results

it is not small number manually can be than but it is to much time consuming. there was a link i don't remember where exactly for checking and repairing hyperlinks but link is dead now ( probably too old)

No need for that because I am the only user. last time aplication worked only for one year. I made changes to work with additional years so the old organization of folders have to be changed. at that time i didnt know that i will broken links that way. so now just in case i want to know if...

why? what I will get if I do that. With each new record there is a new document to scan which means new pdf file. so i put new pdf file in the same or new folders.

your file works but thats not what i want. here example of database with one folder to see how it look like.

i have to test it first. will inform you after that.

moving both database and pdf files. all files go together. in this case almost everything same only drive different. first time when i lost hyperlinks folders were changed. this time it wont be the case. just different drives.

actually i tried it and works. links are ok. but still if folder is changed links wont work. what should be done in such case.

aplication is in the main folder and pdf files are in subfolders. I intend to copy aplication and pdf files also. just copy everything.

you are right I am the only one using the database. tool you mentioned will not work for me. question was if I move database file and pdf files will i loose links again (I believe i would) and if so can I prevent it or what to do.

yes it is split form. i dont understand what are front-end and back-end files can you explain please. also there are no tables. there is only one table. query is made based on the table and split form based on the query.

If I move database and pdf files from usb to hard disk links wont work again?

something like this 2025\101-150\104\03-104(1).pdf and i know exactly by the path which file it is and which field should go. i can repair manually each and I already have some repaired just need too much time this way.

same with me too. folders with subfolders. not same names at least not in same folder. my database was on stcik. i made changes to database so i have to change some folders. also there was some stick failure. I repair it. database was saved only problems with links.

yes broken links. sometimes i do sometimes don't but even if i have too much fields to repair especially when folders are moved.

I have a filed (link) that opens a pdf file when you click it. when folders are moved or from some other reaseon is possible link don't ppen the pdf file. If it is big database checking one link at the time is too much time consuming. is there some faster way.

Hi, Is there a way to check and repair links to pdf files. I don't mean manually one by one. Thanks

Good advise problem is that i am beginner haven't learn about vba yet so i still trying to guess right way. and about fields i think no need to check. As i said i have few combo boxes. each combo is for number or text or date only. one for numbers other for text etc.

It shouldnt? works perfectly with no mistake.

I have few combo boxes so there are text, numbers, dates. in the example i tried with first combo which is number.

I tried few different ways none worked. last attempt was with this code: Private Sub Combo13_AfterUpdate() On Error GoTo Combo13_AfterUpdate_Err DoCmd.SearchForRecord , "", acFirst, "[Number] = " & Str(Nz(Screen.ActiveControl, 0)) DoCmd.Requery "" Combo13_AfterUpdate_Exit: Exit...