Search results

I think that's a better solution update query thanks 🌷

in case u wanna try fixes directly Attached the sample with the last edit on it So if it will be possible to make it work so there's a new field of Date I wanna filter records on Files table So before generating PDFs I must put a year in form

Edit1 : Even when i tried the array with your simplecsv() function alone here Private Sub Command27_Click() Dim rs As Recordset Dim i As Integer Dim LinksArray() As String LinksArray = Split(SimpleCSV("SELECT xLink FROM Files WHERE fType In('xID','Passport') AND User_ID='" & rs!User_ID...

You mean this ? SimpleCSV("SELECT xLink FROM Files WHERE fType In('xID','Passport') AND User_ID='" & rs!files.User_ID & "'") because of the whole table fields here

So the new code will be LinksArray = Split(SimpleCSV("SELECT xLink FROM Files WHERE fType In('xID','Passport') AND User_ID='" & rs!Files.User_ID & "'")) But got a different error Debugging Point to

Hi Thanks for not giving up on me 🌷 So I tried your code and put it where you said then i got this error and that's what it shows after i click debug and what do u think about manipulating Username from StrSQL recordset as grouped?

Same issue It returns d:\1.pdf d:\1.pdf in debug print and that's valid value this one here Debug.Print rs.Fields("User_ID") go through records and there are 2 records with user id = 1 in files table so when looping, it get first record User id = 1 , and it's merged as pdf, next loop will get...

SavePath = "D:\" & rs.Fields("UserName") & ".pdf" i think i figured it but it only get me D:\Mike.pdf file So that's the only thing missing now ,, getting file name saved as record id loop how to make username changes with the ID loops SavePath = "D:\" & rs.Fields("UserName") & ".pdf"

That's what i've reached till now Private Sub cmdFiles_Click() Dim i As Integer Dim db As Database Dim rs As Recordset Dim strSQL As String Dim LinksArray() As String Dim bSuccess As Boolean Dim SavePath As String LinksArray = Split(SimpleCSV("SELECT xLink FROM Files WHERE fType...

bSuccess = MergePDFs(LinkArray, "C:\FolderName\NewName.pdf") this one give me the 1pdf file with 4 pages ( 2 per user ) ( valid file if i wanna combine all file paths ) the other code with strPDFs i must defind all arrays for it now back to the point of how to passing file paths arrays for...

no, i've already posted the simplecsv code before, and really i don't know how to go further i'll apprecaite it if you edit the sample db attached in your reply then i'll understand what u done from the final code !

Arrayname : LinksArray Sub Combine_PDFs_Demo() Dim strPDFs(0 To 2) As String Dim bSuccess As Boolean strPDFs(0) = "C:\Users\Ryan\Desktop\Page1.pdf" strPDFs(1) = "C:\Users\Ryan\Desktop\Page5.pdf" strPDFs(2) = "C:\Users\Ryan\Desktop\Page10.pdf" bSuccess = MergePDFs(strPDFs...

then what's next?

That's true But till this point i've reached i don't know how to continue or do what you telling here in this quote so here is the equivalent of your simpleCSV() function based on the File Table SimpleCSV("SELECT Files.xLink FROM Files WHERE Files.fType In('xID','Passport')") If i may ask...

i don't wanna filter data by client ID , i want all file paths in the table to be extracted but the output needed is 1 pdf for every user ! i think i've failed to explain my idea , i will start a new post, since you already fixed the post issue about printing paths in table

Regarding this code Sub Combine_PDFs_Demo() Dim bSuccess As Boolean Dim strPDFs(0 To 2) As String strPDFs(0) = "C:\Users\Ryan\Desktop\Page1.pdf" strPDFs(1) = "C:\Users\Ryan\Desktop\Page5.pdf" strPDFs(2) = "C:\Users\Ryan\Desktop\Page10.pdf" bSuccess = MergePDFs(strPDFs...

Hi I've checked ur SimpleCSV() function , and you teched me something new today. thanks for that (y) (y) what I learned is Arrays is working like Dim xx as strings or integers, but without sizing and with your SimpleCSV function, it concatenates all file paths to 1 very big string and with...

Hi sir, I managed to make dlookups works in query fields To get me 4 years review degrees But i need to know why u said dont use it in query ??

hi Salary is based on nationality Not Junior and senior junior and senior is just a promotion and nor relates to salary.

Ok here we are