Recent content by alvingenius

  1. alvingenius

    Solved Replicate Text Box in Continuous Form

    it's attendance time !!! I get the time from Attendance Software with update query to attendance table, so in form time is not editable.
  2. alvingenius

    Solved Replicate Text Box in Continuous Form

    employee time is not changeable or editable at all!
  3. alvingenius

    Solved Replicate Text Box in Continuous Form

    i got your point. But in my situation, I only calculate Late time form ClockIn, and clock-in is not editable in form, it got the value from update query that gets the clock-in from another DB storing attendance time from attendance machine . so i'm not afraid of change/update the clockin .
  4. alvingenius

    Solved Replicate Text Box in Continuous Form

    I'm storing em in the table and I'm quoting ur words " especially if there are financial consequences for using them " At the end of the month, there's a report that calculates total hours of lates per employee !! that's why I'm storing em !! Please tell me your concerns in details
  5. alvingenius

    Solved Replicate Text Box in Continuous Form

    Yeah Thank you for the tip 🌷
  6. alvingenius

    Solved Replicate Text Box in Continuous Form

    It's for Late Hours so i need to store this value Thanks again
  7. alvingenius

    Solved Replicate Text Box in Continuous Form

    Hi I forget to make this post as " Solved " and for not allowed to attach, i meant for a not zipped file ".ACCDB" but after zipped its attached and i uploaded it in this post Thanks
  8. alvingenius

    Solved Replicate Text Box in Continuous Form

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

    Solved Print Multiple file paths saved in table

    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
  10. alvingenius

    Solved Print Multiple file paths saved in table

    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...
  11. alvingenius

    Solved Print Multiple file paths saved in table

    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
  12. alvingenius

    Solved Print Multiple file paths saved in table

    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
  13. alvingenius

    Solved Print Multiple file paths saved in table

    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?
  14. alvingenius

    Solved Print Multiple file paths saved in table

    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...
  15. alvingenius

    Solved Print Multiple file paths saved in table

    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"
Top Bottom