Search results

Can you give me an example?

last line "what is wrong" not.

Hi, I have union query and sorting not working. same expression in select query do the job but not in union query. expression is ORDER BY Left([Field],4), DatePart("yyyy",[field1]), table.Field2, table.Field3 what is wrong.

let me see if understood well. first to change hyperlink field to text than to make query to make desired changes and last to back field from text to hyperlink again. if this is correct i can do it. problem solved.

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