Search results

Hi That's great u made it work and PDfs is not fillable, its Scanned files About array .. please explain more as i said i'm not that good in VBA 🙈:(

what i want is : this query have what i want to extract as pdf / i wanna click a btn to merge all file paths for every user and save it automatically to Desktop named by username so the final output in desktop will be Mike.pdf (2 pages) Peter.pdf ( 2 Pages )

true , that's why i wanna use dlookup to get it in the same employee query so i made a form to write the Promotion year like : 2021 then 4 more unbound txtboxs to get the preview 4 year : 2020-2019-2018-2017 then i created a a report and used the employee table then in report i used this...

Thanks for your reply but please tell me why ? because i was gonna create a new post now to how to use dlookup to get data in query fields !because it will fix some issues with me

Thanks for your reply but I can't store salary information in employee table ..

Hi. @Vlad, Thanks for your help i've already figured it the same way you did and stuck with reviews too and I thought there's an easier way instead of doing all these queries like building expressions on query fields ( dlookup , switch , iif ), i tried it but i couldnt make it work with...

@theDBguy any chance you help me completing this code?

Hello For All I hope you doing good in this quarantine Since I'm Home, I'm trying to learn more about Access because I like it and I've got a new idea for an app. So I need your help building it the right way I'll explain what's the output from this idea to help me get it - I'm working on a...

Ooh i think you get me wrong Separate i mean extracting all files per user as 1 pdf i told u before, every user might have 20 requests ( let's say it's 20 ) and i have em in Files table as paths , so i want to extract em as 1 pdf having 20 pages ! named as user name ! and this operation...

So can u edit the Sample DB attached to do this ?

since the number of files is too big to extract it as 1 pdf with 2000 pages or printing 2000 pages on time so the best solution will be output requests for every user separate as 1 pdf named as user name so at the end i will get 50 PDFs for 50 Users i think thats the best solution

Hi For archiving or printing it will be recommended to keep em separate, and i sent you the code, because i'm not that good in vba and i don't know how to code it to save a pdf for every user as user name in desktop or any place i choose.

Hi, i said that because its a big amount of papers i didn't try it before printing +2000 pages one time so for that i asked you to save a 1 pdf for every user requests , and too we might keep em without printing and keeping em as pdf for archiving

the machine that will do this operation has a full acrobat pro ( it only to my company not distributing it ) the reason behind what i want as i said it before: At the end of every year, we are printing all requests by every user to a specific department so , requests may reach 2000 pdf to be...

what about the rest of Files that i need to output them as 1 Pdf per user ( including only ID + Passport Photos ) Named as a user name in location i specified one time ( like desktop ) and it loops for all users exists

Thanks for your reply Regarding #1 , i tried it, if i called the button, it will print main report for all users in table then after that it will start to print files for every user Regarding #2 , i'll choose not to choose any user and it will go for all users , i'll remove filter on users in...

it goes well, now it only prints users ID and Passport selected * what i miss now is 1- I wanna the main report named " UserProfiles " to be printed too with the user selected 2- If I didn't choose any user from the form then it should print all users main report + files related at this order...

thanks again but I didn't finish it this edits applied to this sample v2 but I made em for you, to help u edit the current code edit1 : I tried to edit this code with no luck this code i tried strSQL = "SELECT Files.User_ID, Files.fType, Files.xLink" strSQL = strSQL & " FROM Files" strSQL =...

Wow, you did the hard part and u make it look like Easy Peasy it Prints all file paths linked to the user-chosen in form However, this code needs some edits and i will tell you what i did too in italic I only want ID photo and Passport Printed (fType) and exclude any other file paths. for...

if it will print every user profile + related ID and Passport with it then it will work, but i'm not that good in vba to make it work using ur method!